login column empty, can't login via username / name

Dan F4 years ago

Hi,

Running the latest version of traccar with MySQL database, I noticed that I cannot login using the name/username only email.
So I checked the login column in tc_users only to find there are no entries.

If I change:

<entry key='database.loginUser'>
    SELECT * FROM tc_users
    WHERE email = :email OR login = :email
</entry>

to:

<entry key='database.loginUser'>
    SELECT * FROM tc_users
    WHERE email = :email OR login = :email OR name = :email
</entry>

I can login via name/username but clearly this isn't as intended.
Is there any reason the login column is not getting populated?

Thank you.

Great software by the way ;-)

Anton Tananaev4 years ago

It is only used for LDAP integration.