Re: Mysql and JDBC connection time out.

2005-11-02 Thread Hassan Schroeder
Xiaobo Chen wrote: 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

Re: Mysql and JDBC connection time out.

2005-11-02 Thread Xiaobo Chen
I can not use 'telnet aaa.bbb.ca 3306' on XP machine, it will give error like this: Could not open connection to the host, on port 3306. Connection failed. But if I try on other Solaris machines ,it will say something like this: Trying (IP address) Connected to aaa.bbb.ca. Escape character

Re: Mysql and JDBC connection time out.

2005-11-02 Thread Hassan Schroeder
Xiaobo Chen wrote: I can not use 'telnet aaa.bbb.ca 3306' on XP machine, it will give error like this: Could not open connection to the host, on port 3306. Connection failed. But if I try on other Solaris machines ,it will say something like this: Trying (IP address) Connected

Re: Mysql and JDBC connection time out.

2005-11-02 Thread Paul DuBois
At 14:57 -0400 11/2/05, Xiaobo Chen wrote: 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

Re: SSL connection error

2005-10-18 Thread Gleb Paharenko
Discussion« Previous Message From: Israel Fernández Cabrera Date: October 17 2005 10:18pm Subject: SSL connection error Get Plain Text Hi all I'm back with a new subject may be the last one was not attractive :) I'm using mysql 4.1.11-2 in Fedora Core 4. I need to set

Re: SSL connection error

2005-10-18 Thread Israel Fernández Cabrera
:18pm Subject: SSL connection error Get Plain Text Hi all I'm back with a new subject may be the last one was not attractive :) I'm using mysql 4.1.11-2 in Fedora Core 4. I need to set up mysql connections over SLL I follow the mysql manual instructions, create certificates

Re: SSL connection error

2005-10-18 Thread Gleb Paharenko
Hello. First check the contents of /var/log/messages. SELinux usually puts there some notes about what it is doing. I'm not a SELinux expert, but quick search at fedora.redhat.com has shown me that I should use system-config-securitylevel utility for configuring SELinux. Israel

SSL connection error

