RE: Aborted connection error on RedHat 7
Be so kind and read the archives :-). Do you happen to use PHP? If so, get the newest release from http://snaps.php.net. You should be fine then. Maciek > -Original Message- > From: Daniel Fritzler [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 02, 2001 5:07 AM > To: [EMAIL PROTECTED] > Subject: Aborted connection error on RedHat 7 > > > Hello there. > > I'm writing these lines because I'm having a weird problem with mySQL > 3.23.33 (also with 3.23.32) on servers running RedHat 7.0. > > Each time that I run my SQL based applications, I start getting the > following errors on mySQL: > > 010302 0:45:59 Aborted connection 10207 to db: 'db201' user: 'visual' > host: `sql1' (Got an error reading communication packets) > 010302 0:46:04 Aborted connection 10216 to db: 'db201' user: 'visual' > host: `sql1' (Got an error reading communication packets) > 010302 0:46:10 Aborted connection 10227 to db: 'db201' user: 'visual' > host: `sql1' (Got an error reading communication packets) > 010302 0:46:10 Aborted connection 10225 to db: 'db200' user: 'visual' > host: `sql1' (Got an error reading communication packets) > > I get the above error messages like four times per minute. > > I'm having this problem on three different servers all of them running > RedHat 7.0. > I tried using the precompiled mySQL version, but I got the same error. I > also tried downgrading gcc 2.96 to gcc 2.95 and recompiling mySQL, but the > problem was still there. > > Do you have any ideas of what is causing this? Perhaps it is a > bug on the > RedHat libraries? > > Any help would be appreciated. > > Thank you! > > > Regards, > Daniel Fritzler > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Here you have, ;o)
Isn't it possible the virus itself was actually removed by the mailserver antivirus software? Can anybody confirm this just for we could feel more safe? My Outlook 2000 shows the message and the attachment, but the attachment is a text file with mailing list footer information - just like something in the middle was removed and the rest of mail attached. Maciek > -Original Message- > From: Carsten Gehling [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 13, 2001 9:00 PM > To: [EMAIL PROTECTED] > Subject: Re: Here you have, ;o) > Funny thing actually: My Outlook Express shows a little icon that > symbolizes > an attached file, but there is none in the mailbody? > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: first day glitch
No, you can scroll through your input lines using Up and Down Arrow, then you can edit the particular line using Left and Right Arrow and Backspace. At least this is a way things are supposed to work on a terminal. Maciek > -Original Message- > From: RAJARSHI ADHIKARY [mailto:[EMAIL PROTECTED]] > Sent: Sunday, February 11, 2001 6:44 AM > To: [EMAIL PROTECTED] > Subject: first day glitch > > > I am the first day user. > Do I need to type the commands all over again if it is wrong? > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Add, modify and delete entries with PHP or Perl
try PHPMyEdit: http://phpmyedit.sourceforge.net/ Maciek > -Original Message- > From: Nuno Lopes [mailto:[EMAIL PROTECTED]] > Sent: Saturday, February 10, 2001 11:37 AM > To: Lista MySQL > Subject: Add, modify and delete entries with PHP or Perl > > > Hi, > > I would like to know how to add, modify and delete entries with > PHP or Perl, because I want to create a table in mysql and and > don't know how. > The table look like this: > > -| time spent on-line | leads | mailling list | > e-mail | > -- > - > username1 | 4| 5 | YES | > [EMAIL PROTECTED] | > -- > - > username2 | 6| 8 | NO > | [EMAIL PROTECTED] | > -- > - > username3 | 9| 2 | YES | > [EMAIL PROTECTED] | > -- > - > > > Thanking in advance, > Nuno Lopes > > > P.S.: When you reply to the list, reply to my e-mail > ([EMAIL PROTECTED]), too, please... > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: (Got an error reading communication packets)
> -Original Message- > From: Matis, Jan [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 30, 2001 9:02 PM > To: [EMAIL PROTECTED] > Subject: (Got an error reading communication packets) > do You have an idea why ? yes... > > > I was searching on deja but I didn't found anything :( How did you do it? It's almost impossible... Go to http://www.deja.com/home_ps.shtml and in the 'enter keywords' field type 'error reading communication packets'. Then click 'search'. You'll get about 300 articles on the subject, some with the answer for your question... Maciek - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: aborted connections?
As far as PHP is concerned, 4.0.4pl1 is not enough. You need to install CVS
version later than 2001-01-18. At least this is my experience.
Maciek
> -Original Message-
> From: tc lewis [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 26, 2001 8:47 PM
> To: Maciek Uhlig
> Cc: [EMAIL PROTECTED]
> Subject: RE: aborted connections?
>
>
>
> so we upgraded to 3.23.32 last night, but i'm still seeing a ton of:
> 010126 11:15:24 Aborted connection 30757 to db: 'XXX' user: 'YYY'
> host: `ZZZ' (Got an error reading communication packets)
>
> type errors in the error log.
> i'm seeing these errors from both php connections and from perl dbi
> connections. the versions involved are:
> mysql-3.23.32
> php-4.0.4pl1
> DBI-1.14
> Msql-Mysql-modules-1.2215
> oh and perl is v5.6.0.
>
> which i believe are the latest stable releases of each.
>
> anything else i should be looking for?
>
> -tcl.
>
>
> On Tue, 23 Jan 2001, tc lewis wrote:
>
> >
> > thanks for the reply. i found a followup on this problem from sasha
> > ("Follow up on aborted connections bug in 3.23.31"), but wading through
> > the archive searching for the original thread hasn't ended up being
> > successful yet. anyone know offhand in which thread this was originally
> > discussed?
> >
> > not all of these errors are coming from php connections. does php have
> > some related issue with this also?
> >
> > -tcl.
> >
> > ps- i like these informative changelog entries:
> >
> > . "Fixed security bug in something (please upgrade if you are
> using a earlier MySQL 3.23 version)."
> > . "Fixed buffer overflow bug when writing a certain error message."
> >
> >
> > On Tue, 23 Jan 2001, Maciek Uhlig wrote:
> >
> > > Read the archives. The detailed story can be found there. Use
> newest MySQL
> > > and newest PHP CVS. These errors will go away.
> > >
> > > Maciek
> > >
> > > > -Original Message-
> > > > From: tc lewis [mailto:[EMAIL PROTECTED]]
> > > > Sent: Tuesday, January 23, 2001 3:56 AM
> > > > To: [EMAIL PROTECTED]
> > > > Subject: aborted connections?
> > > >
> > > >
> > > >
> > > > we're seeing a lot of errors like these in our error log
> files from mysql:
> > > >
> > > > 010122 17:38:52 Aborted connection 177373 to db: 'XXX' user: 'YYY'
> > > > host: `ZZZ' (Got an error reading communication packets)
> > > >
> > > > i haven't investigated too too much about this yet, but i
> was wondering
> > > > what common problems this error might be associated with. i'll keep
> > > > looking through the manual, but suggestions would of course
> be wonderful.
> > > >
> > > > the connections are over ethernet/tcp, and the eth
> interfaces on the mysql
> > > > server are showing 0 errors after months of uptime, so i'm
> guessing it's
> > > > not a tcp/ip issue, as the wording of that error might suggest.
> > > >
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: aborted connections?
Read the archives. The detailed story can be found there. Use newest MySQL and newest PHP CVS. These errors will go away. Maciek > -Original Message- > From: tc lewis [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 23, 2001 3:56 AM > To: [EMAIL PROTECTED] > Subject: aborted connections? > > > > we're seeing a lot of errors like these in our error log files from mysql: > > 010122 17:38:52 Aborted connection 177373 to db: 'XXX' user: 'YYY' > host: `ZZZ' (Got an error reading communication packets) > > i haven't investigated too too much about this yet, but i was wondering > what common problems this error might be associated with. i'll keep > looking through the manual, but suggestions would of course be wonderful. > > the connections are over ethernet/tcp, and the eth interfaces on the mysql > server are showing 0 errors after months of uptime, so i'm guessing it's > not a tcp/ip issue, as the wording of that error might suggest. > > -tcl. > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [PHP-DEV] RE: mysql_pconnect still broken (was: RE: What does this mean ?)
I think you might be interested in some feedback after the newest PHP snapshot with a fix was installed here. The "Aborted connection ... (Got an error reading communication packets)" messages disappeared. This may seem as expected behaviour. However there is one additional point worth mentioning: In order to get rid of these annoying messages it is _not_ sufficient to install lastly fixed PHP. In order to get rid of them I had to compile the newest PHP snapshot with MySQL 3.23 (3.23.27-beta or 3.23.28-gamma) client library instead 3.22 (3.22.25) one which was used before till today (releases between them, as well as PHP bundled client, were not tested :-)). I thought it may be interesting for some - and for the record. Thank you, Steven and Zeev :-) Maciek > -Original Message- > From: Zeev Suraski [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 17, 2001 12:48 AM > To: Steven Roussey > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; Mysql > Subject: Re: [PHP-DEV] RE: mysql_pconnect still broken (was: RE: > What does this mean ?) > > > Yep, you're right. Fixed. > > Thanks, > > Zeev > > At 23:24 16/1/2001, Steven Roussey wrote: > > > OK. Look at a quick report. I've just installed > php4-200101152345. It runs > > > with mysql-3.23.27-beta. Apache 1.3.12, Solaris 2.6 (local > host) and 2.4 > > > (remote connection). > > > > > > What I can see is: the offending messages didn't vanish at > all (both hosts > > > are involved): [stuff deleted] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql_pconnect still broken (was: RE: What does this mean ?)
OK. Look at a quick report. I've just installed php4-200101152345. It runs with mysql-3.23.27-beta. Apache 1.3.12, Solaris 2.6 (local host) and 2.4 (remote connection). What I can see is: the offending messages didn't vanish at all (both hosts are involved): 010116 20:52:30 Aborted connection 36021 to db: '***' user: '***' host: `***' (Got an error reading communication packets) So, I think it's not fixed yet. Steven, you wrote about 99,8. I suppose every Apache process here makes this error while ending. I just see it. Steven, thank you for your efforts. Hope you can fix even that. Please let me know about patches: I'll happily test them. I'm not able to fix it by myself, but I'd like at least be helpful. Maciek [stuff deleted] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: What does this mean ?
That is what I suspected. I suffer the same. The problem is buggy PHP persistent connection code. The "almost good" solution was presented to PHP people by Steven Roussey (http://marc.theaimsgroup.com/?l=php-dev&m=97562841130973&w=2) and (http://marc.theaimsgroup.com/?l=php-dev&m=97858730928909&w=2) and according to Andi Gutmans (http://marc.theaimsgroup.com/?l=php-dev&m=97858932431876&w=2) the patch was committed to PHP CVS. However the patch is absent even from PHP 4.0.4pl1 (its zend_list.c is dated 2000-10-20). You might try to patch your PHP by yourself. Or try the latest snapshot from http://snaps.php.net (though I don't know if the patch is there). Sincerely speaking I don't know why Steven's patches haven't been incorporated into PHP 4.0.4pl1. Maybe Andi (Cc:ed) could explain this? Maciek > -Original Message- > From: Denis Gasparin [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 16, 2001 8:50 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: What does this mean ? > > > I use php 4.0.3 with persistent connections. MySQL is installed on Linux > RedHat 7.0. > The problem is that the Mysql exists and I don't know exactly > what appends > to the php process > > Denis > > At 19.21 15/01/01, Maciek Uhlig wrote: > >Could you describe what exactly software connects to MySQL in your case? > > > >Maciek > > > > > -Original Message- > > > From: Denis Gasparin [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, January 15, 2001 6:00 PM > > > To: [EMAIL PROTECTED] > > > Subject: What does this mean ? > > > > > > > > > From when I installed the mysql 3.23.30gamma I have mysql > > > reporting these > > > warnings: > > > > > > 10115 17:51:22 Aborted connection 2886 to db: 'db_name' user: > > > 'user' host: > > > `www.host' > > > (Got an error reading communication packets) > > > 010115 17:51:36 Aborted connection 3754 to db: 'db_name' user: 'user' > > > host: `www.host' > > > (Got an error reading communication packets) > > > > > > We have 700-800 contemporary connections to mysql and these > warnings are > > > given periodically every 5-10 minutes... > > > > > > Why does Mysql generate these logs? > > > > > > Denis > > > > > > > > > - > > > Before posting, please check: > > >http://www.mysql.com/manual.php (the manual) > > >http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Your favorite Windows MySQL GUI client?
Although it is not strictly speaking Windows MySQL GUI client, I'd like to recommend PHPGen (http://opensource.aventus.org/phpgen/phpgen.html) . It meets all your criteria, but it's not a client, but rather PHP client program generator. If you happen to have PHP with your webserver, give it a try. And yes, the generated client runs under Windows - in a browser window... Maciek > -Original Message- > From: Philip Mak [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 15, 2001 7:08 PM > To: [EMAIL PROTECTED] > Subject: Your favorite Windows MySQL GUI client? > > > Hello, > > What is your favorite Windows MySQL GUI client? I'm developing a database > driven website and I'm looking for a program that I can use to maintain > the database. > > One of my special requirements is that I need a client that can edit text > blobs. So far the clients I've seen display the text blob as one very long > line that is difficult to edit. > > Criteria: > > - fairly stable > - free > - can directly edit the data by clicking on rows > - can edit text blobs in a multiline text area > > Thanks, > > -Philip Mak ([EMAIL PROTECTED]) > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: What does this mean ?
Could you describe what exactly software connects to MySQL in your case? Maciek > -Original Message- > From: Denis Gasparin [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 15, 2001 6:00 PM > To: [EMAIL PROTECTED] > Subject: What does this mean ? > > > From when I installed the mysql 3.23.30gamma I have mysql > reporting these > warnings: > > 10115 17:51:22 Aborted connection 2886 to db: 'db_name' user: > 'user' host: > `www.host' > (Got an error reading communication packets) > 010115 17:51:36 Aborted connection 3754 to db: 'db_name' user: 'user' > host: `www.host' > (Got an error reading communication packets) > > We have 700-800 contemporary connections to mysql and these warnings are > given periodically every 5-10 minutes... > > Why does Mysql generate these logs? > > Denis > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
