-
Type:
Suggestion
-
Resolution: Timed out
-
None
-
Component/s: None
-
Environment:System Information
System Date Friday, 24 Aug 2007
System Time 17:57:07
System Favourite Colour Myrtle
Java Version 1.5.0_10
Java Vendor Sun Microsystems Inc.
JVM Version 1.0
JVM Vendor Sun Microsystems Inc.
JVM Implementation Version 1.5.0_10-b03
Java Runtime Java(TM) 2 Runtime Environment, Standard Edition
Java VM Java HotSpot(TM) Client VM
User Name root
User Timezone Europe/London
Operating System Linux 2.6.18-4-686
OS Architecture i386
Filesystem Encoding UTF-8
Java VM Memory Statistics
Total Memory 273 MB
Free Memory 126 MB
Used Memory 147 MB
Memory Graph
[Used Memory (54 %)] [Free Memory (46 %)]
46 % Free
Runtime Information
Database Dialect net.sf.hibernate.dialect.PostgreSQLDialect
Database Connection URL jdbc:postgresql://localhost:5432/confluence
Database Driver Name org.postgresql.Driver
Database Driver Version 8.1
Application Server Apache Tomcat/5.5.15
Servlet Version 2.4
Confluence Home /data/confluence
Uptime 18 hours, 30 minutes, 12 seconds
Confluence Version 2.5.4
Build Number 809System Information System Date Friday, 24 Aug 2007 System Time 17:57:07 System Favourite Colour Myrtle Java Version 1.5.0_10 Java Vendor Sun Microsystems Inc. JVM Version 1.0 JVM Vendor Sun Microsystems Inc. JVM Implementation Version 1.5.0_10-b03 Java Runtime Java(TM) 2 Runtime Environment, Standard Edition Java VM Java HotSpot(TM) Client VM User Name root User Timezone Europe/London Operating System Linux 2.6.18-4-686 OS Architecture i386 Filesystem Encoding UTF-8 Java VM Memory Statistics Total Memory 273 MB Free Memory 126 MB Used Memory 147 MB Memory Graph [Used Memory (54 %)] [Free Memory (46 %)] 46 % Free Runtime Information Database Dialect net.sf.hibernate.dialect.PostgreSQLDialect Database Connection URL jdbc: postgresql://localhost:5432/confluence Database Driver Name org.postgresql.Driver Database Driver Version 8.1 Application Server Apache Tomcat/5.5.15 Servlet Version 2.4 Confluence Home /data/confluence Uptime 18 hours, 30 minutes, 12 seconds Confluence Version 2.5.4 Build Number 809
NOTE: This suggestion is for Confluence Server. Using Confluence Cloud? See the corresponding suggestion.
I'd really like to be able to get information about who logged in from which IP address. I'm not too worried about user interface, I just want to get at the underlying information. The most obvious place to look for this was alongside the last login date, but it appears that the information isn't recorded there (this is querying our PostgreSQL database):
confluence=# select entity_key from os_propertyentry where entity_name='OSUser_user' group by entity_key order by entity_key;
entity_key
-----------------------------------------------
confluence.prefs.email.mimetype
confluence.prefs.notify.for.my.own.actions
confluence.user.dashboard.labels
confluence.user.dashboard.spaces.selected.tab
confluence.user.last.login.date
confluence.user.locale
confluence.user.previous.login.date
confluence.user.profile.picture
confluence.user.runtime.edit.show-labels
confluence.user.runtime.edit.show-location
confluence.user.runtime.edit.show-restrictios
confluence.user.runtime.edit-wysiwyg
confluence.user.runtime.recent-changes.size
confluence.user.runtime.show-children
confluence.user.runtime.show-comments
confluence.user.site.homepage
confluence.user.time.zone
email
fullName
(19 rows)
Is this information stored elsewhere, perhaps in log files? If not then please could you add it alongside the last login data in the above table?
- relates to
-
- Closed