2005-10-17 Thread Israel Fernández Cabrera
-rw-r--r-- 1 root root 887 Oct 14 21:46 server-key.pem -rw-r--r-- 1 root mysql769 Oct 8 16:54 server-req.pem open(/etc/pki/tls/certs/server-cert.pem, O_RDONLY) = -1 EACCES (Permission denied) write(2, Error when connection to server ..., 42) = 42 write(2, 1872:error:0200100D:system

RE: connection issue

2005-10-14 Thread Anil
Than you very much . It is working Anil DBA -Original Message- From: Dobromir Velev [mailto:[EMAIL PROTECTED] Sent: Thursday, October 13, 2005 8:58 PM To: mysql@lists.mysql.com Cc: Anil Subject: Re: connection issue When you connect without specifing the host, the mysql client

connection issue

2005-10-13 Thread Anil
Hi List, When I am trying to connect to mysql 4.0.20 database it is taking very long time when I specified host like Mysql -ux -p -h192.168.3.111 But it is connecting very quickly when I tried like below Mysql -ux -p It is an urgent issue. Please help me. Thanks

Re: connection issue

2005-10-13 Thread Dobromir Velev
When you connect without specifing the host, the mysql client will try to connect using the mysql socket file (usually /tmp/mysql.sock or /var/lib/mysql/mysql.sock) and when you specify the IP address it will try to connect using a TCP connection to port 3306. My guess is the you have name

Aborted connection problems

2005-10-11 Thread Jasper Bryant-Greene
/mysqld.err] 051012 21:53:44 [Warning] Aborted connection 27 to db: 'album' user: 'album_read' host: 'localhost' (Got an error reading communication packets) 051012 21:53:44 [Warning] Aborted connection 28 to db: 'album' user: 'album_read' host: 'localhost' (Got an error reading communication packets

Re: Aborted connection problems

2005-10-11 Thread Jasper Bryant-Greene
') 29 Quit [/var/log/mysql/mysqld.err] 051012 21:53:44 [Warning] Aborted connection 27 to db: 'album' user: 'album_read' host: 'localhost' (Got an error reading communication packets) 051012 21:53:44 [Warning] Aborted connection 28 to db: 'album' user: 'album_read' host: 'localhost' (Got

Re: Aborted connection problems

2005-10-11 Thread Gleb Paharenko
PROTECTED] on album 29 Query SET NAMES utf8 29 Query CALL getHelp('gallery') 29 Quit [/var/log/mysql/mysqld.err] 051012 21:53:44 [Warning] Aborted connection 27 to db: 'album' user: 'album_read' host

How to sort Query Browser's connection list?

2005-09-30 Thread Mihail Manolov
Hi all, It's not a big deal, but I can't seem to find how to sort or order my connection entries in Options-Connections view tree in MySQL Query Browser. (See attached screenshot.) Any ideas? Thanks! Mihail -- Mihail Manolov Government Liquidation, LLC Special Projects Leader 202 558

Re: Lost connection to MySQL server during query when calling stored procedure

2005-09-27 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Fri, 23 Sep 2005, Jasper Bryant-Greene wrote: Thing is, even though I get that error, the server keeps running and accepting other connections and responding to queries fine. Probably because the mysqld_safe wrapper script has restarted it

Re: Lost connection to MySQL server during query when calling stored procedure

2005-09-26 Thread Greg 'groggy' Lehey
On Thursday, 22 September 2005 at 17:06:32 +1200, Jasper Bryant-Greene wrote: Jasper Bryant-Greene wrote: I have a stored procedure defined as follows: ... Sometimes when I execute this stored procedure ... I get the error Lost connection to MySQL server during query. I am using MySQL

Re: Lost connection to MySQL server during query when calling stored procedure

2005-09-22 Thread Jasper Bryant-Greene
Greg 'groggy' Lehey wrote: On Thursday, 22 September 2005 at 17:06:32 +1200, Jasper Bryant-Greene wrote: Jasper Bryant-Greene wrote: Sometimes when I execute this stored procedure ... I get the error Lost connection to MySQL server during query. I am using MySQL 5.0.12-beta-log on Gentoo

Lost connection to MySQL server during query when calling stored procedure

2005-09-21 Thread Jasper Bryant-Greene
the error Lost connection to MySQL server during query. This only ever happens with stored procedures, never with any normal kind of query. I am using MySQL 5.0.12-beta-log on Gentoo Linux x86. -- Jasper Bryant-Greene Freelance web developer http://jasper.bryant-greene.name/ -- MySQL General

Re: Lost connection to MySQL server during query when calling stored procedure

2005-09-21 Thread Martijn Tonies
getUser(7); I get the error Lost connection to MySQL server during query. This only ever happens with stored procedures, never with any normal kind of query. I am using MySQL 5.0.12-beta-log on Gentoo Linux x86. And what is your question? ;-) Most probably, a server crash... With regards

Re: Lost connection to MySQL server during query when calling stored procedure

2005-09-21 Thread Jasper Bryant-Greene
: CALL getUser(7); I get the error Lost connection to MySQL server during query. This only ever happens with stored procedures, never with any normal kind of query. I am using MySQL 5.0.12-beta-log on Gentoo Linux x86. And what is your question? Fairly obviously, how do I fix it!? ;) Most

Re: Lost connection to MySQL server during query when calling stored procedure

2005-09-21 Thread Pooly
; Sometimes when I execute this stored procedure with, for example: CALL getUser(7); I get the error Lost connection to MySQL server during query. This only ever happens with stored procedures, never with any normal kind of query. I am using MySQL 5.0.12-beta-log on Gentoo Linux x86

Re: Lost connection to MySQL server during query when calling stored procedure

2005-09-21 Thread Daniel
users WHERE id=userID LIMIT 1; Sometimes when I execute this stored procedure with, for example: CALL getUser(7); I get the error Lost connection to MySQL server during query. This only ever happens with stored procedures, never with any normal kind of query. I am using MySQL 5.0.12-beta-log

Re: Lost connection to MySQL server during query when calling stored procedure

2005-09-21 Thread Jasper Bryant-Greene
INVOKER SELECT * FROM users WHERE id=userID LIMIT 1; Sometimes when I execute this stored procedure with, for example: CALL getUser(7); I get the error Lost connection to MySQL server during query. This only ever happens with stored procedures, never with any normal kind of query. I am using MySQL

Re: Lost connection to MySQL server during query when calling stored procedure

