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
#27
RE: Upgrading ZPanel 10.1.* to Sentora - Alpha/Beta
(09-24-2015, 08:32 PM)kandrews Wrote: 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.
[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-25-2015, 03:35 AM

Possibly Related Threads...
Thread Author Replies Views Last Post
v2.0.0 Closed Beta testing now ready! TGates 7 4 321 06-11-2021, 06:33 PM
Last Post: simplezed
Sit-rep for Sentora v2.0 TGates 15 7 102 06-09-2021, 03:34 AM
Last Post: iraqiboy90
Sentora 1.0.0 patch Me.B 12 41 416 03-03-2020, 09:21 PM
Last Post: ramanasrimathematics

Forum Jump:


Users browsing this thread: 1 Guest(s)