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 9th May 2006, 02:40
Dave Lane Dave Lane is offline
Junior Member
 
Join Date: Mar 2006
Location: Christchurch, New Zealand
Posts: 9
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via ICQ to Dave Lane
Default Recovering unlinked mysql databases and users...

Hi all,

I'm wondering if there is a Database Schema diagram, showing how various tables relate to each other - specifically, I want to find out how databases and database users (i.e. rows in isp_isp_datenbank table) are associated with web sites (i.e. a row in the isp_isp_web table).

A bit more information - I'm running ISPConfig 2.2.2 on an Ubuntu Breezy server. I found, after upgrading from ISPConfig 2.1.2 -> 2.2.0 that my two resellers were no longer recognised as resellers by the system (i.e. I could see their records in the interface tree, but whenever I checked their reseller details all the fields were blank or filled with default values - a look at the DB isp_isp_reseller table confirmed it was empty). The reseller account still has clients and sites, so it's functioning as would be expected, but its Limits are not held...

In an effort to remedy this (also after upgrading to 2.2.2), I simply created a new reseller with a slightly different name. I moved a test Client and Site as well as my Hostingplans to the new reseller into the appropriate "groups" and all seemed well... then I moved an actual live Client and Site... and was warned that the default Limits for the Reseller didn't allow MySQL databases... The only option was to click "next >>", and I found (according to phpMyAdmin) that the Site's 3 databases web4_db1,2,3 had been deleted from MySQL along with their respective users web4_u1,2,3...

I fixed the Reseller Limits for the new reseller and tried recreating the databases and users through the ISPConfig interface, but it started by creating web4_db4 rather than web4_db1... Looking at the ispconfig MySQL database, I could see in isp_isp_datenbank that the 3 databases and users were still defined. Even so, the the database links associating them with their web_id must've been lost as the Site's "options" tab showed no databases.

I've since manually recreated the relevant databases, users, and recovered the data from backup, but I don't see an easy way to figure out how to reassociate those databases and users to the appropriate site so that I can again manage them through the ISPConfig interface.

Any assistance would be much appreciated!
Kind regards,

Dave (in NZ)
Reply With Quote
Sponsored Links
  #2  
Old 9th May 2006, 17:37
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

Basically all records have an associated record in isp_nodes and isp_dep that link it to other tables. If you play around a little bit, you'll see how it works (but I highly recommend to do it on a test system until you know how things work!).
__________________
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 10th May 2006, 19:45
Norman Norman is offline
HowtoForge Supporter
 
Join Date: May 2006
Posts: 242
Thanks: 0
Thanked 18 Times in 14 Posts
 
Default

Still think we need a schematics of the database. It's not easy testing stuff not knowing what it will do.
Sure we may get it to work, but on the way there it may change something else which surfaces long after.
__________________
http://www.xh.se
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


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


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