RE: Php-mssql connection problems on Windows XP

2008-04-24 Thread Jerry Schwartz
When using odbc_connect, you don't use the DSN you've previously created. You use the complete definition of the connection. Here's an example of connecting to an MS Access database: define('ODBC_CONNECT', 'DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=server

RE: Php-mssql connection problems on Windows XP

2008-04-24 Thread Jerry Schwartz
-Original Message- From: Jerry Schwartz [mailto:[EMAIL PROTECTED] Sent: Thursday, April 24, 2008 10:01 AM To: 'Padiyath Sreekumaran'; mysql@lists.mysql.com Subject: RE: Php-mssql connection problems on Windows XP When using odbc_connect, you don't use the DSN you've previously created

jdbc connection pool problem, help, thanks!

2008-02-24 Thread raybristol
Hi experts, I am looking for a library for managing connection pool as I can't use Tomcat, I found a couple of third party connection pool but with high coupling - using those require me to change quite a lot existing code, I am looking for something which can return a standard connection to me

Re: Lost Connection each hour :(

2008-01-17 Thread Matthias Witte
On Tue, Jan 15, 2008 at 09:27:10PM +0100, MAS! wrote: Can anyone help me to understand why my site (php 4.4.2 / ubuntu dapper) loose all connections to mysql server when /etc/cron/hourly starts? (there are no process to start hourly, the directory is empty) Is the assumption correct, that

Re: Lost Connection each hour :(

2008-01-16 Thread MAS!
Il giorno 16 gen 2008, alle ore 02:59, Moon's Father ha scritto: Post your error message here. (from php) Error message: mysql_connect(): Lost connection to MySQL server during query and I have that for _each_ apache2 thread/php-page opened MAS! -- MySQL General Mailing List For list

Re: Lost Connection each hour :(

2008-01-16 Thread Moon's Father
. (from php) Error message: mysql_connect(): Lost connection to MySQL server during query and I have that for _each_ apache2 thread/php-page opened MAS! -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn

Re: Lost Connection each hour :(

2008-01-16 Thread MAS!
Enter your mysql shell and enter the command: set global max_allowed_packet=10M I have it setted at 32M, but that is not the problem; the data are not too much ... and it's strange because _ALL_ clients seems to died/be disconnected each hour, when the hourly cron runs.. -- MySQL

Re: Lost Connection each hour :(

2008-01-16 Thread Moon's Father
You should give me an error message here. On Jan 16, 2008 4:44 PM, MAS! [EMAIL PROTECTED] wrote: Enter your mysql shell and enter the command: set global max_allowed_packet=10M I have it setted at 32M, but that is not the problem; the data are not too much ... and it's strange because

Re: Lost Connection each hour :(

2008-01-16 Thread Dušan Pavlica
Marco, can you post values of wait_timeout and interactive_timeout variables. You can get them from SHOW VARIABLES output. If they are set to 3600 (1 hour in secs), set them to something bigger like one week and then you will see if it helps or not. You can read more about those timeouts also

Re: Lost Connection each hour :(

2008-01-16 Thread MAS!
can you post values of wait_timeout and interactive_timeout variables. You can get them from SHOW VARIABLES output. If they are set to 3600 (1 hour in secs), set them to something bigger like one week and then you will see if it helps or not. You can read more about

Re: Lost Connection each hour :(

2008-01-16 Thread Dušan Pavlica
MAS! napsal(a): can you post values of wait_timeout and interactive_timeout variables. You can get them from SHOW VARIABLES output. If they are set to 3600 (1 hour in secs), set them to something bigger like one week and then you will see if it helps or not. You can read more about

Re: Lost Connection each hour :(

2008-01-16 Thread Baron Schwartz
Hi, On Jan 16, 2008 3:36 AM, MAS! [EMAIL PROTECTED] wrote: Il giorno 16 gen 2008, alle ore 02:59, Moon's Father ha scritto: Post your error message here. (from php) Error message: mysql_connect(): Lost connection to MySQL server during query and I have that for _each_ apache2 thread

Lost Connection each hour :(

2008-01-15 Thread MAS!
Can anyone help me to understand why my site (php 4.4.2 / ubuntu dapper) loose all connections to mysql server when /etc/cron/hourly starts? (there are no process to start hourly, the directory is empty) I have heavvy web/apache2 traffic on my site and that is not so nice for my users..

Re: Lost Connection each hour :(

2008-01-15 Thread Moon's Father
Post your error message here. On Jan 16, 2008 4:27 AM, MAS! [EMAIL PROTECTED] wrote: Can anyone help me to understand why my site (php 4.4.2 / ubuntu dapper) loose all connections to mysql server when /etc/cron/hourly starts? (there are no process to start hourly, the directory is empty) I

MySQL server connection question.

2007-12-05 Thread Jeffrey M. Johnson
I hope a simple question, Can a MySQL Client (5.0.14) connect to a MySQL Server (5.1.22) (or more specifically I have a static build of PHP using the libmsqlclient.la from MySQL version 5.0.14 as a client attempting to connect to a MySQL server running version 5.1.22rc.)? My thanks in

RE: MySQL server connection question.

2007-12-05 Thread Rolando Edwards
Subject: MySQL server connection question. I hope a simple question, Can a MySQL Client (5.0.14) connect to a MySQL Server (5.1.22) (or more specifically I have a static build of PHP using the libmsqlclient.la from MySQL version 5.0.14 as a client attempting to connect to a MySQL server

Re: mysql connection problems

2007-11-08 Thread Richard Edward Horner
-h127.0.0.1 Sometime I login it successfully,but most time I can't. The connection seems be blocked. (I don't run any iptables or firewall on this host). This let me really be confused. please help. Thanks! --Ken National Bingo Night. Play along for the chance to win $10,000 every week

mysql connection problems

2007-11-06 Thread tech user
, with the command, mysql -uroot -P3307 -h127.0.0.1 Sometime I login it successfully,but most time I can't. The connection seems be blocked. (I don't run any iptables or firewall on this host). This let me really be confused. please help. Thanks! --Ken National Bingo Night. Play along

MYSQL connection failed: Can not connect to MySQL server

2007-10-30 Thread Jose Romero
Hi,I have a mail system on FreeBSD 6.2 + Exim 4.62 + MySQL 5.0. Exim was compiled with MySQL support, the MySQL database is external to the mail server. Although the system works, I have a lot of daily messages in exim's log with the following error: MYSQL connection failed: Can not connect

Re: MYSQL connection failed: Can not connect to MySQL server

2007-10-30 Thread Dan Nelson
error: MYSQL connection failed: Can not connect to MySQL server on'192 .168.5.1 '(1) What causes some messages are rejected. To try to reproduce the problem I have tried doing Telnet connections to the server and MySQL, sometimes I get the following error: Telnet 192.168.5.1 3306 Trying

Re: How to debug a mysqldump dropped connection error?

2007-09-05 Thread Aiton Goldman
the following error : mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table I am running the pre-compiled 64 bit linux 5.1.20 mysql binaries ( specifically, the Linux non RPM packages ) on a machine with 2 gigs of memory. The error has been seen (so far

How to debug a mysqldump dropped connection error?

2007-09-04 Thread Aiton Goldman
I am having debugging a problem I am seeing with mysqldump. While using mysqldump to make backups of my database, I will intermitently get the following error : mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table I am running the pre-compiled 64 bit linux

Lost Connection

2007-07-23 Thread krishna chandra prajapati
Hi All, I have connect to mysql-server using client. When i run the query it give message lost connection to mysql. The details is as below. mysql select user_id, user_name from user_info; ERROR 2013 (HY000): Lost connection to MySQL server during query. System configuration is Pentium 2.6 Ghz

Lost Connection

2007-07-23 Thread krishna chandra prajapati
Hi All, I have connect to mysql-server using client. When i run the query it give message lost connection to mysql. The details is as below. mysql select user_id, user_name from user_info; ERROR 2013 (HY000): Lost connection to MySQL server during query. System configuration is Pentium 2.6 Ghz

Re: Lost Connection

2007-07-23 Thread Carlos Proal
This can be a serious issue, maybe a sign of some kind of data corruption. If you lost the connection, probably the server is restarting (you can check that on the error log), do this happen only with this table ? Carlos krishna chandra prajapati wrote: Hi All, I have connect to mysql

Error 2013 (Lost Connection to MySQL Server) On A Solaris 10 Box

2007-06-12 Thread Rajesh Mehrotra
Hi, We copied over a test copy of a multi-GB database to a new Sun V440 box running Solaris 10 (64-bit) with a 64-bit MySQL install. When trying to connect to the database, we consistently get Error 2013. Any pointers? TIA. Sincerely, Raj Mehrotra hccs [EMAIL PROTECTED] mailto:[EMAIL

Re: Error 2013 (Lost Connection to MySQL Server) On A Solaris 10 Box

2007-06-12 Thread Baron Schwartz
Rajesh Mehrotra wrote: Hi, We copied over a test copy of a multi-GB database to a new Sun V440 box running Solaris 10 (64-bit) with a 64-bit MySQL install. When trying to connect to the database, we consistently get Error 2013. Any pointers? Check the server's error log and see if there's

Mysql 5.0.* client connection to Mysql 4.0.* Database

2007-06-07 Thread dpgirago
Is it possible to connect to a 4.0.18 DB from the client of a 5.0.27 system? I know there is an old_passwords function. Can this be used somehow from a DOS command prompt? David

Re: Mysql 5.0.* client connection to Mysql 4.0.* Database

2007-06-07 Thread Michael Dykman
Have youtried this yet? While 4.0 client can't connect to a v.5 server unless the passwords have explicitly beewen stored as old_password, I have never run into an issue connecting a 5.x client to a 4.0 server. - michael On 6/7/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Is it possible to

Re: Mysql 5.0.* client connection to Mysql 4.0.* Database

2007-06-07 Thread dpgirago
Yes, I did try. The issue was the security level setting on the new DB server, and not the password stuff. I've upgraded apache, mysql, and php in the last few weeks, and 3-4 issues became painfully apparent when going from php4 to php5, so I guess I was operating under similar assumptions and

Server/Client connection compression

2007-06-01 Thread Giorgio Zarrelli
Hi, I saw that to enable server/client protocol compression I can start mysql with the -C option. Is there a configuration keyword to write in my.cnf to enable server/client protocol compression? Thanks Giorgio Zarrelli -- MySQL General Mailing List For list archives:

Re: Server/Client connection compression

2007-06-01 Thread Baron Schwartz
Hi, Giorgio Zarrelli wrote: Hi, I saw that to enable server/client protocol compression I can start mysql with the -C option. Is there a configuration keyword to write in my.cnf to enable server/client protocol compression? Yes. In general, most command-line options can be written into

Connection time out/slow response from server

2007-05-30 Thread Tuc at T-B-O-H.NET
Hi, Running 4.1.22 created from FreeBSD ports on FreeBSD 5.5 . I run under TCP Wrappers. Even if 1 foreign machine attempts to contact us on the tcp port, the database becomes incredibly sluggish or unresponsive at all. Is there something I can do to prevent this from

A question about how to debug the error 2013, 'Lost connection to MySQL server during query'

2007-05-23 Thread aiton
I am running the 64 bit version of mysql server 5.1.18, and on the client side I am running python with the mysqldb module. While running a very large insert query I get the following error : 2013, 'Lost connection to MySQL server during query' I have --log-warnings set to 3, but I get

Re: A question about how to debug the error 2013, 'Lost connection to MySQL server during query'

2007-05-23 Thread Sebastian Mendel
[EMAIL PROTECTED] schrieb: I am running the 64 bit version of mysql server 5.1.18, and on the client side I am running python with the mysqldb module. While running a very large insert query I get the following error : 2013, 'Lost connection to MySQL server during query' I have --log

Re: Weird connection timed-out

2007-05-15 Thread Jerome Macaranas
On Tuesday 15 May 2007 02:56, Dan Buettner wrote: Hi JM - Can you send us a few things? 1 - the exact error message you get the error code it produced is (110) which according to perror is connection time out.. 2 - the output of SHOW VARIABLES; from a mysql session

Re: Weird connection timed-out

2007-05-15 Thread Dan Buettner
Thanks Jerome. With the high number of aborted_clients, it seems like you might have networking issues: http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html Dan

Weird connection timed-out

2007-05-14 Thread JM
Hi, Im using MySQL-5.0.19-0 and for some reason when ever PHP connects to the DB the server won't respond immediately causing the conenct to time-out.. No firewall issues and no network related issues. The only thing that I noticed is that the server's average load is 60%.

Re: Weird connection timed-out

2007-05-14 Thread JM
after trying it again ang again.. maybe for the 5th time.. PHP will now be able to connect.. On Monday 14 May 2007 22:34, JM wrote: Hi, Im using MySQL-5.0.19-0 and for some reason when ever PHP connects to the DB the server won't respond immediately causing the conenct to time-out..

Re: Weird connection timed-out

2007-05-14 Thread Dan Buettner
Hi JM - Can you send us a few things? 1 - the exact error message you get 2 - the output of SHOW VARIABLES; from a mysql session 3 - the output of SHOW STATUS; from a mysql session What have you tried so far in terms of troubleshooting that has been unsuccessful? Any recent changes on the

Re: Weird connection timed-out

2007-05-14 Thread Peter Brawley
DB the server won't respond immediately causing the conenct to time-out.. Does your script start with an information_schema query? The frist one of those is painfully slow with MySQL. Did you try set_time_limit( 0 )? PB - JM wrote: after trying it again ang again.. maybe for the 5th

Re: Mysterious 'Lost connection' errors

2007-05-11 Thread Jon Ribbens
On Thu, May 10, 2007 at 05:17:12PM +0100, Jon Ribbens wrote: I suspect some sort of bug in the MySQLd authentication code. I've managed to discover using --debug that it's due to MySQLd failing to handle EINTR from read() in the authentication stage. I've filed a bug report:

Re: Mysterious 'Lost connection' errors

2007-05-10 Thread Jon Ribbens
connection to MySQL server at 'reading authorization packet', system error: 0) (still nothing in the logfile). Does this ring any bells for anyone? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysterious 'Lost connection' errors

2007-05-10 Thread mos
At 06:03 AM 5/10/2007, you wrote: reading authorization packet If you do a google search: http://www.google.ca/search?q=lost+mysql+connection+%22reading+authorization+packet%22hl=enstart=90sa=N you'll find about a hundred web sites encountering the exact same error. Ironically

Re: Mysterious 'Lost connection' errors

2007-05-10 Thread Jon Ribbens
On Thu, May 10, 2007 at 08:58:37AM -0600, mos wrote: If you do a google search: http://www.google.ca/search?q=lost+mysql+connection+%22reading+authorization+packet%22hl=enstart=90sa=N you'll find about a hundred web sites encountering the exact same error. Indeed, I noticed that ;-) Maybe

Mysterious 'Lost connection' errors

2007-05-09 Thread Jon Ribbens
We are using MySQL 5.0.27 on RedHat Enterprise Linux ES release 4, and the MySQL-python-1.2.1_p2 connector. We are getting intermittent mysterious errors as follows: OperationalError: (2013, 'Lost connection to MySQL server during query') when attempting to connect to the MySQL server

Re: Mysterious 'Lost connection' errors

2007-05-09 Thread Michael Dykman
the problem. On 5/9/07, Jon Ribbens [EMAIL PROTECTED] wrote: We are using MySQL 5.0.27 on RedHat Enterprise Linux ES release 4, and the MySQL-python-1.2.1_p2 connector. We are getting intermittent mysterious errors as follows: OperationalError: (2013, 'Lost connection to MySQL server during query

Re: Mysterious 'Lost connection' errors

2007-05-09 Thread Jon Ribbens
On Wed, May 09, 2007 at 09:22:34AM -0400, Michael Dykman wrote: I realize that's quite unlikely that you have performed a similar sloppy import but there is likely some edge condition on your server (wierd permissions in the data directory, corruoted tables, etc.) but I still recommend that

Re: Mysterious 'Lost connection' errors

2007-05-09 Thread Michael Dykman
When we first examined our server logs, we saw the same.. in our case (again) it was only when we slowed down and examined the timestamps on the start/stop messages that we realized that the server was restarting at unexpected intervals. Over the course of our development, we came across this

Re: Mysterious 'Lost connection' errors

2007-05-09 Thread mos
a simple query has lost the connection. :( Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysterious 'Lost connection' errors

2007-05-09 Thread Jon Ribbens
intervals. The last restart, according to both the content of the log, and the operating system timestamp on the log file itself, was 6 days ago. The 'lost connection' message has happened several times today, however. (how did you get your binaries? pre-compiled from the archive or build your

Re: Mysterious 'Lost connection' errors

2007-05-09 Thread Mathieu Bruneau
Jon Ribbens a écrit : We are using MySQL 5.0.27 on RedHat Enterprise Linux ES release 4, and the MySQL-python-1.2.1_p2 connector. We are getting intermittent mysterious errors as follows: OperationalError: (2013, 'Lost connection to MySQL server during query') when attempting

Re: Mysterious 'Lost connection' errors

2007-05-09 Thread Jon Ribbens
On Wed, May 09, 2007 at 10:07:41PM -0400, Mathieu Bruneau wrote: We found a similar issue because we were using persistent connection in php and had a firewall between the mysql and the webserver. The problem is that our persistent connection were setup for lasting up to something like 8 hours

Database Connection Problem with MAMP (Mac)

2007-03-26 Thread David Blomstrom
a user named 127.0.0.1, which I believe is my webserver's IP address. I assigned no password. This is what my connection looks like: $link = mysql_connect (127.0.0.1 , , ) or die(mysql_error()); mysql_select_db (WebServer, $link) or die(mysql_error()); I also tried it with host also designated

Need Database Connection Sans Password

2007-03-23 Thread David Blomstrom
How would you write a database connection for a database on which you haven't yet established a username or password? None of the following work: $link = mysql_connect (localhost , root , ) or die(mysql_error()); mysql_select_db (test, $link) or die(mysql_error()); $link = mysql_connect

Re: Need Database Connection Sans Password

2007-03-23 Thread Rolando Edwards
??? - Original Message - From: David Blomstrom [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, March 23, 2007 11:42:28 AM (GMT-0500) Auto-Detected Subject: Need Database Connection Sans Password How would you write a database connection for a database on which you haven't yet established

Re: Need Database Connection Sans Password

2007-03-23 Thread David Blomstrom
[EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, March 23, 2007 11:42:28 AM (GMT-0500) Auto-Detected Subject: Need Database Connection Sans Password How would you write a database connection for a database on which you haven't yet established a username or password? None of the following work

Re: Need Database Connection Sans Password

2007-03-23 Thread David Blomstrom
ALL PRIVILEGES Yes Yet I can't write a database connection using chestnut as the usernameexcept for the table test. This is what its privileges look like: User Host Type Privileges Grant Action

ERROR 2013 (HY000): Lost connection to MySQL server during query, 061220 14:48:44 mysqld restarted

2006-12-20 Thread Kieran Kelleher
2013 (HY000): Lost connection to MySQL server during query ([EMAIL PROTECTED]) (none) 061220 14:48:44 mysqld restarted Also, if I execute mysqladmin shutdown, it restarts also slmini:/usr/local admin$ mysqladmin -u root -p shutdown Enter password: slmini:/usr/local admin$ 061220 14:59:19 mysqld

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query, 061220 14:48:44 mysqld restarted

2006-12-20 Thread Kieran Kelleher
): Lost connection to MySQL server during query ([EMAIL PROTECTED]) (none) 061220 14:48:44 mysqld restarted Also, if I execute mysqladmin shutdown, it restarts also slmini:/usr/local admin$ mysqladmin -u root -p shutdown Enter password: slmini:/usr/local admin$ 061220 14:59:19 mysqld restarted

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query, 061220 14:48:44 mysqld restarted

2006-12-20 Thread Kieran Kelleher
was stopped. Here is error I got this time for stop slave: stop slave; ERROR 2013 (HY000): Lost connection to MySQL server during query ([EMAIL PROTECTED]) (none) /usr/local/mysql/bin/mysqld_safe: line 1: 401 Illegal instruction nohup /usr/local/mysql/libexec/ mysqld --defaults-extra-file=/usr

lost connection to MySQL server during qu ery

2006-11-29 Thread wq
i've done a non-stop insert test for 3 days, using mysql++ to connect to MySQL server i only use one connection, if it fails to execute ,it will reconnect during this test , this exception came out twice is that because of the server or the client?

too many connection

2006-11-19 Thread eng.waleed
Hi my database engine stopped suddenly and when I try to open it from shell it give me message too many connection then the server hang and I restart it and every thing go ok but how I can know the reason of that hanging and what have to optimize the number of connections BR

Re: Losing MySQL 5.0 connection at random on Windows box

2006-10-27 Thread Peter Rosenthal
10061 means actively refused. Maybe check your event log around the same time to see if mysql died? On 27/10/06, mos [EMAIL PROTECTED] wrote: Since installing MySQL 5.0.24 on Windows XP, once or twice a week I'll get an error message Can't connect to MySQL server on 'localhost' (10061) Socket

Losing MySQL 5.0 connection at random on Windows box

2006-10-26 Thread mos
Since installing MySQL 5.0.24 on Windows XP, once or twice a week I'll get an error message Can't connect to MySQL server on 'localhost' (10061) Socket error on connect. WSAGetLastError return 10061. Does anyone know what could be causing it? This didn't happen when I ways using MySQL 4.1

Connection character set be changed silently?

2006-10-19 Thread Hanson Lu
4.1.7, the connection was disconnnected by server since wait_timeout was set to 8 hours. why the characoter set would be changed with MYSQL 4.1.12? My programm use MYSQL C API. MySQL setting : My.cnf [mysqld] socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility

Client connection character set be changed after a long while?

2006-10-18 Thread Hanson Lu
My programm connect to MYSQL server, adn set it's charactor set by set NAMES gbk, after a long while, like one night, I found the client charactor set have been changed to latin, it seems related to some timeout value. why the characotor set would be changed? My programm use MYSQL C API.

remote connection

2006-10-14 Thread Chris W
and they all connect fine. The only thing php gives me back is ... *Warning*: mysql_connect(): Lost connection to MySQL server during query in *Test.php* on line *18* Could not connect: Lost connection to MySQL server during query The user I am connecting with has host set to '%' with only one

Re: remote connection

2006-10-14 Thread Dan Buettner
3306 Trying 192.168.2.4... Connected to 192.168.2.4. Escape character is '^]'. A 5.0.21-standard-log8E]@R[Tq,^bSW;_ONv)gO and then after a couple of seconds, Connection closed by foreign host. If you can get this, then your connection is probably not restricted at the firewall. If you can't

Re: FreeBSD 6.1 + Libthr + MySQL 5.0.24a max connection issue or bug?

2006-10-05 Thread Abdullah Ibn Hamad Al-Marri
PROTECTED] Sent: Wednesday, October 4, 2006 11:59:27 PM Subject: Re: FreeBSD 6.1 + Libthr + MySQL 5.0.24a max connection issue or bug? Have a look at kern.threads.max_threads_per_proc: 1500 and kern.threads.max_groups_per_proc: 1500 You are probably hitting one of these sysctl's. Here is a link

Connection timeouts

2006-10-04 Thread Brian Campbell
Hi All, I've got a client, written in C++, that connects to a MySQL (5.x) DB. I need keep my connection open for a long time (right now hours, but possibly days in the future). But I need this client and only this client to maintain the connection for a long time. All my other clients need

Re: FreeBSD 6.1 + Libthr + MySQL 5.0.24a max connection issue or bug?

2006-10-04 Thread Ken Menzel
connection issue or bug? Hello folks, I hope Greg is reading this list I use MySQL 5.0.24a from the FreeBSD ports, with libthr threading. I have a huge app makes alot of connections to MySQL server. The max I could reach is 1500 threads, even I made the max connection in my.cf 5k and I used

FreeBSD 6.1 + Libthr + MySQL 5.0.24a max connection issue or bug?

2006-10-03 Thread Abdullah Ibn Hamad Al-Marri
Hello folks, I hope Greg is reading this list I use MySQL 5.0.24a from the FreeBSD ports, with libthr threading. I have a huge app makes alot of connections to MySQL server. The max I could reach is 1500 threads, even I made the max connection in my.cf 5k and I used

FreeBSD 6.1 + Libthr + MySQL 5.0.24a max connection issue or bug?

2006-10-03 Thread Abdullah Ibn Hamad Al-Marri
Hello folks, I hope Greg is reading this list I use MySQL 5.0.24a from the FreeBSD ports, with libthr threading. I have a huge app makes alot of connections to MySQL server. The max I could reach is 1500 threads, even I made the max connection in my.cf 5k and I used

Connection Pooling with mysql-5.1.11-beta-linux-i686

2006-08-28 Thread Rob Emanuele
Greetings all, I'm working with mysql-5.1.11-beta-linux-i686 set up using the NDB cluster. I was wondering if there are any limitations or inefficiencies if I was to use a connection pool to the mysql server(s) front-ending the cluster? Several processes will make a request of our server

Re: Connection Help - Stupid Question, sorry to bother.

2006-08-13 Thread Chris
Chris W wrote: By default MySQL uses port 3306 so you need to be sure that port is open on the server, and not blocked by a firewall. You also need to be sure the user you are trying to login as can login remotely. In the MySQL user data base, there is a column for host which is the host

Connection Help - Stupid Question, sorry to bother.

2006-08-12 Thread Sana Farshidi
and connection details. I downloaded a mysql program (enginsite MySql client) and tried to connect but am not having any luck and have no idea what the port is supposed to be... the detail i have are: (of course ive undisclosed the username/passwords) DOMAIN ACCOUNT DETAILS Domain Name

Re: Connection Help - Stupid Question, sorry to bother.

2006-08-12 Thread Chris W
connecting. Ive used mysql before, not very efficiently, but never have had to set it up, i was always told the program and connection details. I downloaded a mysql program (enginsite MySql client) and tried to connect but am not having any luck and have no idea what the port is supposed

RE: identify process that created the connection

2006-08-02 Thread Rithish Saralaya
, but on another server. Hence, I would not be using up any up any conenctions on my live server for this. My issue is that I want to log the MySQL connection id of server1 in server 2. How will I achieve this, as connection_id() will return the current connection id (i.e. for server2)? Regards

identify process that created the connection

2006-07-27 Thread Rithish Saralaya
to the fact that some of my web-page(s) have obtained a mysql connection, executed their queries, but have not terminated(and have not released the mysql connection also). If I could know the httpd processes that have created these connections, I would be able to find out the pages

Re: identify process that created the connection

2006-07-27 Thread Ravi Prasad LR
This blog may help, http://www.xaprb.com/blog/2006/07/23/how-to-track-what-owns-a-mysql-connection/ Cheers, Ravi Rithish Saralaya wrote: Hello people. Is it possible to find the process that invoked the mysql thread, given a mysql thread id? We have a web application that runs on Linux

RE: undefined reference to `mysqlpp::Connection::Connection(bool)'

2006-07-25 Thread ali asghar torabi parizy
PROTECTED] Sent: Monday, 24 July 2006 7:29 PM To: mysql@lists.mysql.com Subject: RE: undefined reference to `mysqlpp::Connection::Connection(bool)' Hi.thanks logan. I am begeener to MySQL. I have installed Suse10 and MySQL and mysql++ in my pc. i trying too many pathes in gcc cammand

undefined reference to `mysqlpp::Connection::Connection(bool)'

2006-07-24 Thread ali asghar torabi parizy
): undefined reference to `mysqlpp::Connection::Connection(bool)' custom1.cpp:(.text+0x46): undefined reference to `connect_to_db(int, char**, mysqlpp::Connection, char const*)' custom1.cpp:(.text+0x7f): undefined reference to `mysqlpp::Connection::query()' custom1.cpp:(.text+0x96): undefined reference

RE: undefined reference to `mysqlpp::Connection::Connection(bool)'

2006-07-24 Thread Logan, David (SST - Adelaide)
@lists.mysql.com Subject: undefined reference to `mysqlpp::Connection::Connection(bool)' Hi, I am begeener to MySQL. I have installed Suse10 and MySQL and mysql++ in my pc. i want to connect to MySQL through C. When I am compiling the program, I am getting the following error

RE: undefined reference to `mysqlpp::Connection::Connection(bool)'

2006-07-24 Thread ali asghar torabi parizy
': custom1.cpp:(.text+0x2f): undefined reference to `mysqlpp::Connection::Connection(bool)' custom1.cpp:(.text+0x46): undefined reference to `connect_to_db(int, char**, mysqlpp::Connection, char const*)' custom1.cpp:(.text+0x7f): undefined reference to `mysqlpp::Connection::query()' custom1.cpp:(.text+0x96

RE: undefined reference to `mysqlpp::Connection::Connection(bool)'

2006-07-24 Thread Logan, David (SST - Adelaide)
PROTECTED] Sent: Monday, 24 July 2006 7:29 PM To: mysql@lists.mysql.com Subject: RE: undefined reference to `mysqlpp::Connection::Connection(bool)' Hi.thanks logan. I am begeener to MySQL. I have installed Suse10 and MySQL and mysql++ in my pc. i trying too many pathes in gcc cammand

Re: Announce: LBPool 1.0 beta1 (Load Balancing JDBC Connection Pool)

2006-07-19 Thread Christopher G. Stach II
Kevin Burton wrote: Hey Gang. I wanted to get this out on the list and facilitate some feedback. http://www.feedblog.org/2006/07/announce_lbpool.html What does this have over MySQL Connector/J's load balancing? -- Christopher G. Stach II -- MySQL General Mailing List For list

Re: Announce: LBPool 1.0 beta1 (Load Balancing JDBC Connection Pool)

2006-07-19 Thread Kevin Burton
There was a thread before about this... this is much better than connector J's load balancing. You can take machines out of production, add thhem back in, it's MySQL slave aware, etc On 7/19/06, Christopher G. Stach II [EMAIL PROTECTED] wrote: Kevin Burton wrote: Hey Gang. I wanted to get

mysql hangs on connection attempt

2006-07-18 Thread Steve Strong
we are using php to connect to our mysql database and when we call the php function with this line: $dbh = mysql_connect(localhost, george_full, passwd) or die (formatSQLError()); george_full has full priveleges on localhost with his password. localhost resolves to 127.0.0.1 using the host

Re: mysql hangs on connection attempt

2006-07-18 Thread Daniel da Veiga
On 7/18/06, Steve Strong [EMAIL PROTECTED] wrote: we are using php to connect to our mysql database and when we call the php function with this line: $dbh = mysql_connect(localhost, george_full, passwd) or die (formatSQLError()); That's the only line of your .php script? george_full has

Re: mysql hangs on connection attempt

2006-07-18 Thread Steve Strong
here is the entire function: function readonlyConnect() { $dbh=mysql_connect (localhost, george_readonly, tiWhs!asAt!) or die (formatSQLError()); mysql_select_db (george_crwash2); return $dbh; } a die() statment before the first line of code in this function echos to the

Re: mysql hangs on connection attempt

2006-07-18 Thread Gerald L. Clark
to 127.0.0.1 using the host command pinging localhost returns packets as expected localhost is for a socket connection. If you want 127.0.0.1 than use 127.0.0.1. the execution of the script terminates. from the command line i've done the following: 1. connected to the database with the same credentials

Announce: LBPool 1.0 beta1 (Load Balancing JDBC Connection Pool)

2006-07-18 Thread Kevin Burton
. == The lbpool project provides a load balancing JDBC driver for use with DB connection pools. It wraps a normal JDBC driver providing reconnect semantics in the event of additional hardware availability, partial system failure, or uneven load distribution. It also evenly distributes all new

Funny connection problem

2006-06-25 Thread Severn
Hello, I'm running MySQL 5.0.22 x86_64 on CentOS 4.3 on one server and web apps on another server. Occasionally these web apps (PHP) will return error 1130, Host 'x' is not allowed to connect to this MySQL server. From my understanding of the documentation, this is an access denied

ERROR 2013 (HY000): Lost connection to MySQL server during query

2006-06-08 Thread murthy gandikota
Hi, I am getting this error. Can anyone please help? mysql create table sfgbackup.advEmail select * from sfg.advEmail; ERROR 2013 (HY000): Lost connection to MySQL server during query Bye [EMAIL PROTECTED] mgandikota]$ mysql -V mysql Ver 14.7 Distrib 5.0.2-alpha, for pc-linux (i686) Thanks

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

2006-06-08 Thread 古雷
connection to MySQL server during query Hi, I am getting this error. Can anyone please help? mysql create table sfgbackup.advEmail select * from sfg.advEmail; ERROR 2013 (HY000): Lost connection to MySQL server during query Bye [EMAIL PROTECTED] mgandikota]$ mysql -V mysql Ver 14.7 Distrib

Problem with JDBC Connection

2006-06-03 Thread VenuGopal Papasani
Hi all, I have got a problem with the jdbc connection while connecting to Mysql.I have written an XML file.The following is the code for giving the database connection DATABASE type=String drivercom.mysql.jdbc.Driver\driver database locationjdbc:mysql

error in JDBC Connection(Sorry there was TYPO ERROR in my previous mail)

2006-06-03 Thread VenuGopal Papasani
Hi all, I have got a problem with the jdbc connection while connecting to Mysql.I have written an XML file.The following is the code for giving the database connection DATABASE type=String drivercom.mysql.jdbc.Driver\driver database locationjdbc:mysql

Re: How to find out about SSL connection?

2006-05-31 Thread Joerg Bruehe
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 does not support SSL, or does not have it switched on (lacks a certificate). Please check the bugs database for this, and submit a feature request

Re: How to find out about SSL connection?

2006-05-31 Thread Yves Goergen
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 does not support SSL, or does

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