Website config.ini problem connecting to the server!! please help

[iblue 0]

hi everyone

finally i finished everything on my server but a problem in website has accord

really tried to sole it but i don't know how and didn't find so much help!!!

 

i finally uploaded the script  and i put my information in the config.ini but i dont think i did it right because  when i right my domain name and get into the website the page  says not connected to database  "Verbindung zur Datenbank fehlgeschlagen: Abbruch"

^^ "i didn't translated until im sure its work fine "

 

this is the config.ini and  if someone could tell me what i have  to change and what data i have to change and to what!!!

 

   ===========================================================================================
      DEFINE('SQL_HOST', '*************');       < what to right here?
      DEFINE('SQL_USER', 'root');
      DEFINE('SQL_PASS', '**************');                < what to right here?
      
      DEFINE('SQL_HP_HOST', '**************');       < what to right here?
      DEFINE('SQL_HP_USER', 'root');
      DEFINE('SQL_HP_PASS', '**************');       < what to right here?
      DEFINE('SQL_HP_DB', 'hp');       < what to right here?
      
      $serverSettings['url']="**************";                 < what to right here?           // URL zur Seite (ohne letzten "/")
      $serverSettings['server_ip']="**************";            < what to right here?                    // Server-IP
      $serverSettings['register_on']=true;                                                      // Registration aktiviert (ja = true / nein = false)
      $serverSettings['mail_activation']=false;                                              // Mailaktivierung (ja = true / nein = false)
      $serverSettings['page_entries']=30;                                                        // Eintr�ge pro Seite
      $serverSettings['reg_mail']='[email protected]';          < what to right here?                // E-Mail-Absender bei Registration
      $serverSettings['pass_mail']='[email protected]';           < what to right here?             // E-Mail-Absender bei  
      $serverSettings['titel'] = 'Curse';
 

=============================================================================================

"< what to tight here" thats what i want to know"  and is there anything i have to change so it work?

 

 

 

thank you everybody for who helped me or tired to help me or just  took  a look on my topic thank you all~

 

 

*i have vps server for my game

* a hosting server for my website

 

"they are not i the same server hosting!!!

Edited September 7, 2015 by iblue

[AlCapone 67]

  DEFINE('SQL_HOST', 'ip of server');       < what to right here?
      DEFINE('SQL_USER', 'root');
      DEFINE('SQL_PASS', 'pass of your server');                < what to right here?
      
      DEFINE('SQL_HP_HOST', 'ip of server');       < what to right here?
      DEFINE('SQL_HP_USER', 'root');
      DEFINE('SQL_HP_PASS', 'pass of your server');       < what to right here?
      DEFINE('SQL_HP_DB', 'account');       < 
      
      $serverSettings['url']="your site url";                 < what to right here?           // URL zur Seite (ohne letzten "/")
      $serverSettings['server_ip']="ip of server";            < what to right here?                    // Server-IP
      $serverSettings['register_on']=true;                                                      // Registration aktiviert (ja = true / nein = false)
      $serverSettings['mail_activation']=false;                                              // Mailaktivierung (ja = true / nein = false)
      $serverSettings['page_entries']=30;                                                        // Eintr�ge pro Seite
      $serverSettings['reg_mail']='[email protected]';          < what to right here?                // E-Mail-Absender bei Registration
      $serverSettings['pass_mail']='[email protected]';           < what to right here?             // E-Mail-Absender bei  
      $serverSettings['titel'] = 'Curse';
 

[iblue 0]

  DEFINE('SQL_HOST', 'ip of server');       < what to right here?
      DEFINE('SQL_USER', 'root');
      DEFINE('SQL_PASS', 'pass of your server');                < what to right here?
      
      DEFINE('SQL_HP_HOST', 'ip of server');       < what to right here?
      DEFINE('SQL_HP_USER', 'root');
      DEFINE('SQL_HP_PASS', 'pass of your server');       < what to right here?
      DEFINE('SQL_HP_DB', 'account');       < 
      
      $serverSettings['url']="your site url";                 < what to right here?           // URL zur Seite (ohne letzten "/")
      $serverSettings['server_ip']="ip of server";            < what to right here?                    // Server-IP
      $serverSettings['register_on']=true;                                                      // Registration aktiviert (ja = true / nein = false)
      $serverSettings['mail_activation']=false;                                              // Mailaktivierung (ja = true / nein = false)
      $serverSettings['page_entries']=30;                                                        // Eintr�ge pro Seite
      $serverSettings['reg_mail']='[email protected]';          < what to right here?                // E-Mail-Absender bei Registration
      $serverSettings['pass_mail']='[email protected]';           < what to right here?             // E-Mail-Absender bei  
      $serverSettings['titel'] = 'Curse';
 

