Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #11  
Old 20th April 2013, 19:24
danhansen@denmark danhansen@denmark is offline
HowtoForge Supporter
 
Join Date: Mar 2013
Posts: 215
Thanks: 44
Thanked 4 Times in 4 Posts
Exclamation Fixed the problem: warning: dict_nis_init: NIS domain name not set - NIS lookups disa

Hi,

The goog says - that took care of business!
It looks like its gone - we nailed that one, didn.t we?

Thanks for that Mark,

Hope to see you shine regarding that other issue as well
http://www.howtoforge.com/forums/sho...089#post296089
__________________
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 19:28.
Reply With Quote
Sponsored Links
  #12  
Old 20th April 2013, 20:05
danhansen@denmark danhansen@denmark is offline
HowtoForge Supporter
 
Join Date: Mar 2013
Posts: 215
Thanks: 44
Thanked 4 Times in 4 Posts
Exclamation So far so good...

Quote:
Originally Posted by markc View Post
The next thing to check is this...

check_recipient_access mysql:/etc/postfix/mysql-virtual_recipient.cf

so add this to your /etc/mysql/my.cnf files under the [mysqld] sections...

general_log = 1
general_log_file = /var/log/mysql/mysql.log


and tail -f /var/log/mysql/mysql.log while a message comes in/ What you are looking for is the EXACT mysql query which is defined in the mysql-virtual_recipient.cf file (cat the file to see it).

Once you see the log entry for, say, postmaster then ctrl-c out of tailing the log file and at the prompt type...

mysql -e "PASTE THE ENTIRE QUERY FROM THE MYSQL LOG FILE HERE;"

and that will either successfuly return a correct lookup... or give you an error as to why it failed, which could be as simple as the server_id field being wrong.
Hi Mark,

After making a backup of the original file "/etc/mysql/my.cf" I made the changes you told me too:

Code:
[mysqld]
#
# * Basic Settings
#

#
# * IMPORTANT
#   If you make changes to these settings and your system uses apparmor, you may
#   also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
#

user            = mysql
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
general_log     = 1
general_log_file = /var/log/mysql/mysql.log
skip-external-locking
But the rest you will have to provide me some details, "spell it out" you know

And this:
"IMPORTANT
If you make changes to these settings and your system uses apparmor, you may
also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.


Are all these errors due to the release upgrade I did? According to some, the ISPconfig 3 installation should work as a default installation!?

Well, here's the mail-log after rebooting - theres some remarks regarding SQL:

Code:
Apr 20 20:06:10 server1 amavis[1186]: Module URI 1.59
Apr 20 20:06:10 server1 amavis[1186]: Module Unix::Syslog 1.1
Apr 20 20:06:10 server1 amavis[1186]: Amavis::DB code loaded
Apr 20 20:06:10 server1 amavis[1186]: Amavis::Cache code loaded
Apr 20 20:06:10 server1 amavis[1186]: SQL base code loaded
Apr 20 20:06:10 server1 amavis[1186]: SQL::Log code NOT loaded
Apr 20 20:06:10 server1 amavis[1186]: SQL::Quarantine NOT loaded
Apr 20 20:06:10 server1 amavis[1186]: Lookup::SQL code loaded
Apr 20 20:06:10 server1 amavis[1186]: Lookup::LDAP code NOT loaded
Apr 20 20:06:10 server1 amavis[1186]: AM.PDP-in proto code loaded
Apr 20 20:06:10 server1 amavis[1186]: SMTP-in proto code loaded
Apr 20 20:06:10 server1 amavis[1186]: Courier proto code NOT loaded
Apr 20 20:06:10 server1 amavis[1186]: SMTP-out proto code loaded
Apr 20 20:06:10 server1 amavis[1186]: Pipe-out proto code NOT loaded
Apr 20 20:06:10 server1 amavis[1186]: BSMTP-out proto code NOT loaded
Apr 20 20:06:10 server1 amavis[1186]: Local-out proto code loaded
Apr 20 20:06:10 server1 amavis[1186]: OS_Fingerprint code NOT loaded
Apr 20 20:06:10 server1 amavis[1186]: ANTI-VIRUS code loaded
Apr 20 20:06:10 server1 amavis[1186]: ANTI-SPAM code loaded
Apr 20 20:06:10 server1 amavis[1186]: ANTI-SPAM-EXT code NOT loaded
Apr 20 20:06:10 server1 amavis[1186]: ANTI-SPAM-C code NOT loaded
Apr 20 20:06:10 server1 amavis[1186]: ANTI-SPAM-SA code loaded
Apr 20 20:06:10 server1 amavis[1186]: Unpackers code loaded
Apr 20 20:06:10 server1 amavis[1186]: DKIM code loaded
Apr 20 20:06:10 server1 amavis[1186]: Tools code NOT loaded
Apr 20 20:06:10 server1 amavis[1186]: Found $file at /usr/bin/file
Apr 20 20:06:10 server1 amavis[1186]: No $altermime, not using it
Apr 20 20:06:10 server1 amavis[1186]: Internal decoder for .mail
Apr 20 20:06:10 server1 amavis[1186]: No decoder for .F
Apr 20 20:06:10 server1 amavis[1186]: Found decoder for .Z at /bin/uncompress
Apr 20 20:06:10 server1 amavis[1186]: Internal decoder for .gz
Apr 20 20:06:10 server1 amavis[1186]: Found decoder for .bz2 at /bin/bzip2 -d
Apr 20 20:06:10 server1 amavis[1186]: Found decoder for .lzo at /usr/bin/lzop -d
Apr 20 20:06:10 server1 amavis[1186]: No decoder for .rpm tried: rpm2cpio.pl, rpm2cpio
Apr 20 20:06:10 server1 amavis[1186]: Found decoder for .cpio at /bin/pax
Apr 20 20:06:10 server1 amavis[1186]: Found decoder for .tar at /bin/pax
Apr 20 20:06:10 server1 amavis[1186]: Found decoder for .deb at /usr/bin/ar
Apr 20 20:06:10 server1 amavis[1186]: Internal decoder for .zip
Apr 20 20:06:10 server1 amavis[1186]: No decoder for .7z tried: 7zr, 7za, 7z
Apr 20 20:06:10 server1 amavis[1186]: No decoder for .rar tried: unrar-free
Apr 20 20:06:10 server1 amavis[1186]: Found decoder for .arj at /usr/bin/arj
Apr 20 20:06:10 server1 amavis[1186]: Found decoder for .arc at /usr/bin/nomarch
Apr 20 20:06:10 server1 amavis[1186]: Found decoder for .zoo at /usr/bin/zoo
Apr 20 20:06:10 server1 amavis[1186]: No decoder for .lha
Apr 20 20:06:10 server1 amavis[1186]: No decoder for .doc tried: ripole
Apr 20 20:06:10 server1 amavis[1186]: Found decoder for .cab at /usr/bin/cabextract
Apr 20 20:06:10 server1 amavis[1186]: No decoder for .tnef
Apr 20 20:06:10 server1 amavis[1186]: Internal decoder for .tnef
Apr 20 20:06:10 server1 amavis[1186]: Found decoder for .exe at /usr/bin/arj
Apr 20 20:06:10 server1 amavis[1186]: Using primary internal av scanner code for ClamAV-clamd
Apr 20 20:06:10 server1 amavis[1186]: Found secondary av scanner ClamAV-clamscan at /usr/bin/clamscan
Apr 20 20:06:10 server1 amavis[1186]: Creating db in /var/lib/amavis/db/; BerkeleyDB 0.49, libdb 5.1
Apr 20 20:06:11 server1 spamd[1202]: logger: removing stderr method
Apr 20 20:06:19 server1 spamd[1318]: spamd: server started on port 783/tcp (running version 3.3.2)
Apr 20 20:06:19 server1 spamd[1318]: spamd: server pid: 1318
Apr 20 20:06:19 server1 spamd[1318]: spamd: server successfully spawned child process, pid 1469
Apr 20 20:06:19 server1 spamd[1318]: spamd: server successfully spawned child process, pid 1470
Apr 20 20:06:19 server1 spamd[1318]: prefork: child states: II
Apr 20 20:06:36 server1 authdaemond: modules="authmysql", daemons=5
Apr 20 20:06:36 server1 authdaemond: Installing libauthmysql
Apr 20 20:06:36 server1 authdaemond: Installation complete: authmysql
Apr 20 20:06:38 server1 postfix/master[2075]: daemon started -- version 2.9.6, configuration /etc/postfix
Apr 20 20:07:01 server1 pop3d: Connection, ip=[::ffff:127.0.0.1]
Apr 20 20:07:01 server1 pop3d: Disconnected, ip=[::ffff:127.0.0.1]
Apr 20 20:07:01 server1 imapd: Connection, ip=[::ffff:127.0.0.1]
Apr 20 20:07:01 server1 imapd: Disconnected, ip=[::ffff:127.0.0.1], time=0
Apr 20 20:07:02 server1 postfix/smtpd[2272]: connect from localhost[127.0.0.1]
Apr 20 20:07:02 server1 postfix/smtpd[2272]: lost connection after CONNECT from localhost[127.0.0.1]
Apr 20 20:07:02 server1 postfix/smtpd[2272]: disconnect from localhost[127.0.0.1]
Apr 20 20:07:20 server1 imapd: Connection, ip=[::ffff:127.0.0.1]
Apr 20 20:07:20 server1 imapd: LOGIN, user=postmaster@apollo1.dk, ip=[::ffff:127.0.0.1], port=[42185], protocol=IMAP
Apr 20 20:07:21 server1 imapd: LOGOUT, user=postmaster@apollo1.dk, ip=[::ffff:127.0.0.1], headers=0, body=0, rcvd=87, sent=392, time=1
Apr 20 20:08:01 server1 postfix/smtpd[2272]: connect from localhost[127.0.0.1]
Apr 20 20:08:01 server1 postfix/smtpd[2272]: lost connection after CONNECT from localhost[127.0.0.1]
Apr 20 20:08:01 server1 postfix/smtpd[2272]: disconnect from localhost[127.0.0.1]
Apr 20 20:08:01 server1 pop3d: Connection, ip=[::ffff:127.0.0.1]
Apr 20 20:08:01 server1 pop3d: Disconnected, ip=[::ffff:127.0.0.1]
Apr 20 20:08:01 server1 imapd: Connection, ip=[::ffff:127.0.0.1]
Apr 20 20:08:01 server1 imapd: Disconnected, ip=[::ffff:127.0.0.1], time=0
Apr 20 20:09:01 server1 postfix/smtpd[2272]: connect from localhost[127.0.0.1]
Apr 20 20:09:01 server1 postfix/smtpd[2272]: lost connection after CONNECT from localhost[127.0.0.1]
Apr 20 20:09:01 server1 postfix/smtpd[2272]: disconnect from localhost[127.0.0.1]
Apr 20 20:09:01 server1 pop3d: Connection, ip=[::ffff:127.0.0.1]
Apr 20 20:09:01 server1 pop3d: Disconnected, ip=[::ffff:127.0.0.1]
Apr 20 20:09:01 server1 imapd: Connection, ip=[::ffff:127.0.0.1]
Apr 20 20:09:01 server1 imapd: Disconnected, ip=[::ffff:127.0.0.1], time=0
Apr 20 20:10:01 server1 postfix/smtpd[2272]: connect from localhost[127.0.0.1]
Apr 20 20:10:01 server1 postfix/smtpd[2272]: lost connection after CONNECT from localhost[127.0.0.1]
Apr 20 20:10:01 server1 postfix/smtpd[2272]: disconnect from localhost[127.0.0.1]
Apr 20 20:10:01 server1 pop3d: Connection, ip=[::ffff:127.0.0.1]
Apr 20 20:10:01 server1 pop3d: Disconnected, ip=[::ffff:127.0.0.1]
Apr 20 20:10:01 server1 imapd: Connection, ip=[::ffff:127.0.0.1]
Apr 20 20:10:01 server1 imapd: Disconnected, ip=[::ffff:127.0.0.1], time=0
Apr 20 20:10:02 server1 postfix/smtpd[2272]: connect from localhost[127.0.0.1]
Apr 20 20:10:02 server1 postfix/smtpd[2272]: lost connection after CONNECT from localhost[127.0.0.1]
Apr 20 20:10:02 server1 postfix/smtpd[2272]: disconnect from localhost[127.0.0.1]
Apr 20 20:10:02 server1 pop3d: Connection, ip=[::ffff:127.0.0.1]
Apr 20 20:10:02 server1 pop3d: Disconnected, ip=[::ffff:127.0.0.1]
Apr 20 20:10:02 server1 imapd: Connection, ip=[::ffff:127.0.0.1]
Apr 20 20:10:02 server1 imapd: Disconnected, ip=[::ffff:127.0.0.1], time=0
And regarding the receiving mail part:

Code:
Apr 20 20:16:49 server1 named[1016]: error (network unreachable) resolving '169.212.85.209.in-addr.arpa/PTR/IN': 2001:7fe::53#53
Apr 20 20:16:49 server1 named[1016]: error (network unreachable) resolving '169.212.85.209.in-addr.arpa/PTR/IN': 2001:67c:e0::1#53
Apr 20 20:16:49 server1 named[1016]: error (network unreachable) resolving '169.212.85.209.in-addr.arpa/PTR/IN': 2001:500:87::87#53
Apr 20 20:16:49 server1 named[1016]: error (network unreachable) resolving '169.212.85.209.in-addr.arpa/PTR/IN': 2001:43f8:110::10#53
Apr 20 20:16:49 server1 named[1016]: error (network unreachable) resolving '169.212.85.209.in-addr.arpa/PTR/IN': 2001:500:13::73#53
Apr 20 20:16:49 server1 named[1016]: error (network unreachable) resolving '169.212.85.209.in-addr.arpa/PTR/IN': 2001:dd8:6::101#53
Apr 20 20:16:49 server1 named[1016]: error (network unreachable) resolving 'z.arin.net/A/IN': 2001:500:31::108#53
Apr 20 20:16:49 server1 named[1016]: error (network unreachable) resolving '174.212.85.209.in-addr.arpa/PTR/IN': 2001:5a0:10::2#53
Apr 20 20:16:49 server1 named[1016]: error (network unreachable) resolving '174.212.85.209.in-addr.arpa/PTR/IN': 2001:500:14:6050:ad::1#53
Apr 20 20:16:49 server1 named[1016]: error (network unreachable) resolving 'in-addr.arpa/DS/IN': 2001:dc3::35#53
Apr 20 20:16:50 server1 named[1016]: error (network unreachable) resolving '125.74.in-addr.arpa/DS/IN': 2001:500:f0::63#53
Apr 20 20:16:50 server1 named[1016]: error (network unreachable) resolving '125.74.in-addr.arpa/DS/IN': 2001:500:13::63#53
Apr 20 20:16:50 server1 named[1016]: error (network unreachable) resolving '74.in-addr.arpa/DNSKEY/IN': 2001:500:31::63#53
Apr 20 20:16:50 server1 named[1016]: error (network unreachable) resolving '74.in-addr.arpa/DNSKEY/IN': 2001:500:98::63#53
Apr 20 20:16:50 server1 postfix/smtpd[2493]: connect from mail-we0-f178.google.com[74.125.82.178]
Apr 20 20:16:50 server1 postfix/smtpd[2272]: connect from mail-wi0-f169.google.com[209.85.212.169]
Apr 20 20:16:50 server1 postfix/smtpd[2491]: connect from mail-wi0-f174.google.com[209.85.212.174]
Apr 20 20:16:50 server1 postfix/smtpd[2493]: NOQUEUE: reject: RCPT from mail-we0-f178.google.com[74.125.82.178]: 554 5.7.1 <postmaster@domain.dk>: Relay access denied; from=<mail@gmail.com> to=<postmaster@domain.dk> proto=ESMTP helo=<mail-we0-f178.google.com>
Apr 20 20:16:50 server1 postfix/smtpd[2493]: disconnect from mail-we0-f178.google.com[74.125.82.178]
Apr 20 20:16:50 server1 postfix/smtpd[2491]: NOQUEUE: reject: RCPT from mail-wi0-f174.google.com[209.85.212.174]: 554 5.7.1 <postmaster@domain.dk>: Relay access denied; from=<mail@gmail.com> to=<postmaster@domain.dk> proto=ESMTP helo=<mail-wi0-f174.google.com>
Apr 20 20:16:50 server1 postfix/smtpd[2272]: NOQUEUE: reject: RCPT from mail-wi0-f169.google.com[209.85.212.169]: 554 5.7.1 <postmaster@domain.dk>: Relay access denied; from=<mail@gmail.com> to=<postmaster@domain.dk> proto=ESMTP helo=<mail-wi0-f169.google.com>
Apr 20 20:16:50 server1 postfix/smtpd[2491]: disconnect from mail-wi0-f174.google.com[209.85.212.174]
Apr 20 20:16:50 server1 postfix/smtpd[2272]: disconnect from mail-wi0-f169.google.com[209.85.212.169]
__________________
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 20:29. Reason: Changed "/etc/mysql/my.cf"
Reply With Quote
  #13  
