473,289 Members | 1,840 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,289 software developers and data experts.

Server Log not logging all queries

Hi,

I started the general query log with

mysqld --log

On my machine this command works fine and every select, update and all
statements are logged. I tried the same command on another machine and
many many queries are missing, I am running apache, PHP on that machine
and all the queries come through the web on localhost.

I wonder why this is happening?

Thanks
Rohan

Oct 12 '05 #1
5 1907
My SQL wrote:
Hi,

I started the general query log with

mysqld --log

On my machine this command works fine and every select, update and all
statements are logged. I tried the same command on another machine and
many many queries are missing, I am running apache, PHP on that machine
and all the queries come through the web on localhost.

I wonder why this is happening?


What versions of MySQL are running on your machine and on the other
machine? Behavior of the logging or command-line options might be
different between the MySQL releases.

Is there any pattern to which queries are missing from the logs? Such
as all those after your restarted the MySQL server, or all queries from
your PHP apps, or other pattern?

Regards,
Bill K.
Oct 12 '05 #2
all queries from the PHP apps are missing.The other queries from other
machines are all fine. The PHP and Mysql run on the same machine. I
think the queries from the localhost are all missing.

Help!!

Oct 13 '05 #3
My SQL wrote:
all queries from the PHP apps are missing.The other queries from other
machines are all fine. The PHP and Mysql run on the same machine. I
think the queries from the localhost are all missing.


Check your personal server for the queries (or stop the MySQL daemon on
your personal machine, and see if the PHP apps on the new server get
errors).

I'm wondering if the PHP apps are still configured to connect to MySQL
on your machine. It's worth double-checking.

Regards,
Bill K.
Oct 13 '05 #4
yes the PHP apps stop working when the server is stopped, the PHP apps
are all connecting to the MySQL on the machine..

All the other queries are logged including the connect statements,
except for the queries from PHP on the same machine !!

Thanks

Oct 14 '05 #5
My SQL wrote:
yes the PHP apps stop working when the server is stopped, the PHP apps
are all connecting to the MySQL on the machine..

All the other queries are logged including the connect statements,
except for the queries from PHP on the same machine !!


I don't think you're understanding what I'm asking.

You said that you have two physical machines running these PHP
applications, called them "A" and "B". "A" is your machine. "B" is
what you describe as "another machine" in your original post on this
topic. The SQL queries are logged correctly on machine A, but
apparently are not logged correctly from PHP apps on machine B.

The PHP apps connect to a MySQL database. By doing so, they must
specify a host to which to connect. The host may be the same machine on
which the PHP apps run, but is not necessarily the same machine. PHP
can connect to MySQL running on any machine on the network. It depends
on the PHP code that makes the database connection. I'm assuming that
machines A and B are reachable to each other on your network.

My guess is that the PHP apps running on machine B are connecting to the
MySQL service on machine A. If that is the case, you'll find the
queries logged on machine A.

You can check the database connection code in your PHP apps on machine B
to verify. I suggested another way to verify was to shut off MySQL on
machine A and see if the PHP apps on machine B complain about the lack
of a database.

Regards,
Bill K.
Oct 14 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Ravi Shankar | last post by:
Hi all, I have an enterprise application. I am using Apache Log4J for the logging purposes. WHen a request is received by the application, it goes throug servlets and many classes, and the...
13
by: Fortepianissimo | last post by:
Here is the situation: I want my server started up upon connection. When the first connection comes in, the server is not running. The client realizes the fact, and then starts up the server and...
6
by: Nathan Sokalski | last post by:
I want to set up SQL Server on Windows XP Pro so that I can use the database capabilities of ASP and IIS. I am probably using some incorrect settings, but I am not sure what they are. Here is what...
2
by: Jeff | last post by:
I have the following packages installed on my system: libpq3: 7.3.2r1-5 python-pygresql: 7.3.2r1-5 postgresql: 7.2.1-2woody2 postgresql-client: 7.2.1-2woody2 In my application, which is...
2
by: stig erikson | last post by:
Hi. i would like to log every single query coming in to the database into a table. i would like the log to include the entire query and execution time and execution cost, and if possible the user...
3
by: JayD | last post by:
(Not sure whether it is a general aspnet problem or a specific security problem, hence posting it in 2 groups). This will solve for us a number of problems. I have developed a website on my...
0
by: job | last post by:
Mohamed Sharaf's has produced a Microsoft.Practices.EnterpriseLibrary production server installer: https://blogs.msdn.com/mohamed_sharafs_blog/archive/2005/09/18/470854.aspx Running the...
1
by: eblackmo | last post by:
I have a test network consisting of four servers running windows 2003 server R2 SP2. I have set up a domain which functioned correctly for about a day and a half until the other servers decided they...
2
by: Frank Aune | last post by:
Hi, Explaining this problem is quite tricky, but please bear with me. Ive got an application which uses MySQL (InnoDB) for two things: 1. Store and retrieve application data (including...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.