I am trying to add layers to a new location in 6.1 (cvs) on Mac OSX. I
have successfully used mysql with 5.7 in the past, but am running into
some problems with this release.
I tried connecting to mysql using db.connect/db.login, as recommended
in the documentation, but got the following:
DBMI-MYSQL driver error: mysql_real_connect() error (1045): Access
denied for user: chris@localhost
Despite the fact that I was using the correct login information. If I
go back and do things the old way, using db.connnect:
db.connect database="dbname=florida_gis,user=chris" driver="mysql"
I get the following warning:
WARNING: 'user' in database definition is not supported, use db.login
*yet* it lets me import layers without any problem, and the tables
appear in the database. I'm not sure, therefore, what is the proper
way to do this. Please advise.
Thanks,
Chris
→
Chris wrote
I am trying to add layers to a new location in 6.1 (cvs) on Mac OSX. I
have successfully used mysql with 5.7 in the past, but am running into
some problems with this release.
I tried connecting to mysql using db.connect/db.login, as recommended
in the documentation, but got the following:
DBMI-MYSQL driver error: mysql_real_connect() error (1045): Access
denied for user: chris@localhost
Despite the fact that I was using the correct login information. If I
go back and do things the old way, using db.connnect:
db.connect database=“dbname=florida_gis,user=chris” driver=“mysql”
I get the following warning:
WARNING: ‘user’ in database definition is not supported, use db.login
yet it lets me import layers without any problem, and the tables
appear in the database. I’m not sure, therefore, what is the proper
way to do this. Please advise.
Thanks,
Chris
There are problems with MySQL 4.1.x. Use MySQL 4.0.x (http://www.mysql.org).
Now in OSX work these drivers: dbf, mysql (tested with MySQL 4.0.x, problems with 4.1.x), pg (tested with pgsql 7.4.x+PostGis 0.7.x, tested with pgsql 8.x http://www.druware.com/products/postgresql.html).
There are problems con odbc driver.
Grass under OSX is built with unixodbc support. UnixOdbc is a tool to connect an application under darwin (the unix base of OS X) to external db source via driver. Without an ODBC driver unixodbc is unuseful. ODBC drivers are present for MySQL, for PostgreSQL (see sites) and these driver HAVE TO BUILT with unixodbc support. Today there are problems to connect grass to ODBC source under Mac OS X.
|| Lorenzo Moretti e-mail: lorenzo.moretti@bologna.enea.it
||/|/| ENEA prot/idr Web: http://wwwamb.bologna.enea.it/
|| | via Don Fiammelli, 2 FTP: ftp://ftpamb.bologna.enea.it/ (ris.)
________________________________________________________________________
No problems here (hi Lorenzo). I think the problem, tho is the db.connect command used. Things changed at some point, and the correct way to do a db connection now is (ie to mysql):
db.connect dr=mysql dat="host=localhost,dbname=yourdbname"
db.login user=somemysqluser pass=mysqluserpass
I've been using MySQL 4.1.x since the alpha days with no problems on OS 10.3.
On Apr 6, 2005, at 10:04 AM, Lorenzo Moretti wrote:
Chris wrote
I am trying to add layers to a new location in 6.1 (cvs) on Mac OSX. I
have successfully used mysql with 5.7 in the past, but am running into
some problems with this release.
I tried connecting to mysql using db.connect/db.login, as recommended
in the documentation, but got the following:
DBMI-MYSQL driver error: mysql_real_connect() error (1045): Access
denied for user: chris@localhost
Despite the fact that I was using the correct login information. If I
go back and do things the old way, using db.connnect:
db.connect database="dbname=florida_gis,user=chris" driver="mysql"
I get the following warning:
WARNING: 'user' in database definition is not supported, use db.login
*yet* it lets me import layers without any problem, and the tables
appear in the database. I'm not sure, therefore, what is the proper
way to do this. Please advise.
Thanks,
Chris
There are problems with MySQL 4.1.x. Use MySQL 4.0.x (http://www.mysql.org).
Now in OSX work these drivers: dbf, mysql (tested with MySQL 4.0.x, problems with 4.1.x), pg (tested with pgsql 7.4.x+PostGis 0.7.x, tested with pgsql 8.x http://www.druware.com/products/postgresql.html).
There are problems con odbc driver.
Grass under OSX is built with unixodbc support. UnixOdbc is a tool to connect an application under darwin (the unix base of OS X) to external db source via driver. Without an ODBC driver unixodbc is unuseful. ODBC drivers are present for MySQL, for PostgreSQL (see sites) and these driver HAVE TO BUILT with unixodbc support. Today there are problems to connect grass to ODBC source under Mac OS X.
-----
William Kyngesburye <kyngchaos@charter.net>
http://webpages.charter.net/kyngchaos/
Theory of the Universe
There is a theory which states that if ever anyone discovers exactly what the universe is for and why it is here, it will instantly disappear and be replaced by something even more bizarrely inexplicable. There is another theory which states that this has already happened.
-Hitchhiker's Guide to the Galaxy 2nd season intro