search

Datcyx / NGG-V3--REFIX-

BSD 3-Clause "New" or "Revised" License
5 stars 1 forks source link

External SQL Database Connection #11

Open StreetSamper opened 9 months ago

StreetSamper commented 9 months ago

I can connect locally through XAMPP with no issues. However, when I attempt to connect to a hosted database it can't connect to MySQL even though I am certain the connection credentials are correct. I have tested the same information on another SAMP server and it connected with no error. It seems this script wont listen to outside IPs and is refusing to link the main pipeline. My suspicion is it is something to do with the new mysql.pwn and the way it handles sockets. I have edited the mysql.cfg appropriately. Is there another file that needs to be edited for outside IPs or is it a script issue? Any help on this matter would be much appreciated.

Datcyx commented 9 months ago

https://www.mediafire.com/file/ajje82db6kpaa55/NGG-V3--REFIX--main.rar/file hello the GitHub version I push has some kind of problem, kindly download the stable

Datcyx commented 9 months ago

I can connect locally through XAMPP with no issues. However, when I attempt to connect to a hosted database it can't connect to MySQL even though I am certain the connection credentials are correct. I have tested the same information on another SAMP server and it connected with no error. It seems this script wont listen to outside IPs and is refusing to link the main pipeline. My suspicion is it is something to do with the new mysql.pwn and the way it handles sockets. I have edited the mysql.cfg appropriately. Is there another file that needs to be edited for outside IPs or is it a script issue? Any help on this matter would be much appreciated.

change first host to ip of your vps or make sure the MySQL server is accepting remote host login or I recommend running the server into windows server, I recommend azure VM for that

StreetSamper commented 9 months ago

Still getting the (MainPipeline) Fatal Error! I have quadruple checked and made sure that I have provided the correct connection credentials.

StreetSamper commented 9 months ago

https://www.mediafire.com/file/ajje82db6kpaa55/NGG-V3--REFIX--main.rar/file hello the GitHub version I push has some kind of problem, kindly download the stable

I tested the MaxAndolini version as well and found it has the same issue. Since you adapted your fix from that version I am assuming it has been an issue since before you edited the files. Could you please attempt to test a remote host and see if you can get it working? I would just like to know if it is an issue on my end or not. Thank you. For a free and easy to set up remote database host, I suggest using Lemehost(https://lemehost.com/).

Datcyx commented 9 months ago

Try using servers from Microsoft azure 😀, I tried it too and it worked, make sure you choose windows vm

StreetSamper commented 9 months ago

Try using servers from Microsoft azure 😀, I tried it too and it worked, make sure you choose windows vm

Is there no other way to get it hosted remotely? I have a specific paid hosting I want to connect it to.

Datcyx commented 2 months ago

On host use the up instead of localhost

Datcyx commented 1 month ago

I found a fix, don't use the ini if you want to use it on linux

StreetSamper commented 1 week ago

It's been a while, just got back into it. I was hoping to get it remotely hosted on a Windows based hosting service, but if you say it will work with Linux I suppose I will have to take that route. It's just that I have never encountered an issue hosting a server like this. I want to know what is going on in the background that is refusing the pipeline connection. I would like to say once again, the server gives my no issues locally. Only if I try to host it externally it doesn't seem to like.