2005-09-21 Thread Jasper Bryant-Greene
with, for example: CALL getUser(7); I get the error Lost connection to MySQL server during query. This only ever happens with stored procedures, never with any normal kind of query. I am using MySQL 5.0.12-beta-log on Gentoo Linux x86. This only seems to happen when accessing MySQL from PHP's MySQLi API

Connection Failure

2005-09-17 Thread Darrell Cormier
root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 4.1.13-Max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql GRANT ALL PRIVILEGES ON lts.* TO 'dbmgr'@'localhost' IDENTIFIED BY 'pwd'; Then I run

Re: Connection Failure

2005-09-17 Thread Michael Stassen
Can't call method disconnect on an undefined value at ./lts_connect_test.pl line 30. I have just created the user and granted all privileges with the following sequence: mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7

Re: Connection Failure

2005-09-17 Thread Darrell Cormier
On Saturday 17 September 2005 16:12, Michael Stassen wrote: You are trying to connect to a 4.1 server with a 4.0 client. This is explained in the manual http://dev.mysql.com/doc/mysql/en/old-client.html. Michael Thanks for the information. I guess the perl-DBD and perl-DBI are old. I

Re: user and hostname connection priveleges

2005-09-15 Thread Michael Stassen
command line? What does it won't allow me to mean? Did you get an error message? If so, what was it, exactly? I then had to add this entry: User: user1 Host: % One possibilty, then, is that mysql saw the connection as coming from a machine other than 111.xx.xx.xx, so the wild card worked

Re: user and hostname connection priveleges

2005-09-15 Thread Gleb Paharenko
Hello. If you want to have a complete understanding of how MySQL access privilege system works, read this chapter of the manual: http://dev.mysql.com/doc/mysql/en/privilege-system.html James [EMAIL PROTECTED] wrote: I had set up the following I have a MYSQL server running on

user and hostname connection priveleges

2005-09-14 Thread James
I had set up the following I have a MYSQL server running on let's say 123.xx.xx.xx User: user1 Host: 111.xx.xx.xx and gave that user the appropriate priveleges. So. I tried to connect to the MYSQL server from 111.xx.xx.xx using user1, but it won't allow my to. I then had to add this

Re: Please I need inputs on Lost connection to MySQL server during query

2005-09-02 Thread Jerome Macaranas
-away.html; hoping this has something to do with the error... Ive already checked based on the page the list of roots of error to produce gone-away.. w/c i hope leads to Lost connection to MySQL server during query and non of it is present. One thing Ive noticed. When I tried

Re: Please I need inputs on Lost connection to MySQL server during query

2005-09-02 Thread Jerome Macaranas
on the page the list of roots of error to produce gone-away.. w/c i hope leads to Lost connection to MySQL server during query and non of it is present. One thing Ive noticed. When I tried connecting using mysql client from web server to my DB box its takes time before mysql console

Please I need inputs on Lost connection to MySQL server during query

2005-09-01 Thread JM
Hi all, Ive read this link http://dev.mysql.com/doc/mysql/en/gone-away.html; hoping this has something to do with the error... Ive already checked based on the page the list of roots of error to produce gone-away.. w/c i hope leads to Lost connection to MySQL server during

Re: Please I need inputs on Lost connection to MySQL server during query

2005-09-01 Thread Pooly
read this link http://dev.mysql.com/doc/mysql/en/gone-away.html; hoping this has something to do with the error... Ive already checked based on the page the list of roots of error to produce gone-away.. w/c i hope leads to Lost connection to MySQL server during query and non

Re: Please I need inputs on Lost connection to MySQL server during query

2005-09-01 Thread SGreen
hope leads to Lost connection to MySQL server during query and non of it is present. One thing Ive noticed. When I tried connecting using mysql client from web server to my DB box its takes time before mysql console shows-up after giving the password. Client and Server

Regarding the usage of mutex in the mysql connection threading

2005-08-30 Thread lakshmi.narasimharao
Hi, We migrated a NMS project from oracle 7.3 database to mysql 4.0.23. In the migration we kept the mutex mechanism followed in the oracle for connection threading. Actually these mutex are mainly used before executing the sql statements which returns multiple number of records

Re: Regarding the usage of mutex in the mysql connection threading

