Putting it in /tmp/ just did the job. Sorry, I posted my older my.cnf file.
I actaully did have the log under mysqld rather than the safe version but it
didn't work. I will put this to privilage problems.
On Thu, Jul 8, 2010 at 9:55 PM, Steve Edwards wrote:
> On Thu, 8 Jul 2010, bruce bruce wrote
On Thu, 8 Jul 2010, bruce bruce wrote:
> I have this in /etc/my.cnf:
>
> [mysqld]
> datadir=/var/lib/mysql
> socket=/var/lib/mysql/mysql.sock
> user=mysql
> old_passwords=1
> log-error=/var/log/mysqld.log
>
> [mysqld_safe]
> log-error=/var/log/mysqld.log
> pid-file=/var/run/mysqld/mysqld.pid
> l
I have this in /etc/my.cnf:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
log-error=/var/log/mysqld.log
[mysqld_
On Thu, 8 Jul 2010, bruce bruce wrote:
> Thanks for the input. Tailing the mysql log file doesn't show me
> anything even though FreePBX does right to the asterisk table. I think
> log is more for errors and unexpected shutdowns etcand not queries.
> In the my.cnf file there is no configura
Thanks for the input. Tailing the mysql log file doesn't show me anything
even though FreePBX does right to the asterisk table. I think log is more
for errors and unexpected shutdowns etcand not queries. In the my.cnf
file there is no configuration to higher or lower the verbose to show
queries
On a separate terminal, you can do something like 'tail -f
/var/log/mysqld.log' or whatever the name of the mysql log file is.
Zeeshan A Zakaria
--
www.ilovetovoip.com
On 2010-07-07 9:43 PM, "Carlos Chavez" wrote:
*On Wed, 7 Jul 2010 19:19:28 -0400, bruce bruce wrote*
> Hi Guys,
>
> This is
On Wed, 7 Jul 2010 19:19:28 -0400, bruce bruce wrote
> Hi Guys,
>
> This is something related and yet un-related to Asterisk. I have a
> FreePBX/Asterisk server running and I want to trace everything that FreePBX
> does to MySQL. Is there a verbose CLI to MySQL that I can pull up on terminal
>
Hi Guys,
This is something related and yet un-related to Asterisk. I have a
FreePBX/Asterisk server running and I want to trace everything that FreePBX
does to MySQL. Is there a verbose CLI to MySQL that I can pull up on
terminal and make configuration change to FreePBX and see it in real-time on