sqlgrey-users

[Sqlgrey-users] DBD::MySQL help!

[Joshua B. <jb...@at...>]

Hey guys, I seem to have a problem I was hoping someone could shed some
light on.   I am running CentOS 4, and I have installed sqlgrey from the
sqlgrey-1.6.7-1.noarch.rpm.  I have installed all the pre-requisites,
however when I go to launch sqlgrey from the init script, I see the
following in my logs:


fatal: Can't locate DBD/MySQL.pm in @INC (@INC contains:
/usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi /usr/lib/perl5/5.8.5
/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi
/usr/lib64/perl5/site_perl/5.8.4/x86_64-linux-thread-multi
/usr/lib64/perl5/site_perl/5.8.3/x86_64-linux-thread-multi
/usr/lib64/perl5/site_perl/5.8.2/x86_64-linux-thread-multi
/usr/lib64/perl5/site_perl/5.8.1/x86_64-linux-thread-multi
/usr/lib64/perl5/site_perl/5.8.0/x86_64-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl/5.8.4
/usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl/5.8.2
/usr/lib/perl5/site_perl/5.8.1 /usr/lib/perl5/site_perl/5.8.0
/usr/lib/perl5/site_perl
/usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi
/usr/lib64/perl5/vendor_perl/5.8.4/x86_64-linux-thread-multi
/usr/lib64/perl5/vendor_perl/5.8.3/x86_64-linux-thread-multi
/usr/lib64/perl5/vendor_perl/5.8.2/x86_64-linux-thread-multi
/usr/lib64/perl5/vendor_perl/5.8.1/x86_64-linux-thread-multi /usr/lib64/p
Jun 18 23:34:37 vps-100_mx1 sqlgrey: fatal: install_driver(MySQL) failed:
Can't locate DBD/MySQL.pm in @INC (@INC contains:
/usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi /usr/lib/perl5/5.8.5
/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi
/usr/lib64/perl5/site_perl/5.8.4/x86_64-linux-thread-multi
/usr/lib64/perl5/site_perl/5.8.3/x86_64-linux-thread-multi
/usr/lib64/perl5/site_perl/5.8.2/x86_64-linux-thread-multi
/usr/lib64/perl5/site_perl/5.8.1/x86_64-linux-thread-multi
/usr/lib64/perl5/site_perl/5.8.0/x86_64-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl/5.8.4
/usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl/5.8.2
/usr/lib/perl5/site_perl/5.8.1 /usr/lib/perl5/site_perl/5.8.0
/usr/lib/perl5/site_perl
/usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi
/usr/lib64/perl5/vendor_perl/5.8.4/x86_64-linux-thread-multi
/usr/lib64/perl5/vendor_perl/5.8.3/x86_64-linux-thread-multi
/usr/lib64/perl5/vendor_perl/5.8.2/x86_64-linux-thread-multi


However,  DBD::MySQL is installed, as follows

[root@vps-100_mx1 src]# rpm -qi perl-DBD-MySQL-2.9004-3.1.centos4
Name        : perl-DBD-MySQL               Relocations: (not relocatable)
Version     : 2.9004                            Vendor: CentOS
Release     : 3.1.centos4                   Build Date: Sun May 20 15:06:51
2007
Install Date: Tue Jun 19 00:42:35 2007      Build Host: v20z-x86-64
Group       : Applications/Databases        Source RPM:
perl-DBD-MySQL-2.9004-3.1.centos4.src.rpm
Size        : 243733                           License: distributable
Signature   : DSA/SHA1, Sun May 20 15:48:02 2007, Key ID a53d0bab443e1821
Packager    : Johnny Hughes <jo...@ce...>
URL         : http://search.cpan.org/search?query=DBD%3A%3AMySQL
Summary     : A MySQL interface for perl
Description :
An implementation of DBI for MySQL for Perl.
[root@vps-100_mx1 src]# rpm -ql perl-DBD-MySQL-2.9004-3.1.centos4
/usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi/Bundle/DBD/mysq
l.pm
/usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi/DBD/mysql.pm
/usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi/DBD/mysql/GetIn
fo.pm
/usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi/DBD/mysql/INSTA
LL.pod
/usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi/Mysql.pm
/usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi/Mysql/Statement
.pm
/usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi/auto/DBD/mysql/
mysql.bs
/usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi/auto/DBD/mysql/
mysql.so
/usr/share/man/man3/Bundle::DBD::mysql.3pm.gz
/usr/share/man/man3/DBD::mysql.3pm.gz
/usr/share/man/man3/DBD::mysql::INSTALL.3pm.gz
/usr/share/man/man3/Mysql.3pm.gz
 

