search

eksoverzero / whmcs-freeradius

FreeRADIUS server module for WHMCS
111 stars 79 forks source link

FreeRadius Database Query Error #25

Open jjumpm2 opened 7 years ago

jjumpm2 commented 7 years ago

Hi,

Has anyone got the following error:

FreeRadius Database Query Error: Access denied for user 'xxxxxxx'@'localhost' to database 'radius'

xxxxxxx = the WHMCS MySQL username.

I have found a few mentions of the above error, but no solution..

Thanks

lukehebb commented 7 years ago

That means the database details are wrong. Which side are you seeing this on and is the script in the correct place?

jjumpm2 commented 7 years ago

WHMCS side - followed the instructions and all seems to be installed correctly. Should it be the WHMCS MySQL username? Should it not be picking up what I have entered into the server set up?

lukehebb commented 7 years ago

That looks like the script you are using is the one that runs on the freeradius server - this should be on a web server on the freeradius server or set to connect to the freeradius server remotely (and the user have the correct permissions granted)

jjumpm2 commented 7 years ago

Yes, WHMCS is set to connect to the remote server running freeradius. I have input the DB username/password that I used to set up freeradius, but it is showing the local username instead..

lukehebb commented 7 years ago

Let me take a look at the code, which file have you put the details in?

jjumpm2 commented 7 years ago

On the WHMCS side, the login details are entered within WHMCS, not into a file directly. On the server side, it is entered into config.php

lukehebb commented 7 years ago

Is the server IP set correctly in the module config within WHMCS? It seems to be connecting to localhost, I'm assuming that freeradius isn't running on the same server as WHMCS?

jjumpm2 commented 7 years ago

Yes, server IP is set correctly within WHMCS and yes, the server is external.

jjumpm2 commented 7 years ago

Ok, figured it out now - was a permissions issue on the DB. Thanks for your help.

kami-nashi commented 7 years ago

So I'm running into a similar issue here, I think it might just be some confusion about some of the settings.

The error:

Module Create Failed - Service ID: 3 - Error: FreeRadius Database Query Error: No database selected

My test env: WHMCS server @ 192.168.100.107 WHMCS DB @ 192.168.100.13 Freeradius server @ 10.68.100.71 Freeradius DB @ 10.68.100.80

Now, when I manually exec the cron.php file on the freeradius side, it picks up names that are in the RADCHECK table that aren't in WHMCS, so that tells me that its reading the DB correctly but I'm not sure where WHMCS knows about this.

On the WHMCS side, on the servers page, I have an entry pointing to the freeradius server ip, but I think thats inaccurate, since the module appears to be throwing SQL, which tells me that I should be using the freeradius db IP and credentials, yet I still get a fail for that as well.

Where are my wires crossed?

kami-nashi commented 7 years ago

Actually, I found it. I didn't realize that the 'server hash' was where the database name needed to be placed, which with the radius db host info following, I have a successful insertion when an order is accepted. Freak'n awesome.

shahmeer commented 7 years ago

@kami-nashi where did you find the HASH ENTRY. I am facing the same issue. where can i find the hash entry to put in to the server config from whmcs side to connect to the radius server to run the create account module. Please mention that.

eksoverzero commented 6 years ago

@shahmeer, it's under the server configuration settings