2005-08-30 Thread SGreen
[EMAIL PROTECTED] wrote on 08/30/2005 08:54:44 AM: Hi, We migrated a NMS project from oracle 7.3 database to mysql 4.0.23. In the migration we kept the mutex mechanism followed in the oracle for connection threading. Actually these mutex are mainly used before executing the sql

RE: Regarding the usage of mutex in the mysql connection threading

2005-08-30 Thread lakshmi.narasimharao
the applications login to the database- gets free connection id from pool (local data structure maintained in application) - do the operation - logout - return the connection id to the pool. - we are going to MySQL through ODBC which identifies the transactions by there connection handles. So

RE: Regarding the usage of mutex in the mysql connection threading

2005-08-30 Thread lakshmi.narasimharao
hi , Could any one of you please let me know in mysql/myODBC that the session control is now under their management meaning - handles different queries/write from different threads within the same connection - handles different queries (or batch fetches) from multi-connections

RE: Regarding the usage of mutex in the mysql connection threading

2005-08-30 Thread lakshmi.narasimharao
Hi, Please advise us whether mysql/myodbc - handles different queries/write from different threads within the same connection or not? - handles different queries (or batch fetches) from multi-connections or not? Thanks, Narasimha -Original Message- From: Lakshmi NarasimhaRao

RE: Regarding the usage of mutex in the mysql connection threading

