[GRASS-dev] Access of remote Mysql database ?

[Stephan Holl]

Hello Peter,

"Peter Löwe" <peter.loewe at gmx.de>, [20070502 - 10:40:54]

> Dear all,
> 
> the problem I am dealing seems currently not to be covered in the
> manuals:
> 
> How to hook up a remote mysql-database which requires a login ?
> 
> There is a mysql-database "the_database" with a table "the_table" on
> a remote computer "dbserver.foo.org", which can be accessed by a
> db-user  "joshua" (password: swordfish).
> 
> The goal is to establish a layer 2 link between this table (let the
> column be "id") similar to:
> 
> v.db.connect -o map=my_map   table=the_table layer=2 key=id
> driver=mysql database="host=dbserver.foo.org,dbname=the_database"
> key=id

what about (untested):
v.db.connect -o map=my_map   table=the_table layer=2 key=id
driver=mysql
database="host=dbserver.foo.org,dbname=the_database,user=joshua,password=swordfish"
key=id

> 
> Unfortunately db.login does not provide means to enter a remote
> server.
> 
> Is there a known workaround like hacking the .grasslogin6 -file ?
> 
> Any help would be much appreciated,

Best

	Stephan

-- 
Stephan Holl <stephan.holl at intevation.de>, http://intevation.de/~stephan
Tel: +49 (0)541-33 50 8 32 | Intevation GmbH | AG Osnabrück - HR B 18998
Geschäftsführer:  Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner