[Gambas-user] Cannot find driver for database: postgresql

[Karl Martindale]

Hi John, Benoit, everybody,

I apologise if this is a double post, but I sent another message, much like this 
one with the trace attached as a gzip archive but it hasn't appeared.  So here 
it is, uncompressed.

Yes, there's only one installation of gambas2 on this machine.
The version of postgres that's running is 7.4.6

Find attached what I think is the trace you're after, I ran:
strace gbx2 &> DBTest.trace
in the project directory.  The program ran and behaved 'normally'.

-Karl.

johnf wrote:
> On Wednesday 04 January 2006 22:58, Karl Martindale wrote:
> 
>>johnf wrote:
>>
>>>On Wednesday 04 January 2006 21:42, Karl Martindale wrote:
>>>
>>>>The message "Failed to open DB connection" does fire, it prepends the
>>>>"Cannot find driver for database: postgresql" message.
>>>>
>>>>This box had a postgres that was compiled from source and I pointed the
>>>>gambas configure at the include directory in the postgres tree.
>>>>
>>>> ps -efa | grep postmaster
>>>>postgres  1852     1  0 Jan02 ?        00:00:00
>>>>/usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data
>>>>
>>>>The DB property is checked in project properties.
>>>>
>>>>I also get the same message from the gambas database manager when trying
>>>>to connect.
>>>>
>>>>I have pgAdminIII installed on another box on the same network and it
>>>>successfully makes a connection.  The postgres server has been in use for
>>>>a little over a year now (involved in a PHP project).
>>>>
>>>>Karl.
>>>
>>>Any chance the localhost has been turned off in the pg.conf?  I use
>>>postgres daily with Gambas for the last two weeks (when I really started
>>>programming in Gambas) and it works perfectly.
>>>
>>>Just to insure I have it right you are attempting to connect to a
>>>postgres database on the same computer that postgres is running (and this
>>>is 'THE' new computer).  You might want to try using the IP address of
>>>the postgres server.  I once saw a box that did not accept 'localhost'
>>>but accepted the IP address (never did figure that out).
>>>
>>>When I compiled gambas 1.9.23 I did not have adjust anything (SUSE 10.0,
>>>worked with 9.3 too) to get postgres working.
>>>
>>>John
>>
>>One other thing I've noticed is that the gambas database manager will pick
>>up both the MySQL and postgres servers when you do a "Scan database
>>servers" from the menu.  It just won't connect.
>>
>>Karl.
> 
> 
> Hey Karl I think we forgot to ask the obivious - what version of Postgres are 
> you running?  I think 1.9.23 needs 7.4 or better - not sure about that.  
> Maybe that version limitation has something to with a different lang.
> John
> 
> John
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
> 
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: DBTest.trace
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20060106/a7116abe/attachment.ksh>