Re: max_user_connections problem after upgrading
Matt W wrote: I guess you'll have to see if it's fixed in the next release (4.0.17). Any clue as to when 4.0.17 will be released? Joe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: max_user_connections problem after upgrading
William R. Mussatto wrote: Joe Lewis said: We're experiencing the same issues, but not neccesarily after an upgrade. We're using MySQL 4.0.12 and FreeBSD 4.7 Release. We're getting max'd connections only on specific users, and the show processlist is returning only the show processlist process. the results of netstat show absolutely nothing. What I think is happening is the connections are not properly getting closed. The users are allowed to connect after a flush user_resources is run. Is there a bug in the particular version of MySQL (4.0.12) where the user connections are not getting decremented when a connection is closed? Joe Is the user running show processlist allowed to see all processes (e.g. 'root')? Yes, indeed. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Processes Closed, but max_connections exceeded...
MAX_CONNECTIONS_PER_HOUR ? Now, I set the MAX_CONNECTIONS, but I didn't know about MAX_CONNECTIONS_PER_HOUR. Still, the problem has persisted when left for a day or two without restarting. In fact, the issues only go away when the server is restarted (though I did NOT try the flush). Thank you for the pointers. I will see what I can dig up. Thx, Joe Victoria Reznichenko wrote: Joe Lewis [EMAIL PROTECTED] wrote: I've got a question for you. I've got a MySQL db running in FreeBSD 4.8, and have encountered the following problem. When I try to connect to a database by a specific user, I get the following response : #mysql -p -u comet Enter password: ERROR 1226: User 'comet' has exceeded the 'max_connections' resource (current value: 100) Now, that is exactly what I'd expect to see, IF the user had 100 connections. Instead, when viewing the processlist, I get : If you set up MAX_CONNECTIONS_PER_HOUR 100 for user it means that user can open 100 new connections per our. #mysqladmin -p processlist Enter password: +-+--+---++-+--+---+---+ | Id | User | Host | db | Command | Time | State | Info | +-+--+---++-+--+---+---+ | 469 | root | localhost || Query | 0| | show processlist | +-+--+---++-+--+---+---+ I think that the code that had established all of those connections didn't properly dispose of the connections (a PHP script that one of our clients is using). Is there a way to clear those? Execute FLUSH USER_RESOURCES command or mysqladmin reload to flush current values. You can read about limiting resources at: http://www.mysql.com/doc/en/User_resources.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Processes Closed, but max_connections exceeded...
Ladies and Gents; I've got a question for you. I've got a MySQL db running in FreeBSD 4.8, and have encountered the following problem. When I try to connect to a database by a specific user, I get the following response : #mysql -p -u comet Enter password: ERROR 1226: User 'comet' has exceeded the 'max_connections' resource (current value: 100) Now, that is exactly what I'd expect to see, IF the user had 100 connections. Instead, when viewing the processlist, I get : #mysqladmin -p processlist Enter password: +-+--+---++-+--+---+---+ | Id | User | Host | db | Command | Time | State | Info | +-+--+---++-+--+---+---+ | 469 | root | localhost || Query | 0| | show processlist | +-+--+---++-+--+---+---+ I think that the code that had established all of those connections didn't properly dispose of the connections (a PHP script that one of our clients is using). Is there a way to clear those? Joe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Your professional opinion Please...
Peter L. Berghold wrote: On Mon, Mar 24, 2003 at 06:41:07PM -0800, Brian wrote: I have a client with approximately 2 gigabytes of un-indexed document files (includes text and graphics). He wants to be able to enter a few parameters and bring up a list of all [snip] I'd leave them as flat text files and go from there. If they are adding or removing from the library then do a re-index at an interval that makes sense. I'd use MySQL, Apache, and UDMSEARCH. It provides the web interface for the google search engine (Apache and UDMSearch), while connecting to MySQL. If you want, the re-indexing can occur using a cron, and then by making apache serve the documents from the root and doing the fancy indexing. I suppose this is getting off topic, though. [grin] Joe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Custom Authentication Mechanisms
Hello, all! I would like to alter MySQL in the following manner : - If the standard MySQL [PASSWORD()] fails, use PAM to auth - If the user is authenticated using PAM : - If a database does not exist of the users name, create it - Restrict the datamanipulation to that specific database I know, some of these ideas may be way out in left field, but I am handling some dynamic web hosting and do not want the users' to be able to view each others tables and data. But, at the same time, I don't want to have to enter in the data for every user if they request MySQL access. My questions are : - has this already been implemented anywhere? (If so, how) - If not implemented, which files in the source code would have to be altered? Joe ReliaNet - 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: Can't Load Data Into The Database With Operator
I know DOS doesn't have a cat command, so try : type create_president.sql samp_db Or have I been out of the DOS world too long? Joe Yasen Petrov wrote: Hello, I'm using Win98 OS and MySQL 3.23.39-max. Now, I'm trying to load data from the DOS Prompt into a new database (samp_db): samp_db create_president.sql and it returns ERROR 1064: you have an error in your sql syntax near 'samp_db create_president.sql' at line 1 Any ideas will be highly appreciated. Yasen - 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