[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
