For whatever reason, it appeared to be looking for a libmySQL.so; however my
installation did not have such a beast...
Here is what I have (a Redhat 7.3 installation--I used the Mysql rpms not
the redhat rpms...)
[root@devserver root]# rpm -qa | grep -i mysql
MySQL-python-0.9.1-1
MySQL-devel-3.23.54a-1
MySQL-shared-3.23.54a-1
Mnogosearch-mysql-3.1.20-1
MySQL-3.23.54a-1
MySQL-client-3.23.54a-1
php-mysql-4.1.2-7.3.6
MySQL-Max-3.23.54a-1
For testing purposes here is what I did:
cd /usr/lib
rm libmySQL.so (its only a link)
cd /usr2/csharp (where I copied the .cs file)
mcs TestMySqlExecuteReader.cs -r System.Data.dll -r Mono.Data.MySql.dll
mono TestMySqlExecuteReader.exe
Started.
Create MySQL Connection...
** (TestMySqlExecuteReader.exe:23470): WARNING **: Failed to load library
libmySQL (libmySQL): libmySQL.so: cannot open shared object file: No such
file or directory
Open the connection...
Unhandled Exception: System.NullReferenceException: Object reference not set
to an instance of an object
in <0x00025> 06 Mono.Data.MySql.MySql:Init (intptr)
in <0x00187> 00 Mono.Data.MySql.MySqlConnection:Open ()
in <0x000f5> 00 TestSystemDataSqlClient.TestSqlDataReader:Main (string[])
Now if I:
cd /usr/lib
ln -s libmysqlclient.so libmySQL.so
mono TestMySqlExecuteReader.exe
Output:
Started.
Create MySQL Connection...
** (TestMySqlExecuteReader.exe:23552): WARNING **: Failed to load function
my_thread_end from libmySQL
** (TestMySqlExecuteReader.exe:23552): WARNING **: Failed to load function
my_thread_end from libmySQL
** (TestMySqlExecuteReader.exe:23552): WARNING **: Failed to load function
my_thread_init from libmySQL
** (TestMySqlExecuteReader.exe:23552): WARNING **: Failed to load function
my_thread_init from libmySQL
Open the connection...
select * from testable
Create command...
ExecuteReader...
Reading data...
Row: 1
{all the expected and correct data follow}
Clean up...
Unhandled Exception: System.NullReferenceException: Object reference not set
to an instance of an object
in <0x00025> 06 Mono.Data.MySql.MySql:ThreadEnd ()
in <0x000b5> 00 Mono.Data.MySql.MySqlConnection:CloseDataSource ()
in <0x00053> 00 Mono.Data.MySql.MySqlConnection:Close ()
in <0x00411> 00 TestSystemDataSqlClient.TestSqlDataReader:Main (string[])
HTH,
Steven Balthazor
-----Original Message-----
From: Daniel Morgan [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 04, 2003 2:28 AM
To: Steven Balthazor; 'Rolf Tollerud'; [EMAIL PROTECTED]
Subject: RE: [Mono-list] MySQL Data Provider for MySQL (Mono 0.17)
Hmmm... I'm not sure.
What version of the MySQL client library are you using? Where did you get
it?
The MySQL provider in mono was built for the Production version of MySQL
3.23.xx.
I wonder if there is a tracing or debugging mechanism in mono we could use
to see what it is doing.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Steven Balthazor
Sent: Friday, January 03, 2003 3:36 PM
To: 'Rolf Tollerud'; [EMAIL PROTECTED]
Subject: RE: [Mono-list] MySQL Data Provider for MySQL (Mono 0.17)
I had a similar problem (if I remember correctly). To get it to compile
correctly on Linux I had to add a link from /usr/lib/libmysqlclient.so to
/usr/lib/libmySQL.so e.g.: ln -s libmysqlclient.so libmySQL.so
Cheers,
Steven Balthazor
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
Behalf Of Rolf Tollerud
Sent: Friday, January 03, 2003 1:02 PM
To: [EMAIL PROTECTED]
Subject: [Mono-list] MySQL Data Provider for MySQL (Mono 0.17)
When I try to run MySqlTest (which compiles just fine) on windows XP I get
following error messages:
(mono MySqlTest.exe)
** (MySqlTest.exe:3924): WARNING **: Failed to load function mysql_connect
from libmySQL
** (MySqlTest.exe:3924): WARNING **: Failed to load function mysql_connect
from libmySQL
Unhandled Exception: System.NullReferenceException: Object reference not set
to an instance of an object in <0x00025> 06 Mono.Data.MySql.MySql:Connect
(intptr,string,string,string,string,uint,string,uint)
in <0x003e6> 00 Mono.Data.MySql.MySqlConnection:Open ()
in <0x00057> 00 Test.Mono.Data.MySql.MySqlTest:Main (string[])
Why will it not load mysql_connect? Apparently its loads all the other
functions from libmySQL.dll..
_______________________________________________
Mono-list maillist - [EMAIL PROTECTED]
http://lists.ximian.com/mailman/listinfo/mono-list
_______________________________________________
Mono-list maillist - [EMAIL PROTECTED]
http://lists.ximian.com/mailman/listinfo/mono-list
