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

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 15th September 2008, 02:08
Br8knitOFF Br8knitOFF is offline
Member
 
Join Date: Sep 2008
Posts: 35
Thanks: 0
Thanked 1 Time in 1 Post
Default 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

Last edited by Br8knitOFF; 15th September 2008 at 03:08.
Reply With Quote
Sponsored Links
  #2  
Old 15th September 2008, 13:24
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

Does the MySQL user exist (with the correct password) in the mysql.user table?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 15th September 2008, 14:30
Br8knitOFF Br8knitOFF is offline
Member
 
Join Date: Sep 2008
Posts: 35
Thanks: 0
Thanked 1 Time in 1 Post
Default

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
Reply With Quote
  #4  
Old 16th September 2008, 01:21
Br8knitOFF Br8knitOFF is offline
Member
 
Join Date: Sep 2008
Posts: 35
Thanks: 0
Thanked 1 Time in 1 Post
Default

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
Reply With Quote
  #5  
Old 16th September 2008, 01:31
Br8knitOFF Br8knitOFF is offline
Member
 
Join Date: Sep 2008
Posts: 35
Thanks: 0
Thanked 1 Time in 1 Post
Default

...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 Images
  
Reply With Quote
  #6  
Old 16th September 2008, 16:52
Br8knitOFF Br8knitOFF is offline
Member
 
Join Date: Sep 2008
Posts: 35
Thanks: 0
Thanked 1 Time in 1 Post
Default

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
Reply With Quote
  #7  
Old 16th September 2008, 17:13
Br8knitOFF Br8knitOFF is offline
Member
 
Join Date: Sep 2008
Posts: 35
Thanks: 0
Thanked 1 Time in 1 Post
Default

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
Reply With Quote
  #8  
Old 16th September 2008, 18:12
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

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
?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #9  
Old 16th September 2008, 18:21
Br8knitOFF Br8knitOFF is offline
Member
 
Join Date: Sep 2008
Posts: 35
Thanks: 0
Thanked 1 Time in 1 Post
Default

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
Reply With Quote
  #10  
Old 16th September 2008, 18:43
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

What's the MySQL server address you're using in the ISPConfig configuration? Is it localhost?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
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
ISPConfig 2 > 3 upgrade path? wpwood3 General 7 11th August 2010 23:24
ISPConfig 3.0.0.6 Beta released till General 38 21st September 2008 19:15
Questions before installing ISPConfig 2.2.24 chrisbloom7 Installation/Configuration 2 15th September 2008 14:58
ISPConfig 2.2.24 | mailuser app bug? Hans General 19 4th August 2008 15:18
SP-Server Setup - Ubuntu 5.10 "Breezy Badger" - Page 6 (changes) LuisC-SM HOWTO-Related Questions 0 21st April 2006 15:16


All times are GMT +2. The time now is 20:37.


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