<!doctype html public "-//W3C//DTD W3 HTML//EN">
<html><head> <!-- <DEFANGED_STYLE type="text/css"><!--
blockquote, dl, ul, ol, li { padding-top: 0 ; padding-bottom: 0 }
--> --> </DEFANGED_STYLE><title>Re: [GRASSLIST:6339] mysql attribute management in
6.1cvs</title></head><body>
<div>Chris wrote</div>
<div><br></div>
<blockquote type="cite" cite>I am trying to add layers to a new
location in 6.1 (cvs) on Mac OSX. I<br>
have successfully used mysql with 5.7 in the past, but am running
into<br>
some problems with this release.<br>
<br>
I tried connecting to mysql using db.connect/db.login, as
recommended<br>
in the documentation, but got the following:<br>
<br>
DBMI-MYSQL driver error: mysql_real_connect() error (1045): Access<br>
denied for user: chris@localhost<br>
<br>
Despite the fact that I was using the correct login information. If
I<br>
go back and do things the old way, using db.connnect:<br>
<br>
db.connect database="dbname=florida_gis,user=chris"
driver="mysql"<br>
<br>
I get the following warning:<br>
<br>
WARNING: 'user' in database definition is not supported, use
db.login<br>
<br>
*yet* it lets me import layers without any problem, and the tables<br>
appear in the database. I'm not sure, therefore, what is the
proper<br>
way to do this. Please advise.<br>
<br>
Thanks,<br>
Chris</blockquote>
<div><br></div>
<div>There are problems with MySQL 4.1.x. Use MySQL 4.0.x
(http://www.mysql.org).</div>
<div><br></div>
<div>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<font face="Lucida Grande" size="-4"
color="#000000">
http://www.druware.com/products/postgresql.html</font>).</div>
<div><br></div>
<div>There are problems con odbc driver.</div>
<div>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.</div>
<div><br></div>
<div><br></div>
<div><br></div>
<div><br></div>
<x-sigsep><pre>--
</pre></x-sigsep>
<div
>____________________________________________________________________<span
></span>____<br>
|| Lorenzo
Moretti e-mail:
lorenzo.moretti@bologna.enea.it <br>
||/|/| ENEA
prot/idr Web:
http://wwwamb.bologna.enea.it/ <br>
|| | via Don Fiammelli, 2 FTP:
ftp://ftpamb.bologna.enea.it/ (ris.)<br>
~~~~~~ 40128 BOLOGNA - ITALY Ph: +39-0516098086 Fax:
+39-0516098131<br>
_____________________________________________________________________<span
></span>___</div>
</body>
</html>