Hi Yves, all!
Yves Goergen wrote:
On 31.05.2006 10:21 (+0100), Joerg Bruehe wrote:
According to your description below, where you got Could not connect
..., you are given this warning if establishing the connection fails.
So the remaining case is a client trying to connect to a server which
On 31.05.2006 12:47 (+0100), Joerg Bruehe wrote:
I said I am no SSL expert, I just go by this quote from the manual:
Yes, I saw that. But it doesn't apply on Query Browser because there is
no such option available in the UI.
Btw, I cannot connect to MySQL5+SSL with Query Browser/Win but I can
On 31.05.2006 14:46 (+0100), Paul DuBois wrote:
--ssl on the client side (mysql) isn't sufficient to enable an SSL
connection, as stated in the manual. That's why Joerg indicated the
use of the other options.
Why do I need to provide the client with a certificate? I don't have one
and I also
On 21.05.2006 00:16 (+0100), Yves Goergen wrote:
Hello,
I'm using MySQL Query Browser on Windows XP to connect to a remote MySQL
4.0 and 5.0 database server, both on Linux. In Query Browser, I can
check the options Use SSL if available but how do I know if it is
available and used? I couldn't
Hi Yves, all!
Yves Goergen wrote:
On 21.05.2006 00:16 (+0100), Yves Goergen wrote:
Hello,
I'm using MySQL Query Browser on Windows XP to connect to a remote MySQL
4.0 and 5.0 database server, both on Linux. In Query Browser, I can
check the options Use SSL if available but how do I know if it
On 30.05.2006 16:28 (+0100), Joerg Bruehe wrote:
To find out whether your server(s) support(s) or not, you need to check
the corresponding variables. All this is described in the manual,
section 5.9.7. Using Secure Connections:
I still think that the client should actually inform me when I
On 21.05.2006 07:35 (+0100), paul rivers wrote:
Are you certain? Which version are you running?
I don't have it on MySQL 4.0 and on MySQL 5.0 it has the value 0 so I
guess it's not connecting through SSL.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
http://beta.unclassified.de – My web
Why am I suddenly getting huge volumes of mail about SQL? What forum is
this, and how do I get out of it?
++
Phil Robbins
Auckland
New Zealand
++
_
Discover fun and games at @
Hello,
I'm using MySQL Query Browser on Windows XP to connect to a remote MySQL
4.0 and 5.0 database server, both on Linux. In Query Browser, I can
check the options Use SSL if available but how do I know if it is
available and used? I couldn't find any SQL command to show me the
encryption status
I've wrestled with the same question. The only options I came up with were:
- Do as you suggest and require SSL for the account.
- Inspect the 'show status' variable of Ssl_accepts after a connection
attempt on an otherwise quiet mysql instance.
- Sniff the traffic between client and server
, May 20, 2006 3:39 PM
To: 'Yves Goergen'; 'List: MySQL'
Subject: RE: How to find out about SSL connection?
I've wrestled with the same question. The only options I came up with were:
- Do as you suggest and require SSL for the account.
- Inspect the 'show status' variable of Ssl_accepts after
On 21.05.2006 00:38 (+0100), paul rivers wrote:
- Inspect the 'show status' variable of Ssl_accepts after a connection
attempt on an otherwise quiet mysql instance.
I have no such status variable in my server.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
http://beta.unclassified.de – My web
Has anyone implemented connection pooling in C# .NET?
On 5/8/06, romyd misc [EMAIL PROTECTED] wrote:
What i meant by implementing connection pooling i meant if i need to do
any code changes other than changes in connection string.
Thanks,
Romy
On 5/8/06, Tim Lucia [EMAIL PROTECTED] wrote
Hi Everyone,
I'm developing an application using C# .NET and mysql as database. It's a
multithreaded application, we open a mysql database connection at the very
beginning when the application is started and all the database requests use
the same connection. But under stress or when more than
I don't hear you need to implement connection pooling. Maybe, but I think
you might still have errors under load, as you approach the maximum
connection count in the pool.
Tim
-Original Message-
From: romyd misc [mailto:[EMAIL PROTECTED]
Sent: Monday, May 08, 2006 2:37 PM
To: mysql
romyd misc said:
Hi Everyone,
I'm developing an application using C# .NET and mysql as database. It's a
multithreaded application, we open a mysql database connection at the very
beginning when the application is started and all the database requests
use
the same connection. But under
What i meant by implementing connection pooling i meant if i need to do any
code changes other than changes in connection string.
Thanks,
Romy
On 5/8/06, Tim Lucia [EMAIL PROTECTED] wrote:
I don't hear you need to implement connection pooling. Maybe, but I
think
you might still have errors
It sounds like you need to either synchronize access to 'the connection'
(one user at a time), or have a connection per request. In the latter case,
obtaining a connection from a pool of connections makes sense.
Unfortunately, I have only done this with Java -- not with .NET. I would
Service in Control Panel of my machine Window Xp,
I can still make connection to the mysql database with the old password of the
user 'root'.
Only when I Stop and Start again the mysql from Service in Control Panel ,
the connection to the mysql database with the old password of the user 'root
[snip]
My question is I hope the new password will be effective for connection
immediately
without ' Stop and Start ' the mysql Service.
[/snip]
Instead of stopping and starting the service you should do the following
query;
FLUSH PRIVILEGES;
That will cause new passwords to take effect
In the last episode (Apr 04), NanFei Wang said:
I want to change the password of the User( which is root) in the
table 'user' from the database 'mysql'.
I use the String sql = update user set
Password=password('somePassWord') where User='root'; I see from
MySql Query Browser the password
Only if you run this SQL statement:
*FLUSH PRIVILEGES*
That will make the new password effective.
--
Gabriel PREDA
Senior Web Developer
still make connection to the mysql database with the old password of
the user 'root'.
Only when I Stop and Start again the mysql from Service in Control Panel ,
the connection to the mysql database with the old password of the user
'root' will fail,
and with the new password of the user 'root
forwarded
MySQL connection was taken as a local connection. But my own testing
cannot agree with that. I'm confused. Here is what I did:
On server1:
server1% ssh -2 -l myusername -N -L 3307:server2:3306 server2
server1% mysql -P 3307 (in another term window)
ERROR 1045 (28000): Access
in port forwarding , all you are saying is !!ok, if server1 gets any
connection on port 3307 then forward that connection to port 3306 on
server2, so essentially the connection on server2 for Mysql is coming from
the client on server1 , so the user you are using to connect to server2 from
server1
connection was taken as a local connection. But my own testing
cannot agree with that. I'm confused. Here is what I did:
On server1:
server1% ssh -2 -l myusername -N -L 3307:server2:3306 server2
server1% mysql -P 3307 (in another term window)
ERROR 1045 (28000): Access denied for user
forwarded
MySQL connection was taken as a local connection. But my own testing
cannot agree with that. I'm confused. Here is what I did:
On server1:
server1% ssh -2 -l myusername -N -L 3307:server2:3306 server2
server1% mysql -P 3307 (in another term window)
ERROR 1045 (28000): Access
Hello,
again, I'm having problems with InnoDB tables. A certain table cannot be
dropped. If I'm issueing the drop table statement, the connection is
lost and I get the following in the logfile:
060327 14:38:11 InnoDB: error: space object of table db15670/mw_pagelinks,
InnoDB: space id 12
Sent: Monday, March 27, 2006 3:46 PM
Subject: ERROR 2013 (HY000): Lost connection to MySQL server during query
Hello,
again, I'm having problems with InnoDB tables. A certain table cannot be
dropped. If I'm issueing the drop table statement, the connection is
lost and I get the following
Is there anything I can put into the my.cnf file to buffer connection
(leave it open) to give a similar effect as connection pooling?
Thanks in advance!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I think you are asking for mysql_pconnect(localhost,root)
-Original Message-
From: Cory at SkyVantage [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 22, 2006 2:20 PM
To: MySQL-List
Subject: Connection Buffer
Is there anything I can put into the my.cnf file to buffer
connection
(leave
wait_timeout setting would leave the connection/thread open for the
defined time even after the query has been executed..
Kishore Jalleda
On 3/22/06, Cory at SkyVantage [EMAIL PROTECTED] wrote:
Is there anything I can put into the my.cnf file to buffer connection
(leave it open) to give
]
To: mysql@lists.mysql.com
Sent: Tue, 14 Mar 2006 13:37:55 -0500
Subject: MySQL JDBC Exception: No operations allowed after connection
closed
I use Tomcat 5.0.28 on both Fedora and FreeBSD, MySQL 4.1.14,
J/Connector JDBC driver for MySQL 3.1.11 and JOTM 2.0.10. From time to
time I get the MySQL JDBC
I use Tomcat 5.0.28 on both Fedora and FreeBSD, MySQL 4.1.14,
J/Connector JDBC driver for MySQL 3.1.11 and JOTM 2.0.10. From time to
time I get the MySQL JDBC driver exception No operations allowed after
connection closed, after which DB calls from my application keep
failing. The stack trace
I have MySQL 5 installed on My Machine,
But it could handle only max about 350 concurrent mysql connection
Unbelieveable, i have 4 Gbytes, but on the next 351 connection i always
got Can't create a new thread (errno 12); if you are not out of
available memory, you can consult the manual
concurrent mysql connection
Unbelieveable, i have 4 Gbytes, but on the next 351 connection i always
got Can't create a new thread (errno 12); if you are not out of
available memory, you can consult the manual for
a possible OS-dependent bug in
Is it mysql bug, incorrect Linux setting or what
assigned 2G to innodb buffer and other buffers and your kernel lets you
to go upto 2G for user space process. For each connection coming MySQL
dedicates at least 128K (thread size) memory, so for 350 connection, you
end up using +43M memory which makes MySQL's total mem usage 2G + 43M.
This may
connection
Unbelieveable, i have 4 Gbytes, but on the next 351 connection i always
got Can't create a new thread (errno 12); if you are not out of
available memory, you can consult the manual for
a possible OS-dependent bug in
Is it mysql bug, incorrect Linux setting or what?
--
MySQL
lets you
to go upto 2G for user space process. For each connection coming MySQL
dedicates at least 128K (thread size) memory, so for 350 connection, you
end up using +43M memory which makes MySQL's total mem usage 2G + 43M.
This may be the reason why you're seeing can't create new thread.
Kayra
itself to be very stable. The
Windows version of MySQL has the same features as the
corresponding Unix version, with the following exceptions:
Limited number of ports
Windows systems have about 4,000 ports available for client
connections, and after a connection on a port closes, it
takes two
ports available for client
connections, and after a connection on a port closes, it
takes two to four minutes before the port can be reused. In
situations where clients connect to and disconnect from the
server at a high rate, it is possible for all available
ports to be used up before
I have been experiencing some weird MySQL connection issues lately.
Twice now in that last couple weeks, there have been times where some
mysql applications are working, and others are not working. Both times
the mysql connection limit was rather high. A simple mysql restart has
fixed
.
But afterwards, on the second and subsequent attempts, the database
runs fine. It is only the first try after a long idle period that I
get this error message. I am not sure how to fix this. I am
guessing that the database connection is down after a long idle
period and have to recreate
Hi all,
I'd like to clarify on this odd issue. It seems to me that MySQL will
automatically drop database handles, assumably if the handle has not
been used for some time. Is this true? If so, how can I disable timeout?
This is an unexpected behavior, because I have tried MSSQL and Postgre,
, on the second and subsequent attempts, the database
runs fine. It is only the first try after a long idle period that I
get this error message. I am not sure how to fix this. I am
guessing that the database connection is down after a long idle
period and have to recreate a connection first after
nct domain from email_table where domain='bob.com'" gave DEFER: MYSQL connection failed: Can't connect to MySQL server on '127.0.0.1' (61)(where bob.com is one of our customer's domains that we host.)This has been happening for months, and I'm trying to get rid of these errors. The come in bursts - i
'}{$value}} while checking a list: lookup of select distinct
domain from email_table where domain='bob.com' gave DEFER: MYSQL connection
failed: Can't connect to MySQL server on '127.0.0.1' (61)
(where bob.com is one of our customer's domains that we host.)
This has been happening for months
Casey,
in a Terminal window, type
ps -ef | grep -i mysql
and see if there is a mysqld process actually running and not a zombie
(defunct).
See if you can connect on the localhost.
See if the socket exists.
I'd bet that one of those three will find your problem. Please let
us know if this
Hi,
Use this :
ps awux | grep mysqld -i
On 2/4/06, Casey Rhodes [EMAIL PROTECTED] wrote:
Casey,
in a Terminal window, type
ps -ef | grep -i mysql
and see if there is a mysqld process actually running and not a zombie
(defunct).
See if you can connect on the localhost.
See if the
if this helps.
-Sheeri
On 2/2/06, Rhodes, Casey [EMAIL PROTECTED] wrote:
When testing my connection via Dreamweave MX, I get the following error
message:
2002 Can't connect to local MySQL server through socket
'/var/mysql/mysql.sock' (2)
It was suggested to me that the server may
I'm trying to set up SSL connectivity to a Fedora Core 4 server running
mysql-server-4.1.16-1.FC4.1 and not having much success. I keep getting
ERROR 2026 (HY000): SSL connection error
no matter what I do.
I followed the directions on
http://dev.mysql.com/doc/refman/4.1/en/secure-create
When testing my connection via Dreamweave MX, I get the following error message:
2002 Can't connect to local MySQL server through socket '/var/mysql/mysql.sock'
(2)
It was suggested to me that the server may not be running, though when I go to
my System Preferences Panel (MacOSX), I have
:
To: mysql@lists.mysql.com
From: Rhodes, Casey [EMAIL PROTECTED]
Subject: MySQL Connection Problem
When testing my connection via Dreamweave MX, I get the
following error message:
2002 Can't connect to local MySQL server through socket
'/var/mysql/mysql.sock' (2
and subsequent attempts, the database
runs fine. It is only the first try after a long idle period that I
get this error message. I am not sure how to fix this. I am guessing
that the database connection is down after a long idle period and have
to recreate a connection first after the first try.
Hi
, the database runs
fine. It is only the first try after a long idle period that I get this
error message. I am not sure how to fix this. I am guessing that the
database connection is down after a long idle period and have to
recreate a connection first after the first try.
--
MySQL General Mailing
night when doing a
numeric comparison on a varchar column. Oops.
Kind of misleading, though.
- Original Message -
From: David Godsey [EMAIL PROTECTED]
To: George Law [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, January 24, 2006 4:43 PM
Subject: RE: Lost connection
I am getting this error when connecting to mysql with PHP:
Lost connection to MySQL server during query
This happens only when I use this procedure, but it doesn't necessarily
fail when this procedure is called. The error will happen frequently,
however it is not consistent. This is my first
David,
Are you using persistent connections? Sounds like perhaps a persistent
connection is timing out.
Maybe a quick work around would be to call a check status routine (ie
- do a show status), just to see if the connection is still there. If
this fails, just do a mysql_connect... Before
Thanks for the reply. I'm not using persistend connections though. It
appears that it looses the connection in the middle of the query or in
other words, before the procedure returns. So that means I not getting
the data I need. So for debug purposes, are you saying to do a check
status from
PM
Subject: RE: Lost connection to MySQL server during query
Thanks for the reply. I'm not using persistend connections though. It
appears that it looses the connection in the middle of the query or in
other words, before the procedure returns. So that means I not getting
the data I need
Hello.
[EMAIL PROTECTED]:~# telnet localhost 43306
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
Connection closed by foreign host.
I had an experience with similar symptoms which was caused by TCP
wrapper. Check your /etc/hosts.allow.
Lance
is '^]'.
Connection closed by foreign host.
[EMAIL PROTECTED]:~# telnet 127.0.0.1 43306
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
Connection closed by foreign host.
[EMAIL PROTECTED]:~# netstat -an |grep LISTEN
tcp0 0 0.0.0.0:22 0.0.0.0:* LISTEN
tcp
Hello.
See:
http://dev.mysql.com/doc/refman/5.0/en/connection-pool.html
wangxu wrote:
Are Mysql ODBC supporting connection pool?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net
) the query executes
quickly and without any errors or warnings.
On our linux box, which is our production box, we get
the following error as soon as the query is executed:
ERROR 2013 (HY000): Lost connection to MySQL server
during query
The databases have a similar amount of data in them
Connection pool facility is not in the JDBC driver. It is provided by the
application server like JBoss, Websphere, Weblogic, etc.
Tool like Hibernate and IBatis also provide it.
Vi.
wangxu [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Are Mysql ODBC supporting connection pool
The fact that on your Mac installation you re-imported your table data
makes me think it's an index efficiency issue. I have seen MySQL just
lose the connection if the join becomes massively big. On re-import,
the indexes would have been rebuilt and your query would be able to
take advantage
On 1/4/06, Tripp Bishop [EMAIL PROTECTED] wrote:
We did recently upgrade the server from 4.0.40 to
5.0.15 and we did not dump the tables and reimport
them. On the MAC we did do a dump and reimport. I
wonder if that could be the cause of this problem. I
had forgetten about that important
/5.0/en/gone-away.html
Ed
-Original Message-
From: Tripp Bishop [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 03, 2006 4:45 PM
To: mysql@lists.mysql.com
Subject: Lost Connection executing query
Howdy all,
First off, We're running 5.0.15.
Theres a particular update statement that we
message, for list of
things to try.
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
Ed
-Original Message-
From: Tripp Bishop [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 03, 2006 4:45 PM
To: mysql@lists.mysql.com
Subject: Lost Connection executing query
Howdy all
: Lost Connection executing query
The query fails instantly so I don't think it's a
timeout issue.
The wait_timeout and interactive_timeout variables are
set to 28800.
The server seems to be crashing and auto restarting
because as you suggested the uptime is small when I do
a show status right
To: emierzwa; mysql@lists.mysql.com
Subject: RE: Lost Connection executing query
The query fails instantly so I don't think it's a
timeout issue.
The wait_timeout and interactive_timeout variables
are
set to 28800.
The server seems to be crashing and auto restarting
because as you
the following error as soon as the query is executed:
ERROR 2013 (HY000): Lost connection to MySQL server
during query
The databases have a similar amount of data in them.
I've googled on the error but mostly get pages
containing questions about the error when generated by
stored procedures
the
default port is 3306. I have made sure that I've edited my connection string
to account for this difference. I have also unblocked that port in the
firewall on my laptop. I know it's working, because I can hook in with MySQL
Query Browser, or the MySQL Command prompt, and do what ever I
.
Jesse
- Original Message -
From: Jesse [EMAIL PROTECTED]
To: MySQL List mysql@lists.mysql.com
Sent: Monday, December 19, 2005 2:15 PM
Subject: Possible Connection Issue
I have finished my ASP.Net/MySQL 5.0 application on my development machine.
I am now ready to move it to our server
Hello.
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html
Doug Dalton wrote:
I found a log error after turning on warning running the server manually:
051215 17:32:42 [Warning] Aborted connection 3961 to db: 'db' user:
'user' host: `client
Hi,
I am using Mysql
4.1.15(mysql-standard-4.1.15-sun-solaris2.8-sparc-64bit)on
a solaris machine. My application is running on
weblogic8.1 sp2.
I have configured the mysql connection pool on
weblogic and tested from configuration wizard. I am
facing issues when connecting to Mysql pool from my
Hello.
Check that MySQL doesn't die during the query. See:
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
oug Dalton wrote:
I am running mysql 4.1.13 on Suse 10 and I get an error on a simple
select query, I have checked the threads on lost connection and my
connection
through this document for the last week rewritten code based on the
suggestions and still get the error.
Regards,
Doug
oug Dalton wrote:
I am running mysql 4.1.13 on Suse 10 and I get an error on a simple
select query, I have checked the threads on lost connection and my
connection times
Dalton wrote:
I am running mysql 4.1.13 on Suse 10 and I get an error on a simple
select query, I have checked the threads on lost connection and my
connection times as well as making sure my calls are all made from non
forking processes etc... I cannot seem to resolve this error? can
someone
I found a log error after turning on warning running the server manually:
051215 17:32:42 [Warning] Aborted connection 3961 to db: 'db' user:
'user' host: `client' (Got timeout reading communication packets)
Any idea what this error is ? the interfaces show no errors from a
network
I am running mysql 4.1.13 on Suse 10 and I get an error on a simple
select query, I have checked the threads on lost connection and my
connection times as well as making sure my calls are all made from non
forking processes etc... I cannot seem to resolve this error? can
someone point me
the queries are completed. Since there are no
connection timers in the default client our app was hanging until the
query was completed. We applied the patches in the bug and we have a
patched client with connection timers but I want to ask a few questions
relative to these types of issues.
1
[EMAIL PROTECTED] wrote:
Responses intermixed. See below...
untz [EMAIL PROTECTED] wrote on 12/02/2005 10:43:41 PM:
snip
3. After logging into mysql, I created the following database:
mysql create database music_development to 'untz'@'localhost'
identified by 'paintball';
MySQL
Michael,
I would still appreciate it if someone could tell me what the default
port number is because I need that to set up a local JDBC connection.
Kindest regards,
Unnsse
On Dec 2, 2005, at 11:05 PM, Michael Stassen wrote:
untz wrote:
Hello there!
This is a continuation of a previous
PROTECTED] wrote on 12/03/2005 05:17:37 AM:
Michael,
I would still appreciate it if someone could tell me what the default
port number is because I need that to set up a local JDBC connection.
Kindest regards,
Unnsse
On Dec 2, 2005, at 11:05 PM, Michael Stassen wrote:
untz wrote
CocoaMySQL v0.7b2.
6. Put in the following information for the connection information:
Host: localhost
User: untz
Password: paintball
Database: music_development
Socket: /tmp/mysql.sock
Port:
My question(s) are:
(1) What is the default port number for a freshly created database in
MySQL 5
that to set up a local JDBC connection.
Kindest regards,
Unnsse
On Dec 2, 2005, at 11:05 PM, Michael Stassen wrote:
untz wrote:
Hello there!
This is a continuation of a previous posting of mine... I noticed
that that
the CocoaMySQL v0.7b2 client lists the Database, Socket
untz wrote:
Hello there!
This is a continuation of a previous posting of mine... I noticed that
that
the CocoaMySQL v0.7b2 client lists the Database, Socket, and Port
fields as optional,
so I filled the other fields and when I clicked on Connect,
I received this error message:
Unable to
a
connection object from my servlet and for the life of me, I can't figure
out why. Here is what I have done:
Downloaded mysql-connector-java-3.1.11-bin.jar into
$CATALINA_HOME/common/lib
Added mysql-connector-java-3.1.11-bin.jar to my classpath
and I created the following servlet, TestSQL
Xiaobo Chen wrote:
Have you tried to put the port 3306 after the host? I assume you are in
the localhost.
Yes, I am trying to connect in localhost. I did 'nmap localhost' and
port 3306 is open and I can connect to mysqld with mysql client. I will
try putting 3306 after the host when I
from outside. I had once had such connection
issue. If that will be your case, I guess you have to ask admin for help,
it's not mysql at all. If your database is on a XP box, you need to create
a service and open the 3306 port there (assuming you have firewall on it,
otherwise you shouldn't have
connect to the database from outside. I had once had such connection
issue. If that will be your case, I guess you have to ask admin for help,
it's not mysql at all. If your database is on a XP box, you need to create
a service and open the 3306 port there (assuming you have firewall on it,
otherwise
Hassan Schroeder wrote:
Gobi wrote:
MySQL 5.0.15 and Tomcat 5.5.12. However, I cannot seem to get a
connection object from my servlet and for the life of me, I can't figure
out why. Here is what I have done:
and I created the following servlet, TestSQL:
It's possible
Not sure if this is the place to ask but hopefully someone can help me
here. I am setting an application system and have successfully setup
MySQL 5.0.15 and Tomcat 5.5.12. However, I cannot seem to get a
connection object from my servlet and for the life of me, I can't figure
out why. Here
Hello all,
Suddenly in the last hour or so the connection speed
between our webserver and database server has
skyrocketed to the point that our site is no longer
usable! Just trying to connection via the mysql client
takes a long time. Once the connection is established,
however, queries seem
Tripp Bishop wrote:
Hello all,
Suddenly in the last hour or so the connection speed
between our webserver and database server has
skyrocketed to the point that our site is no longer
usable! Just trying to connection via the mysql client
takes a long time. Once the connection is established
was captured from our PHP logs. Not
sure what that's on about. We'll just have to monitor
it and see if pattern develops.
Thanks for your help.
Cheers,
Tripp
--- Michael Stassen [EMAIL PROTECTED]
wrote:
Tripp Bishop wrote:
Hello all,
Suddenly in the last hour or so the connection
speed
= com.mysql.jdbc.Driver;
String URL = jdbc:mysql://url:3306/mydatabase;
String username = abc;
String password = abc;
Connection con;
Class.forName(driver).newInstance();
con = DriverManager.getConnection(URL, username, password);
I got error like this:
root cause
java.sql.SQLException: Unable to connect to any
Xiaobo Chen wrote:
then I tried 'telnet':
telnet aaa.bbb.ca or telnet aaa.bbb.ca:3306
both case, it said: Could not connected to the host , on port 23: connect
failed.
Your second example is invalid -- it should be `aaa.bbb.ca 3306` --
so it's not surprising that didn't work :-)
But
I already turned off the firewall on the XP machine, but it doesn't work
either. I am doubting that in the database on the other Solaris machine,
it doesn't allow the connection from the XP machine. I am doubting this
way because other application on other Solaris machine can conenction
301 - 400 of 1704 matches
Mail list logo