Old 20th April 2013, 21:04
danhansen@denmark danhansen@denmark is offline
HowtoForge Supporter
 
Join Date: Mar 2013
Posts: 215
Thanks: 44
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
  #14  
Old 20th April 2013, 21:06
danhansen@denmark danhansen@denmark is offline
HowtoForge Supporter
 
Join Date: Mar 2013
Posts: 215
Thanks: 44
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 21:55.
Reply With Quote
  #15  
Old 21st April 2013, 03:42
markc markc is offline
Member
 
Join Date: Dec 2012
Posts: 56
Thanks: 6
Thanked 9 Times in 9 Posts
Default

Presumably you know what the root password to MySQL is as it will ask for it below...

mysql -u root -p -e "SELECT access FROM mail_access WHERE source='postmaster@domain.dk' and type = 'recipient' and active = 'y' and server_id = 1;" dbispconfig
Reply With Quote
  #16  
Old 21st April 2013, 05:46
danhansen@denmark danhansen@denmark is offline
HowtoForge Supporter
 
Join Date: Mar 2013
Posts: 215
Thanks: 44
Thanked 4 Times in 4 Posts
Exclamation The do-release-upgrade from Ubuntu 10.04 - 12.04 did it!

Hi,

The do-release-upgrade from Ubuntu 10.04 - 12.04 did it! I'm sure..
There was corrections to be made regarding ipv6 which we fixed. Now I can see files as /etc/postfix/main.cf , /etc/postfix/master.cf and others which is totally different compared to the samples of the tutorial "The Perfect Server - Ubuntu 12.04".
Therefor I will make an reinstallation, again. But with the 12.04 from the beginning. Then lets see if it betters the errors with postfix/Relay access denied..

