HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=16)
-   -   ISPConfig 2.2.18 ----> 2.2.24 (http://www.howtoforge.com/forums/showthread.php?t=26837)

Br8knitOFF 15th September 2008 02:08

ISPConfig 2.2.18 ----> 2.2.24
 
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

falko 15th September 2008 13:24

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

Br8knitOFF 15th September 2008 14:30

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

Br8knitOFF 16th September 2008 01:21

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

Br8knitOFF 16th September 2008 01:31

2 Attachment(s)
...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

Br8knitOFF 16th September 2008 16:52

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

Br8knitOFF 16th September 2008 17:13

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

falko 16th September 2008 18:12

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
?

Br8knitOFF 16th September 2008 18:21

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

falko 16th September 2008 18:43

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


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

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