View Single Post
  #13  
Old 20th April 2013, 21:04
danhansen@denmark danhansen@denmark is offline
HowtoForge Supporter
 
Join Date: Mar 2013
Posts: 201
Thanks: 41
Thanked 4 Times in 4 Posts
Exclamation OK - did tail -f /var/log/mysql/mysql.log

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...
__________________
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"
Reply With Quote