access denied when trying to loging to proxysql portal

[arun chakrapani rao]

Hi, I am rying to access the webproxy portal 

the following configurations has been set.

I tried accessing the portal with the default admin as the username and the pwd as admin too. I did create a new user calleed radmin and tried. both the users are not working.

admin_credentials="admin:admin"
#       mysql_ifaces="127.0.0.1:6032;/tmp/proxysql_admin.sock"
        mysql_ifaces="0.0.0.0:6032"
#       refresh_interval=2000
#       debug=true
        admin-web_enabled=true
        admin-web_port=6080
        admin-web_verbosity=4
        stats_credentials="stats:admin"

Can you please do let know what is the default username  which needs to be used to login to the portal

thanks in advance

Arun

[arun chakrapani rao]

i have set 

ProxySQLAdmin:SET admin-web_enabled='true';
Query OK, 1 row affected (0.002 sec)

ProxySQLAdmin:LOAD ADMIN VARIABLES TO RUNTIME;
Query OK, 0 rows affected (0.006 sec)

ProxySQLAdmin:UPDATE global_variables SET variable_value='admin:admin;radmin:radmin' WHERE variable_name='admin-admin_credentials';
Query OK, 1 row affected (0.009 sec)

ProxySQLAdmin:SET admin-web_enabled='true';
Query OK, 1 row affected (0.002 sec)

ProxySQLAdmin:LOAD ADMIN VARIABLES TO RUNTIME;
Query OK, 0 rows affected (0.005 sec)

it still says access denied

--
You received this message because you are subscribed to the Google Groups "proxysql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+u...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/proxysql/1c113d5e-f123-4376-ab63-b5095e10167fn%40googlegroups.com.

[arun chakrapani rao]

2025-06-03 07:33:27 [INFO] Received command SET admin-web_enabled='true'
2025-06-03 07:33:37 [INFO] Received LOAD ADMIN VARIABLES TO RUNTIME command
2025-06-03 07:33:37 [INFO] Computed checksum for 'LOAD ADMIN VARIABLES TO RUNTIME' was '0x141EFDF257BA9D3B', with epoch '1748916217'
Error: received handshake message out of context.
Error: received handshake message out of context.
Error: received handshake message out of context.
Error: received handshake message out of context.
Error: received handshake message out of context.
Error: received handshake message out of context.
Error: received handshake message out of context.
Error: received handshake message out of context.
Error: received handshake message out of context.
Error: received handshake message out of context.
2025-06-03 07:37:26 [INFO] Received command SET admin-web_enabled='true'
2025-06-03 07:37:30 [INFO] Received LOAD ADMIN VARIABLES TO RUNTIME command
2025-06-03 07:37:30 [INFO] Computed checksum for 'LOAD ADMIN VARIABLES TO RUNTIME' was '0x141EFDF257BA9D3B', with epoch '1748916450'
Error: received handshake message out of context.
Error: received handshake message out of context.
Error: received handshake message out of context.
Error: received handshake message out of context.
Error: received handshake message out of context.
Error: received handshake message out of context.
Error: received handshake message out of context.
Error: received handshake message out of context.
Error: received handshake message out of context.
Error: received handshake message out of context.


Should the user be inserted in the mysql_users too ?

Please do let me know

[arun chakrapani rao]

Hi, All,

Has anybody faced this issue if yes can you please do let me know how to solve this ?

I have reinstalled the software and also updated the proxysql admin allowing the web acess and also i also added radmin for the remote loging too. still the same issue

Your help is greatly appreciated

Arun

[Dave Rix]

Hi Arun,

I have managed to get the web interface to work, but it doesn't provide an administrator interface for ProxySQL, just some metrics and monitoring data.

I can't comment on your setup config as I've not looked properly to compare with mine, but I did notice from your screenshot that you are using the 'admin' user on the web interface. I do not think that will work, as the 'admin' user is restricted to only be allowed from the local host on the admin interface (port 6032).

I think from your config snippets above, you would need to use the username 'stats' with the password 'admin' to gain access to the web interface, based on the config of your `stats_credentials` variable.

The first para of this from the docs suggests this, but the second para describes the use of the 'admin' user to allow editing of the config. That might be a new thing in ProxySQL v3 though, as I can't recal that being an option when I configured the web interface.

ProxySQL embeds an HTTP web server from where it is possible to gather certain metrics. Credentials to access the web interfaces are the same as those defined in admin-stats_credentials. When Web UI plugin is enabled, the HTTP web server can be used to reconfigure ProxySQL itself, and the credentials configured in admin-admin_credentials can be used to access the web interface.

Oh, and don't add any of the ProxySQL users - admin, radmin, cluster or stats - to the mysql_users table, that causes mayhem :) 

Not sure if that helps, but it might!

Regards,

Dave