[MXS-404] Authentication fail on Ubuntu 14.04 Created: 2015-10-11  Updated: 2015-12-01  Resolved: 2015-12-01

Status: Closed
Project: MariaDB MaxScale
Component/s: mariadbbackend
Affects Version/s: 1.2.1
Fix Version/s: 1.2.1

Type: Bug Priority: Major
Reporter: Tim Clark Assignee: Timofey Turenko
Resolution: Cannot Reproduce Votes: 0
Labels: None
Environment:

binary install on Ubuntu 14.04 - talking to Galera 3 + MariaDB+5.5.42



 Description   

Using readwritesplit - the following error happens:

  1. mysql -h172.18.1.45 -P3309 -p******* -u*******
    Welcome to the MariaDB monitor. Commands end with ; or \g.
    Your MariaDB connection id is 10748
    Server version: 5.5.42-MariaDB

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [an]> select * from *******;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 10748


Looking at debug log:

2015-10-11 21:42:55 140689459013504 [gw_read_backend_event] Read dcb 0x337eae0 fd 20 protocol state 4, MYSQL_AUTH_RECV.
2015-10-11 21:42:55 140689459013504 [dcb_read] Read 75 bytes from dcb 0x337eae0 in state DCB_STATE_POLLING fd 20.
2015-10-11 21:42:55 140689459013504 [gw_receive_backend_auth] Invalid authentication message from backend dcb 0x337eae0 fd 20, ptr[4] = 0xff, error 28000, msg Access denied for user '*******'@'172.18.1.45' (using password: NO).
2015-10-11 21:42:55 140689459013504 [gw_read_backend_event] after gw_receive_backend_authentication fd 20, state = MYSQL_AUTH_FAILED.
2015-10-11 21:42:55 140688884750080 [poll_waitevents] epoll_wait found 1 fds

---------

Password seem to be dropped from MaxScale connection. I've checked for underscores in grant table... but there are none - and same config works when running Maxscale 1.2.1 on a 12.04 server.



 Comments   
Comment by markus makela [ 2015-11-16 ]

Are there any errors in the error log? Does this happen on all users or just one?

Comment by Timofey Turenko [ 2015-12-01 ]

I can't reproduce it. error log would be useful to check.

Generated at Thu Feb 08 03:59:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.