List:General Discussion« Previous MessageNext Message »
From:michel Date:July 5 2010 10:55pm
Subject:re: Connection Diagnostic Tool
View as plain text  
I have been trying to figure this one out, but I don't have the skill sets
 here so I can use some help.

 I tried ' -h 127.0.0.1' in my bash shell and I get a command not found, so 
I
 am still really off-the-mark. Is there a place on the net I can look up 
what
 it does and how to run it?



 Thanks!

> ----- Original Message ----- 
> From: "Michael Dykman" <mdykman@stripped>
> To: "michel" <compukat@stripped>
> Sent: Saturday, July 03, 2010 11:37 PM
> Subject: Re: Connection Diagnostic Tool
>
>
> You are right..  Java never coonnects on that domain socket, it
> *always* used TCP.
>
> Check your credentials at the command line using -h 127.0.0.1 (or even
> the LAN ip, depending on how your JDBC connections are configured)
> which will force your client to connect via TCP, just as Java will.
>
> I expect that you will find that there are permission errors
> preventing the TCP connec which are not obvious when connecting via
> the domain socket.
>
> - michael
>
> On Sat, Jul 3, 2010 at 11:14 PM, michel <compukat@stripped> wrote:
>> Michael,
>>
>>
>> I am able to connect using the socket, so MySQL is working fine. The 
>> problem
>> is when 'SoftSlate Commerce' tries to connect as localhost. From what I 
>> have
>> been reading I am using the 'mysql.sock', but it's not at the default
>> '/tmp/mysql.sock', it's created in "/home/sgdev/mysql"; so it may bew 
>> that
>> I need a way to specify to 'SoftSlate Commerce' where the socket is.
>>
>>
>> Regards,
>>
>>
>>
>> Michel
>>
>>
>>
>> ----- Original Message ----- From: "Michael Dykman" <mdykman@stripped>
>> To: "michel" <compukat@stripped>
>> Cc: <mysql@stripped>
>> Sent: Saturday, July 03, 2010 2:43 PM
>> Subject: Re: Connection Diagnostic Tool
>>
>>
>> I use c3p0 to manage MySQL connections in my JVM stack and have for
>> years in many installations, I have never had to do anything special.
>> If I can connect to the server through the console at the command line
>> of the client machine using the same credentials, then the stack will
>> just work. Are you using Tomcat's JNDI config? I have always found
>> those to be a pain.. I manage my DataSource via Spring which I find
>> to be much more portable.
>>
>> At the end of the day, if you are able to connect manually as
>> described above but your Tomcat application cannot, it's is not a
>> MySQL problem.. It's more likely a Tomcat/JNDI problem. If you can't
>> connect via the command line (same client, same host, same
>> credentials), then we have a MySQL issue we can address as such.
>>
>> - michael dykman
>>
>>
>> On Sat, Jul 3, 2010 at 8:08 AM, michel <compukat@stripped> wrote:
>>>
>>> I am setting up the Softslate web store package that uses Hibernate to
>>> connect to MySQL. Softslate fails to connect to MysQL on the c3p0
>>> connection
>>> pooling. While I would love to solve this little problem it would be 
>>> wiser
>>> if I learn to diagnose the problem. Is there a tool that can run on the
>>> Tomcat server that can help me replicate/diagnose the problem? 
>>> Softslaste
>>> is
>>> running on the same box as MySQL.
>>>
>>>
>>> Thank you!
>>>
>>> --
>>> MySQL General Mailing List
>>> For list archives: http://lists.mysql.com/mysql
>>> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>>>
>>>
>>
>>
>>
>> --
>> - michael dykman
>> - mdykman@stripped
>>
>> May the Source be with you.
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>>
>>
>
>
>
> -- 
> - michael dykman
> - mdykman@stripped
>
> May the Source be with you. 

Thread
Connection Diagnostic Toolmichel3 Jul
  • Re: Connection Diagnostic ToolMichael Dykman3 Jul
re: Connection Diagnostic Toolmichel6 Jul
  • Re: Connection Diagnostic ToolRob Wultsch6 Jul
  • Re: Fixed Connection Diagnostic Toolmichel7 Jul
    • Re: Fixed Connection Diagnostic ToolMichael Dykman7 Jul
  • Re: Fixed Connection Diagnostic Toolmichel7 Jul