View Single Post
  #44  
Old 4th September 2011, 20:49
isn isn is offline
Member
 
Join Date: Oct 2009
Posts: 57
Thanks: 6
Thanked 3 Times in 3 Posts
Default

The smoke has cleared and everything is working but squirrelmail.

Error message is:

ERROR: Connection dropped by IMAP server.
when I use info@localhost as username


I've looked at a few threads.


http://www.howtoforge.com/forums/showthread.php?t=41068

These make me wonder about:
[root@mercury oldvar]# cat /etc/postfix/mysql-virtual_domains.cf
user = ispconfig
password = 777aa60c2d727a4e41b8b526f744979b
dbname = dbispconfig
table = mail_domain
select_field = domain
where_field = domain
additional_conditions = and active = 'y' and server_id = 1

Maybe there is something that needs to be done with the password.
mysql> select domain from mail_domain;
+-------------------------+
| domain |
+-------------------------+
....snip.....
| tehillimsongs.com |
| woordridgeapartment.com |
+-------------------------+
16 rows in set (0.00 sec)

mysql> desc mail_domain;
+----------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+------------------+------+-----+---------+----------------+
| domain_id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| sys_userid | int(11) unsigned | NO | | 0 | |
| sys_groupid | int(11) unsigned | NO | | 0 | |
| sys_perm_user | varchar(5) | NO | | | |
| sys_perm_group | varchar(5) | NO | | | |
| sys_perm_other | varchar(5) | NO | | | |
| server_id | int(11) unsigned | NO | MUL | 0 | |
| domain | varchar(255) | NO | MUL | | |
| active | enum('n','y') | NO | | NULL | |
+----------------+------------------+------+-----+---------+----------------+
9 rows in set (0.00 sec)

mysql> select domain_id,domain,server_id,active from mail_domain;
+-----------+-------------------------+-----------+--------+
| domain_id | domain | server_id | active |
+-----------+-------------------------+-----------+--------+
...snip....
| 19 | linuxauthority.com | 1 | y |
| 20 | newdatacloud.com | 1 | y |
+-----------+-------------------------+-----------+--------+
16 rows in set (0.00 sec)




I did not migrate that file from the old setup, but it looks like its reading a particular table.


My migration method was as follows for the record.

I did a clean install.

I rebuilt the soft links in /etc/httpd/conf/sites-enabled
Copied across the content in /etc/httpd/conf/sites-available

Restored the dbispconfig database from backup with mysql down.

I've got all the data and I'm seeing new mail piling up in /var/vmail

Looking for a little help with what is ailing squirrelmail.

/var/log/maillog right after a login attempt.

Sep 4 17:40:01 mercury postfix/smtpd[321]: disconnect from localhost[::1]
Sep 4 17:42:29 mercury imapd: Connection, ip=[::1]
Sep 4 17:45:01 mercury imapd: Connection, ip=[::1]
Sep 4 17:45:01 mercury imapd: Disconnected, ip=[::1], time=0
Sep 4 17:45:01 mercury pop3d: Connection, ip=[::1]
Sep 4 17:45:01 mercury pop3d: Disconnected, ip=[::1]
Sep 4 17:45:01 mercury postfix/smtpd[479]: connect from localhost[::1]
Sep 4 17:45:01 mercury postfix/smtpd[479]: lost connection after CONNECT from localhost[::1]
Sep 4 17:45:01 mercury postfix/smtpd[479]: disconnect from localhost[::1]

[root@mercury oldvar]# netstat -nap | grep ":143 "
tcp 0 0 :::143 :::* LISTEN 32451/couriertcpd

All services seem to be running fine.

Realizing it is a weekend I'm going over the install document again to see if I missed anything.

http://www.howtoforge.com/perfect-se...ispconfig-3-p6

Other variances that could be important.

# SSL Configuration
#SSLEngine On
#SSLCertificateFile /usr/local/ispconfig/interface/ssl/ispserver.crt
#SSLCertificateKeyFile /usr/local/ispconfig/interface/ssl/ispserver.key


Was changed in 000-ispconfig.vhost

When the following error occurred:

Starting httpd: Syntax error on line 48 of /etc/httpd/conf/sites-enabled/000-ispconfig.vhost:
SSLCertificateFile: file '/usr/local/ispconfig/interface/ssl/ispserver.crt' does not exist or is empty


The file is indeed empty. hoping this helps.

I will try mail reader other than squirrelmail when some more time presents itself.

Also having some issues running Joomla 1.7 sites. White screen occurs, probably due to incorrect settings.

Regards,

Update: Joomla issues are resolved. Merely had to pick the right default php to make it work. I am documenting as I go. If I fix squirrelmail, I'm in good shape. I guess I would be better off if I found those crt files. I don't know if that is wreckage from my migration methodology or what.
__________________
isn aka SEP from ITRC forums

Last edited by isn; 5th September 2011 at 04:08.
Reply With Quote