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" <mdyk...@gmail.com>
To: "michel" <compu...@videotron.ca>
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 <compu...@videotron.ca> 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" <mdyk...@gmail.com>
To: "michel" <compu...@videotron.ca>
Cc: <mysql@lists.mysql.com>
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 <compu...@videotron.ca> 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=mdyk...@gmail.com
--
- michael dykman
- mdyk...@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=compu...@videotron.ca
--
- michael dykman
- mdyk...@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=arch...@jab.org