2005-08-30 Thread SGreen
[EMAIL PROTECTED] wrote on 08/30/2005 10:03:51 AM: Could any one of you please let me know in mysql/myODBC that the session control is now under their management meaning - handles different queries/write from different threads within the same connection - handles different queries (or batch

RE: Regarding the usage of mutex in the mysql connection threading

2005-08-30 Thread SGreen
[EMAIL PROTECTED] wrote on 08/30/2005 10:09:27 AM: Hi, Please advise us whether mysql/myodbc - handles different queries/write from different threads within the same connection or not? - handles different queries (or batch fetches) from multi-connections

RE: Regarding the usage of mutex in the mysql connection threading

2005-08-30 Thread lakshmi.narasimharao
Hi Green, We are at the last stage of the project (migration from Oracle to MySQL). We are demanded to adopt the MYODBC as a customer requrement. As mutex was implemented for oracle so it is there in our code. Now we are thinking to remove that because application level we have connection id. So

RE: Regarding the usage of mutex in the mysql connection threading

2005-08-30 Thread SGreen
that each connection can only be used by one thread/process at a time, then you should not need to synchronize (serialize) access to any connection. Connection pooling IS NOT connection sharing. It sounds to me that the previous version of your application shared a single connection between

Remote Connection Problem

2005-08-08 Thread Kent Roberts
I am having inconsistent behavior maintaining a remote connection with MySql Administrator/Browser. Brand new installations of clients on Windows XP and MySql server on Windows 2003 server. It worked fine at first then suddenly I could no longer connect (Error #1045. Access denied for user

Re: Remote Connection Problem

2005-08-08 Thread SGreen
Kent Roberts [EMAIL PROTECTED] wrote on 08/08/2005 04:50:15 PM: I am having inconsistent behavior maintaining a remote connection with MySql Administrator/Browser. Brand new installations of clients on Windows XP and MySql server on Windows 2003 server. It worked fine at first then suddenly

Re: Remote Connection Problem

2005-08-08 Thread Kent Roberts
Thanks Shawn. It seems to be just that. [EMAIL PROTECTED] 08/08/05 03:02PM Kent Roberts [EMAIL PROTECTED] wrote on 08/08/2005 04:50:15 PM: I am having inconsistent behavior maintaining a remote connection with MySql Administrator/Browser. Brand new installations of clients on Windows XP

port fwding connection

2005-07-21 Thread kaustubh shinde
Hi, I have a MySQL server running on a machine, say A, and I want to access the DB from another machine B. Now A has blocked port 3306. So I fwded port 3306 on B to 3306 on A using SSH. This works just fine. I can access Mysql fom local machine's port 3306 and no problems there. Problem is it

RE: telnet localhost 3306 Connection refused [SOLVED]

2005-07-11 Thread Daevid Vincent
Yep. That was it. No firewall rules needed to change. -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 1:24 AM To: mysql@lists.mysql.com Subject: Re: telnet localhost 3306 Connection refused Hello. Are you sure that mysql

telnet localhost 3306 Connection refused

2005-07-07 Thread Daevid Vincent
to connect to remote host: Connection refused I've tried to comment, uncomment and change to * this 'bind-address' line in /etc/mysql/my.cnf # keep secure by default! #bind-address= 127.0.0.1 #bind-address= * port= 3306 Of course, I can't connect from any of the other IP addresses

Re: telnet localhost 3306 Connection refused

2005-07-07 Thread Louie Miranda
: Unable to connect to remote host: Connection refused I've tried to comment, uncomment and change to * this 'bind-address' line in /etc/mysql/my.cnf # keep secure by default! #bind-address = 127.0.0.1 http://127.0.0.1 #bind-address = * port = 3306 Of course, I can't connect from any

Re: telnet localhost 3306 Connection refused

2005-07-07 Thread Philippe Poelvoorde
Daevid Vincent wrote: What is causing me to have this problem in mysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i686). I am running shorewall, but that shouldn't affect localhost should it? My firewall, web, and mySQL server are the same machine. Shorewall can affect localhost as well Try

Re: telnet localhost 3306 Connection refused

2005-07-07 Thread Ady Wicaksono
Try /sbin/iptables -L -n make sure there's no rule that block connection to/from port 3306 (TCP) Daevid Vincent wrote: What is causing me to have this problem in mysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i686). I am running shorewall, but that shouldn't affect localhost should

Re: telnet localhost 3306 Connection refused

2005-07-07 Thread Gleb Paharenko
12.22 Distrib 4.0.24, for pc-linux-gnu (i686). I am running shorewall, but that shouldn't affect localhost should it? My firewall, web, and mySQL server are the same machine. # telnet localhost 3306 Trying 127.0.0.1... telnet: Unable to connect to remote host: Connection refused

Re: telnet localhost 3306 Connection refused

2005-07-07 Thread l'[EMAIL PROTECTED]
4.0.24, for pc-linux-gnu (i686). I am running shorewall, but that shouldn't affect localhost should it? My firewall, web, and mySQL server are the same machine. # telnet localhost 3306 Trying 127.0.0.1... telnet: Unable to connect to remote host: Connection refused I've tried to comment, uncomment

Re: default connection charset - SOLVED

2005-06-30 Thread Varshavchick Alexander
'koi8r' and I have the following problem: when connecting from PHP, the default results and connection charsets become latin1, so all not-latin characters get lost (they are displayed as ?). Of cause, if I explicitely set these charsets to koi8r in the PHP scripts after the mysql_connect statement

default connection charset

2005-06-29 Thread Varshavchick Alexander
Hi, I have mysql 4.1.12 started with the default charset 'koi8r' and I have the following problem: when connecting from PHP, the default results and connection charsets become latin1, so all not-latin characters get lost (they are displayed as ?). Of cause, if I explicitely set

Re: connection error from c application

2005-06-29 Thread Elizabeth Bonifacio
Dear Guys, I have been stucked in loading file using load data local infile command. At first it is loading a null value on my first record followed with one record from my input file. The rest are ignored and i've been receiving lots of warnings. I tried converting the text file into a csv

Re: connection error from c application

2005-06-29 Thread Kristen G. Thorson
Your syslog8.txt file has two problems: 1. The first field, log_date, is in m/d/ format. It will not be converted by MySQL automatically. It needs to be in -mm-dd format. For this reason, all records will have the default value of '-00-00' for that field. 2. The primary key

Re: default connection charset

2005-06-29 Thread Gleb Paharenko
the following problem: when connecting from PHP, the default results and connection charsets become latin1, so all not-latin characters get lost (they are displayed as ?). Of cause, if I explicitely set these charsets to koi8r in the PHP scripts after the mysql_connect statement, it starts working

Re: connection error from c application

2005-06-27 Thread Gleb Paharenko
Hello. Send an example of your file and your table's definition (use SHOW CREATE TABLE for this purpose). Please, next time send your replies to the list. Hope you're doing great today. Back to my question last week, I've been encountering this problem of loading my file using the

Re: connection error from c application

2005-06-24 Thread Elizabeth Bonifacio
Dear Gleb, Thanks, i will try that as well, so far my program can access the server now by using the old password. Now my problem is when i load file, its only reading the first line and some more insert a null record before the ist record. here is the result i get after loading the text file:

MySQL Remote Connection?

2005-06-24 Thread Badr Al-Muzini
hi, i try to access the MySQL server remotely using Command prompet how can i do so? i mean i want to run all MySQL command on my hosting server ... _ Don’t just search. Find. Check out the new MSN Search!

RE: MySQL Remote Connection?

2005-06-24 Thread Berman, Mikhail
- From: Badr Al-Muzini [mailto:[EMAIL PROTECTED] Sent: Friday, June 24, 2005 11:51 AM To: mysql@lists.mysql.com Subject: MySQL Remote Connection? hi, i try to access the MySQL server remotely using Command prompet how can i do so? i mean i want to run all MySQL command on my hosting server

Re: MySQL Remote Connection?

2005-06-24 Thread Gleb Paharenko
Hello. Do you have a shell account on that server? Are you allowed to connect to your server from remote machines (ask support of your hosting about this). Badr Al-Muzini [EMAIL PROTECTED] wrote: hi, i try to access the MySQL server remotely using Command prompet how can i do so?

Re: connection error from c application

2005-06-24 Thread Gleb Paharenko
Hello. What 'SHOW WARNINGS' reports? Elizabeth Bonifacio [EMAIL PROTECTED] wrote: Dear Gleb, Thanks, i will try that as well, so far my program can access the server now by using the old password. Now my problem is when i load file, its only reading the first line and some more

connection error from c application

2005-06-23 Thread Elizabeth Bonifacio
Dear All, I'm new into mysql and has been encountering huge problem in connecting to the database from the c application. The code execute with an error message : Failed to connect to database: Error: Client does not support authentication protocol requested by server; consider upgrading MySQL

Re: connection error from c application

2005-06-23 Thread Kishore Jalleda
I guess this is a problem with the version of the C client Libraries that you are using, because of the way 4.1.x version of mysql stores the hash value of the password using the PASSWORD( ) function, so when you are giving the password embedded in the C code, may be the server does not match it

Re: connection error from c application

2005-06-23 Thread Gleb Paharenko
Hello. I've compiled your code using libraries and includes from MySQL-4.1.6 (yes, my testing environment isn'tperfect :) and successfully connected to MySQL-4.1.10. Old passwords was off, so I used a 4.1. authorization protocol. Elizabeth Bonifacio [EMAIL PROTECTED] wrote: Dear All,

Connection Issue with DBI::DBD::Mysql

2005-06-21 Thread TheRefUmp
Hi everyone, Trying to connect to a MySQL database from a Linux Server using PERL to a Windows Machine with a MySQL database (5.0.6). I can connect successfully on the windows box but cannot on the Linux server! I ran a SQLTRACE (DBD) with the following output: imp_dbh-connect: dsn =

Re: Connection Issue with DBI::DBD::Mysql

2005-06-21 Thread SGreen
[EMAIL PROTECTED] wrote on 06/21/2005 01:56:50 PM: Hi everyone, Trying to connect to a MySQL database from a Linux Server using PERL to a Windows Machine with a MySQL database (5.0.6). I can connect successfully on the windows box but cannot on the Linux server! I ran a SQLTRACE (DBD) with

Re: Connection Issue with DBI::DBD::Mysql (more information)

2005-06-21 Thread TheRefUmp
] To: mysql@lists.mysql.com Subject: Connection Issue with DBI::DBD::Mysql Hi everyone, Trying to connect to a MySQL database from a Linux Server using PERL to a Windows Machine with a MySQL database (5.0.6). I can connect successfully on the windows box but cannot on the Linux server! I ran