The error earlier on in this thread: "warning: dict_nis_init: NIS domain name not set - NIS lookups disabled" was "nuked" by a very sharp player "MarkC". The fix can be found further up this thread. So thanks for that Mark!

I will enter the result here in this thread - it might help some others who upgraded from ubuntu 10.04 --> 12.04 and ran into the same errors..

To be continued...
__________________
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; 21st April 2013 at 05:51.
Reply With Quote
  #17  
Old 22nd April 2013, 15:41
danhansen@denmark danhansen@denmark is offline
HowtoForge Supporter
 
Join Date: Mar 2013
Posts: 215
Thanks: 44
Thanked 4 Times in 4 Posts
 
Exclamation Reinstallation - From Ubuntu 10.04 upgraded to 12.04 to a reinstalled Ubuntu 12.04

Hello everyone,

I'm happy to be able to tell you that the ISPconfig 3 on Ubuntu Server 12.04 works perfectly and have been for 24 hours now.. Mail keeps on working just fine..

So my advice to peole with a Ubuntu 10.04 release upgraded to 12.04, if you are having mailproblems like the ones we have discussed her, to reinstall the server. Please keep in mind that I'm no guru - and therefore please take this advice for exactly what it is - an advice

Special thanks to Mark C. of this forum!
__________________
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
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
link my domain to my server, impossible! 007007 Installation/Configuration 7 17th January 2012 13:59
Postfix doesn't have Nolan Installation/Configuration 5 13th April 2011 05:00
SugarCRM Install on ISPConfig3 w/ SuPHP clucena Installation/Configuration 1 9th February 2010 09:29
ISP Config hesitation when opening web pages frankb Installation/Configuration 7 15th December 2008 13:06
Questions in regards to ISP-Server Setup - Ubuntu 5.10 "Breezy Badger" rbrantley HOWTO-Related Questions 16 10th April 2006 18:26


All times are GMT +2. The time now is 13:08.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.