Re: Stopping DNS Lookups

2008-10-24 Thread Richard S. Huntrods
(assuming those entries were already in 'db' and 'user') work fine, but 'localhost' no longer works after the reboot. Cheers, -Richard Moon's Father wrote: Add skip-name-reslove in my.cnf and restart mysql immediately. On Thu, Oct 23, 2008 at 12:37 AM, Richard S. Huntrods [EMAIL PROTECTED

Re: Stopping DNS Lookups

2008-10-24 Thread Richard S. Huntrods
' and 'user') work fine, but 'localhost' no longer works after the reboot. Cheers, -Richard Moon's Father wrote: Add skip-name-reslove in my.cnf and restart mysql immediately. On Thu, Oct 23, 2008 at 12:37 AM, Richard S. Huntrods [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote

Stopping DNS Lookups

2008-10-22 Thread Richard S. Huntrods
I have a server that runs only MySQL. It services several other servers inside a firewalled intranet. All connections to the MySQL database are done using static IP addresses. Recently I had to start monitoring the firewall traffic on this intranet, and discovered the MySQL server is

Re: Stopping DNS Lookups

2008-10-22 Thread Richard S. Huntrods
[EMAIL PROTECTED] wrote: Point to an internal dns server We don't have one. Is somebody with a weird hostname connecting to your server via ssh ? Nope. This is occurring while the server's intranet is totally unmanned. -Richard --Original Message-- From: Richard S

Re: Stopping DNS Lookups

2008-10-22 Thread Richard S. Huntrods
Awesome! Thanks very much - exactly what I was looking for. I'm in the field and was under the gun, otherwise would have checked the manuals first. Again, thanks. -Richard Hassan Schroeder wrote: On Wed, Oct 22, 2008 at 7:40 AM, Richard S. Huntrods [EMAIL PROTECTED] wrote: Recently I

Re: Directory question for the masters...

2004-03-29 Thread Richard S. Huntrods
SIGNED MESSAGE- Hash: SHA1 Richard S. Huntrods wrote: I need to access a specific directory from within tomcat, but I'm having a specific problem and require some advice. I have a link to a file in the servlet, something like https://myserver.com/special-directory/file.zip; If I create

Directory question for the masters...

2004-03-27 Thread Richard S. Huntrods
I need to access a specific directory from within tomcat, but I'm having a specific problem and require some advice. I have a link to a file in the servlet, something like https://myserver.com/special-directory/file.zip; If I create the directory as follows:

MY APOLOGIES!!!

2004-03-27 Thread Richard S. Huntrods
Very Sorry!!! I sent a Tomcat request to this list by mistake. Please ignore it. Thanks, -Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

BUG IN MYSQL

2004-01-03 Thread Richard S. Huntrods
I've submitted this problem three times now, and been ignored all three times. I guess bugs are simply not popular. Since the problem described below is 100% repeatable, I will now escallate it from problem with delete/insert to BUG IN MYSQL. Cheers... I've distilled the problem I'm having

Re: BUG IN MYSQL

2004-01-03 Thread Richard S. Huntrods
Miguel, miguel solorzano wrote: At 16:05 3/1/2004 -0700, Richard S. Huntrods wrote: I've submitted this problem three times now, and been ignored all three times. Sorry for this inconvenience but I suggest you in the next time to use the MySQL's forums for to report bugs instead

Re: BUG IN MYSQL

2004-01-03 Thread Richard S. Huntrods
Udo, Thanks - I found the bug in the database. Looks like it's been fixed in 4.0.17 (the bug was reported in 4.0.14 and I'm running 4.0.15). The bug was also not in my Solairs system - using 4.0.5a. Thanks, -Richard Ugo Bellavance wrote: -Message d'origine- De : Richard S

Problem Solved - AND - How to decide when to upgade a production server MySQL

2004-01-03 Thread Richard S. Huntrods
My problem with deletes/inserts corrupting the database table has been resolved. I was using version 4.0.15, and the very bug I experienced was reported for version 4.0.14. As of 4.0.17, it is fixed. Interestingly, the bug does not appear in 4.0.5a on my Solaris box. Which brings me to my more

Problem with DELETE/INSERT - even simpler example!

2003-12-31 Thread Richard S. Huntrods
I've distilled the problem I'm having with DELETE/INSERT to an even simpler test case. Here's the SQL - it can be used with any database, not just the special expdb I created. I run this script followed by running mysqlcheck expdb. # USE expdb; DROP

Problem with table corrupting

2003-12-30 Thread Richard S. Huntrods
I've isolated this problem down to a single table and SQL script that demonstrates the problem repeatably. There are 4 SQLl scripts here - one to create remove the database, one to create the database and user entries, one to create the table, and one to access the table. It is the 3rd that

Problem with delete

2003-12-26 Thread Richard S. Huntrods
I'm having a strange problem with trying to delete records with MySQL. System: Win XP home, Mysql 4.0.15. Implementation with this version since 10/01/2003 with no problems. Normal access: MySQL JDBC driver (used to be the MM driver, now obtained from MySQL), Java SDK 1.4.2_01. Problem has been