PHP MySQL connection problem

2005-06-10 Thread Andre Matos
Hi list, I am getting slow connections between php4 and MySQL 4.1.9. There are some connections that are very fast, but others can take from 5 to 20 second or more (usually it takes less than 0.1 second to create a new connection). I tried to identify if there is a pattern but it seems

Re: PHP MySQL connection problem

2005-06-10 Thread Greg Donald
On 6/10/05, Andre Matos [EMAIL PROTECTED] wrote: I am getting slow connections between php4 and MySQL 4.1.9. There are some connections that are very fast, but others can take from 5 to 20 second or more (usually it takes less than 0.1 second to create a new connection). I tried

Lost connection to MySQL server during query - on long queries

2005-06-01 Thread Amir Shay
Hello, Each time we run long queries (over around 5 seconds) the mySQL server fails and restarts (you can see it in the error log that starts with Database page corruption on disk or a fail.. and then there is a dump...) and the query return with Lost connection to MySQL server during query

Re: Lost connection to MySQL server during query - on long queries

2005-06-01 Thread Dobromir Velev
2005 12:04, Amir Shay wrote: Hello, Each time we run long queries (over around 5 seconds) the mySQL server fails and restarts (you can see it in the error log that starts with Database page corruption on disk or a fail.. and then there is a dump...) and the query return with Lost connection

