Help with MySQL on SuSE

I've compiled libdvi, libdvi-drivers, and gps today. I compiled the libraries to live in /usr and gps to live in /usr/local/bin. I ran 'make check' on libdbi-drivers, and was able to connect to the DB. However gps is unable to connect to MySQL. Here is some info:

libdbi-0.8.1
libdbi-drivers-0.8.1
gps-1.004

Feb 10 13:34:58 furnsrv gps[25156]: error while initialising: DB: no dbi drivers installed, or none found, NO GREYLISTING WILL BE DONE

Logging into MySQL as user 'greylist':
furnsrv:/usr/local/src # su nobody -c 'mysql -u greylist -p'
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 21 to server version: 4.1.13

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

Please help! :(

Misty

Forums: 

FarmGrrl Wrote:
-------------------------------------------------------
> I've compiled libdvi, libdvi-drivers, and gps
> today. I compiled the libraries to live in /usr
> and gps to live in /usr/local/bin. I ran 'make
> check' on libdbi-drivers, and was able to connect
> to the DB. However gps is unable to connect to
> MySQL. Here is some info:
>
> libdbi-0.8.1
> libdbi-drivers-0.8.1
> gps-1.004

You also installed 'libdbi-dbd-mysql-0.8.1', didn't you? If not, this may be the problem.

> Feb 10 13:34:58 furnsrv gps[25156]: error while
> initialising: DB: no dbi drivers installed, or
> none found, NO GREYLISTING WILL BE DONE

It's not a separate package when compiled from source. You tell libdbi-drivers which drivers to build. The mySQL one was present. I've decided to use another greylisting facility because I had to get it working ASAP.

You didn't build RPM packages, did you? Shudder! This is usually a recipy for disaster in the long run on a system that uses RPM for package management.

If you're interested, I have SuSE 9.3 RPMs for libdbi, libdbi-drivers and gps available as a YaST installation source. Using these makes sure that the location of files is consistent throughout the packages. Send me a private message for the download location (not publicly available due to bandwidth constraints).

Arjen

Silly question, did you do make install on the db drivers as well as the base libdbi?

gps use libdbi-functions, last use libdbi-drivers

after make, you must do make install !!!

haseigel