Please disregard the previous email.

[Patrick Kaldawy]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hi,

I Apologize for not making myself clear earlier. I have just start working on MonoDevelop and i am currently learning it and exploring my way around it. below is my real issue.

I have developed a console application using .NET 2.0 (C#) on windows and compiled it with MONO. The application mainly connects to a MySQL DB and retrieves data. I used the MySQL (mysql.data.dll) connector to do so. Now, i'm running this application from a Linux server and the DB is local to the server, attached is the log file of the error i am getting. Can anyone help me with that?.

I registered the connector in the GAC. Is there anything else i should be doing? Is there any configuration that I'm missing?

Thank You.

Regards,

Patrick Kaldawy

---

Windows 7: I wanted more reliable, now it's more reliable. Wow!
[root@veechi01 rb]# mono VeechiResumeBuilder.exe 1


Retrieving Data from Veechi DB (UserID = 1)...


Unhandled Exception: MySql.Data.MySqlClient.MySqlException:
Unable to connect to any of the specified MySQL hosts. --->
System.Net.Sockets.SocketException: Connection refused
  at System.Net.Sockets.Socket.Connect (System.Net.EndPoint remote_end) [0x00000]
  at System.Net.Sockets.Socket+Worker.Connect () [0x00000] --- End of inner exception stack trace ---

  at MySql.Data.MySqlClient.NativeDriver.Open () [0x00000]
  at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x00000]
  at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection () [0x00000]
  at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection () [0x00000]
  at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver () [0x00000]


_______________________________________________
Monodevelop-list mailing list
Monodevelop-list@...
http://lists.ximian.com/mailman/listinfo/monodevelop-list

[Ian Norton-Badrul-2]

On Fri, 2009-10-30 at 07:02 +0000, Patrick Kaldawy wrote:
> System.Net.Sockets.SocketException: Connection refused

Suggests your mysql server is not running or not listening on the port
you expect.

What do you get from running:-

$ netstat -ln -p|grep mysql

Ian

_______________________________________________
Monodevelop-list mailing list
Monodevelop-list@...
http://lists.ximian.com/mailman/listinfo/monodevelop-list

[Slug]

Ian Norton-Badrul-2 wrote:

Suggests your mysql server is not running or not listening on the port you expect. What do you get from running:-

$ netstat -ln -p|grep mysql

That is the winning solution...

In my case the IP address was the referring to the server's IP address (10.0.0.123:3306) rather than localhost (127.0.0.1:3306). Putting the IP address in the connection string (rather than using 'localhost') finally got it to work.

Now I just have to figure out how to get MYSQL listening on both. Documentation must exist on that somewhere.

Thanks for the great post.