IP Adress from Users

[Elsi29]

Hello everybody,

Sorry for my bad English, but i came from Germany

How can I see from a User the last IP Adress in the Logs?? It isnt in /subsonic/subsonic.log

Is it shown at another Place or isnt it logged??

Also is it Possible, when a User type 3 x a wrong password, that his account is locked??

Thanks for answers anyway

[MadEvil]

Hello everybody,
Is it shown at another Place or isnt it logged??

Hi,

there are many ways ..

1. try to query via \db.view

Code: Select all

SELECT USERNAME, IP_ADDRESS, LAST_SEEN FROM PLAYER

2. or you can modify your playerSettings.jsp settings page like -> (viewtopic.php?f=8&t=8824)

I hope this help you!
Best regards

[Elsi29]

Thanks for your Answer.

The User have logged at 3. February, i have seen him the Webif, also the User is listed in /subsonic/subsonic.txt that he streamed a few Songs.

But he isnt listed in /db.view

Can you explain this please??

[MadEvil]

Thanks for your Answer.

The User have logged at 3. February, i have seen him the Webif, also the User is listed in /subsonic/subsonic.txt that he streamed a few Songs.

But he isnt listed in /db.view

Can you explain this please??

The IP Adress will be saved only for Players not for user, so if the user delete his own Player from Webinterface you can't see it through db.view.
This must be changed in the Subsonic java code to save the last IP back into User-Table.

Maybe if you using the sharing-feature the guest account will be used for.

Best regards