Connection Diagnostic Tool

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=gcdmg-mysql-2@m.gmane.org

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 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 connect=
ion
> pooling. While I would love to solve this little problem it would be wise=
r
> 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: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail=
..com
>
>



--=20
- michael dykman
- mdykman@gmail.com

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=3Dgcdmg-mysql-2@m.gmane.o rg

re: Connection Diagnostic Tool

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"
> To: "michel"
> 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 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"
>> To: "michel"
>> Cc:
>> 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 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=mdykman@gmail.com
>>>
>>>
>>
>>
>>
>> --
>> - michael dykman
>> - mdykman@gmail.com
>>
>> 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=compukat@videotron.ca
>>
>>
>
>
>
> --
> - michael dykman
> - mdykman@gmail.com
>
> 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=gcdmg-mysql-2@m.gmane.org

Re: Connection Diagnostic Tool

On Mon, Jul 5, 2010 at 3:55 PM, michel wrote:
>
> 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!

I am pretty sure Michael that meant running the command line mysql client:
mysql -uuser -ppass -h127.0.0.1 -e 'select "hello world!"'


--
Rob Wultsch
wultsch@gmail.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Fixed Connection Diagnostic Tool

Thank you all for the help and info! This error happened because I started
MySQL with -bind-address=91.203.57.207; even if Softslate is given the
proper IP address and port number is fails on connection pooling. I fixed
the problem by setting the MySQL IP address to 127.0.0.1.

I am thinking that the reason is that the C3P0 connection pooling cannot
work on a 'remote' machine.


Michel


----- Original Message -----
From: "Rob Wultsch"
To: "michel"
Cc:
Sent: Tuesday, July 06, 2010 1:52 AM
Subject: Re: Connection Diagnostic Tool


> On Mon, Jul 5, 2010 at 3:55 PM, michel wrote:
>>
>> 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!
>
> I am pretty sure Michael that meant running the command line mysql client:
> mysql -uuser -ppass -h127.0.0.1 -e 'select "hello world!"'
>
>
> --
> Rob Wultsch
> wultsch@gmail.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=compukat@videotron.ca
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Fixed Connection Diagnostic Tool

C3P0 connection does, indeed work well on remote machines.. In fact,
I only deploy it locally on dev servers. My production systems all
use c3p0 on remote servers.

Again, if you can connect from the command line of your client machine
to the server *via TCP* with the same credentials as your DataSource
is using, then it will all just work fine. You appear to have
specified a bind address which made local TCP connections impossible.
Address that, and you sohuld have no trouble at all.

- md

On Tue, Jul 6, 2010 at 6:45 PM, michel wrote:
> Thank you all for the help and info! This error happened because I starte=
d
> MySQL with -bind-address=3D91.203.57.207; even if Softslate is given the
> proper IP address and port number is fails on connection pooling. I fixed
> the problem by setting the MySQL IP address to 127.0.0.1.
>
> I am thinking that the reason is that the C3P0 connection pooling cannot
> work on a 'remote' machine.
>
>
> Michel
>
>
> ----- Original Message ----- From: "Rob Wultsch"
> To: "michel"
> Cc:
> Sent: Tuesday, July 06, 2010 1:52 AM
> Subject: Re: Connection Diagnostic Tool
>
>
>> On Mon, Jul 5, 2010 at 3:55 PM, michel wrote:
>>>
>>> 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!
>>
>> I am pretty sure Michael that meant running the command line mysql clien=
t:
>> mysql -uuser -ppass -h127.0.0.1 -e 'select "hello world!"'
>>
>>
>> --
>> Rob Wultsch
>> wultsch@gmail.com
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dcompukat@videotron.=
ca
>>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail=
..com
>
>



--=20
- michael dykman
- mdykman@gmail.com

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=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Fixed Connection Diagnostic Tool

Mike, much thanks and I have it fixed!


The problem was that I screwed up setting the database permissions. I am
really happy that I learned about

"mysql -h"


It will be a great help!



Michel


----- Original Message -----
From: "Michael Dykman"
To: "michel"
Cc:
Sent: Tuesday, July 06, 2010 7:15 PM
Subject: Re: Fixed Connection Diagnostic Tool


C3P0 connection does, indeed work well on remote machines.. In fact,
I only deploy it locally on dev servers. My production systems all
use c3p0 on remote servers.

Again, if you can connect from the command line of your client machine
to the server *via TCP* with the same credentials as your DataSource
is using, then it will all just work fine. You appear to have
specified a bind address which made local TCP connections impossible.
Address that, and you sohuld have no trouble at all.

- md

On Tue, Jul 6, 2010 at 6:45 PM, michel wrote:
> Thank you all for the help and info! This error happened because I started
> MySQL with -bind-address=91.203.57.207; even if Softslate is given the
> proper IP address and port number is fails on connection pooling. I fixed
> the problem by setting the MySQL IP address to 127.0.0.1.
>
> I am thinking that the reason is that the C3P0 connection pooling cannot
> work on a 'remote' machine.
>
>
> Michel
>
>
> ----- Original Message ----- From: "Rob Wultsch"
> To: "michel"
> Cc:
> Sent: Tuesday, July 06, 2010 1:52 AM
> Subject: Re: Connection Diagnostic Tool
>
>
>> On Mon, Jul 5, 2010 at 3:55 PM, michel wrote:
>>>
>>> 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!
>>
>> I am pretty sure Michael that meant running the command line mysql
>> client:
>> mysql -uuser -ppass -h127.0.0.1 -e 'select "hello world!"'
>>
>>
>> --
>> Rob Wultsch
>> wultsch@gmail.com
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=compukat@videotron.ca
>>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=mdykman@gmail.com
>
>



--
- michael dykman
- mdykman@gmail.com

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=compukat@videotron.ca


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org