Can't connect to local admin interface

[Julian Dehn]

I've just installed ProxySQL on CentOS 7 and wanted to connect to the local admin interface, but getting an error:

[root@machine ~]# mysql -uadmin -padmin -P6032 -h127.0.0.1
ERROR 1040 (42000): User 'admin' can only connect locally

Did I miss some configuration or could that be a bug?

[René Cannaò]

I think CentOS (or RH) have the weird idea of assigning 127.0.0.2 .

Try this:

ifconfig lo 127.0.0.1

mysql -uadmin -padmin -P6032 -h127.0.0.1

If my hypothesis is correct, I wouldn't call it a bug in ProxySQL, but is surely something that we can improve to make it works nicely on CentOS

--
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+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Hornet]

I have PS installed on several C7 boxes and never had that problem. Judging by his other emails he got it working.

To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+u...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
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.

[Julian Dehn]

Thank you for your fast replies!

Sorry for creating this question - it was an error in my configuration.

I had a local DNAT via iptables on port 3307 to database:3306. I just deleted this two rules and now it is working :)