Can anyone offer any suggestions?


-JB

Re: [Sqlgrey-users] DBD::MySQL help!

[Daniel J M. <dan...@au...>]

On Mon, 2007-06-18 at 14:22 -0700, Joshua Brewer wrote:
> 
> 
> 
> 
> Hey guys, I seem to have a problem I was hoping someone could shed some
> light on.   I am running CentOS 4, and I have installed sqlgrey from the
> sqlgrey-1.6.7-1.noarch.rpm.  I have installed all the pre-requisites,
> however when I go to launch sqlgrey from the init script, I see the
> following in my logs:
> 
> 
> fatal: Can't locate DBD/MySQL.pm in @INC (@INC contains:
[...]
> /usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi/DBD/mysql.pm
>  
> 
> Can anyone offer any suggestions?

Case matters.

-- 
Daniel J McDonald, CCIE # 2495, CISSP # 78281, CNX
Austin Energy
http://www.austinenergy.com

Re: [Sqlgrey-users] DBD::MySQL help!

[Joshua B. <jb...@at...>]

Jeeze, I feel like an idiot.


I've copied the mysql.pm to MySQL.pm, and now something new in the logs:

Jun 19 03:25:00 vps-100_mx1 sqlgrey: fatal: Can't locate object method
"driver" via package "DBD::MySQL" at
/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/DBI.pm line 782.
Jun 19 03:25:00 vps-100_mx1 sqlgrey: fatal: DBD::MySQL initialisation
failed: Can't locate object method "driver" via package "DBD::MySQL" at
/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/DBI.pm line 782.
Perhaps the capitalisation of DBD 'MySQL' isn't right. at /usr/sbin/sqlgrey
line 775 

Does this mean im not crazy?




On 6/18/07 2:27 PM, "Daniel J McDonald" <dan...@au...>
wrote:

> On Mon, 2007-06-18 at 14:22 -0700, Joshua Brewer wrote:
>> 
>> 
>> 
>> 
>> Hey guys, I seem to have a problem I was hoping someone could shed some
>> light on.   I am running CentOS 4, and I have installed sqlgrey from the
>> sqlgrey-1.6.7-1.noarch.rpm.  I have installed all the pre-requisites,
>> however when I go to launch sqlgrey from the init script, I see the
>> following in my logs:
>> 
>> 
>> fatal: Can't locate DBD/MySQL.pm in @INC (@INC contains:
> [...]
>> /usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi/DBD/mysql.pm
>>  
>> 
>> Can anyone offer any suggestions?
> 
> Case matters.

Re: [Sqlgrey-users] DBD::MySQL help!

[Daniel J M. <dan...@au...>]

On Mon, 2007-06-18 at 15:09 -0700, Joshua Brewer wrote:
> 
> 
> 
> 
> 
> Jeeze, I feel like an idiot.
> 
> 
> I've copied the mysql.pm to MySQL.pm, and now something new in the logs:
> 
> Jun 19 03:25:00 vps-100_mx1 sqlgrey: fatal: Can't locate object method
> "driver" via package "DBD::MySQL" at
> /usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/DBI.pm line 782.
> Jun 19 03:25:00 vps-100_mx1 sqlgrey: fatal: DBD::MySQL initialisation
> failed: Can't locate object method "driver" via package "DBD::MySQL" at
> /usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/DBI.pm line 782.
> Perhaps the capitalisation of DBD 'MySQL' isn't right. at /usr/sbin/sqlgrey
> line 775 
> 
> Does this mean im not crazy?

