How to install website at a different dedicated than your main-server.

[kito2]

I have tried Modern AAC, Znote AAC, Nicaw AAC, Gesior AAC and no one works... Anyone knows how to install their website in a different dedicated than your server?

 

[sn3ejk]

Could you post here error?

 

[TGYoshi]

Just do it.
Make sure the database + server is on the main dediated while the website is in a secundary. Make sure you set the mysql port/url etc. to the primary server and open the mysql port. (default 3306) Recommended is to block any other ip's at the main server on the mysql port since you do not want other people to be able to attempt to log in.

 

[kito2]

Could you psot here error?

Yes: couldn't connect to database.

Just do it.
Make sure the database + server is on the main dediated while the website is in a secundary. Make sure you set the mysql port/url etc. to the primary server and open the mysql port. (default 3306) Recommended is to block any other ip's at the main server on the mysql port since you do not want other people to be able to attempt to log in.

Already done and doesn't work... Try it and you will see that those websites doesn't support this feature.

 

[TGYoshi]

Well, I'm not going to try that for you. You eventually have to change some tiny things in the source code of the website.
Since I have the Geisor source lying around, I found this:

$server_config = parse_ini_file($config_ini['server_path'].'config.lua');
$mysqlhost = $server_config['mysqlHost'];

So, have you set the mysqlHost value correctly (and related things) in the dummy config.lua you have on your webserver?

 

[kito2]

Yes I did, I changed all where it said to connect to localhost to the main server IP, also the config.lua since it is needed for all websites.

 

[TGYoshi]

Well, I can't just guess the problem like this, are you sure 3306 is bound to mysql and the port is open (check at http://www.yougetsignal.com/tools/open-ports/ )?
Also try to var_dump($config['server']) at the end of Geisor's index.php, check the output and eventually post it here (censor passwords etc.).

 

[djtuca]

kito, gesior and modern support this feature
you have to give access to another user in your database with GRANT

sry for my bad english

 

[kito2]

djtuca, already did that, specified the server ip, the user and the password and granted the permissions needed.

 

[Ancore]

Hmm yo creo que tendrás que buscar por otros foros porque es algo complicado...

 

[Znote]

In phpmyadmin (mysql user management):
You need to create a user that allows that specific IP to connect to the database.
So you need to make a new user there, and instead of localhost as host you write the IP of the website.

3306 must be ported.
You also need to edit the mysql config files to allow external hosts to connect to it.

Then I think you should be all set. D:

 

[kito2]

Znote I did all what you said, less the part of the port 3306... Maybe there is the problem.

- - - Updated - - -

Bump this thread?

 

[kito2]

Bump?

 

[kito2]

Bump?