Suggestion : Better error message for hostname resolution error during MySQL installation

2010-08-22 Thread Jaikiran Pai
Hello everyone, Recently, while installing MySQL, I ran into an error[1] which complained about the hostname: --- Neither host 'blahblah' nor 'localhost' could be looked up with /usr/bin/resolveip Please configure the 'hostname' command to return a correct hostname. If you want to solve

RESOLUTION: mysqld works but not mysqld_safe

2007-07-20 Thread Chris Africa
1. Get rid of the offending $hostname.index file that keeps track of binlogs (Thanks, Olaf!). 2. Fix permissions (Thanks, Gerald Clark!). Have a nice day! Chris On Jul 18, 2007, at 2:19 PM, Olaf Stein wrote: You have bin log enabled and it might be looking for the last bin log

Symbol resolution failed for /usr/local/lib/libz.so.

2007-04-24 Thread suresh kumar
Hi, Warm Greetings! I am using C mysql for my program In AIX and while compiling I am getting the following error. “exec(): 0509-036 Cannot load program /az/smsbbs/bin/wittservw because of the following errors: 0509-130 Symbol resolution failed for /usr/local/lib

Re: Symbol resolution failed for /usr/local/lib/libz.so.

2007-04-24 Thread Joerg Bruehe
-036 Cannot load program /az/smsbbs/bin/wittservw because of the following errors: 0509-130 Symbol resolution failed for /usr/local/lib/libz.so because: 0509-136 Symbol _GLOBAL__F__Unwind_GetLanguageSpecificData (number 23) is not exported from dependent

Re: IP Resolution

2005-10-17 Thread Ben Clewett
Eric, Thanks for the advise. I was not reporting a bug. This is a live installation of a database I have to get working. I was hoping somebody may give me some compilation options to make MySQL understand IP addresses. Or something. I cannot upgrade the database as this is our production

IP Resolution

2005-10-14 Thread Ben Clewett
Dear MySQL, My MySQL 4.1.9 has lost the ability to work out what IP address clients are connecting from. Eg: $ mysqladmin processlist ++--+---+--+-+--+---+--+ | Id | User | Host | db | Command | Time | State | Info|

Re: IP Resolution

2005-10-14 Thread Eric Bergen
MySQL 4.1.14 is the current version. You should always upgrade to the lastest release and test your problem before trying to report bugs. Ben Clewett wrote: Dear MySQL, My MySQL 4.1.9 has lost the ability to work out what IP address clients are connecting from. Eg: $ mysqladmin

tmestamp resolution problem (rounding off to a day)

2005-07-29 Thread Nick Sinclair
Hi All, I seem to be having a problem with the resolution using the timestamp function. I am accessing the database snort on an ACID/SNORT/MySQL installation utilizing a collection of shell scripts that are run as cron jobs and function as a bot adding and removing firewall rules (iptables

timestamp resolution problem (rounding off to a day)

2005-07-29 Thread Nick Sinclair
Hi All, I seem to be having a problem with the resolution using the timestamp function. I am accessing the database snort on an ACID/SNORT/MySQL installation utilizing a collection of shell scripts that are run as cron jobs and function as a bot adding and removing firewall rules (iptables

Re: tmestamp resolution problem (rounding off to a day)

2005-07-29 Thread Jigal van Hemert
Nick Sinclair wrote: [.] WHERE date_format(timestamp, '%Y-%m-%d %T') =DATE_SUB(CURDATE(),INTERVAL $BLACKLIST_DECAY HOUR) * ...It only resolves to the DAY and not an hourly resolution. I have included a script below that I use for debugging, the MySQL functionality is taken directly from one

Re: tmestamp resolution problem (rounding off to a day)

2005-07-29 Thread Nick
Jigal van Hemert wrote: Nick Sinclair wrote: [.] WHERE date_format(timestamp, '%Y-%m-%d %T') =DATE_SUB(CURDATE(),INTERVAL $BLACKLIST_DECAY HOUR) * ...It only resolves to the DAY and not an hourly resolution. I have included a script below that I use for debugging, the MySQL functionality

High resolution timestamps

2004-03-23 Thread Leon Brocard
Hello, Recently I've been needing high-resolution timestamps (year/month/day/hour/minute/seconds/microseconds) in MySQL (to store network packets, mmm). Is this a planned feature for MySQL in the future? Cheers, Leon -- Leon Brocard.http://www.astray.com/ scribot

Re: High resolution timestamps

2004-03-23 Thread Joshua J. Kugler
You can get millisecond resolution in MySQL 4.1. Considering most systems don't even support *true* millisecond resolution, I don't think you're going to find anything that supports microsecond resolution. j- k- On Tuesday 23 March 2004 07:18 am, Leon Brocard wrote: Hello, Recently

RE: Suggestions on joins/merges, resolution

2003-06-05 Thread Peter J. Milanese
- Forwarded by Peter J. Milanese/MHT/Nypl on 06/05/2003 07:35 AM - Peter J. Milanese 06/04/2003 09:55 PM To: Peter J. Milanese/MHT/Nypl cc: Mike Hillyer [EMAIL PROTECTED], [EMAIL PROTECTED] Subject:RE: Suggestions on joins/merges, resolution

Windows install hangs (resolution)

2002-06-25 Thread Bill Easton
this to the list, in the hope of helping someone who might hit the same problem. Resolution: When we tried to reboot, there was a program not responding. When we said to exit same, the MySQL install screen started to come up while the system was shutting down. We killed that and rebooted. Then, we tried

Re: replication problems -- resolution

2002-06-18 Thread Jeff Hill
Just to let you know that when I installed 3.23.51 binary on both Debian Linux boxes, same problem, but when I re-installed the 3.23.49a binary on both boxes the problem went away. Uncertain why. Regards, Jeff Hill At 08:25 AM 18/06/2002 -0400, Jeff Hill wrote: I'm having the same problems,

User setup IP resolution

2001-04-19 Thread SteveW
Request help getting myself setup with my website host. They offer mySQL but do not know very much about it and we seem to be stuck. the error I am getting is this: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) where "userid" is my userid and "xx.xxx.xxx.xxx" is my

Resolution

2001-03-12 Thread Daren Cotter
Since I posted so many times about my problem, I feel obligated to notify everyone I have resolved it, and exactly what was wrong. I have two fields: last_update, and last_login. Both fields are timestamps, with defaults of "000". My queries were doing things like:

Re: Newbie Questions and a resolution

2001-02-10 Thread Lad . Gaal
Well, I finally got that portion working. After I putzed around for awhile, I said to myself - Self, With all this putzing, I probably need to restart the mysqld server. So I tried that from linuxconf and for some reason it just didn't want to restart! So, I went and did a /etc/rc5.d/S85mysqld