View Single Post
  #14  
Old 20th April 2013, 22:06
danhansen@denmark danhansen@denmark is offline
Senior Member
 
Join Date: Mar 2013
Posts: 255
Thanks: 55
Thanked 4 Times in 4 Posts
Exclamation tail -f /var/log/mysql/mysql.log

Hi,

Replied the wrong place - hope this is better...

Code:
root@server1:/home/administrator# tail -f /var/log/mysql/mysql.log

                  291 Quit
130420 20:51:01   294 Connect   ispconfig@localhost on dbispconfig
                  294 Query     SET NAMES utf8
                  294 Query     SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'
                  294 Query     SELECT * FROM server WHERE server_id = 1
                  294 Query     SELECT * FROM server WHERE server_id = 1
                  294 Query     SELECT count(server_id) as number from sys_datalog WHERE datalog_id > 790 AND (server_id = 1 OR server_id = 0)
                  294 Query     SELECT * FROM server WHERE server_id = 1
                  294 Query     SELECT action_id, action_type, action_param FROM sys_remoteaction WHERE server_id = 1  AND  action_id > 0 ORDER BY action_id
                  294 Quit
130420 20:51:43   296 Connect   ispconfig@localhost on dbispconfig
                  296 Query     SELECT access FROM mail_access WHERE source='postmaster@domain.dk' and type = 'recipient' and active = 'y' and server_id = 1
                  296 Query     SELECT access FROM mail_access WHERE source='domain.dk' and type = 'recipient' and active = 'y' and server_id = 1
                  296 Query     SELECT access FROM mail_access WHERE source='dk' and type = 'recipient' and active = 'y' and server_id = 1
                  296 Query     SELECT access FROM mail_access WHERE source='postmaster@' and type = 'recipient' and active = 'y' and server_id = 1
                  297 Connect   ispconfig@localhost on dbispconfig
                  297 Query     SELECT access FROM mail_access WHERE source='postmaster@domain' and type = 'recipient' and active = 'y' and server_id = 1
                  297 Query     SELECT access FROM mail_access WHERE source='domain.dk' and type = 'recipient' and active = 'y' and server_id = 1
                  297 Query     SELECT access FROM mail_access WHERE source='dk' and type = 'recipient' and active = 'y' and server_id = 1
                  297 Query     SELECT access FROM mail_access WHERE source='domain@' and type = 'recipient' and active = 'y' and server_id = 1
                  298 Connect   ispconfig@localhost on dbispconfig
                  298 Query     SELECT access FROM mail_access WHERE source='domain@domain.dk' and type = 'recipient' and active = 'y' and server_id = 1
                  298 Query     SELECT access FROM mail_access WHERE source=domain.dk' and type = 'recipient' and active = 'y' and server_id = 1
                  298 Query     SELECT access FROM mail_access WHERE source='dk' and type = 'recipient' and active = 'y' and server_id = 1
                  298 Query     SELECT access FROM mail_access WHERE source='postmaster@' and type = 'recipient' and active = 'y' and server_id = 1

^C

You have new mail in /var/mail/root
root@server1:/home/administrator# mysql -e "PASTE THE ENTIRE QUERY FROM THE MYSQL LOG FILE HERE;"
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
root@server1:/home/administrator#
I'm sorry, to g.. d... stupid.

Think we are talking total reinstallation, again...

The onlý other place I could find which relate to this was this:
http://www.howtoforge.com/forums/showthread.php?t=49546
But I need a guru to confirm it..
__________________
Kind Regards
Dan

__________________________________________________ _______
Fixed IP/WAN
DMZ -> "ispserverip"
Primary NameServer -> ns1.myprimarynameserver.tld
Secondary NameServer -> ns2.somedomainservice.tld

Ubuntu Server 12.04.4
ISPconfig 3 v.3.0.5.2 (Single Server Setup)
NameServer: BIND v.9.8.1-P1
SquirrelMail: v.1.4.22
MailServer: PostFix v.2.9.6 - IMAP/POP3 Dovecot v.2.0.19
Database: MySQL Server v.5.5.29-0ubuntu0.12.04.2
Tutorial: "ThePerfectServer-ISPconfig3-Ubuntu12.04"

Last edited by danhansen@denmark; 20th April 2013 at 22:55.
Reply With Quote