This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

Upgrading ZPanel 10.1.* to Sentora - Alpha/Beta
#13
RE: Upgrading ZPanel 10.1.* to Sentora - Alpha/Beta
(09-23-2015, 04:13 AM)kandrews Wrote: Basically there are many many many configuration and code and database changes between ZPanel and Sentora. The quickest way to make an upgrade was to take the ZPanel databases over to Sentora fresh install and rerun the daemon.

All of my servers, pcs and even my PI has /etc/hostname ... little bit strange yours doesn't, who is your server provider?

can you run:
Code:
cat /etc/sentora/panel/cnf/db.php | grep "pass" | cut -d \' -f 2

and see if it returns the current zpanel root password correctly?

Also is your shell set /bin/bash?

I understand. i mainly had some questionsSmile.

We have our own servers. Don't know why there's no hostname file. I don;t think thats the biggest problem.

Try'd you code and the sql password was giving back correctly.

Shell is:

Code:
[root@192 ~]# ps -p $$ | tail -1 | awk '{print $NF}'
bash
[root@192 ~]#

Did some manual sql entry's from the script:

Code:
[root@192 /]# mysql -u root -pLmmFO7D6gR9PJmtA -e "DELETE FROM mysql.user WHERE User='root' AND Host != 'localhost'"
[root@192 /]# mysql -u root -pLmmFO7D6gR9PJmtA-e "DELETE FROM mysql.user WHERE User=''";
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@192 /]# mysql -u root -pLmmFO7D6gR9PJmtA -e "DELETE FROM mysql.user WHERE User=''";
[root@192 /]# mysql -u root -pLmmFO7D6gR9PJmtA -e "DELETE FROM mysql.user WHERE User='root' AND Host != 'localhost'"
[root@192 /]# mysql -u root -pLmmFO7D6gR9PJmtA -e "DELETE FROM mysql.user WHERE User=''";
[root@192 /]# mysql -u root -pLmmFO7D6gR9PJmtA -e "FLUSH PRIVILEGES";
[root@192 /]# mysql -u root -pLmmFO7D6gR9PJmtA -e "DROP DATABASE IF EXISTS test";
[root@192 /]#  mysql -u root -pLmmFO7D6gR9PJmtA < /etc/sentora/configs/sentora-update/zpanel/sql/update-structure.sql
ERROR 1091 (42000) at line 50: Can't DROP 'pk_enablecgi_in'; check that column/key exists
[root@192 /]# mysql -u root -pLmmFO7D6gR9PJmtA < /etc/sentora/configs/sentora-update/zpanel/sql/update-data.sql
ERROR 1062 (23000) at line 17: Duplicate entry '48' for key 'PRIMARY'
[root@192 /]#

After this the new sentora tables is still not visible in phpmyadmin...


So now i did a force with sql:

Code:
[root@192 /]#  mysql -f -u root -pLmmFO7D6gR9PJmtA < /etc/sentora/configs/sentora-update/zpanel/sql/update-structure.sql
ERROR 1091 (42000) at line 50: Can't DROP 'pk_enablecgi_in'; check that column/key exists
ERROR 1060 (42S21) at line 68: Duplicate column name 'vh_soaserial_vc'
[root@192 /]# mysql -f -u root -pLmmFO7D6gR9PJmtA < /etc/sentora/configs/sentora-update/zpanel/sql/update-data.sql
ERROR 1062 (23000) at line 17: Duplicate entry '48' for key 'PRIMARY'
ERROR 1062 (23000) at line 19: Duplicate entry '94' for key 'PRIMARY'
ERROR 1062 (23000) at line 20: Duplicate entry '93' for key 'PRIMARY'
ERROR 1062 (23000) at line 21: Duplicate entry '92' for key 'PRIMARY'
ERROR 1091 (42000) at line 166: Can't DROP 'pk_enablecgi_in'; check that column/key exists
[root@192 /]# mysqldump -u root -pLmmFO7D6gR9PJmtA zpanel_core | mysql -u root -pLmmFO7D6gR9PJmtA  -D sentora_core

Now i can see the tables in phpmyadmin and the rest of the scripts contiunes better.
There is something wrong with the update sql files.
[Image: logo2.png]

My being on this forum is all personal and all is done here by me has nothing to with the company Web Improved I work for Smile
Reply
Thanks given by:


Messages In This Thread
RE: Upgrading ZPanel 10.1.* to Sentora - Alpha/Beta - by bbspike - 09-23-2015, 04:54 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
Sentora v2.0.2 SitRep TGates 2 924 03-16-2024, 11:58 AM
Last Post: TGates
Sentora for Developers TGates 0 874 02-12-2024, 12:10 PM
Last Post: TGates
EOL Sentora v1.x.x and ZPanel No Longer Supported TGates 0 563 01-24-2024, 12:03 PM
Last Post: TGates

Forum Jump:


Users browsing this thread: 1 Guest(s)