
4th June 2009, 03:24
|
|
Senior Member
|
|
Join Date: May 2007
Posts: 189
Thanks: 11
Thanked 2 Times in 2 Posts
|
|
Log error after 3.0.1.3 update
The update went fine on one of my servers, but shows an err in the monitor. The ISPConfig Log has:
Code:
Unable to connect to the database Can't create database 'c2list'; database exists
c2list is one of the databases I had before the update, and I didn't change any permissions. I can't honestly say the error wasn't there before the update because I didn't check just before running it. I know it wasn't there a short time ago though.
|

4th June 2009, 08:11
|
|
Super Moderator
|
|
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 31,888
Thanks: 693
Thanked 4,188 Times in 3,205 Posts
|
|
The error just means that the database could not be created because it existed already. Just click on the delete button in the error lost to remove it as it will block the config queue otherwise.
|

4th June 2009, 16:30
|
|
Senior Member
|
|
Join Date: May 2007
Posts: 189
Thanks: 11
Thanked 2 Times in 2 Posts
|
|
Thanks Till that looks better now. After I removed it it showed up again though. I tried backing it up, and removing it. ISPC made a new one so I thought it would be happy now, but it keeps generating tha same error.
This was my first upgrade after moving to version 3.
Last edited by wxman; 4th June 2009 at 17:42.
|

5th June 2009, 11:40
|
|
Super Moderator
|
|
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 31,888
Thanks: 693
Thanked 4,188 Times in 3,205 Posts
|
|
This has nothing to do with a ispconfig update. Basically you can not create a database adain that exists already.
|

5th June 2009, 13:37
|
|
Senior Member
|
|
Join Date: May 2007
Posts: 189
Thanks: 11
Thanked 2 Times in 2 Posts
|
|
Quote:
Originally Posted by till
This has nothing to do with a ispconfig update. Basically you can not create a database adain that exists already.
|
So how do I stop the error. It keeps coming back even if I delete the database. I don't see how we can ever upgrade again if it won't like the databases that are already there.
|

5th June 2009, 14:06
|
|
Super Moderator
|
|
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 31,888
Thanks: 693
Thanked 4,188 Times in 3,205 Posts
|
|
Which commands exactly did you execute as you updated?
|

5th June 2009, 14:51
|
|
Senior Member
|
|
Join Date: May 2007
Posts: 189
Thanks: 11
Thanked 2 Times in 2 Posts
|
|
From root I did "ispconfig_update.sh".
I've really messed things up now. My two servers are replicated/mirrored, and when I removed the DB on web1 it of course removed it on web2.
|

5th June 2009, 15:47
|
|
Senior Member
|
|
Join Date: May 2007
Posts: 189
Thanks: 11
Thanked 2 Times in 2 Posts
|
|
It does seem that this was all because of DB replication. I guess I needed to shut off replication completely before I did any upgrade. Because I didn't, the upgrade of one got stuck in the DB logs so it kept trying to do the same on the other slave. The two databases just kept trying to sync each other, which kept messing them up. What I ended up doing was shut off the slaves, fixed the databases from back up, the completely redid the master/master replication setup so the all at the same point again. I won't make that mistake next time.
|

5th June 2009, 16:13
|
|
Super Moderator
|
|
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 31,888
Thanks: 693
Thanked 4,188 Times in 3,205 Posts
|
|
Ok, this means you use mysql replication? This is not compatible with ispconfig 3, no wonder that the update failed. ISPConfig uses its own replication.
|

6th June 2009, 01:48
|
|
Senior Member
|
|
Join Date: May 2007
Posts: 189
Thanks: 11
Thanked 2 Times in 2 Posts
|
|
OK now I'm really confused. I asked that when I first started this project, but it sounded like because I was running this as a load balancer/fail over system, the built in replication wouldn't work.
I need both servers to be exactly the same in case of fail over to the second server. I even tried installing ISPC on the second server as a slave, but it didn't seem to work. Am I wrong, and I should reinstall it? If that's true, how should it be done?
|
| Thread Tools |
|
|
| Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT +2. The time now is 08:21.
|
|
Recent comments
1 day 5 hours ago
1 day 10 hours ago
1 day 12 hours ago
1 day 13 hours ago
1 day 14 hours ago
1 day 19 hours ago
1 day 20 hours ago
1 day 22 hours ago
2 days 11 hours ago
2 days 13 hours ago