Okay- in hindsight, I know what I did wrong, but am struggling with correcting the problem. First off, MANY thanks to all of the developers for an OUTSTANDING product!!! Problem is this: Old Debian Etch box, to new Debian Etch box, both configured exactly the same, except for minor version differences in apache2, mysql, etc. Migrated all 16 sites over onto the new box, db's, etc. according to Falko's excellent post: Migrating an ISPConfig Installation I, uhmmmm, forgot to upgrade the initial installation of ISPConfig 2.2.18 to 2.2.24 before importing all of the databases, including the ISPConfig database. (new server is running 2.2.24) Now, I obviously have all sorts of strangeness. I have since upgraded the old machine's ISPConfig installation to 2.2.24 without any problems, re-exported the ISPConfig database, created a new DB on the new server, imported the v2.2.24 database, but it looks like there are a TON of tables missing. I changed the name of the ISPConfig database in the '/home/admispconfig/ispconfig/lib/config.inc.php' and login credentials, pointing to the newly created/imported ISPConfig database, but I can't login to the admin interface- just keep getting failed logins. (I also restarted the ispconfig_server) Is there a way to downgrade my currently installed version 2.2.24 to 2.2.18, use the 2.2.18 imported ISPConfig database, and perform an upgrade to 2.2.24? Is there any easier way to get all this working? Again- thanks for a tremendous product!!! //Todd
Yes- same user/pwd that I'm using for the other ISPConfig database. (v2.2.18) Is there another file(s) that I need to update with the new database name? Thanks! //Todd
A little more info: When I restart isconfig_server with the new database info (same user/pwd credentials as the old ispconfig 2.2.18 DB), I get this: Starting ISPConfig system... /root/ispconfig/httpd/bin/apachectl startssl: httpd started Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/ispconfig/scripts/lib/config.inc.php on line 47 No results found!ISPConfig system is now up and running! It appears to be running, but can't login to the admin web interface as any user, nor as admin... Thanks, //Todd
...and more info: The first is the old 2.2.18 ispconfig database tables. The second is the new ispconfig database dumped from old server after successful upgrade from 2.2.18 to 2.2.24, and imported onto the new server. Thanks, //Todd
More info: DNS lookups for my primary domain fail. Lookups for any other domain hosted on my machine work fine. /etc/bind/named.conf shows the zone file configured, the zone files are there with the others, have NS records listed, A records for the 2 NS records, etc. This is getting maddening- feel like I'm chasing my tail here. All the sites/mail work that I migrated over, but each/every attempt to add any fails miserably- no mysql ability, no ftp, etc. About to shave my head, because I know pulling my hair out would hurt too much... //Todd
Anybody ever get the feeling that they're talking to themselves in a public forum? Another question since I think I've opened up a huge, stinking can o' worms here: Would it be possible to do another installation (aside from the current installation) using different paths, different databases, etc.? I think I already know the answer because of things like bind, the mysql DB, etc., but I'm running out of ideas/time/patience. Where would anybody else go from here? I'm willing to re-install everything from scratch and start over, but my biggest concern is having to reset a butt-ton of username/pwd combinations and having my phone ring off the hook... My thought is to go with a VM and slowly migrate everything over, get it all working, then migrate back. Part of the problem is that I was rushed to do this migration to begin with and had to do it in the wee hours of the night, after LONG days at work. Thanks, //Todd
Does connecting to MySQL (with the login details from /home/admispconfig/ispconfig/lib/config.inc.php) work? E.g. Code: mysql -u root -p What's the output of Code: netstat -tap ?
Yes: liasis:/home/admispconfig/ispconfig/lib# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12276 Server version: 5.0.32-Debian_7etch6-log Debian etch distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> Output of netstat -tap: liasis:/home/admispconfig/ispconfig/lib# netstat -tap Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 localhost:60000 *:* LISTEN 1065/postgrey.pid - tcp 0 0 localhost:10024 *:* LISTEN 953/amavisd (master tcp 0 0 localhost:10025 *:* LISTEN 12849/master tcp 0 0 localhost:mysql *:* LISTEN 18520/mysqld tcp 0 0 *:81 *:* LISTEN 5897/ispconfig_http tcp 0 0 morelia.5minutem:domain *:* LISTEN 31925/named tcp 0 0 liasis.5minutema:domain *:* LISTEN 31925/named tcp 0 0 localhost:domain *:* LISTEN 31925/named tcp 0 0 *:ftp *:* LISTEN 6084/proftpd: (acce tcp 0 0 localhost:953 *:* LISTEN 31925/named tcp 0 0 *:smtp *:* LISTEN 12849/master tcp 0 0 *:2525 *:* LISTEN 12849/master tcp 0 0 liasis.5minutemaj:58154 liasis.5minutemaj:imaps ESTABLISHED21598/sshd: toddl tcp 0 0 liasis.5minutemaj:57915 liasis.5minutemaj:imaps ESTABLISHED21598/sshd: toddl tcp 0 0 liasis.5minutemaj:50444 liasis.5minutemaj:imaps CLOSE_WAIT 21598/sshd: toddl tcp 0 0 liasis.5minutemaj:59331 www.howtoforge.com:www TIME_WAIT - tcp 0 0 localhost:mysql localhost:46646 ESTABLISHED18520/mysqld tcp 0 0 liasis.5minutemaj:59419 yw-in-f166.google.c:www ESTABLISHED21598/sshd: toddl tcp 0 0 liasis.5minutemaj:59421 yw-in-f166.google.c:www ESTABLISHED21598/sshd: toddl tcp 0 0 localhost:46646 localhost:mysql ESTABLISHED23785/2 tcp 1181 0 liasis.5minutemaj:39988 ns.atl.org:www CLOSE_WAIT 1157/freshclam tcp 0 0 localhost:60000 localhost:37899 ESTABLISHED1065/postgrey.pid - tcp 0 0 liasis.5minutemaj:41216 206.57.28.51:www TIME_WAIT - tcp 0 0 localhost:37899 localhost:60000 ESTABLISHED31480/smtpd tcp 66369 0 liasis.5minutemaj:33058 clamav-mirror.sonic:www ESTABLISHED1157/freshclam tcp 0 0 liasis.5minutemaj:43144 oam-m15a.blue.aol.c:aol ESTABLISHED21598/sshd: toddl tcp 106785 0 liasis.5minutemaj:48488 clamav-du.viaverio.:www CLOSE_WAIT 1157/freshclam tcp 0 0 liasis.5minutemaj:34415 64.12.30.88:aol ESTABLISHED21598/sshd: toddl tcp 0 0 liasis.5minutemaj:33407 cs116.msg.mud.yaho:mmcc ESTABLISHED21598/sshd: toddl tcp 0 0 liasis.5minutemaj:44141 206.57.28.64:www ESTABLISHED21598/sshd: toddl tcp 0 0 liasis.5minutema:domain s239.c4.crucialx.:42852 ESTABLISHED31925/named tcp 0 0 liasis.5minutemaj:55427 64.12.26.86:aol ESTABLISHED21598/sshd: toddl tcp 0 0 liasis.5minutema:domain s239.c4.crucialx.:42758 TIME_WAIT - tcp6 0 0 *:imaps *:* LISTEN 1188/couriertcpd tcp6 0 0 *op3s *:* LISTEN 1207/couriertcpd tcp6 0 0 *op3 *:* LISTEN 1193/couriertcpd tcp6 0 0 *:imap2 *:* LISTEN 1176/couriertcpd tcp6 0 0 *:www *:* LISTEN 5943/apache2 tcp6 0 0 *:ssh *:* LISTEN 1406/sshd tcp6 0 0 ::1%2793:953 *:* LISTEN 31925/named tcp6 0 0 *:smtp *:* LISTEN 12849/master tcp6 0 0 *:https *:* LISTEN 5943/apache2 tcp6 0 0 *:2525 *:* LISTEN 12849/master tcp6 0 91 liasis.5minutemajop3s mobile-032-175-24:50254 FIN_WAIT1 - tcp6 0 0 liasis.5minutemajor:ssh ::ffff:207.193.12:46754 ESTABLISHED23783/sshd: toddl [ tcp6 0 0 liasis.5minutemaj:imaps liasis.5minutemaj:58154 ESTABLISHED21623/couriertls tcp6 0 0 liasis.5minutemaj:imaps liasis.5minutemaj:57915 ESTABLISHED21819/couriertls tcp6 0 0 liasis.5minutemajor:www ::ffff:207.54.197:30860 FIN_WAIT2 - tcp6 0 0 liasis.5minutemajor:www ::ffff:207.54.197:30861 FIN_WAIT2 - tcp6 0 0 liasis.5minutemajor:www ::ffff:207.54.197:30862 FIN_WAIT2 - tcp6 0 0 liasis.5minutemajor:ssh ::ffff:207.193.12:52188 ESTABLISHED22761/sshd: bengelh tcp6 0 0 liasis.5minutemajor:ssh ::ffff:207.193.12:52016 ESTABLISHED21596/sshd: toddl [ tcp6 0 528 liasis.5minutemajor:ssh ::ffff:207.193.12:36162 ESTABLISHED31846/sshd: toddl [ tcp6 0 0 liasis.5minutemajop3s ip72-197-156-187.s:2834 TIME_WAIT - tcp6 0 0 liasis.5minutemaj:imaps bda109b.bis.na.bl:55022 ESTABLISHED13121/couriertls Thanks Falko! //Todd
Yes- look like most of them are ca errors: [Tue Sep 16 06:08:04 2008] [error] mod_ssl: SSL handshake failed (server liasis.5minutemajor.net:81, client 24.28.4.49) (OpenSSL library error follows) [Tue Sep 16 06:08:04 2008] [error] OpenSSL: error:14094418:SSL routines:SSL3_READ_BYTES:tlsv1 alert unknown ca [Tue Sep 16 06:08:05 2008] [error] mod_ssl: SSL handshake failed (server liasis.5minutemajor.net:81, client 24.28.4.49) (OpenSSL library error follows) [Tue Sep 16 06:08:05 2008] [error] OpenSSL: error:14094418:SSL routines:SSL3_READ_BYTES:tlsv1 alert unknown ca [Tue Sep 16 06:08:07 2008] [error] mod_ssl: SSL handshake failed (server liasis.5minutemajor.net:81, client 24.28.4.49) (OpenSSL library error follows) [Tue Sep 16 06:08:07 2008] [error] OpenSSL: error:14094418:SSL routines:SSL3_READ_BYTES:tlsv1 alert unknown ca [Wed Sep 17 08:42:58 2008] [error] mod_ssl: SSL handshake failed (server liasis.5minutemajor.net:81, client 72.179.41.14) (OpenSSL library error follows) [Wed Sep 17 08:42:58 2008] [error] OpenSSL: error:14094418:SSL routines:SSL3_READ_BYTES:tlsv1 alert unknown ca [Wed Sep 17 09:07:03 2008] [error] mod_ssl: SSL handshake failed: HTTP spoken on HTTPS port; trying to send HTML error page (OpenSSL library error follows) [Wed Sep 17 09:07:03 2008] [error] OpenSSL: error:1407609C:SSL routines:SSL23_GET_CLIENT_HELLO:http request [Hint: speaking HTTP to HTTPS port!?] [Wed Sep 17 09:07:04 2008] [error] mod_ssl: SSL handshake failed: HTTP spoken on HTTPS port; trying to send HTML error page (OpenSSL library error follows) [Wed Sep 17 09:07:04 2008] [error] OpenSSL: error:1407609C:SSL routines:SSL23_GET_CLIENT_HELLO:http request [Hint: speaking HTTP to HTTPS port!?] [Wed Sep 17 09:07:06 2008] [error] mod_ssl: SSL handshake failed (server liasis.5minutemajor.net:81, client 72.179.41.14) (OpenSSL library error follows) [Wed Sep 17 09:07:06 2008] [error] OpenSSL: error:14094418:SSL routines:SSL3_READ_BYTES:tlsv1 alert unknown ca [Wed Sep 17 09:07:07 2008] [error] mod_ssl: SSL handshake failed: HTTP spoken on HTTPS port; trying to send HTML error page (OpenSSL library error follows) [Wed Sep 17 09:07:07 2008] [error] OpenSSL: error:1407609C:SSL routines:SSL23_GET_CLIENT_HELLO:http request [Hint: speaking HTTP to HTTPS port!?] [Wed Sep 17 09:08:21 2008] [error] [client 72.179.41.14] File does not exist: /home/admispconfig/ispconfig/web/webmail/images/empty.gif //Todd
This looks like a broken SSL cert. Can you recreate it as shown on http://www.howtoforge.com/forums/showthread.php?t=121 ?
Yes- will fix the cert stuff tonight. I fixed the bind problem- VERY strange, but after deleting an odd CNAME record in the zone file in question, it loaded good. I don't remember if I added the CNAME record in that zone or not, but bind had been working for all of the other domains, and for the domain in questions all along until the server migration. Thanks, //Todd
Okay- cert stuff is fixed. Didn't do a self-signed cert, though... [Fri Sep 19 07:53:07 2008] [notice] caught SIGTERM, shutting down [Fri Sep 19 07:53:13 2008] [notice] Apache configured -- resuming normal operations [Fri Sep 19 07:53:13 2008] [notice] Accept mutex: sysvsem (Default: sysvsem) Any idea on the other stuff? The ispconfig DB stuff is driving me nuts. I still can't create mysql Db's with newly created sites, and I know there's prob a bunch of other stuff too because of the database schema problems... Thanks, //Todd
Falko, What would you suggest as the easiest/quickest way to fix this by re-migrating everything over? I have the hardware the old working installation is installed on sitting here in my office, and the new/problematic installation running on a hosted VM. (XEN) How would you suggest blowing everything away (except for the webroots) and re-migrating over? I did perform a successful upgrade from v2.2.18 ----> v2.2.24 on the old hardware, so that all *should* be ready to go. I know there is an uninstall for ispconfig, but will that take care of the mysql database stuff, too? Thanks! //Todd
Yes - that is, if the uninstaller can connect to MySQL... If it can't, you can still delete the databases manually.
Falko, Thanks again for your time and effort. I got my system rockin' again. I backed up my db's, webroot and ran the uninstall. While it did remove *most* everything, I cleaned up everything else before installing v2.2.25, restored the DB's after creating everything again from scratch from within ISPConfig, and all is good. (It didn't remove the bind zone files, the user accounts/pwds from /etc/passwd and /etc/shadow, etc.) I don't know WHAT exactly happened, but is was total chaos! Thanks again for a great product! //Todd
