Cannot Connect Error

[daveyhellstormelite]

Getting error cannot connect tried a remote server and same server my XC panel is on

[tweakunwanted]

Did you run install.php?

[daveyhellstormelite]

yes tells me to make sure config file is correct in the config file do I change the port from 7999 or leave as is thanks

[FerrahWolfeh]

It depends on where are you running the office panel
If you're running on a server that's different from the main admin panel, you'll have to give permissions for the panel to access the remote database

[FerrahWolfeh]

If it is on a different server, you'll have to go into your root (or given user in config.php) user in the main server's mysql and type

grant all on xtream_iptvpro.* to root@(office server ip) identified by 'password'; .
Then you type

flush privileges;

and try

[FerrahWolfeh]

In the 'password' you put the db password (with quotes) that you wrote on Config.php

[daveyhellstormelite]

im running it on same server for testing first but cannot get it to work

[FerrahWolfeh]

So, let's start from the beginning...
What appears when you enter install.php

[FerrahWolfeh]

And, give me a screenshot of your config.php

[daveyhellstormelite]

i get the check config.php on `install

[daveyhellstormelite]

`<?php
/* SERVER SETTINGS / / CONFIGURAÇÕES DO SERVIDOR */
define("OFFICE_KEY", "YOUR_LICENCE_KEY");

/* RESELLERS PANEL DATABASE SETTINGS */ /* CONFIGURAÇÕES DO BANCO DE DADOS DO PAINEL REVENDEDOR */
   define("OFFICE_DB_HOST", "localhost");
   define("OFFICE_DB_PORT", "3306");
   define("OFFICE_DB_NAME", "openxc_resellers");
   define("OFFICE_DB_USER", "root");
   define("OFFICE_DB_PASS", "PASSWORD");

/* XTREAM PANEL DATABASE SETTINGS */ /* CONFIGURAÇÕES DO BANCO DE DADOS DO SERVIDOR XTREAM CODES */
define("DB_HOST", "127.0.0.1");
define("DB_PORT", "7999");
define("DB_NAME", "xtream_iptvpro");
define("DB_USER", "root");
define("DB_PASS", "PASSWORD");

/* REPLACE WITH YOUR DOMAIN OR IP BUT KEEP /i */ /* SUBSTITUA COM O SEU ENDEREÇO IP OU DOMINIO MATENHA O /i */
define("SHORTENER_URL", "http://MY-IP/i");

/* ALLOWED EMAILS FOR TESTS */ /* EMAILS PERMITIDOS PARA TESTES */
define ("ALLOWED_EMAILS", serialize (array ("[email protected]", "[email protected]")));

/* ENABLE DEBUG LOG */
define("OFFICE_DEBUG", 0);

?>
`

[daveyhellstormelite]

i have created DB and imported the 2 sql files

[FerrahWolfeh]

Hmm, well, assuming that you placed the configs correctly, and the office is installed on the same server as the OpenXC, try to change the panel db port to 7999 and put you user, etc. Then tell me what happens?

[daveyhellstormelite]

still get the same page in install.php I change port to 7999 and checked in mysql if it change which it did after mysql restart.

[FerrahWolfeh]

Ok, just to clear my consciousness, try to install php-mysqli, sometimes it's not installed with php alone

[daveyhellstormelite]

fixed it mate it was mysql problems wouldnt let me login with phpmyadmin part either