madrigo64 / bliss_admin_panel

Web Admin Panel on PHP for Reality Dayz Private Server
12 stars 12 forks source link

DB Hostname for Config #13

Open Zicore opened 11 years ago

Zicore commented 11 years ago

Add a db host to the config. The mysql server doesn't need to run on the same machine, as the gameserver.

qartex commented 11 years ago

yaa i need to :)

cproudlock commented 11 years ago

Added to adm_config.php: define('SERVSQL', 'IP HERE'); //mysql ip

Changed SERVERIP in config.php: SERVSQL

JiFMike commented 11 years ago

I see this issue is old, but still open, and I am having a DB connect issue. MySQL is on the same server but on a non standard port.

I tried adding the above to my config file, but it didn't matter. Any other info on this?

MajorPainage commented 11 years ago

Ours is installed in a different location then our game server and it works. Install the files on the same server that your database is installed.

I just wish I could get the rcon to work.

JiFMike commented 11 years ago

That's not possible. I simply need to specify the database port.

MajorPainage commented 11 years ago

It does work. I have been doing it for months.

define('SERVERIP', '127.0.0.1');//server ip define('SERVERPORT', 3306); //server port define('USERNAME', 'dayz_user'); //mysql user define('PASSWORD', 'dbpassword'); //mysql pass define('DBNAME', 'dayz_dbname'); // Mysql Data Base name. You can use several bdnames separated by comma

I don't know why, but server port is the mysql port or local host in my case. Server port is the mysql port.

I haven't changed any files.
Works just the way it is.

JiFMike commented 11 years ago

The default value for Serverport listed in the example config is "2302" which is the default port for the game. Since my server also runs on a non-standard port I put my game server port in there. Leaving no place for the mysql port. It was easy enough to fix in the code myself though. That may be why your rcon is not working... ;)

MajorPainage commented 11 years ago

Rcon doesn't work because if I put 2302 in the port as it is for my server, it says failed to connect to db. If I change it to 3306 as for the mysql port, it works fine.

Honestly, the coding needs a lot of cleaning up.