thank you that means not the SQL pass !!! i will try just right now i was wondering which password i have to put  SQL or SERVER

still having the same problem!!

[AlCapone 67]

For first sql password of dedicated server and for second sql the navicat pass

[iblue 0]

still same problem

[Ayaka 296]

if you dont even know how to configurate your config to connect to mysql you shouldn't set up a website by yourself...

[Aurora 46]

     DEFINE('SQL_HOST', 'IP OF GAME SERVER');       < what to right here?
      DEFINE('SQL_USER', 'NAME OF MYSQL USER');
      DEFINE('SQL_PASS', 'PASS OF MYSQL USER');                < what to right here?
      
      DEFINE('SQL_HP_HOST', 'IP OF WEBHOST');       < what to right here?
      DEFINE('SQL_HP_USER', 'NAME OF WEBHOST MYSQL');
      DEFINE('SQL_HP_PASS', 'PASS OF WEBHOST MYSQL');       < what to right here?
      DEFINE('SQL_HP_DB', 'DATABASE NAME');       < 

 

I hope i helped you out

[iblue 0]

     DEFINE('SQL_HOST', 'IP OF GAME SERVER');       < what to right here?
      DEFINE('SQL_USER', 'NAME OF MYSQL USER');
      DEFINE('SQL_PASS', 'PASS OF MYSQL USER');                < what to right here?
      
      DEFINE('SQL_HP_HOST', 'IP OF WEBHOST');       < what to right here?
      DEFINE('SQL_HP_USER', 'NAME OF WEBHOST MYSQL');
      DEFINE('SQL_HP_PASS', 'PASS OF WEBHOST MYSQL');       < what to right here?
      DEFINE('SQL_HP_DB', 'DATABASE NAME');       < 

 

I hope i helped you out

thank you i hope it works but for my little knowledge of websites

could you tell me what WEBHOST ip means if im not wrong it means my website ip right? or the DNS servername?

the other things i know i just made a new database

"it did not"!!!

Edited September 9, 2015 by iblue

[iblue 0]

     DEFINE('SQL_HOST', 'IP OF GAME SERVER');       < what to right here?
      DEFINE('SQL_USER', 'NAME OF MYSQL USER');
      DEFINE('SQL_PASS', 'PASS OF MYSQL USER');                < what to right here?
      
      DEFINE('SQL_HP_HOST', 'IP OF WEBHOST');       < what to right here?
      DEFINE('SQL_HP_USER', 'NAME OF WEBHOST MYSQL');
      DEFINE('SQL_HP_PASS', 'PASS OF WEBHOST MYSQL');       < what to right here?
      DEFINE('SQL_HP_DB', 'DATABASE NAME');       < 

 

I hope i helped you out

thank you i hope it works but for my little knowledge of websites

could you tell me what WEBHOST ip means if im not wrong it means my website ip right? or the DNS servername?

the other things i know i just made a new database

"it did not"!!!

well i  know the problem now

 

its my website database doesnt contain anything

 

i have 0 database so i great one with MyAdminPhp but i dont know what i have to import to it

 

i have the script but witch file i have to upload it to the web database

[Dr3Ame3r 32]

Make a new database via cpanel , then go to phpmyadmin , select the new database then you have an option to the top right and it says like " import " press that button , select the file , process , done .

[iblue 0]

Make a new database via cpanel , then go to phpmyadmin , select the new database then you have an option to the top right and it says like " import " press that button , select the file , process , done .

yup thats what i mean but  what file i have to select? and how i can get it?

[Dr3Ame3r 32]

Wait a second , you want to connect your webserver TO your webserver's database?

If yes , then you got some problems . Because you have to write the databases by yourself from 0

