Sentora with external database, same local network

[Khalimerot]

Hi, 

I plan to update my Zpanel (CentOS 6) server to a Sentora (CentOS 7) server.

Right now my zpanel use a database on an other server from the local network.

This other server is exclusively use for SQL.

I don't remember how i setup this in Zpanel, but i would like to do the same with Sentora, and i don't see this option in the Sentora install.

Is possible to use a database on an other server with Sentora? And if yes, how can i do?

Thank You.

Khalimerot.

[shaylami]

hi if you able to do it can you post the steps later thanks

[Ron-e]

Sentora is as fork from Zpanel and is almost the same.
If you found how you did it on Zpanel on the old Zpanel forums you can translate them to Sentora?

[Khalimerot]

I found how i did with Zpanel.

I edited the /etc/zpanel/panel/cnf/db.php file.

Code:

<?php
/*
* Database configuration file.
* @package zpanelx
* @subpackage core -> config
* @author Bobby Allen (ballen@bobbyallen.me)
* @copyright ZPanel Project (http://www.zpanelcp.com/)
* @link http://www.zpanelcp.com/
* @license GPL (http://www.gnu.org/licenses/gpl.html)
*/
$host = 'mysql.local';
$dbname = 'zpanel_core';
$user = 'zpanel';
$pass = 'xxxx';

i'll search after this file with sentora.

[Khalimerot]

So i manage to make it work.

Here is my method.

Installing Sentora
Log In
Dump SQL from phpmyadmin
Write SQL to the external database
edit: Create a sentora User and password in your external DB, with full access.
Edit /etc/sentora/panel/cnf/db.php
$host = '(where is your external database)';
edit: $user = '(the user you created)';
edit: $pass = '(the password you put for the user)';

And it works.

edit: forgot some steps

[kini]

@Khalimerot,
Do you know how to move and store all client databases on another server from local network?

[Khalimerot]

@Khalimerot,
Do you know how to move and store all client databases on another server from local network?

MMMmmmm if there is an automatic way to do it nope i don"t know.

I dump my databases to an SQL file from Phpmyadmin, navicat, or command line  and importe the SQL to the other SQL server.

at the moment all my clients databases are already on the external server (manage by Zpanel), so i juste have to recreate clients informations in Sentora, to make it manage those DB. 

or trying an export from zpanel to sentora DB.

[TGates]

You also need to update the roundcube config, phpmyadmin config, postfix config and proftp configs to use this new database also! There may be more, but those are the ones off the top of my head. ZPanel used a single user (root) for all services which is no longer the case in Sentora (More security).

Me.B might have some more information on this also.

[Khalimerot]

I'll also update these config files, thank you.

[Khalimerot]

So,

For Roundcube you have to edit:

/etc/sentora/configs/roundcube/roundcube_config.inc.php

For Proftpd:

/etc/sentora/configs/proftpd/proftpd-mysql.conf

For Postfix:

/etc/sentora/configs/postfix/mysql-relay_domains_maps.cf
/etc/sentora/configs/postfix/mysql-virtual_alias_maps.cf
/etc/sentora/configs/postfix/mysql-virtual_domains_maps.cf
/etc/sentora/configs/postfix/mysql-virtual_mailbox_limit_maps.cf
/etc/sentora/configs/postfix/mysql-virtual_mailbox_maps.cf

I will update, when i'll continue to setup this.