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