Re: Error msg saying what?
On Thu, 15 Mar 2001, Eric Holmbom wrote: Thu, 15 Mar 2001 11:09:14 +0100 SQL SQLDriverConnect Thu, 15 Mar 2001 11:09:14 +0100 ERR [TCX][MyODBC]Access denied for user: 'root@ipaddress' (Using password: YES) It is saying (quite straightforwardly) that you either a) are using a wrong username b) are using a wrong or no password c) are using the correct username/pw but are trying to connect from a wrong IP address Have a look at your login rights and the fine manual on http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.html#Privilege_system If you have further problems/questions, feel free to contact the list again, but not after you tried long and hard yourself figuring it out! :-) Good luck regards, Jan-Aage Bruvoll - 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: ReisserFS
On Thu, 22 Feb 2001, Simon Windsor wrote: Has anyone user MySql on a ReisserFS file system ? Where any problems encountered ? and do you have any pearls of wisdom that you are willing to share ? No problems at all. Even power outages and severe crashes did not touch the MySQL stuff on the ReiserFS file system, but that's probably all luck. :-) Regards, Jan - 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: ReisserFS
On Thu, 22 Feb 2001, Sinisa Milivojevic wrote: No, that is not just luck. ReiserFS is a journalling file system. Sure thing. The luck part was referring to the fact that even the consistency in the tables was ok, which is more on the luck side, since all buffers were flushed at the time of the crashes. Regards, Jan - 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: ReisserFS
On Thu, 22 Feb 2001, William R. Mussatto wrote: What is the hardware (32 bit or 64) and what is the maximum files size MySql will support on it? Thanks. I'm a mere end user when it comes to ReiserFS... I think you should be able to find all information you need on http://www.reiserfs.com/ As for MySQL, I guess the Fine Manual is the place to check, or even a search on http://www.google.com/ might do it. (The question has been asked before on the list, but I do not remember the correct answer.) Regards, Jan-Aage -- Mr. Jan-Aage Bruvoll Managing Director Bruvoll Brains in Bits, 7a Neal's Yard, London WC2H 9DP, UK Office/fax: +44 20 72408283 Mobile: +44 7740291600 - 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: ODBC error
On Sat, 17 Feb 2001, Ingrid Kast Fuller wrote: I'm having an ODBC call failed error when I open one of my customers databases. I've tried re-linking it and still get the error. My other Mysql databases are working. But we just upgraded from FreeBSD 2.2.8 to FreeBSD 4.2 and we have had a few files come over with wrong permissions. It's saying "access denied" by cityscope.net. Is it something to do with my address accessing it or file permissions or password problem? Any ideas or help for that matter would be most appreciative. I need to get this resolved today. Thanks. What is the exact error message and where do you get it (as in do you see it on screen, in a log file (which) and so on...) Regards, Jan-Aage -- Mr. Jan-Aage Bruvoll Managing Director Bruvoll Brains in Bits, 7a Neal's Yard, London WC2H 9DP, UK Office: +442072408283 Cell: +4792492482 Fax: +4792571158 - 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: MySQL CRM
On Fri, 16 Feb 2001, Steve Ruby wrote: Does anybody know of any commercial or opensource CRM systems that run with MySQL on Linux (and/or FreeBSD)? Mainly I need canned responses and ticket management and some other standard features. Have a look at http://freshmeat.net/, where most of the OSC software is announced anyway. Regards, Jan-Aage -- Mr. Jan-Aage Bruvoll Managing Director Bruvoll Brains in Bits, 7a Neal's Yard, London WC2H 9DP, UK Office: +442072408283 Cell: +4792492482 Fax: +4792571158 - 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: Table timestamps? More specific control of SHOW TABLE STATUScommand
On Thu, 15 Feb 2001, Jay Lawrence wrote: Atle, your suggestion is for the last time a record was updated. I am interested in the entire table. A temporary workaround could be select max(timestamp) from sometable. Jan - 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: Cannot load connection class 'java.sql.SQLException problem !
On Wed, 14 Feb 2001, Daniel Ducat wrote: Thanks for the answer, Jonathan. I have already tried the way you propose, but it gives me the same error. Any other ideas ? Lebrun Jonathan wrote: Try this : Connection C=DriverManager.getConnection( "jdbc:mysql://localhost/test","username","password"); Well, as far as I can see, you are trying to log on with the user 'username' and password 'password'. Unless you actually have a user in MySQL called 'username' with PW 'password', MySQL will complain just the way it did. Cannot load connection class 'java.sql.SQLException: Invalid authorization specification: Access denied for user: 'username@localhost' (Using password: YES)'.:08001:0 This is exactly what I mentioned above: MySQL denies access to the user 'username@localhost' (there is more about that in the manual, look for the part which describes how MySQL handles users, keyword: a user is always user@somehost). Hope this helps. Regards, Jan - 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: Upgrading
On Mon, 12 Feb 2001, Ben Ocean wrote: I'm trying to upgrade to the latest distro. I thought I could simply d'l the distro, go in as root (Apache, RedHat) and enter the following command: # rpm -U MySQL-3.23.32-1.src.rpm Being no rpm expert, the above suggests that you fetched the source distribution, ie. you'd have to recompile to get the new version. Try searching for a file that's named similarly, but without the 'src'. Regards, Jan-Aage -- Mr. Jan-Aage Bruvoll Managing Director Bruvoll Brains in Bits, 7a Neal's Yard, London WC2H 9DP, UK Office: +442072408283 Cell: +4792492482 Fax: +4792571158 - 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: wait_timeout?
On Wed, 31 Jan 2001, Andrew Benham wrote: I'm glad it's not just me. I have 2 v3.22.32 servers running under HP-UX 10.20 Both servers are being used by FCGI processes on the web with persistant connections to the database servers. Ok, I'll join in on this. I have servers running Slackware 7.1 with v3.22.28-gamma servers (yes, I'll upgrade), and I had to let persistent connections go because of this. It seems, things are extremely sluggish as soon as I reach 100+ connections (and this is a dual PIII/700 with 1Gb RAM and my-huge.cnf) and the connections tend to stay around. Good luck with hunting it down, thou' :-) Regards, Jan-Aage -- Mr. Jan-Aage Bruvoll Managing Director Bruvoll Brains in Bits, 7a Neal's Yard, London WC2H 9DP, UK Office: +442072408283 Cell: +4792492482 Fax: +4792571158 - 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