Sentora UI not fully loading.

[psyfer]

Hi,

I did pay the premium service for a month. However haven't received any info from you guys regarding that.. I tried sending mails to info[at]sentora as well with no response. I do have the receipt from paypal which states paid.

On this website there's no other place to log ticket or premium support area..?
That's why I posted in forum.

Please advise.

[TGates]

Hmmm, after looking at the screen shot again it looks more like the package or user levels are messed up. Maybe even the groups table.

Log into phpmyadmin and compare the tables with the ones from github: https://github.com/sentora/sentora-insta...a_core.sql


Also check these two rows in the x_accounts table:
`ac_package_fk`, `ac_group_fk`

[TGates]

psyfer also updated your account.

[psyfer]

Thanks.

Ok so I'm not very good with databases, but seems that in the structure of the table x_accounts the default values for all is NULL, only ac_enabled_in is marked = 1

Hmm, also see the first row shows allow Nulls=No. But default value there is NULL though.

Field name Type Allow nulls? Key Default value Extras
ac_id_pk int(6) unsigned No Primary NULL auto_increment
ac_user_vc varchar(50) Yes None NULL
ac_pass_vc varchar(200) Yes None NULL
ac_email_vc varchar(250) Yes None NULL
ac_reseller_fk int(6) Yes None NULL
ac_package_fk int(6) Yes None NULL
ac_group_fk int(6) Yes None NULL
ac_enabled_in int(1) Yes None 1

Can I just dump and recreate structure? or perhaps just edit first row?

[psyfer]

x_accounts data looks just fine. See my backup data below:

Code:

LOCK TABLES `x_accounts` WRITE;
/*!40000 ALTER TABLE `x_accounts` DISABLE KEYS */;
INSERT INTO `x_accounts` VALUES (1,'zadmin','JrfJd2o.JpIwT69PRJWrET92WMS62h.','zadmin@localhost',1,1,1,'Sentora_Default','default',1,1424698624,'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,'gd.sLc/rMej19iP143.Nwl',NULL,0,NULL),(2,'iroardxb','Tdib.wgty1JtRFwCJbNEX3l3z.vemYK','charlesodendaal43@gmail.com',1,3,2,'Sentora_Default','default',1,1425150666,'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,'dPZW12NT7D1leJhmG2Mj20',NULL,1424699028,NULL),(3,'test','Bok1njSwuNleea11sM7h01HNEP56qOe','pieter@jhost.co.za',2,4,3,'Sentora_Default','default',1,NULL,NULL,NULL,'GMynV5I6d8KjsCCg2Jc7ys',NULL,1424701287,1424702219);
/*!40000 ALTER TABLE `x_accounts` ENABLE KEYS */;
UNLOCK TABLES;

[TGates]

Ok, did you get to compare the x_groups and x_packages tables?

[psyfer]

yes they match and data correct.
The only one I found different was x_permissions which data contained only 4 rows where the github compare had to 25.

I did a server reboot but nothing changed, I was even still logged into sentora (on 3 browsers) as I'm unable to logout at all.
Isn't there a table for the login sessions? or perhaps a file I can clear?

[psyfer]

To whom should I PM my server access info? I really need this issue resolved.

Please can someone take a look?

[TGates]

Ok, and you restored the permissions table with the one form github?

You can pm the login url, pass, and mysql root and I will take a look.

[psyfer]

Hi TGates,

Ok PM has been sent with full access info.
Please do provide us the ip address you're connecting from if you are unable to login..
Thanks