At 15:30 29.11.2000, Oliver Bleutgen wrote:
You didn't tell what SQL-Database you use, but Postgres and Mysql allow logging/monitoring of the queries they get. So you are able to get the information straight before/while it hits the backend.
Yes, I'm using Postgres - just discovered the "-o"-flag, but I don't know exactly how to log all SQL-queries right now. Guess, I'll read a bit in the Postgres book and the manpages.
Perhaps this spares some time, digged out of my .bash_history, a relic from LoginManager experiments (really handy there...). First stop postgres and then ... /usr/local/pgsql/bin/pg_ctl -o "-i -d 3" -D /var/lib/pgsql/data start (YMMV with the path etc...) This logs everything to the console. You can vary the debugging level, 3 is a bit "vocal", try 2. cheers, oliver