Re: [Planner Dev] Changes and Test guide for database backend
- From: Geoffrey <esoteric 3times25 net>
- To: Planner Project Manager - Development List <planner-dev lists imendio com>
- Subject: Re: [Planner Dev] Changes and Test guide for database backend
- Date: Wed, 27 Oct 2004 07:51:42 -0400
Alvaro del Castillo wrote:
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";
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
Until later, Geoffrey
] [Thread Prev