Daryl Pawluk wrote:
> [EMAIL PROTECTED] wrote:
>
> > On 21 Aug, Daryl Pawluk wrote:
> > > mysql> select count(*) from Artist;
> > > +----------+
> > > | count(*) |
> > > +----------+
> > > | 1 |
> > > +----------+
> > > 1 row in set (0.01 sec)
> > >
> > > isn't this odd. haven't changed anything. but all the other problems
> > > persist.
> >
> > This makes sense -- it seems that the perl/DBI/mysql combination is
> > working as expected.
> >
> > > /usr/lib/mysql/libmysqlclient.so.9
> > > /usr/lib/mysql/libmysqlclient.so.9.0.0
> >
> > > i think these rpm's are just packaged differently?
> >
> > It sure looks this way. In the rpm header is said that the rpms were
> > built by RedHat. I would suggest to uninstall all of these RPMs and then
> > install the rpms that you can get from www.mysql.com. They are
> > definitely packaged differently.
> >
> > > could the problem be with perl 5.6.0?
> >
> > No, the perl stuff seems happy.
> >
> > --ruaok Freezerburn! All else is only icing. -- Soul Coughing
> >
> > Robert Kaye -- [EMAIL PROTECTED] http://moon.eorbit.net/~robert
> >
> > _______________________________________________
> > Obs-dev mailing list
> > [EMAIL PROTECTED]
> > http://www.freeamp.org/mailman/listinfo/obs-dev
>
> i tried installing the rpm's from mysql.com but i couldn't build obs. the
> link failed with undefined references to compress/uncompress in
> libmysqlclient.a, so i went back to the redhat rpms for now. here's
> something that may be of interest:
>
> [root@daryl log]# tail -f /var/log/mysqld.log
> /usr/libexec/mysqld, Version: 3.23.22-beta-log, started with:
> Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
> Time Id Command Argument
> 000821 18:32:44 1 Connect obs@localhost on
> 1 Init DB obs
> 1 Query select * from Album limit 1
> 1 Query select * from Artist limit 1
> 1 Query select * from Listitems limit 1
> 1 Query select * from Playlist limit 1
> 1 Query select * from RandomListitems limit 1
> 1 Query select * from RandomActive limit 1
> 1 Query select * from RandomSets limit 1
> 1 Query select * from Track limit 1
> 1 Query select * from VolumeList limit 1
> 1 Quit
>
> this is from running obsd. it doesn't look like the database connection
> failed.
>
> this is from obs.log:
>
> ----- Obsequieum started Mon Aug 21 18:32:44 2000
>
> ...and then obsd starts looping.
>
> another thing that seems peculiar to me (i'm not at all familiar with
> mysql):
>
> [root@daryl /root]# mysqladmin -h`hostname` -p status
> Enter password:
> mysqladmin: connect to server at 'daryl.pawluk' failed
> error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)'
>
> and yet
>
> [root@daryl /root]# mysqladmin -h localhost -p status
> Enter password:
> Uptime: 1411 Threads: 1 Questions: 12 Slow queries: 0 Opens: 15 Flush
> tables: 1 Open tables: 11 Queries per second avg: 0.009
>
> succeeds. could this mean anything?
>
> _______________________________________________
> Obs-dev mailing list
> [EMAIL PROTECTED]
> http://www.freeamp.org/mailman/listinfo/obs-dev
this is from trying to open localhost/obs in netscape:
/var/log/httpd/error_log:
DBI->connect failed: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13) at /var/www/cgi-bin/obs/album.pl line 64
DBI->connect failed: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13) at /var/www/cgi-bin/obs/album.pl line 64
DBI->connect failed: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13) at /var/www/cgi-bin/obs/artist.pl line 70
DBI->connect failed: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13) at /var/www/cgi-bin/obs/listsel.pl line 63
DBI->connect failed: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13) at /var/www/cgi-bin/obs/playlist.pl line 72
Can't call method "prepare" on an undefined value at
/var/www/cgi-bin/obs/playlist.pl line 306.
_______________________________________________
Obs-dev mailing list
[EMAIL PROTECTED]
http://www.freeamp.org/mailman/listinfo/obs-dev
