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

[Karl Martindale]

johnf wrote:
> On Wednesday 04 January 2006 20:56, Karl Martindale wrote:
> 
>>johnf wrote:
>>
>>>On Wednesday 04 January 2006 18:16, Karl Martindale wrote:
>>>
>>>>Hi Guys,
>>>>
>>>>I've compiled and installed gambas v1.9.23 on a Slackware Linux 10.0 box.
>>>>A project that runs on another machine fails with the error: Cannot find
>>>>driver for database: postgresql
>>>>
>>>>When I compiled gambas the postgresql driver was compiled and wasn't
>>>>listed as 'disabled' after ./configure
>>>>
>>>>This install will successfully talk to a MySQL host running on the same
>>>>machine. The postgres driver appears to be in the lib directory:
>>>>
>>>>root at ...56...:/usr/local/lib/gambas2# ls -l gb.db.*sql*
>>>>-rwxr-xr-x  1 root root   905 2006-01-05 01:29 gb.db.mysql.la*
>>>>lrwxrwxrwx  1 root root    20 2006-01-05 01:29 gb.db.mysql.so ->
>>>>gb.db.mysql.so.0.0.0*
>>>>lrwxrwxrwx  1 root root    20 2006-01-05 01:29 gb.db.mysql.so.0 ->
>>>>gb.db.mysql.so.0.0.0*
>>>>-rwxr-xr-x  1 root root 74376 2006-01-05 01:29 gb.db.mysql.so.0.0.0*
>>>>-rwxr-xr-x  1 root root   879 2006-01-05 01:29 gb.db.postgresql.la*
>>>>lrwxrwxrwx  1 root root    25 2006-01-05 01:29 gb.db.postgresql.so ->
>>>>gb.db.postgresql.so.0.0.0*
>>>>lrwxrwxrwx  1 root root    25 2006-01-05 01:29 gb.db.postgresql.so.0 ->
>>>>gb.db.postgresql.so.0.0.0*
>>>>-rwxr-xr-x  1 root root 73938 2006-01-05 01:29 gb.db.postgresql.so.0.0.0*
>>>>
>>>>I have logged on to that database using the same credentials as in the
>>>>project using the CLI program psql.
>>>>
>>>>Does anyone have a suggestion as to what I'm doing wrong?
>>>>
>>>>Thanks in advance,
>>>>Karl.
>>>
>>>I'm not sure but can you create a small project on the new computer and
>>>make sure the db property is checked - then check for access?
>>>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
>>
>>This fairly minimal project behaves in the same way:
>>
>>PUBLIC SUB Form_Open()
>>DIM conn AS NEW connection
>>DIM connected AS Boolean
>>
>>WITH conn
>>         .Type = "postgresql"
>>         .Host = "localhost"
>>         .Login = "karl"
>>         .Name = "growl"
>>         '.Password = "karl"
>>     END WITH
>>
>>     TRY conn.Open
>>     IF ERROR THEN
>>         Message("Failed to open DB connection." & Error.Text)
>>         connected = FALSE
>>     ELSE
>>         connected = TRUE
>>     END IF
>>END
> 
> 
> OK just to be sure you enabled the 'DB' property - right?
> 
> Does the message fire in your example? "Failed to open DB connection" ?
> 
> Do you have pgAdminIII on the system?  You could use it to insure that you 
> have a running postmaster and you are allowed access to the localmachine. 
> Also try "ps -efa | grep postmaster" to see if your postgres is running as 
> root.
> 
> What happens from the example database? Can you get a connection and run a 
> simple SQL statement from the example?
> John

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.