Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
mysql openssl Question
ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
Update one field with more fields from another table
Getting Identity after INSERT
ERROR 2002: Can 't connect to local MySQL server through socket
mysql test 4 1 fails with the gis test
MySQL Cluster Software
Downgrade Mysql from 4 to 3 23
Mysql 4 0 Oracle Stored Procedure Trigger Conversion
Can 't access mysql after kernel upgrade
Executing MySQL Commands From Within C Program
Comparing and writing out BLOBS
Preventing Duplicate Entries
FULLTEXT query format question
Strange behavior, Table Level Permission
Does the binary log enabling affect the MySQL performances?
mysql:it 's a db not a dbms how it 's possible?!
mysql have same function mthod as Oracle decode()
 
Problems connecting

Problems connecting

2006-07-20       - By Albert E. Whale

 Back
Reply:     1     2     3     4     5     6  

I am having a problem diagnosing the reason I am getting an error on one
of my MySQL Servers.  The script I am running works on one server, and
not another.  The Script connects to the MySQL Database and collects
information.  Here is one of the Errors I am receiving.

DBI::db=HASH(0x846067c)->disconnect invalidates 1 active statement
handle (either destroy statement handles or call finish on them before
disconnecting) at /var/www/html/.ServAdmin/ServerAdministrator.pm line 70.

Line 70 is:

   $dbh->disconnect();

I have un-installed and re-installed the DBD::mysql module, but I do not
know why this is still failing.  Any suggestions?

Here is a list of RPMs involved.

rpm -qa | grep -i mysql
php-mysql-4 (See http://sql-4.ora-code.com).3.10-7mdk
MySQL-client-4 (See http://ent-4.ora-code.com).1.12-2.1.101mdk
libmysql14-4.1.12-2.1.101mdk
libmysql14-devel-4 (See http://vel-4.ora-code.com).1.12-2.1.101mdk
libmysql15-5.0.2-0.3mdk
libmysql12-4.0.20-3.5.101mdk
perl-DBD-mysql-3 (See http://sql-3.ora-code.com).0002-1mdk
MySQL-common-4 (See http://mon-4.ora-code.com).1.12-2.1.101mdk
MySQL-4 (See http://SQL-4.ora-code.com).1.12-2.1.101mdk

I have no idea where to look for this issue.

I am also aware that the following Perl Directories are on the server:

cd /usr/lib/perl5
ls
5.8.5/  5.8.6/  site_perl/  vendor_perl/

Any suggestion where I should look for this error?

--
Albert E. Whale, CHS CISA CISSP
Sr. Security, Network, Risk Assessment and Systems Consultant
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ----
ABS Computer Technology, Inc. - www.ABS-CompTech.com
SPAM Zapper - No-JunkMail.com - Spam-Zapper.com - SPAM Stops Here.


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=mysql@(protected)