I upgrade all slave server on my clustered setup, not by runnging the ispconfig update script but by removeing all dbispconfig db and ispconfig user and also /usr/local/ispconfig, and do a new install of the latest version. What happens i after each server install , then i add is to the panel , but there's the problem, the existing detail on the panel cannot replicate to the slaves, either i did not finish the update or anything like that. Then lastly i update my panel server a i did above, and here is the main problem, i use tar pcf to zip my ispconfig folder but when run tar zxvf file.tar.gz it result with un recoverable message .... in addition to that after dumping my dbispoconfig db to the new emtpy dbisconfig db and access to panel webpage ... their's whole lot's of php code appear even i cannot logi .... anybody have any idea before i redo my whole setup ....... ????
What you did is not an update. you simply destroyed all servers by removing their databases. Thats what you can expect when you destroy the slave databases. The master recognizes them as empty or damaged and will not replicate data until you restore the original databases that match the data series of the master. If you want to update a ispconfig system, then NEVER remove any files or databases. Just run the ispconfig_update.sh script as described in the update instructions. This means that your tar.gz file is damaged. Maybe the ispconfig version that you installed now and the ispconfig version where you put the dump were not the same.
thanks srijan for your kind reply appreciate that ... are you aware that it can be recovered or not ???? i think this is the danger of trying to shortcut, i did not read the forums regarding update/upgrade ispconfig, anyway the good part is i manage to make sure the service is running smoothly , and now i have to rebuild my whole setup ... i'll wait another day and see if someone have an idea or else i have no other choice but to redo the whole setup again. Regards Maile
thanks srijan for your kind reply appreciate that ... are you aware that it can be recovered or not ???? i think this is the danger of trying to shortcut, i did not read the forums regarding update/upgrade ispconfig, anyway the good part is i manage to make sure the service is running smoothly , and now i have to rebuild my whole setup ... i'll wait another day and see if someone have an idea or else i have no other choice but to redo the whole setup again. Regards Maile Note I attache the screen shot when accessing the new ispconfig version
the ispconfig version i upgrade to is the latest. All my slave and lastly the panel i upgrade to it. Anyway what is your best advice, do you think any chance that i can recover from this otherwise i will redo my setup again.
Regarding the sql issues: it seems as if you restred a old database on a new ispconfig install. so your database layout does not match the installed ispconfig version, its just too old. To fix that, you will have to do a correct update: Download the ispconfig tar.gz, unpack it, run the update.php script in the install folder and let the updater reconfigure your system.
I did this to my panel server and PAM !!!! i am able to access to it on a normal view ...... for the rest of the slave, shall i re run the update.php???in each of them, and maybe this will allow me to edit my pre existing data on the panel before i re install them as mention ealier ???... please confirm before i do that ?????
In your case you should choose yes. Normally you would choose yes on one of the slaves, it does not matter whch one as the function updates the permissions for all slaves.
you should run a update on the slaves as well. Then you should try to find a copy of the slave databases. If you dont have one, then you can copy the content of the master database to the slaves. its not ideal biút it might work.
i did backup all slave dbispconfig database and i have already restore all of them, the only thing i have'nt done is 1. re run updade.php which i will do now 2. How about the ispconfig folder, do i have to copy back the old ones which i manually back up or shall i leave the current one which hold the files for the latest ispconfig version which i reinstall ....
http://www.howtoforge.com/forums/showthread.php?t=62948 i have same issue as this thread .. in my case i have all my slaves and master all on one version ISCONFIG 3.0.5.4p3. any hint why i still recieve this error if my version are the same.
again this is the error i got on all my slave server ERROR - Replication failed. Error: (client) in MySQL server: (localhost) Unknown column 'gender' in 'field list' any hint to solve this issue ???
not a problem srijan ... i have passwed that hurdle ... now m issue is the is a common error on all slave server ispconfig log file ERROR - Error in Replication, changes were not processed. i also find this in that same log file ... -> mysqli_query Unknown column 'gender' in 'field list' 12.09.2014-09:24 - ERROR - Replication failed. Error: (client) in MySQL server: (localhost) Unknown column 'gender' in 'field list' any hint , Note I have update all my ispconfig to the latest version both the slaves and the master. Regards Maile
i check on the dbispconfig database there is no gender field on client table, i guess this error reporting that, i then check on /ispconfig3_install/install/sql/ispconfig3.sql that there is a line there to create a field on table client with name gender. My guess is this dbispconfig database i have i was created with the older isoconfig version therefore it does not have this field while my installing the newer version has this gender, but because i restore the original database , therefore it's overrite with it's older setting and remove the gender field therefore the /usr/local/ispconfig/server/server.sh of the newer version report this error becaue my current dataabse has no gender field. Suggestion and please someone confirm it ... 1. i have to backup my current dbispconfig, remove the dbispconfig database and run install again to have the newer version of the database format which i guess it will have this field and find a way to fill that newer database version with data from older database version. in that case not only it will have my previous db data, also with htis new field such as gender for instance. 2. or is there is another way to update my older db structure with the newer structure ????
when you say copy the content means to dump the dbispconfig database from the mater to each and every slave server ?.... i just check that my panel has these mission fields on my slaves server ... i guess it's db has been the newer version ....
all servers in a cluster have to use the same ispconfig version. same ispconfig version means that all servers are updated or installed with the same version by using the ispconfig update or install script. so if one of your database layouts differs, then either you did not update the server by using the correct script or you replaced its database with a older one after install or update which means that you have to update again to fix your server.