your database reference should all be lower case:

[mcdonalddj@sa ~]$ grep -i mysql  /etc/sqlgrey/sqlgrey.conf 
# instead of Pg below use "mysql" for MySQL, "SQLite" for SQLite
db_type = mysql

> 
> 
> 
> 
> On 6/18/07 2:27 PM, "Daniel J McDonald" <dan...@au...>
> wrote:
> 
> > On Mon, 2007-06-18 at 14:22 -0700, Joshua Brewer wrote:
> >> 
> >> 
> >> 
> >> 
> >> Hey guys, I seem to have a problem I was hoping someone could shed some
> >> light on.   I am running CentOS 4, and I have installed sqlgrey from the
> >> sqlgrey-1.6.7-1.noarch.rpm.  I have installed all the pre-requisites,
> >> however when I go to launch sqlgrey from the init script, I see the
> >> following in my logs:
> >> 
> >> 
> >> fatal: Can't locate DBD/MySQL.pm in @INC (@INC contains:
> > [...]
> >> /usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi/DBD/mysql.pm
> >>  
> >> 
> >> Can anyone offer any suggestions?
> > 
> > Case matters.
> 
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Sqlgrey-users mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlgrey-users

Re: [Sqlgrey-users] DBD::MySQL help!

[Joshua B. <jb...@at...>]

Gotcha, that did it, thanks again




On 6/18/07 3:19 PM, "Daniel J McDonald" <dan...@au...>
wrote:

> On Mon, 2007-06-18 at 15:09 -0700, Joshua Brewer wrote:
>> 
>> 
>> 
>> 
>> 
>> Jeeze, I feel like an idiot.
>> 
>> 
>> I've copied the mysql.pm to MySQL.pm, and now something new in the logs:
>> 
>> Jun 19 03:25:00 vps-100_mx1 sqlgrey: fatal: Can't locate object method
>> "driver" via package "DBD::MySQL" at
>> /usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/DBI.pm line 782.
>> Jun 19 03:25:00 vps-100_mx1 sqlgrey: fatal: DBD::MySQL initialisation
>> failed: Can't locate object method "driver" via package "DBD::MySQL" at
>> /usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/DBI.pm line 782.
>> Perhaps the capitalisation of DBD 'MySQL' isn't right. at /usr/sbin/sqlgrey
>> line 775 
>> 
>> Does this mean im not crazy?
> 
> your database reference should all be lower case:
> 
> [mcdonalddj@sa ~]$ grep -i mysql  /etc/sqlgrey/sqlgrey.conf
> # instead of Pg below use "mysql" for MySQL, "SQLite" for SQLite
> db_type = mysql
> 
>> 
>> 
>> 
>> 
>> On 6/18/07 2:27 PM, "Daniel J McDonald" <dan...@au...>
>> wrote:
>> 
>>> On Mon, 2007-06-18 at 14:22 -0700, Joshua Brewer wrote:
>>>> 
>>>> 
>>>> 
>>>> 
>>>> Hey guys, I seem to have a problem I was hoping someone could shed some
>>>> light on.   I am running CentOS 4, and I have installed sqlgrey from the
>>>> sqlgrey-1.6.7-1.noarch.rpm.  I have installed all the pre-requisites,
>>>> however when I go to launch sqlgrey from the init script, I see the
>>>> following in my logs:
>>>> 
>>>> 
>>>> fatal: Can't locate DBD/MySQL.pm in @INC (@INC contains:
>>> [...]
>>>> /usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi/DBD/mysql.pm
>>>>  
>>>> 
>>>> Can anyone offer any suggestions?
>>> 
>>> Case matters.
>> 
>> 
>> 
>> -------------------------------------------------------------------------
>> This SF.net email is sponsored by DB2 Express
>> Download DB2 Express C - the FREE version of DB2 express and take
>> control of your XML. No limits. Just data. Click to get it now.
>> http://sourceforge.net/powerbar/db2/
>> _______________________________________________
>> Sqlgrey-users mailing list
>> Sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sqlgrey-users
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Sqlgrey-users mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlgrey-users