ISPConfig 2.2.18 ----> 2.2.24

Discussion in 'Installation/Configuration' started by Br8knitOFF, Sep 15, 2008.

  1. Br8knitOFF

    Br8knitOFF New Member

    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
     
    Last edited: Sep 15, 2008
  2. falko

    falko Super Moderator

    Does the MySQL user exist (with the correct password) in the mysql.user table?
     
  3. Br8knitOFF

    Br8knitOFF New Member

    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
     
  4. Br8knitOFF

    Br8knitOFF New Member

    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
     
  5. Br8knitOFF

    Br8knitOFF New Member

    ...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
     

    Attached Files:

  6. Br8knitOFF

    Br8knitOFF New Member

    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
     
  7. Br8knitOFF

    Br8knitOFF New Member

    Anybody ever get the feeling that they're talking to themselves in a public forum?:D

    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
     
  8. falko

    falko Super Moderator

    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
    ?
     
  9. Br8knitOFF

    Br8knitOFF New Member

    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 *:pop3s *:* LISTEN 1207/couriertcpd
    tcp6 0 0 *:pop3 *:* 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.5minutemaj:pop3s 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.5minutemaj:pop3s ip72-197-156-187.s:2834 TIME_WAIT -
    tcp6 0 0 liasis.5minutemaj:imaps bda109b.bis.na.bl:55022 ESTABLISHED13121/couriertls

    Thanks Falko!
    //Todd
     
  10. falko

    falko Super Moderator

    What's the MySQL server address you're using in the ISPConfig configuration? Is it localhost?
     
  11. Br8knitOFF

    Br8knitOFF New Member

    Yes:

    $go_info["server"]["db_host"] = "localhost";^

    //Todd
     
  12. falko

    falko Super Moderator

    Are there any errors in the error log in /root/ispconfig/httpd/logs?
     
  13. Br8knitOFF

    Br8knitOFF New Member

    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
     
  14. falko

    falko Super Moderator

  15. Br8knitOFF

    Br8knitOFF New Member

    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
     
  16. Br8knitOFF

    Br8knitOFF New Member

    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
     
    Last edited: Sep 19, 2008
  17. falko

    falko Super Moderator

    To be honest, I'm running out of ideas... :(
     
  18. Br8knitOFF

    Br8knitOFF New Member

    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
     
  19. falko

    falko Super Moderator

    Yes - that is, if the uninstaller can connect to MySQL...
    If it can't, you can still delete the databases manually.
     
  20. Br8knitOFF

    Br8knitOFF New Member

    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
     

Share This Page