[Mono-list] Re: Web Service cannot connect to Database

[Robert Jordan]

Hi,

> Thanks for your suggestion. But it has nothing to do with TCP. Because I use the same webservice coding with ByteFX on Windows and trying to access the mysql database on Linux, I can access it without any problems at all. So I think the problem is lying somewhere else. 

Please try this command line on your linux server
and tell us what happens:

telnet localhost 3306

Thanks,
Rob

>  
> Regards,
> Ko Ko
> 
> Gonzalo Paniagua Javier <gonzalo at ximian.com> wrote:
> On Thu, 2005-09-29 at 00:15 -0700, Ko Ko wrote:
> 
>>Hi
>>
>>I got problem connecting to MySQL Database on Mono. I can run the
>>webservices. But when ever I try to invoke the database from
>>webservices it kept giving me this error
>>
>>The remote server returned an error: (500) Internal Server Error. 
>>Unable to connect to any of the specified MySQL hosts
>>
>>I am using ByteFX and also MySQL connector/Net. These are working fine
>>on Windows Platform when I tested with .Net. On Linux it cannot
>>connect to database. What could be the problem?
> 
> 
> Check the output of 'netstat -ltn'. If there's nothing listening on port
> 3306 (may be on 127.0.0.1 or 0.0.0.0), mysql is not running with TCP
> enabled and just listens on the unix socket.
> 
> -Gonzalo
> 
> 
> 
> _______________________________________________
> Mono-list maillist - Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
> 
> 
> 
> Reality starts with Dream 
> 
> 		
> ---------------------------------
> Yahoo! for Good
>  Click here to donate to the Hurricane Katrina relief effort. 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Mono-list maillist  -  Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list