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.

Sentora Panel Database Missing 5 Tables
#1
Sentora Panel Database Missing 5 Tables
I have following problem with one of my vps which is very strange.
"Sentora Panel Database Missing 5 Tables"
I try to login to my sentora login panel but it's shown only blank ( it's doesn't display the field for entering user & password, like my another sentora login )
After comparing with one of another my working sentora login with the problem ones, I found there are Sentora Panel Database Missing 5 Tables. As show below :
sentora working Wrote:    
sentora doesn\t working Wrote:    

As shown above tables that is gone / missing is :
x_accounts
x_aliases
x_bandwidth
x_cronjobs
x_distlists

I have try to copy the table from working sentora panel the 5 missing one, but it's show me an error look's like the table still exist.
here is the code I have to execute :
Quote:DROP TABLE IF EXISTS `x_accounts`;

CREATE TABLE `x_accounts` (
 `ac_id_pk` int(6) unsigned NOT NULL AUTO_INCREMENT,
 `ac_user_vc` varchar(50) DEFAULT NULL,
 `ac_pass_vc` varchar(200) DEFAULT NULL,
 `ac_email_vc` varchar(250) DEFAULT NULL,
 `ac_reseller_fk` int(6) DEFAULT NULL,
 `ac_package_fk` int(6) DEFAULT NULL,
 `ac_group_fk` int(6) DEFAULT NULL,
 `ac_usertheme_vc` varchar(45) DEFAULT NULL,
 `ac_usercss_vc` varchar(45) DEFAULT NULL,
 `ac_enabled_in` int(1) DEFAULT '1',
 `ac_lastlogon_ts` int(30) DEFAULT NULL,
 `ac_notice_tx` text,
 `ac_resethash_tx` text,
 `ac_passsalt_vc` varchar(22) DEFAULT NULL,
 `ac_catorder_vc` varchar(255) DEFAULT NULL,
 `ac_created_ts` int(30) DEFAULT NULL,
 `ac_deleted_ts` int(30) DEFAULT NULL,
 PRIMARY KEY (`ac_id_pk`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

insert into `x_accounts` (`ac_id_pk`, `ac_user_vc`, `ac_pass_vc`, `ac_email_vc`, `ac_reseller_fk`, `ac_package_fk`, `ac_group_fk`, `ac_usertheme_vc`, `ac_usercss_vc`, `ac_enabled_in`, `ac_lastlogon_ts`, `ac_notice_tx`, `ac_resethash_tx`, `ac_passsalt_vc`, `ac_catorder_vc`, `ac_created_ts`, `ac_deleted_ts`) VALUES
(1, 'zadmin', 'xxxxxxxxxxxxxxxx', 'zadmin@localhost', 1, 1, 1, 'Sentora_Default', 'default', 1, xxxxxxxxxxx, 'Welcome to your new Sentora installation! You can remove this message from the Client Notice Manager module. This module allows you to notify your clients of service outages, upgrades and new features etc :-)', NULL, 'xxxxxxxxxxxxxxxxxxxxxxxx', NULL, 0, NULL),
(2, 'client1', 'xxxxxxxxxxxxxx', 'admin@client.com', 1, 3, 3, 'Sentora_Default', 'default', 1, 1455877011, NULL, NULL, 'xxxxxxxxxxx', NULL, xxxxxxxxx, NULL);
My last idea is to deploy or re install the VPS with the new ones. If someone have same problem with me please help.

Ps: I didn't remember when the last time the panel was working or what kind of task I have done before.
Reply
Thanks given by:
#2
RE: Sentora Panel Database Missing 5 Tables
Have you tried restating mysql?
Reply
Thanks given by:
#3
RE: Sentora Panel Database Missing 5 Tables
How did you end up there with 5 tables missing already. The damage may be more widespread.

M B
No support using PM (Auto adding to IGNORE list!), use the forum. 
How to ask
Freelance AWS Certified Architect & SysOps// DevOps

10$ free to start your VPS
Reply
Thanks given by:


Possibly Related Threads…
Thread Author Replies Views Last Post
Is Sentora dead? rajeevrrs 2 2 ,992 12-17-2022, 09:20 AM
Last Post: TGates
Sentora debug and error files johnnyp 0 1 ,158 10-27-2022, 06:16 PM
Last Post: johnnyp
Transfer Account to another Sentora BenI 1 2 ,568 07-21-2022, 07:19 PM
Last Post: Nigel

Forum Jump:


Users browsing this thread: 1 Guest(s)