Re: Problem reloading data...

2003-02-20 Thread Richard S. Huntrods
Stefan, Stefan Hinz wrote: Richard, set-variable = max_allowed_packet=16M Yikes!!! I knew that running default configuration gave you SOME values, but I didn't know they were so small. I've placed the my-medium.cnf as my.cnf in /etc on the Sparc 20, and also in C:\ on the

Re: Problem reloading data...

2003-02-19 Thread Richard S. Huntrods
Stefan, H. On the solaris machines (both), there is currently NO my.cnf file anywhere, yet MySQL has been working just fine. I imagine default values are being used for everything. I'll have to select one of the .cnf files from support-files. I'll let you know how it works. -Richard

Re: Problem reloading data...

2003-02-19 Thread Richard S. Huntrods
Sefan, Stefan Hinz wrote: Richard, H. On the solaris machines (both), there is currently NO my.cnf file anywhere, yet MySQL has been working just fine. I imagine default values are being used for everything. I'll have to select one of the .cnf files from support-files. I'll let you

Problem reloading data...

2003-02-18 Thread Richard S. Huntrods
I am having a strange problem reloading data into one copy of MySQL. Details: production server: MySQL - Ver 8.38 Distrib 4.0.5a-beta, for sun-solaris2.8 on sparc development system: MySQL - Ver 8.38 Distrib 4.0.5a-beta, for Win95/Win98 on i32 test system: MySQL - Ver 8.38 Distrib 4.0.5a-beta,

Re: Problem reloading data...

2003-02-18 Thread Richard S. Huntrods
machine). Still, it may be a concern to the MySQL developers - not that there are memory limitations, but rather that they resulted in error messages that were both incorrect and not indicative of the real problem. -Richard Richard S. Huntrods wrote: I am having a strange problem reloading

Lost connection to server during query error just started

2002-09-12 Thread Richard S. Huntrods
I have been running MySQL on a W2K platform for over a year now. The system is normally accessed through servlets, using the mm jdbc driver. I have a number of standalone java programs that also access the database using the mm driver. These have always worked quite well, until today. One

Lost connection to server during query error just started

2002-09-12 Thread Richard S. Huntrods
I have been running MySQL on a W2K platform for over a year now. The system is normally accessed through servlets, using the mm jdbc driver. I have a number of standalone java programs that also access the database using the mm driver. These have always worked quite well, until today. One of

Re: Lost connection to server during query error just started

2002-09-12 Thread Richard S. Huntrods
Mark, Mark Matthews wrote: Richard S. Huntrods wrote: I have been running MySQL on a W2K platform for over a year now. The system is normally accessed through servlets, using the mm jdbc driver. I have a number of standalone java programs that also access the database using the mm

Re: Default record order...

2002-03-05 Thread Richard S. Huntrods
Benjamin, Benjamin Pflugmann wrote: Hi. I guess your problem comes from the fact that SQL has no concept of internal order. If you do not specify an ORDER BY clause, the order or records returned is undefined, i.e. random. That's what I was figuring. I asked because I wanted it

Re: Default record order...

2002-03-05 Thread Richard S. Huntrods
DLN, Thanks. Interestingly enough, pulling records without a sort was rather random (rather, influence by the last sort) - but once I placed a primary key on the table, the order of unsorted records is always constant, even after a sort (based on numerous tests yesterday and today with the

Default record order...

2002-03-04 Thread Richard S. Huntrods
Greetings! If you do not have an index on any column in a table, how does mysql handle repeated queries (i.e. SELECT * FROM report;) I am noticing that if I run the following three queries, I get different results for the third query: SELECT * FROM report; SELECT * FROM report ORDER BY

Re: Annoying article about MySql

2001-12-08 Thread Richard S. Huntrods
Ingvar, I have not used mysql data dumps directly to restore my databases, but I take the mysqldump output and massage them a bit, then use them for restores. Basically, the mysqldump output is missing the use xxx command to change to the target database. I have a perl script that does that

Re: Annoying article about MySql

2001-12-08 Thread Richard S. Huntrods
Arjen, Arjen G. Lentz wrote: Hi, Thanks for the great reply! - Original Message - From: Richard S. Huntrods [EMAIL PROTECTED] Basically, the mysqldump output is missing the use xxx command to change to the target database. I have a perl script that does that (and extracts

Probably something very simple...

2001-12-04 Thread Richard S. Huntrods
Greetings! I am having a real silly problem - probably something simple I've forgotten. I have been running mysql 3.23.39a on both Windows and Solaris for 5 months now, no problems. I just upgraded the windows machine to mysql 4alpha, and had a problem with passwords. I have one key user

Fixed MYSQL password problem!

2001-12-04 Thread Richard S. Huntrods
I fixed the problem I just posted with MySql new installs not seeing my passwords. I had simply forgotten to flush the permissions after I set the password. mysqladmin -u root flush-privileges Cheers, -Richard - Before