Re: [Planner Dev] Changes and Test guide for database backend

[Geoffrey <esoteric 3times25 net>]

Alvaro del Castillo wrote:
> Hi!
>
> El jue, 21-10-2004 a las 18:19, Geoffrey escribió:
>
> > Charles Tryon wrote:
> >
> > > Same or different host?
> > >
> > > (I've been bit way too many times by forgetting to allow remote TCP
> > > access to a new database I've installed.)
> >
> > Response regarding a different thread.  I've tried to access a remote 
> > database via planner, and it appears to me that there is a bug in the 
> > code, in that the server field appears to be ignored, thus defaulting to 
> > local server.  If you know a way to make this work, I'd appreciate 
> > knowing as well.
>
>
> Hmmm, I will look at it because I have no idea about this problem. I
> hope I will give some light today.

I posted more specific info regarding this issue earlier, here it is again:

Okay, so it appears that the server is simply ignored in 
src/planner-sql-plugin.c  It's passed into 
sql_plugin_retrieve_project_id(), but no portion of the server is passed 
to gda_config_save_data_source().  I'm assuming it should/could be 
passed as part of the db_txt.  Currently db_txt = "DATABASE=plannerdb"

I don't know what syntax it's expecting though, I'm thinking either:

db_txt = "DATABASE=plannerdb, HOST=db.home.edu";

OR

db_txt = "DATABASE=plannerdb:HOST=db.home.edu";

I do see one example for MySQl showing the comma delimited approach, but 
from my postgresql/perl coding experience, colon delimited is used, so I 
don't know if the syntax is dependent on gda code or provider 
expectation. Then again, I attempted to hack the code both ways, still 
couldn't get connected.

Figured I'd share this and keep hacking at it.  If you see something 
glaringly stupid in my assessment, let me know and I'll back down this 
path. :)
--
Until later, Geoffrey