Re: Lost connection to MySQL server during query problem

2005-05-31 Thread Gleb Paharenko
Hello. You should solve the issue with server crashes. I'm not familiar with JDBC, and if changing the values of parameters with SET statement doesn't work with JDBC, probably somebody clever on the list could help you. You may forward your message to: http://lists.mysql.com/java

Re: Lost connection to MySQL server during query problem

2005-05-27 Thread Amir Shay
(check the error log)? Sometimes you should increase interactive_timeout as well. A lot of variables usually could be changed using SET statement. See: http://dev.mysql.com/doc/mysql/en/system-variables.html Sometimes when querying mySQL 4.1.11 on Linux machine I get the error Lost connection

Re: Lost connection to MySQL server during query problem

2005-05-26 Thread Gleb Paharenko
: http://dev.mysql.com/doc/mysql/en/system-variables.html Sometimes when querying mySQL 4.1.11 on Linux machine I get the error Lost connection to MySQL server during query. Here are the symptoms 1.When running the query from the server it returns OK 2.When running

Lost connection to MySQL server during query problem

2005-05-25 Thread Amir Shay
Hi, Sometimes when querying mySQL 4.1.11 on Linux machine I get the error Lost connection to MySQL server during query. Here are the symptoms 1. When running the query from the server it returns OK 2. When running the query from another machine using the mySQL query browser

Connection problem

2005-05-24 Thread razat gupta
Hello Everyone, I am working on an architecture on which i am using common database mysql4 for two web servers(Tomcat 5.x). After moving to 150 number of connections using a java application, mysql gives an error (exception): Server Connection Failure during transaction.Attempt reconnect 3

problem-Lost connection to MySQL server during query

2005-05-24 Thread Ying Sun
Dear there, I met some problem when I try to use \. command to create several tables from a file in mysql. I got error as follows: ERROR 2013 (HY000): Lost connection to MySQL server during query ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... ERROR 2002

Re: problem-Lost connection to MySQL server during query

2005-05-24 Thread Gleb Paharenko
Hello. Have you looked into error log? Server could die during the query execution. Dear there, I met some problem when I try to use \. command to create several tables from a file in mysql. I got error as follows: ERROR 2013 (HY000): Lost connection to MySQL server during query

problem-Lost connection to MySQL server during query

