Found the problem. There was cached DNS info on the host. Restarted
nscd and then it worked.
On Thu, Apr 18, 2013 at 10:59 AM, Larry Martell wrote:
> We use host aliases to connect to MySQL all the time, never had an
> issue before. Today we added a new alias, and we cannot connect to the
> serve
Andy,
On Tue, Feb 9, 2010 at 10:27 AM, andy knasinski wrote:
> I've used the general and slow query log in the past, but I am trying to
> track down some queries from a compiled app that never seem to be hitting
> the DB server.
>
> My guess is that the SQL syntax is bad and never get executed, b
Am 09.02.2010 16:27, schrieb andy knasinski:
I've used the general and slow query log in the past, but I am trying to
track down some queries from a compiled app that never seem to be
hitting the DB server.
My guess is that the SQL syntax is bad and never get executed, but I
don't see any relate
I'm not positive if the general log captures all invalid queries but
it does capture at least some.
I was asked the same question a few months back and checking to make
sure that manually issued invalid queries are logged (IIRC).
Could it be that the queries are never even making it to the database
Unfortunately, I'm using a commercial application and trying to debug
as to why some data does and does not get updated properly.
On Feb 9, 2010, at 2:57 PM, mos wrote:
I do something like that in my compiled application. All SQL queries
are sent to a single procedures and executed there.
At 09:27 AM 2/9/2010, andy knasinski wrote:
I've used the general and slow query log in the past, but I am trying
to track down some queries from a compiled app that never seem to be
hitting the DB server.
My guess is that the SQL syntax is bad and never get executed, but I
don't see any related
Getting the slow query data in the database was a breeze with
mk-query-digest, but now does anyone happen to know of scripts out
there that will generate an html page to view the output? This is
probably a better question for the maatkit mailing list but figure
someone here might have a link.
Th
Nuno, thanks for the tips. I think I will work on getting
mk-query-digest to log to a db table and run it periodically. Sounds
like a very useful thing to have.
--
Milan
On Sun, Aug 2, 2009 at 10:02 AM, wrote:
> Hi Milan,
>
> I can see many ways of accomplish what you want:
> * I'm almost sure
Hi Milan,
I can see many ways of accomplish what you want:
* I'm almost sure mk-query-digest will allow you to do so;
* Either crop the slow query log for the desired timespan (that's a couple of
shell scripting commands) and run mk-query-digest against it;
* Set the query log file to a filename w
Thanks for the quick replies guys. I won't be pulling queries our of
Drupal anytime soon. The optimizations I will do are minimal. Sounds
like we might just have to live with mediocre performance for now.
I will definitely looks further at maatkit though. I actually ran it
mk-query-digest on my
On Fri, Jul 31, 2009 at 8:14 PM, Milan Andric wrote:
Hello,
I'm serving a burly Drupal install and at some points throughout the
day the mysql threads go way up and iowait peaks. I'm not sure which
is causing which but during this time the server is unresponsive. I
would like to determine if th
Entries in the slow log have a timestamp. You can read the file directly, but
it's much easier to use a tool like maatkit for parsing the results of the log.
Try this:
http://www.maatkit.org/doc/mk-query-digest.html
Regards,
Gavin Towey
-Original Message-
From: Milan Andric [mailto:ma
Hi
Thanks for the response. In fact my main requirement is to track the
queries executed in the event we have some data which has been contaminated
in some way - which will help us with our investigations. Basically I've
designed a brand new back end office - and feel I need to record the querie
Hi
The purpose is really for auditing and constant performance analysis ? I
could save each query in my own user generated table. But thought maybe
best to use mysql's built in feature.
Neil
On Wed, May 27, 2009 at 5:22 PM, Baron Schwartz wrote:
> Neil,
>
> What is the purpose? Is it for au
Neil,
What is the purpose? Is it for auditing, performance analysis, ...?
Regards
Baron
On Wed, May 27, 2009 at 10:12 AM, Tompkins Neil
wrote:
> Hi,
>
> We've developed a new extranet system and feel that we need to record all
> queries performed. What is the best / recommended way to achieve
Enable mysql SQL logging in the configuration file.
[mysqld]
log
Cheers
Claudio
2009/5/27 Tompkins Neil
> Hi,
>
> We've developed a new extranet system and feel that we need to record all
> queries performed. What is the best / recommended way to achieve this.
>
> Thanks
> Neil
>
Hi, you can start mysql server with --log=/someplace/my_queries.txt and
every query the server runs is logged in that file. Keep in mind that if the
server runs another systems all queries are logged so you need to identify
the ones belong to your system. Also, if you system has a lot of query ca
Neil,
You can turn on the general query log by adding a line like this to your
configuration file:
log=/var/log/mysql_queries.log
Regards,
Nathan
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Wednesday, May 27, 2009 9:13 AM
To: [MySQL]
Subject: Log
Help and much, thank you for the answer, I just want to know if there
is something specific to the purpose of the access log of users.
But the alternative is a good start :)
On Thu, Nov 27, 2008 at 3:06 PM, Andy Shellam <[EMAIL PROTECTED]> wrote:
> Hi Darvin,
>
> Does this not help?
>
> http://dev
Hi Darvin,
Does this not help?
http://dev.mysql.com/doc/refman/5.0/en/query-log.html
(replace 5.0 with 5.1 if you've already upgraded.)
"The general query log is a general record of what mysqld is doing. The
server writes information to this log when clients connect or
disconnect, and it log
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Markus Fischer wrote:
> Before I re-invent the wheel I'ld like to know if there are tools/helper
> like this available ... ?
Being impatient and in need of this I've written my own version. Maybe
it is valuable to others.
http://markus.fischer.name/l
Manuel Schmitt (manitu) wrote:
Hi,
I'am searching for a way to have mysqld log all passwords which clients
are using ("trying") while connecting.
As to the documentation and to my trials neither the error log nor the
general query log contain passwords, only the usernames.
I already tried to g
I believe Daniel is correct. The passwords are hashed before leaving the
client. You may be able to capture invalid hashes but they are already
encrypted before they get to the server. I do not know of any event or
callback function you can use to tie into the server to trigger a logging
event.
On 3/5/06, Manuel Schmitt (manitu) <[EMAIL PROTECTED]> wrote:
> > is there a reason that the unknown passwords can't simply be reset?
>
> yes, because not all clients are currently known and resetting them
> would possibly break the application(s)
I am not pretty sure, but MySQL use to send encryp
> is there a reason that the unknown passwords can't simply be reset?
yes, because not all clients are currently known and resetting them
would possibly break the application(s)
--
Manuel Schmitt
- Geschäftsführer -
manit
> having an application log actual passwords (whether the login was
> successful or not) is a major security risk, hence no self-respecting,
> security-conscious application will do this. all that should be logged
> is the username attempted, along with a login success/failure
> indication, never t
I'm inclined to think this is a database config issue in MailScanner.
Double check the Port setting that MailScanner is using and check that
against the port that your MySQL server binds to. It is normally 3306,
and they should match. If you don't know how to check, can you send me
the output of:
Morning Jon,
You will not be too successful in using MySQL logging to trace this. You
need to be able to connect to the server at the very least before this
would help.
I don't know much about MailScanner but I would be checking a couple of
things, 1) do you have a firewall in place? is the port
Jon Miller wrote:
System:
Red hat 7.2
My SQL modules:
MySQL-devel-4.0.13-0
php-mysql-4.1.2-7.2.6
MySQL-shared-3.23.55-1
MySQL-server-4.0.13-0
MySQL-client-4.0.13-0
CAMysql-9.0-220
Msql-Mysql-DBI-perl-bin-1.1823-1
I would like to log or turn on the facility to do a verbose logging to
troublesh
Hello.
You may use the General Query Log. See:
http://dev.mysql.com/doc/mysql/en/query-log.html
MrExecutive <[EMAIL PROTECTED]> wrote:
> Hello Guys,
>
> I am using mySQL 4.1 for windows. How do i go about logging all failed
> login attempts?
>
> Thanks!
>
>
--
For
> > > > I have a curious issue here, maybe someone can help.
> > > >
> > > > I have a single process that inserts data into tables that contain
> > > > purely logging information. This table is then searched by our Care
> > > > department to troubleshoot issues. I am looking for the best way to
"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 01/19/2005 03:33:32 AM:
> Hello Jeremy,
>
> > > I have a curious issue here, maybe someone can help.
> > >
> > > I have a single process that inserts data into tables that contain
> > > purely logging information. This table is then searched by our C
Martijn Tonies wrote:
Hello Jeremy,
I have a curious issue here, maybe someone can help.
I have a single process that inserts data into tables that contain
purely logging information. This table is then searched by our Care
department to troubleshoot issues. I am looking for the best way to
st
Hello Jeremy,
> > I have a curious issue here, maybe someone can help.
> >
> > I have a single process that inserts data into tables that contain
> > purely logging information. This table is then searched by our Care
> > department to troubleshoot issues. I am looking for the best way to
> > st
: Tuesday, January 18, 2005 3:30 PM
To: Thomas Lekai
Cc: mysql@lists.mysql.com
Subject: Re: Logging Data: Should I use MyIsam or InnoDB?
Hi Thomas,
> Thanks, this is what I was originally thinking of, but how I am
> getting rid of the data in log_view_today? OR, are you saying that
> log_view
Hi Thomas,
Thanks, this is what I was originally thinking of, but how I am
getting rid of the data in log_view_today? OR, are you saying that
log_view_today is a merge table for only the current day? That table
def is defined every night? Then I would go about dropping
everything in whatever fas
omas Lekai
Cc: mysql@lists.mysql.com
Subject: Re: Logging Data: Should I use MyIsam or InnoDB?
Hi Thomas,
> I have a curious issue here, maybe someone can help.
>
> I have a single process that inserts data into tables that contain
> purely logging information. This table is then sear
Hi Thomas,
I have a curious issue here, maybe someone can help.
I have a single process that inserts data into tables that contain
purely logging information. This table is then searched by our Care
department to troubleshoot issues. I am looking for the best way to
store this data, and the struc
In all likelihood in your database you have not setup any access
privilege yet. You need to look at GRANT command and assign password
to atleast root account and any other accounts which will be
connecting over network.
On Fri, 23 Jul 2004 11:38:06 -0700 (PDT), john sayre
<[EMAIL PROTECTED]> wrote
Your default anonymous account is still active. The Fine Manual describes
how to fix this: http://dev.mysql.com/doc/mysql/en/Default_privileges.html
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Victor Pendleton <[EMAIL PROTECTED]> wrote on 07/23/2004 03:01:56 PM:
Is the ODBC account still enabled on the database server?
-Original Message-
From: john sayre
To: [EMAIL PROTECTED]
Sent: 7/23/04 1:38 PM
Subject: Logging on through ODBC w/o UN & Password (Why is my query tool
allowing this?)
I am able to log onto a database through ODBC without using a
Erich Beyrent wrote:
Hi all,
I need some advice as to how to manage a user login system using PHP and
MySQL. Currently, I have the following table:
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+--
At 21:01 -0700 6/9/03, CM Miller wrote:
Hello.
Been lurkin' on the list for awhile, I have the summer
off, got Paul's book MySQL next to me, so I'm gonna
hunker down and learn mysql on RH 8.0.
Anyway, I'm learning about logging in. I saw the
thread about user mysql and not having a password.
When
iginal Message -
From: "ErwiniEtzsche" <[EMAIL PROTECTED]>
To: "Steve J Racicot" <[EMAIL PROTECTED]>
Sent: Monday, November 04, 2002 3:09 PM
Subject: Re: Logging In Errors
>
>
>
> On Monday 04 November 2002 19:23, you wrote:
> > Hi Group,
> >
&
Stop mysqld and start it again using the --skip-grant-tables command line
option.
--
FROM THE MANUAL AT http://www.mysql.com/doc/en/Command-line_options.html
This option causes the server not to use the privil
So add the user.
See the privilege section of the manual. The GRANT command.
[EMAIL PROTECTED] wrote:
I have the MySQL client installed on "workstation_2". MySQL is installed on
"server_1". When I try to login to the MySQL server using the admin client
it tries to login using username [EMAIL PR
Don,
- Original Message -
From: "Don Arnett" <[EMAIL PROTECTED]>
To: "'Heikki Tuuri'" <[EMAIL PROTECTED]>
Sent: Tuesday, October 29, 2002 8:12 PM
Subject: logging
>
> I'm new to this list. I couldn't find a search facility for searching
> previous answers. If there is one, please let m
The command is th same on just about all systems:
mysql -u username -p
You would then be prompted for the password. These are mysql username
and passwords, not os level users. Typically the user would be root,
meaning the mysql root user, not OSX root user.
MySQL has to be running too.
safe_mys
On Thu, Feb 21, 2002 at 01:47:50PM -0500, Luc Foisy wrote:
>
> maybe the variable you are using is not right
>
> my 'show variables' indicates log with a value of OFF
> | log | OFF
>
> yet mysql still generates its standard error file
Hi Luc,
Thanks for the reply (but ple
ssage-
From: alastair [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 1:17 PM
To: [EMAIL PROTECTED]
Subject: Re: Logging problem with --log, my.cnf etc.
On Thu, Feb 21, 2002 at 01:02:02PM -0500, Luc Foisy wrote:
> Does mysql have permission to write to that location?
Yes.
On Thu, Feb 21, 2002 at 01:02:02PM -0500, Luc Foisy wrote:
> Does mysql have permission to write to that location?
Yes. I'm starting and stopping MySQL using an init script a la Redhat.
This calls 'safe_mysqld' with some args (e.g. --user,--pid-file etc.) -
all started as user root as usual.
The
Does mysql have permission to write to that location?
-Original Message-
From: alastair [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 10:33 AM
To: [EMAIL PROTECTED]
Subject: Logging problem with --log, my.cnf etc.
Hello,
I am using MySQL 3.23.36 on Linux. This is a small
- Original Message -
From: "Tadej Guzej" <[EMAIL PROTECTED]>
> How would I log connections to MySQL server?
> I need the time user connects and the time user disconnects.
It's a workaround, but the general MySQL log actually has this information.
Here's a sample:
/usr/sbin/mysqld,
uot;Werner Stuerenburg" <[EMAIL PROTECTED]>
To: "Tadej Guzej" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, August 07, 2001 9:35 PM
Subject: Re: Logging connections
> You have timestamp fields in your table. When the user connects,
> you inse
You have timestamp fields in your table. When the user connects,
you insert a row. The first timestamp field is set to the entry
time automatically, you just record the user.
When he disconnects, you update the second timestamp with the
disconnect time. You can later compute the difference.
I wo
Have a look at /etc/my.cnf
Simon
-Original Message-
From: Glenn Emery [mailto:[EMAIL PROTECTED]]
Sent: 04 June 2001 19:14
To: [EMAIL PROTECTED]
Subject: Logging
Hi All,
I'm trying to turn on logging for MySQL 3.23.36 and upon running
/etc/rc.d/init.d/mysqld start --log=/var/log/somefil
56 matches
Mail list logo