Page 1 of 1
Couldn't connect to MariaDB Database
Posted: 21 Apr 2018, 23:10
by Tortilleto[40RUS]
Couldn't connect to MariaDB Database 'lif_1' on 109.225.63.73 (3306). <<<<<==== Help to solve the problem, when adding a server to the site feudal.tools gives an error. How to fix it? And how to make a map online. It is possible in detail with instructions. Thank you.
Re: Couldn't connect to MariaDB Database
Posted: 22 Apr 2018, 02:39
by Nyuton
Hi,
your database is refusing connections from foreign hosts. You want to set it up to allow connections from either the feudal.tools server (88.198.53.198) or anywhere (%).
If you have access to your database through HeidiSQL, you can change this setting in the users & permissions control.
For example, if you are using the root user, you can edit the ::1 entry to "allow access from everywhere". See screenshot example.
*Moved this topic to FeudalTools support
Re: Couldn't connect to MariaDB Database
Posted: 01 Jun 2018, 13:26
by nsooooi
This didn't work for me, I still get the error message. I did set it for everyone, I've also tried allowing the direct ip aswell. Anything else I can try?
Re: Couldn't connect to MariaDB Database
Posted: 01 Jun 2018, 15:13
by Nyuton
Not without detailed information about your setup.
Can you connect using HeidiSQL or other SQL client using the exact same ip/port and credentials entered on FeudalTools?
Re: Couldn't connect to MariaDB Database
Posted: 01 Jun 2018, 16:24
by nsooooi
Sorry, I am not the best when it comes to describing things. I can access it using heidisql, if I change it to the wrong file name it does tell me that the file cannot be found so I believe I keep setting it up right as far as entering the details into the site. I did set the permissions already, set permissions specifically for the ip address given in faq. Do you need my computer setup? Or a different setup?
Re: Couldn't connect to MariaDB Database
Posted: 01 Jun 2018, 19:00
by Nyuton
I mean your server setup.
Server environment would be useful. Like, have you rented a gameserver from one of the popular gameserver hosters like PingPerfect/BlueFang/etc, or have you rented a windows root server, or are you trying to host the server at home...
I can check connectivity from the FeudalTools server if you want to provide the database IP address/port/username/db name that is being used. Send in private message if you want. That would at least give us a proper error description.
Re: Couldn't connect to MariaDB Database
Posted: 01 Jun 2018, 22:51
by nsooooi
Okay, sorry for the late reply just getting home from work, I'll shoot you over the info I use to connect. Thanks a ton for your fast replies. You seriously seem more on top of this forum than any other forum I've seen with like dedicated gms! Major thanks to all of your awesome work!
Re: Couldn't connect to MariaDB Database
Posted: 16 Aug 2018, 03:29
by Johno13
Hello. Yesterday I was able to connect the server with the same credentials and today I am not able to. Everything is correct and I have done everything at the top of this post with setting root to connect anywhere. I am out of ideas. Is there someone that I can email so I can share some of the info to get this resolved?
Re: Couldn't connect to MariaDB Database
Posted: 11 Jan 2019, 16:18
by Ervin_fon_Romel
привет не могу добавить сервер пишет,что 127.0.0.1 это частная база данных как это исправить?