Help with MySQL on SuSE

Submitted by FarmGrrl on Fri, 02/10/2006 - 20:01

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: 
gps forum

Submitted by adkorte on Sat, 02/18/2006 - 21:22.

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

Submitted by FarmGrrl on Mon, 02/20/2006 - 14:23.

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.

Submitted by adkorte on Tue, 02/21/2006 - 22:15.

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

Submitted by bib on Sun, 02/26/2006 - 22:15.

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

Submitted by haseigel on Fri, 02/16/2007 - 17:17.

gps use libdbi-functions, last use libdbi-drivers

after make, you must do make install !!!

haseigel