Sentora with external database, same local network

Sentora with external database, same local network - Printable Version

+- Sentora Support Forums (https://senforums.mach-hosting.com)
+-- Forum: Sentora Forum Archives (https://senforums.mach-hosting.com/forumdisplay.php?fid=5)
+--- Forum: Sentora Public Support Forums v1.0.x (https://senforums.mach-hosting.com/forumdisplay.php?fid=32)
+---- Forum: General Support Forum v1.0.x (https://senforums.mach-hosting.com/forumdisplay.php?fid=36)
+---- Thread: Sentora with external database, same local network (/showthread.php?tid=3112)

Sentora with external database, same local network - Khalimerot - 09-28-2016

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.

RE: Sentora with external database, same local network - shaylami - 09-29-2016

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

RE: Sentora with external database, same local network - Ron-e - 09-30-2016

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?

RE: Sentora with external database, same local network - Khalimerot - 09-30-2016

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.

RE: Sentora with external database, same local network - Khalimerot - 09-30-2016

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

RE: Sentora with external database, same local network - kini - 09-30-2016

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

RE: Sentora with external database, same local network - Khalimerot - 09-30-2016

(09-30-2016, 09:49 PM)kini Wrote: @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.

RE: Sentora with external database, same local network - TGates - 10-01-2016

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.

RE: Sentora with external database, same local network - Khalimerot - 10-04-2016

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

RE: Sentora with external database, same local network - Khalimerot - 10-05-2016

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.