2005-05-24 Thread Ying Sun
Hi, I install Mysql 4.1.12-0 by rpm. When I try to create a table, it give me Lost connection to MySQL server during query. My query is like: CREATE TABLE ArrayBatch ( id int(11) NOT NULL auto_increment, arrayType int(11) NOT NULL default '0', descr text NOT NULL, printStartDate

Re: problem-Lost connection to MySQL server during query

2005-05-24 Thread Gleb Paharenko
Hello. Resolve a stack trace. See: http://dev.mysql.com/doc/mysql/en/using-stack-trace.html Hi, This is my first time to instll mysql. So I have not so much experience. I am apprecia ted your help! Now I check my mysqld.log file, there is something like: mysqld got signal

Re: Connection problem

2005-05-24 Thread Warren Young
razat gupta wrote: But it gives an exception on the reach of 150 connections.It should allow us to create almost 500 connection. Use netstat on the server to find out how many connections are actually in use. You may find that your program is not properly closing down connnections

remote connection

2005-05-21 Thread Chris Faulkner
Hello I am trying to connect from host 192.168.0.8 on my home network to a database on 192.168.0.7. When I connect as root on 192.168.0.7 itself, I can do this mysql show grants for 'root'@'192.168.0.8'; ++ | Grants for [EMAIL PROTECTED]

Re: remote connection

2005-05-21 Thread mfatene
Hi, haven't you added identified by * int he grant statement. I don't see it in your show grants comand. Mathias Selon Chris Faulkner [EMAIL PROTECTED]: Hello I am trying to connect from host 192.168.0.8 on my home network to a database on 192.168.0.7. When I connect as root on

Re: remote connection problem

2005-05-19 Thread Gleb Paharenko
Hello. After checking that MySQL server listens on the interface to which you are connecting, solve network problems. If you're able to connect from one host to another it doesn't mean that the opposite is true. Andy McHargue [EMAIL PROTECTED] wrote: Here's some more data on this,

Re: remote connection problem

2005-05-19 Thread Gleb Paharenko
Hello. Your server listens only on a single interface. Options could be given in different ways, not only from configuration file. If you want MySQL server to listen on every interface you should find where the bind option is given and remove it. See:

Re: Lost connection to Mysql server during query using a group by clause and sub query

2005-05-19 Thread Ware Adams
On May 19, 2005, at 12:51 AM, Dan Rossi wrote: Hi there, I am having issues with this funny error message. I am trying to do a sub query and then a group by clause on a date. However i keep getting this annoying message for some reason. Happens via terminal aswell as my sql gui. Here is the

remote connection problem

2005-05-18 Thread Andy McHargue
I'm having trouble connecting remotely from Server A (local) to Server B (remote). Both Linux. From Server A, I'm issuing this command mysql -h [domain.com] -u [user] -p And I get ERROR 2003: Can't connect to MySQL server on 'domain.com' (110) I assume this is a time out. 1. The user on Server

Re: remote connection problem

2005-05-18 Thread Andy McHargue
Here's some more data on this, if anyone can help. --I can connect the other way around ... i.e. I can connect from B to A. So there's no general connectivity problem. --did an nmap on B, $ nmap -sT -T Polite -p3306 xx.com Starting nmap V. 2.54BETA22 ( www.insecure.org/nmap/ ) Interesting

Lost connection to Mysql server during query using a group by clause and sub query

2005-05-18 Thread Dan Rossi
Hi there, I am having issues with this funny error message. I am trying to do a sub query and then a group by clause on a date. However i keep getting this annoying message for some reason. Happens via terminal aswell as my sql gui. Here is the query I am trying to do select (select

RE: mysql-mysqld connection

2005-05-03 Thread Reggie Burnett
Skoric [mailto:[EMAIL PROTECTED] Sent: Monday, May 02, 2005 10:30 AM To: Jeremiah Gowdy; mysql@lists.mysql.com Subject: Re: mysql-mysqld connection Dana Sun, 1 May 2005 11:11:40 -0700, Jeremiah Gowdy rece: Where could I find speciffication of how MySQL client and server communicate? /... Look

RE: mysql-mysqld connection

2005-05-03 Thread Nikola Skoric
Dana Tue, 3 May 2005 11:34:39 -0500, Reggie Burnett rece: Just to echo the thoughts from Jeremiah, we have several freely available open source connectors that work *VERY HARD* tracking the protocol so it's hard to understand a situation where you would need to write your own implementation.

Re: mysql-mysqld connection

2005-05-03 Thread Eric Bergen
you would need to write your own implementation. -Reggie -Original Message- From: Nikola Skoric [mailto:[EMAIL PROTECTED] Sent: Monday, May 02, 2005 10:30 AM To: Jeremiah Gowdy; mysql@lists.mysql.com Subject: Re: mysql-mysqld connection Dana Sun, 1 May 2005 11:11:40 -0700, Jeremiah

Re: mysql-mysqld connection

2005-05-02 Thread Nikola Skoric
Dana Sun, 1 May 2005 11:11:40 -0700, Jeremiah Gowdy rece: Where could I find speciffication of how MySQL client and server communicate? /... Look at the source code of libmysql? So, document regarding this protocol doesn't exist? Hm, and, where could I find the source code of libmysql? I

Re: mysql-mysqld connection

2005-05-02 Thread Jeremiah Gowdy
Where could I find speciffication of how MySQL client and server communicate? /... Look at the source code of libmysql? So, document regarding this protocol doesn't exist? I didn't say that. I don't know of such a document, but I have never heard of it. However, since the protocol can change

<    1   2   3   4   5   6   7   8   9   10   >