What databases/tables does Sentora use?

I accidentally deleted some databases Sentora uses to store its system data, which leads to the inaccessibility of Sentora panel. To recover   corrupted or deleted Sentora system databases/tables, you should first know what databases/tables it uses.

During installation, Sentora creates the following databases:

  • sentora_core
  • sentora_postfix
  • sentora_proftpd
  • sentora_roundcube

The sentora_core database includes the following tables:

  • x_accounts
  • x_aliases
  • x_bandwidth
  • x_cronjobs
  • x_distlists
  • x_distlistusers
  • x_dns
  • x_dns_create
  • x_faqs
  • x_forwarders
  • x_ftpaccounts
  • x_groups
  • x_htaccess
  • x_htpasswd_file
  • x_htpasswd_mapper
  • x_htpasswd_user
  • x_logs
  • x_mailboxes
  • x_modcats
  • x_modules
  • x_mysql_databases
  • x_mysql_dbmap
  • x_mysql_users
  • x_packages
  • x_permissions
  • x_profiles
  • x_quotas
  • x_settings
  • x_translations
  • x_vhosts

Interestingly, some of the sentora_core tables use MyIsam storage engine, others use innodb as their storage engine. This makes recovery of problematic sentora databases even harder. The tables of sentora_core that use innodb storage engine are:

  • x_accounts
  • x_aliases
  • x_distlists
  • x_distlistusers
  • x_dns
  • x_dns_create
  • x_faqs
  • x_forwarders
  • x_logs
  • x_mailboxes
  • x_modcats
  • x_modules
  • x_profiles
  • x_settings
  • x_translations

In the directory:/var/lib/mysql/sentora_core, you will see these tables do not have a tablename.MYD and tablename.MYI file as other MyISAM tables have. (The schema file tablename.frm does exists. )So if you accidentally delete the file ibdata1 in /var/lib/mysql/, you will lose those tables. Although you can see those innodb tables using “show tables”, they are actually inaccessible. If you use mysqlchk or myisamchk to repair those tables, you will get the error:”Operation failed  Table xx x doesn’t exist”. You can not select from those tables, either.

sentora_postfix includes the following tables;

  • admin
  • alias
  • alias_domain
  • config
  • domain
  • mailbox
  • quota2
  • vacation

sentora_proftpd includes the following tables:

  • ftpgroup
  • ftpquotalimits
  • ftpquotatallies
  • ftpuser

sentora_roundcube includes the following tables:

  • cache
  • cache_index
  • cache_messages
  • cache_thread
  • contactgroupmembers
  • contactgroups
  • contacts
  • dictionary
  • identities
  • searches
  • session
  • system
  • users

 

Posted in tips of hosting