MySQL 4.0.27-client and MySQL-4.1.21 server
hi Why is it that I cannot connect to mysql-4.1 server using mysql-4.0.27 client? ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client Where is the RTFM on this? I just want to read it. -Wash http://www.netmeister.org/news/learn2quote.html DISCLAIMER: See http://www.wananchi.com/bms/terms.php -- +==+ |\ _,,,---,,_ | Odhiambo Washington[EMAIL PROTECTED] Zzz /,`.-'`'-. ;-;;,_ | Wananchi Online Ltd. www.wananchi.com |,4- ) )-,_. ,\ ( `'-'| Tel: +254 20 313985-9 +254 20 313922 '---''(_/--' `-'\_) | GSM: +254 722 743223 +254 733 744121 +==+ Any fool can paint a picture, but it takes a wise person to be able to sell it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Table Corruption
Hello DB-users,admins, I have serious problem with a table in a DB that I have. This is on a mysql-4.0.20. mysql CHECK TABLE Users; +--+---+--+--+ | Table| Op| Msg_type | Msg_text | +--+---+--+--+ | atmail.Users | check | warning | Table is marked as crashed | | atmail.Users | check | warning | Size of indexfile is: 23552 Should be: 1024 | | atmail.Users | check | warning | Size of datafile is: 81368 Should be: 0 | | atmail.Users | check | error| Found wrong record at 0 | | atmail.Users | check | error| Corrupt | +--+---+--+--+ 5 rows in set (0.39 sec) Initially ... beastie# ls -al Users.* -rwxr-x--- 1 mysql mysql 81368 Aug 4 11:33 Users.MYD -rwxr-x--- 1 mysql mysql 23552 Aug 4 14:29 Users.MYI -rwxr-x--- 1 mysql mysql 9404 Aug 4 11:33 Users.frm I have read the manuals about myisamchk (-e, -r, -o) and REPAIR TABLE table_name USE_FRM but in both cases when I perform the repair, the Users.MYI is then reset to a value of 0. After I run repair mysql REPAIR TABLE Users USE_FRM; +--++--++ | Table| Op | Msg_type | Msg_text | +--++--++ | atmail.Users | repair | info | Key 1 - Found wrong stored record at 0 | | atmail.Users | repair | status | OK | +--++--++ 2 rows in set (0.05 sec) beastie# ls -al Users.* -rwxr-x--- 1 mysql mysql 0 Aug 4 14:36 Users.MYD -rwxr-x--- 1 mysql mysql 1024 Aug 4 14:36 Users.MYI -rwxr-x--- 1 mysql mysql 9404 Aug 4 11:33 Users.frm Now for sure there is no data at all in the table. mysql select * from Users; Empty set (0.01 sec) Is there hope for me in this situation??? I have googled and googled but all that I see doesn't seem to help me to recover the data in the table. This makes me very desparate. I'd be very thankful for any pointers that would help me out of this successfully. I have backup copies of those files. -Wash http://www.netmeister.org/news/learn2quote.html -- +==+ |\ _,,,---,,_ | Odhiambo Washington[EMAIL PROTECTED] Zzz /,`.-'`'-. ;-;;,_ | Wananchi Online Ltd. www.wananchi.com |,4- ) )-,_. ,\ ( `'-'| Tel: +254 20 313985-9 +254 20 313922 '---''(_/--' `-'\_) | GSM: +254 722 743223 +254 733 744121 +==+ The fact that boys are allowed to exist at all is evidence of a remarkable Christian forbearance among men. -- Ambrose Bierce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Table Corruption
* Egor Egorov [EMAIL PROTECTED] [20040804 16:24]: wrote: Odhiambo Washington [EMAIL PROTECTED] wrote: +--++--++ | atmail.Users | repair | info | Key 1 - Found wrong stored record at 0 | | atmail.Users | repair | status | OK | +--++--++ 2 rows in set (0.05 sec) It seems that MYD contains incorrect data. This might be just a binary junk. Not sure if that is even possible to fix. When I do strings Users.MYD, I can actually see the data!! So there is data in the file. -Wash http://www.netmeister.org/news/learn2quote.html -- +==+ |\ _,,,---,,_ | Odhiambo Washington[EMAIL PROTECTED] Zzz /,`.-'`'-. ;-;;,_ | Wananchi Online Ltd. www.wananchi.com |,4- ) )-,_. ,\ ( `'-'| Tel: +254 20 313985-9 +254 20 313922 '---''(_/--' `-'\_) | GSM: +254 722 743223 +254 733 744121 +==+ Portable, adj.: Survives system reboot. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Convert query from v4 syntax to v3
* Rory McKinley [EMAIL PROTECTED] [20040109 13:21]: wrote: On 7 Jan 2004 at 11:04, Odhiambo Washington wrote: Hello, I have a query that executes well when run on MySQL-4.x, but not 3.23.x: SELECT popbox.local_part, popbox.password_hash, popbox.domain_name, CONCAT(domain.path,'/',popbox.mbox_name) AS path FROM popbox JOIN domain USING (domain_name) I would like to make this query run on a 3.23.58 server. I have tried SELECT popbox.local_part, popbox.password_hash, popbox.domain_name, CONCAT(domain.path,'/',popbox.mbox_name) AS path FROM popbox JOIN domain ON popbox.domain_name=domain.domain_name ..but I still end up with error. Of course I am lost about the syntax now ;) Basically, the problem begings with the USING... [snip] Hi Wash Can you post the error message? The line is part of a small script. The error is: You have an error in your SQL syntax near 'USING (domain_name)' Best regards, Odhiambo Washington Wananchi Online Ltd. PS::REQUEST A: Because it reverses the logical flow of conversation. Q: Why is top posting frowned upon? http://learn.to/edit_messages http://www.netmeister.org/news/learn2quote.html --+- Odhiambo W. wash(at)wananchi(dot)com . WANANCHI ONLINE LTD (Nairobi, KE) http://www.wananchi.com/email/ . 1ere Etage, Loita Hse, Loita St., Mobile: (+254) 722 743 223 . # 10286, 00100 NAIROBI --+- What the hell, go ahead and put all your eggs in one basket. Pride goes before destruction, a haughty spirit before a fall. Proverbs 16:18 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Convert query from v4 syntax to v3
Hello, I have a query that executes well when run on MySQL-4.x, but not 3.23.x: SELECT popbox.local_part, popbox.password_hash, popbox.domain_name, CONCAT(domain.path,'/',popbox.mbox_name) AS path FROM popbox JOIN domain USING (domain_name) I would like to make this query run on a 3.23.58 server. I have tried SELECT popbox.local_part, popbox.password_hash, popbox.domain_name, CONCAT(domain.path,'/',popbox.mbox_name) AS path FROM popbox JOIN domain ON popbox.domain_name=domain.domain_name ..but I still end up with error. Of course I am lost about the syntax now ;) Basically, the problem begings with the USING... -Wash -- +==+ |\ _,,,---,,_ | Odhiambo Washington[EMAIL PROTECTED] Zzz /,`.-'`'-. ;-;;,_ | Wananchi Online Ltd. www.wananchi.com |,4- ) )-,_. ,\ ( `'-'| Tel: +254 20 313985-9 +254 20 313922 '---''(_/--' `-'\_) | GSM: +254 722 743223 +254 733 744121 +==+ Whatever the missing mass of the universe is, I hope it's not cockroaches! -- Mom smime.p7s Description: S/MIME cryptographic signature
mysql 4.1.0-alpha and innodb
Excuse my dumbness, but how do I tell MySQL server that I need InnoDB tables, not MyISAM? I was running 4.0.14 and it was ok, but now when I create a new db in 4.1.0-alpha the tables are defaulting to MyISAM Am I missing some startup option? Thanks. -Wash -- Odhiambo Washington [EMAIL PROTECTED] The box said 'Requires Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,' Tel: +254 2 313985-9 +254 2 313922 so I installed FreeBSD. GSM: +254 72 743223 +254 733 744121 This sig is McQ! :-) You can't carve your way to success without cutting remarks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
strange behaviour
I run mysql on FreeBSD and it's been giving me a lot of problems. Sometimes the load shoots up and some applications cannot access mysql server anymore. During such instances, when I run top, I get something like this: last pid: 57669; load averages: 1.40, 1.52, 1.52 up 30+00:05:29 10:07:24 105 processes: 2 running, 101 sleeping, 1 stopped, 1 zombie CPU states: 10.1% user, 0.0% nice, 69.3% system, 0.2% interrupt, 20.4% idle Mem: 522M Active, 284M Inact, 146M Wired, 48M Cache, 112M Buf, 3916K Free Swap: 1374M Total, 1208K Used, 1373M Free PID USERNAME PRI NICE SIZERES STATE C TIME WCPUCPU COMMAND 12192 mysql 64 0 279M 13716K CPU0 1 93.1H 92.82% 92.82% mysqld I see mysqld taking so much processor time and then I run mytop and I get: MySQL on localhost (3.23.41-log) up 5+18:36:24 [10:04:04] Queries Total: 3,135,669 Avg/Sec: 6.28 Now/Sec: 9.00 Slow: 0 Threads Total: 23Active: 1 Cached: 7 Key Efficiency: 99.99% Bytes in: 285,244,678 Bytes out: 181,425,048 Id User Host DB TimeCmd Query or State -- -- --- -- 399603 root localhosttest 0 Query show full processlist 186085 wolvmail localhost virtualemai 6 Sleep 102684 wolrt2use localhost rt2 12 Sleep 399436 wolvmail localhost virtualemai 86 Sleep 104018 wolrt2use localhost rt2124 Sleep 103015 wolrt2use localhost rt2213 Sleep 103557 wolrt2use localhost rt2213 Sleep 109938 wolrt2use localhost rt2292 Sleep 102741 wolrt2use localhost rt2370 Sleep 103063 wolrt2use localhost rt2410 Sleep 102009 wolrt2use localhost rt2425 Sleep 102737 wolrt2use localhost rt2425 Sleep 103585 wolrt2use localhost rt2707 Sleep 330671 twig275us localhosttwig 55140 Sleep 340661 twig275us localhosttwig 55147 Sleep 340198 twig275us localhosttwig 55206 Sleep 179428 twig275us localhosttwig 55244 Sleep 179385 twig275us localhosttwig 55260 Sleep 349415 twig275us localhosttwig 55334 Sleep 179413 twig275us localhosttwig 55365 Sleep 326960 twig275us localhosttwig 55402 Sleep 330717 twig275us localhosttwig 55453 Sleep 340067 twig275us localhosttwig 0 Sleep 1 system us none 498984 Connec connecting to master My question is: Why connecting to master? Can someone explain this to me? I am lost for what could be causing me so much grief. I am not an MySQL expert. Thanks -Wash -- Odhiambo Washington [EMAIL PROTECTED] The box said 'Requires Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,' Tel: +254 2 313985-9 +254 2 313922 so I installed FreeBSD. GSM: +254 72 743223 +254 733 744121 This sig is McQ! :-) Take my word
DB Problems
Hi Users, I have some problems with my database and not being quite profficient in SQL, I did myisamcheck and posted the data on the site below: http://ns2.wananchi.com/~wash/RT2/myisamcheck.txt I am wondering if someone can take a look and possibly tell me if they notice a problem and what I can do to fix that problem. Thanking you in advance. -Wash -- Odhiambo Washington [EMAIL PROTECTED] The box said 'Requires Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,' Tel: +254 2 313985-9 +254 2 313922 so I installed FreeBSD. GSM: +254 72 743223 +254 733 744121 This sig is McQ! :-) We ARE as gods and might as well get good at it. -- Whole Earth Catalog - 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
Query Error
Hello gurus, Please help. Where is my mistake? I get the following error... MYSQL: query failed: You have an error in your SQL syntax near ') rei_ts' at line 1 When I run the query below SELECT rei_ip \ FROM relay_ip \ WHERE rei_ip=${sender_host_address} AND DATE_SUB(NOW(), INTERVAL 10) rei_ts And the tabledesign is ... CREATE TABLE relay_ip ( rei_aid int(11) NOT NULL auto_increment, rei_uname varchar(30) NOT NULL default '', rei_domain varchar(128) NOT NULL default '', rei_ip varchar(64) NOT NULL default '', rei_ts datetime NOT NULL default '-00-00 00:00:00', PRIMARY KEY (rei_aid), KEY rei_ip (rei_ip) ) ; -Wash -- Odhiambo Washington [EMAIL PROTECTED] The box said 'Requires Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,' Tel: +254 2 313985-9 +254 2 313922 so I installed FreeBSD. GSM: +254 72 743223 +254 733 744121 This sig is McQ! :-) If the King's English was good enough for Jesus, it's good enough for me! -- Ma Ferguson, Governor of Texas (circa 1920) - 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
Help! MySQL overloading my system
Alors! I run MySQL-3.23.41 on FreeBSD-4.5-STABLE but everytime I get my system slowing down and on checking with `top` I see MySQL as the culprit: cut last pid: 29586; load averages: 1.41, 1.45, 1.48 up 28+10:55:17 20:10:59 90 processes: 3 running, 83 sleeping, 1 stopped, 3 zombie CPU states: 16.7% user, 0.0% nice, 51.4% system, 0.4% interrupt, 31.5% idle Mem: 249M Active, 36M Inact, 71M Wired, 16M Cache, 48M Buf, 1960K Free Swap: 1374M Total, 58M Used, 1316M Free, 4% Inuse PID USERNAME PRI NICE SIZERES STATE C TIME WCPUCPU COMMAND 28687 mysql 63 0 40604K 5940K RUN0 27.8H 88.23% 88.23% mysqld 29489 wash 10 0 12944K 12420K nanslp 0 0:04 23.89% 11.43% perl 29424 wash 10 0 12904K 12376K nanslp 1 0:04 10.06% 6.54% perl 29382 root 30 0 2072K 1200K CPU0 0 0:02 3.50% 2.83% top 29511 exim2 0 3692K 2240K select 1 0:01 3.84% 1.51% exim 29576 exim2 0 3700K 2240K select 0 0:00 9.74% 0.93% exim 41215 www18 0 41056K 24592K lockf 1 0:40 0.29% 0.29% httpd 41216 www18 0 39980K 24316K lockf 1 0:23 0.15% 0.15% httpd 684 root2 0 1492K 840K select 1 110:49 0.10% 0.10% tpop3d Could someone more knowledgeable point me in the right direction towards isolating what could be causing this load. I have several databases on this box, TWO of which are very busy as the SMTP/POP3 daemons both interact with it as this is the main server. Thanking you in advance. -Wash -- Odhiambo Washington [EMAIL PROTECTED]The box said 'Requires Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,' Tel: 254 2 313985-9 Fax: 254 2 313922 so I installed FreeBSD. GSM: 254 72 743 223 GSM: 254 733 744 121 This sig is McQ! :-) Westheimer's Discovery: A couple of months in the laboratory can frequently save a couple of hours in the library. - 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
GUI Tools for courier-imap user management
Hello good people, Okay I don't mean to offend anyone. I'm a newbie but I have managed to do courier-imap-authmysql today. I can add/remove/changepasswd for users comfortably. Command line is no problem. However, this is a bit slow and I was wondering if anyone out there already invented the GUI wheel to do that stuff. I am especially concerned is some user asks me that he wants to be able to change password. Adding/deleting them is not a problem ;-) I believe the gurus her have perl/php utils that are accessible via a browser that can handle such tasks, no? Last question: I use set crypt=ENCRYPT('passwd_text_here') but can I generate MD5 passwords this way (I mean a simpler method)?? Pointers, and even flames are okay. Much thanks in advance. -Wash S y s t e m s A d m i n. -- Odhiambo Washington [EMAIL PROTECTED]The box said 'Requires Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,' Tel: 254 2 313985-9 Fax: 254 2 313922 so I installed FreeBSD. GSM: 254 72 743 223 GSM: 254 733 744 121 This sig is McQ! :-) ++ Eat drink and be merry, for tomorrow they may make it illegal. - 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
Clear table contents
Hello gurus, Please allow me to request for help with the table below. mysql select * from relay_ip; +-+++-+-+ | rei_aid | rei_uname | rei_domain | rei_ip | rei_ts | | +-+++-+-+ | 1 | wash | alligator.wananchi.com | 62.8.64.4 | 2002-02-08 |18:17:36 | | 2 | wash | alligator.wananchi.com | 62.8.64.108 | 2002-02-08 |20:36:51 | | 3 | wash | alligator.wananchi.com | 62.8.64.108 | 2002-02-08 |20:42:27 | | 4 | wash | alligator.wananchi.com | 62.8.64.108 | 2002-02-09 |13:03:27 | | 5 | wash | alligator.wananchi.com | 62.8.64.108 | 2002-02-09 |13:03:28 | | 6 | [EMAIL PROTECTED] | freebsd.co.ke | 62.8.64.108 | 2002-02-11 |09:46:43 | | 7 | [EMAIL PROTECTED] | freebsd.co.ke | 62.8.64.108 | 2002-02-11 |09:47:27 | +-+++-+-+ I am looking for a way to clear each record that is older than 10 minutes by referring to the timestamp. Something that I can run from cron. tia -Wash S y s t e m s A d m i n. -- Odhiambo Washington [EMAIL PROTECTED]The box said 'Requires Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,' Tel: 254 2 313985-9 Fax: 254 2 313922 so I installed FreeBSD. GSM: 254 72 743 223 GSM: 254 733 744 121 This sig is McQ! :-) ++ No problem is so formidable that you can't just walk away from it. - 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
Clear table contents
Hello gurus, Please allow me to request for help with the table below. mysql select * from relay_ip; +-+++-+-+ | rei_aid | rei_uname | rei_domain | rei_ip | rei_ts | | +-+++-+-+ | 1 | wash | alligator.wananchi.com | 62.8.64.4 | 2002-02-08 |18:17:36 | | 2 | wash | alligator.wananchi.com | 62.8.64.108 | 2002-02-08 |20:36:51 | | 3 | wash | alligator.wananchi.com | 62.8.64.108 | 2002-02-08 |20:42:27 | | 4 | wash | alligator.wananchi.com | 62.8.64.108 | 2002-02-09 |13:03:27 | | 5 | wash | alligator.wananchi.com | 62.8.64.108 | 2002-02-09 |13:03:28 | | 6 | [EMAIL PROTECTED] | freebsd.co.ke | 62.8.64.108 | 2002-02-11 |09:46:43 | | 7 | [EMAIL PROTECTED] | freebsd.co.ke | 62.8.64.108 | 2002-02-11 |09:47:27 | +-+++-+-+ I am looking for a way to clear each record that is older than 10 minutes by referring to the timestamp. Something that I can run from cron. tia -Wash S y s t e m s A d m i n. -- Odhiambo Washington [EMAIL PROTECTED]The box said 'Requires Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,' Tel: 254 2 313985-9 Fax: 254 2 313922 so I installed FreeBSD. GSM: 254 72 743 223 GSM: 254 733 744 121 This sig is McQ! :-) ++ No problem is so formidable that you can't just walk away from it. - 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 gurus - easy one.
Hello list, Please forgive my bad step of joining the list and begining with questions. I'm a NEWBIE at MySQL with very minimal knowledge. I'm beginning to learn (self-teaching). I am trying to create a table and made a file as below: ## CONNECT mysql; CREATE TABLE maildb ( id int primary key auto_increment, date varchar(100), from varchar(200), to varchar(200), subject varchar(200), body text ); ### When I execute it I get the error below: [root@ns2]#mysql mysql_table_create.sql ERROR 1064 at line 3: You have an error in your SQL syntax near 'from varchar(200), to varchar(200), subject varchar(200), body text )' at line 4 What could I be missing in the field definitions? TIA -Wash S y s t e m s A d m i n. -- Odhiambo Washington [EMAIL PROTECTED]The box said 'Requires Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,' Tel: 254 2 313985-9 Fax: 254 2 313922 so I installed FreeBSD. GSM: 254 72 743 223 GSM: 254 733 744 121 This sig is McQ! :-) ++ If dolphins are so smart, why did Flipper work for television? - End forwarded message - -Wash S y s t e m s A d m i n. -- Odhiambo Washington [EMAIL PROTECTED]The box said 'Requires Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,' Tel: 254 2 313985-9 Fax: 254 2 313922 so I installed FreeBSD. GSM: 254 72 743 223 GSM: 254 733 744 121 This sig is McQ! :-) ++ If you perceive that there are four possible ways in which a procedure can go wrong, and circumvent these, then a fifth way will promptly develop. - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php