Error is not allowed to connect to this MariaDB server

[deanm1990]

trafficstars

Hi Guys

Read the other issues on this, but the responses are vague.

If i remember rightly,

When you create a new user for a remote connection from a web server, the host option needs to be the ip that the database is hosted on ? is that correct ?

I also remember though either the user - or host option had the % symbol in it for somewhere.

Can someone explain step by step on what exactly needs to be in the username and host option when creating a new user - The privelages are all set.

[MightySCollins]

How is your MySQL server currently setup? Though something like XAMPP, cPanel or on a Linux server. You are right about the % sign. If you add that the user can connect to the database from any IP although I would recommend using your web server's ip.

Depending on your setup you also might need to bind it to 0.0.0.0. If you can give me as much detail as possible I might be able to do you a guide.

[deanm1990]

Xampp

http://imgur.com/a/zNo5h

So is it just one % symbol in the user slot or do i need %any% or something like that

[Jason2605]

If you wish the user to have access from anywhere its just the % on its own, other wise you can specify an ip, or an ip range

[deanm1990]

OK , i put just the % in the host section, still get this though Connect failed: Access denied for user 'AdminPanel'@'ns1.uk3.siteground.eu' (using password: YES)

[Jason2605]

And can you connect to the DB externally, say from your computer not where the database is hosted itself, that can be a good identifier to make sure of the permissions.

[MightySCollins]

Yep because it seems you have already externally bound it if it can access it

[deanm1990]

ok working :) , but no information on players or vehicles

[Jason2605]

By no information do you mean the tables aren't populated? Also what version of AL are you running?

[deanm1990]

its arma 3 life - i've used this panel with it before with no issues.

But yes the players are not populated. but the main dashboard shows total number of vehicles and players

[Jason2605]

Okay, well I'm guessing that was based off of the Altis Life framework still, so instead. In your database in the players table, is it playerid or pid?

[deanm1990]

But yes the players are not populated. but the main dashboard shows total number of vehicles and players

[deanm1990]

http://imgur.com/a/wPU7u

[MightySCollins]

Can you uncomment line 3 from index.php and show us any errors.

[Jason2605]

Its due to the settings being set to pid, give me 15 mins, and ill push something. That should be able to fix it

[MightySCollins]

Ahh yep I forgot I set that to default. A nice settings option in firstTime.php might help.

[Jason2605]

Yup, and in the options tab.

[deanm1990]

ok :) like it, can you let me know when to download new update

[deanm1990]

Im very impressed with the reply responses- will certainly make a donation

[MightySCollins]

Thanks :smile: https://paypal.me/CyberbyteStudios ill make sure @Jason2605 gets some too

[Jason2605]

Ill try and get this done quite soon, sorry something came up.

[Jason2605]

Give me, 20/30 mins

[Jason2605]

@deanm1990 Ive pushed the changes, it should now allow the selection between pid(AL 5.0) and playerid (all other vers). Please let me know if you experience any problems with the recent change, and ill try my best to amend them.

[deanm1990]

Hey, been ill so just had chance to see the new update. All works now, can see all data etc. The only thing is, when i make changes on the panel, it doesn't update on the DB, except for licenses, that works ok.