1 Topic by redbaron

  • redbaron
  • Member
  • Offline
  • Registered: 2012-03-21
  • Posts: 11

Topic: Cant read lastloginipv4

==== Provide required information to help troubleshoot and get quick answer ====
- Linux/BSD distribution name and version: Ubuntu 10.04 LTS
- iRedMail version and backend (LDAP/MySQL): Pro 1.3.1 MySQL
- Any related log? Log is helpful for troubleshooting.
====

Hello I setup up tracking of User Last Login Date and IP Address using this FAQ
http://www.iredmail.org/forum/topic379- … tocol.html
Everything works and info is logged but I cant read lastloginipv4 using PHPMyAdmin, IP when written to db becomes like one number (integer) without any dots. How to read IP from there? Is there any other way to see this info?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: Cant read lastloginipv4

Reference: http://dev.mysql.com/doc/refman/5.0/en/ … tions.html

You need two MySQL functions:

INET_ATON()     Return the numeric value of an IP address
INET_NTOA()     Return the IP address from a numeric value

For example:

mysql> SELECT INET_NTOA(lastloginipv4) FROM ...

3 Reply by redbaron

  • redbaron
  • Member
  • Offline
  • Registered: 2012-03-21
  • Posts: 11

Re: Cant read lastloginipv4

Thanks didn't know that.