[fenixplayscz 16]

     DEFINE('SQL_HOST', 'IP OF GAME SERVER');       < what to right here?
      DEFINE('SQL_USER', 'NAME OF REMOTE  MYSQL USER');
      DEFINE('SQL_PASS', 'PASS OF REMOTE MYSQL USER');                < what to right here?
      
      DEFINE('SQL_HP_HOST', 'IP OF GAME SERVER');       < what to right here?
      DEFINE('SQL_HP_USER', 'NAME OF REMOTE  MYSQL USER');
      DEFINE('SQL_HP_PASS', 'PASS OF REMOTE  MYSQL USER');       < what to right here?
      DEFINE('SQL_HP_DB', 'account');       < 

make like this, and its working fine for me

[Ayaka 296]

Is this really metin2dev?? I have the sense that im reading epvper threads. The level has decreased significantly.

Edited September 12, 2015 by Ayaka

[Aurora 46]

     DEFINE('SQL_HOST', 'IP OF GAME SERVER');       < what to right here?
      DEFINE('SQL_USER', 'NAME OF MYSQL USER');
      DEFINE('SQL_PASS', 'PASS OF MYSQL USER');                < what to right here?
      
      DEFINE('SQL_HP_HOST', 'IP OF WEBHOST');       < what to right here?
      DEFINE('SQL_HP_USER', 'NAME OF WEBHOST MYSQL');
      DEFINE('SQL_HP_PASS', 'PASS OF WEBHOST MYSQL');       < what to right here?
      DEFINE('SQL_HP_DB', 'DATABASE NAME');       < 

 

I hope i helped you out

thank you i hope it works but for my little knowledge of websites

could you tell me what WEBHOST ip means if im not wrong it means my website ip right? or the DNS servername?

the other things i know i just made a new database

"it did not"!!!

well i  know the problem now

 

its my website database doesnt contain anything

 

i have 0 database so i great one with MyAdminPhp but i dont know what i have to import to it

 

i have the script but witch file i have to upload it to the web database

There should be a install.php in your directory use that or you must have .SQL files otherwise your CMS is shit

[iblue 0]

     DEFINE('SQL_HOST', 'IP OF GAME SERVER');       < what to right here?
      DEFINE('SQL_USER', 'NAME OF REMOTE  MYSQL USER');
      DEFINE('SQL_PASS', 'PASS OF REMOTE MYSQL USER');                < what to right here?
      
      DEFINE('SQL_HP_HOST', 'IP OF GAME SERVER');       < what to right here?
      DEFINE('SQL_HP_USER', 'NAME OF REMOTE  MYSQL USER');
      DEFINE('SQL_HP_PASS', 'PASS OF REMOTE  MYSQL USER');       < what to right here?
      DEFINE('SQL_HP_DB', 'account');       < 

make like this, and its working fine for me

i tried not working!!!

     DEFINE('SQL_HOST', 'IP OF GAME SERVER');       < what to right here?
      DEFINE('SQL_USER', 'NAME OF MYSQL USER');
      DEFINE('SQL_PASS', 'PASS OF MYSQL USER');                < what to right here?
      
      DEFINE('SQL_HP_HOST', 'IP OF WEBHOST');       < what to right here?
      DEFINE('SQL_HP_USER', 'NAME OF WEBHOST MYSQL');
      DEFINE('SQL_HP_PASS', 'PASS OF WEBHOST MYSQL');       < what to right here?
      DEFINE('SQL_HP_DB', 'DATABASE NAME');       < 

 

I hope i helped you out

thank you i hope it works but for my little knowledge of websites

could you tell me what WEBHOST ip means if im not wrong it means my website ip right? or the DNS servername?

the other things i know i just made a new database

"it did not"!!!

well i  know the problem now

 

its my website database doesnt contain anything

 

i have 0 database so i great one with MyAdminPhp but i dont know what i have to import to it

 

i have the script but witch file i have to upload it to the web database

There should be a install.php in your directory use that or you must have .SQL files otherwise your CMS is shit

well like any one else i have a script and i uploaded and changed the config file but its seems does not connect to my database

 

any one tried "www.domain.com" hosting plans?  i see it bad after this problem!!!