Upgrading ZPanel 10.1.* to Sentora - Alpha/Beta

[kandrews]

Glad emails and clients / websites are working without issues let me know if anything isn't working ....

[Ilia]

Hi, All

As im using My zpanel on live and in virtual server i can do bakup and restore it on another VPS, if you guys need to test !

Gonna give it atry once i reinstall the Dedicated !

[bbspike]

Hi, All

As im using My zpanel on live and in virtual server i can do bakup and restore it on another VPS, if you guys need to test !

Gonna give it atry once i reinstall the Dedicated !

That would be great! Wait for kandrews to commit the SQL update fix then we can both give it a try again.

[bbspike]

I noticed that the protected directory's module is not part of the upgrade?

[kandrews]

Think i added that to the sql files.. can you double check me?

[kandrews]

If you need to fix after the conversion over to sentora_ prefixed databases run the following:

Code:

CREATE TABLE `sentora_core`.`x_htpasswd_file` (
  `x_htpasswd_file_id` int(11) NOT NULL AUTO_INCREMENT,
  `x_htpasswd_file_target` varchar(255) NOT NULL,
  `x_htpasswd_file_message` varchar(255) NOT NULL,
  `x_htpasswd_file_created` int(11) NOT NULL,
  `x_htpasswd_file_deleted` int(11) DEFAULT NULL,
  `x_htpasswd_sentora_user_id` int(11) NOT NULL,
  PRIMARY KEY (`x_htpasswd_file_id`),
  UNIQUE KEY `x_htpasswd_file_target` (`x_htpasswd_file_target`),
  KEY `x_htpasswd_file_x_htpasswd_sentora_user_id_idx` (`x_htpasswd_sentora_user_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE `sentora_core`.`x_htpasswd_mapper` (
  `x_htpasswd_mapper_id` int(11) NOT NULL AUTO_INCREMENT,
  `x_htpasswd_file_id` int(11) NOT NULL,
  `x_htpasswd_user_id` int(11) NOT NULL,
  PRIMARY KEY (`x_htpasswd_mapper_id`),
  KEY `x_htpasswd_mapper_x_htpasswd_file_id_idx` (`x_htpasswd_file_id`),
  KEY `x_htpasswd_mapper_x_htpasswd_user_id_idx` (`x_htpasswd_user_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE `sentora_core`.`x_htpasswd_user` (
  `x_htpasswd_user_id` int(11) NOT NULL AUTO_INCREMENT,
  `x_htpasswd_user_username` varchar(255) NOT NULL,
  `x_htpasswd_user_password` varchar(255) NOT NULL,
  `x_htpasswd_user_created` int(11) NOT NULL,
  `x_htpasswd_user_deleted` int(11) DEFAULT NULL,
  `x_htpasswd_sentora_user_id` int(11) NOT NULL,
  PRIMARY KEY (`x_htpasswd_user_id`),
  UNIQUE KEY `x_htpasswd_user_username` (`x_htpasswd_user_username`),
  UNIQUE KEY `x_htpasswd_user_password` (`x_htpasswd_user_password`)
) DEFAULT CHARSET=utf8;

[bbspike]

If you need to fix after the conversion over to sentora_ prefixed databases run the following:

Code:

CREATE TABLE `sentora_core`.`x_htpasswd_file` (
 `x_htpasswd_file_id` int(11) NOT NULL AUTO_INCREMENT,
 `x_htpasswd_file_target` varchar(255) NOT NULL,
 `x_htpasswd_file_message` varchar(255) NOT NULL,
 `x_htpasswd_file_created` int(11) NOT NULL,
 `x_htpasswd_file_deleted` int(11) DEFAULT NULL,
 `x_htpasswd_sentora_user_id` int(11) NOT NULL,
 PRIMARY KEY (`x_htpasswd_file_id`),
 UNIQUE KEY `x_htpasswd_file_target` (`x_htpasswd_file_target`),
 KEY `x_htpasswd_file_x_htpasswd_sentora_user_id_idx` (`x_htpasswd_sentora_user_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE `sentora_core`.`x_htpasswd_mapper` (
 `x_htpasswd_mapper_id` int(11) NOT NULL AUTO_INCREMENT,
 `x_htpasswd_file_id` int(11) NOT NULL,
 `x_htpasswd_user_id` int(11) NOT NULL,
 PRIMARY KEY (`x_htpasswd_mapper_id`),
 KEY `x_htpasswd_mapper_x_htpasswd_file_id_idx` (`x_htpasswd_file_id`),
 KEY `x_htpasswd_mapper_x_htpasswd_user_id_idx` (`x_htpasswd_user_id`)
) DEFAULT CHARSET=utf8;

CREATE TABLE `sentora_core`.`x_htpasswd_user` (
 `x_htpasswd_user_id` int(11) NOT NULL AUTO_INCREMENT,
 `x_htpasswd_user_username` varchar(255) NOT NULL,
 `x_htpasswd_user_password` varchar(255) NOT NULL,
 `x_htpasswd_user_created` int(11) NOT NULL,
 `x_htpasswd_user_deleted` int(11) DEFAULT NULL,
 `x_htpasswd_sentora_user_id` int(11) NOT NULL,
 PRIMARY KEY (`x_htpasswd_user_id`),
 UNIQUE KEY `x_htpasswd_user_username` (`x_htpasswd_user_username`),
 UNIQUE KEY `x_htpasswd_user_password` (`x_htpasswd_user_password`)
) DEFAULT CHARSET=utf8;

This code is in the update-structure.sql file. Strange it did not appeared.

Gone give it another go.

[Ilia]

Everything went Good after upgrade !
4 problem found :
1st one change theme name in database after upgrading from /etc/sentora/panel/etc/styles/zpanelx
to
/etc/sentora/panel/etc/styles/Sentora_Default
2nd one : the vhosts probleme :

PHP Code:

<Directory "/etc/zpanel/panel/">
DocumentRoot "/etc/zpanel/panel/"

NameVirtualHost *:
NameVirtualHost *:80
Listen 
Listen 80

# Configuration for Sentora control panel.
<VirtualHost *:>
ServerAdmin webmaster@......
DocumentRoot ""
ServerName 
ErrorLog "/var/zpanel/logs/sentora-error.log" 
CustomLog "/var/zpanel/logs/sentora-access.log" combined
CustomLog "/var/zpanel/logs/sentora-bandwidth.log" common
AddType application/x-httpd-php .php
<Directory "">
Options +FollowSymLinks -Indexes
    AllowOverride All
    Order allow,deny
    Allow from all
</Directory>

# Custom settings are loaded below this line (if any exist)

</VirtualHost>

....and my other domaine ..... 


tried twice and the same errors .

3rd problem, the version shown in sentora is the same version of Zpanel means 10.1.1 Knowing that we are on 1.0.3.

4rth problem : when i launch run daemon the link doesn't exist, when i searched on /panel/modules/ i found a subforlder called modules ,/panel/modules/modules/ wich contain all zpanel modules .

and there is no rundaemon.php under modules/sentoraconfig/code/rundaemon.php
but exists under : modules/modules/zpanelconfig/code/rundaemon.php

That's all

[kandrews]

Theme name should have been changed - must be related to failing SQL statements, will be fixed shortly.

Code:

NameVirtualHost *:
NameVirtualHost *:80
Listen
Listen 80

That doesn't look right... i'll try and replicate... This file should have been overwritten and regenerated...

In sentora i'm not sure if you can run the daemon from the web front anymore.. have a look round the forums about this.

Thanks for reporting the issues i'll get them fixed

[bbspike]

Everything went Good after upgrade !
4 problem found :
1st one change theme name in database after upgrading from /etc/sentora/panel/etc/styles/zpanelx
to
/etc/sentora/panel/etc/styles/Sentora_Default
2nd one : the vhosts probleme :

PHP Code:

<Directory "/etc/zpanel/panel/">
DocumentRoot "/etc/zpanel/panel/"

NameVirtualHost *:
NameVirtualHost *:80
Listen 
Listen 80

# Configuration for Sentora control panel.
<VirtualHost *:>
ServerAdmin webmaster@......
DocumentRoot ""
ServerName 
ErrorLog "/var/zpanel/logs/sentora-error.log" 
CustomLog "/var/zpanel/logs/sentora-access.log" combined
CustomLog "/var/zpanel/logs/sentora-bandwidth.log" common
AddType application/x-httpd-php .php
<Directory "">
Options +FollowSymLinks -Indexes
    AllowOverride All
    Order allow,deny
    Allow from all
</Directory>

# Custom settings are loaded below this line (if any exist)

</VirtualHost>

....and my other domaine ..... 


tried twice and the same errors .

3rd problem, the version shown in sentora is the same version of Zpanel means 10.1.1 Knowing that we are on 1.0.3.

4rth problem : when i launch run daemon the link doesn't exist, when i searched on /panel/modules/ i found a subforlder called modules ,/panel/modules/modules/ wich contain all zpanel modules .

and there is no rundaemon.php under modules/sentoraconfig/code/rundaemon.php
but exists under : modules/modules/zpanelconfig/code/rundaemon.php

That's all

Strange... did not run in to these problem with my updates.