Advertisement
jontheil

postgresql log iPhone

Feb 20th, 2017
238
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Feb  6 00:01:04 [4-1] LOG:  connection received: host=127.0.0.1 port=28393
  2. Feb  6 00:01:04 [5-1] LOG:  connection authorized: user=root database=root
  3. Feb  6 00:01:04 [6-1] LOG:  disconnection: session time: 0:00:00.003 user=root database=root host=127.0.0.1 port=28393
  4. Feb  6 00:01:04 [4-1] LOG:  connection received: host=[local]
  5. Feb  6 00:01:04 [5-1] LOG:  connection authorized: user=root database=root
  6. Feb  6 00:01:04 [6-1] LOG:  disconnection: session time: 0:00:00.003 user=root database=root host=[local]
  7. Feb  6 00:01:06 [4-1] LOG:  connection received: host=[local]
  8. Feb  6 00:01:06 [4-1] LOG:  connection received: host=[local]
  9. Feb  6 00:01:06 [5-1] LOG:  connection authorized: user=davical_app database=davical
  10. Feb  6 00:01:06 [5-1] LOG:  connection authorized: user=davical_app database=davical
  11. Feb  6 00:01:06 [6-1] LOG:  execute pdo_stmt_00000001: SELECT version()
  12. Feb  6 00:01:06 [6-1] LOG:  execute pdo_stmt_00000001: SELECT version()
  13. Feb  6 00:01:06 [7-1] LOG:  statement: DEALLOCATE pdo_stmt_00000001
  14. Feb  6 00:01:06 [7-1] LOG:  statement: DEALLOCATE pdo_stmt_00000001
  15. Feb  6 00:01:06 [4-1] LOG:  connection received: host=[local]
  16. Feb  6 00:01:06 [4-1] LOG:  connection received: host=[local]
  17. Feb  6 00:01:06 [8-1] LOG:  execute pdo_stmt_00000002: SELECT schema_major, schema_minor, schema_patch FROM awl_db_revision ORDER BY schema_id DESC LIMIT 1;
  18. Feb  6 00:01:06 [8-1] LOG:  execute pdo_stmt_00000002: SELECT schema_major, schema_minor, schema_patch FROM awl_db_revision ORDER BY schema_id DESC LIMIT 1;
  19. Feb  6 00:01:06 [9-1] LOG:  statement: DEALLOCATE pdo_stmt_00000002
  20. Feb  6 00:01:06 [9-1] LOG:  statement: DEALLOCATE pdo_stmt_00000002
  21. Feb  6 00:01:06 [5-1] LOG:  connection authorized: user=davical_app database=davical
  22. Feb  6 00:01:06 [10-1] LOG:  execute pdo_stmt_00000003: SET TIMEZONE TO 'Europe/Copenhagen'
  23. Feb  6 00:01:06 [10-1] LOG:  execute pdo_stmt_00000003: SET TIMEZONE TO 'Europe/Copenhagen'
  24. Feb  6 00:01:06 [5-1] LOG:  connection authorized: user=davical_app database=davical
  25. Feb  6 00:01:06 [11-1] LOG:  statement: DEALLOCATE pdo_stmt_00000003
  26. Feb  6 00:01:06 [12-1] LOG:  disconnection: session time: 0:00:00.008 user=davical_app database=davical host=[local]
  27. Feb  6 00:01:06 [11-1] LOG:  statement: DEALLOCATE pdo_stmt_00000003
  28. Feb  6 00:01:06 [12-1] LOG:  disconnection: session time: 0:00:00.008 user=davical_app database=davical host=[local]
  29. Feb  6 00:01:06 [6-1] LOG:  execute pdo_stmt_00000001: SELECT version()
  30. Feb  6 00:01:06 [6-1] LOG:  execute pdo_stmt_00000001: SELECT version()
  31. Feb  6 00:01:06 [7-1] LOG:  statement: DEALLOCATE pdo_stmt_00000001
  32. Feb  6 00:01:06 [7-1] LOG:  statement: DEALLOCATE pdo_stmt_00000001
  33. Feb  6 00:01:06 [8-1] LOG:  execute pdo_stmt_00000002: SELECT schema_major, schema_minor, schema_patch FROM awl_db_revision ORDER BY schema_id DESC LIMIT 1;
  34. Feb  6 00:01:06 [8-1] LOG:  execute pdo_stmt_00000002: SELECT schema_major, schema_minor, schema_patch FROM awl_db_revision ORDER BY schema_id DESC LIMIT 1;
  35. Feb  6 00:01:06 [9-1] LOG:  statement: DEALLOCATE pdo_stmt_00000002
  36. Feb  6 00:01:06 [9-1] LOG:  statement: DEALLOCATE pdo_stmt_00000002
  37. Feb  6 00:01:06 [10-1] LOG:  execute pdo_stmt_00000003: SET TIMEZONE TO 'Europe/Copenhagen'
  38. Feb  6 00:01:06 [10-1] LOG:  execute pdo_stmt_00000003: SET TIMEZONE TO 'Europe/Copenhagen'
  39. Feb  6 00:01:06 [11-1] LOG:  statement: DEALLOCATE pdo_stmt_00000003
  40. Feb  6 00:01:06 [11-1] LOG:  statement: DEALLOCATE pdo_stmt_00000003
  41. Feb  6 00:01:06 [12-1] LOG:  disconnection: session time: 0:00:00.008 user=davical_app database=davical host=[local]
  42. Feb  6 00:01:06 [12-1] LOG:  disconnection: session time: 0:00:00.008 user=davical_app database=davical host=[local]
  43. Feb  6 00:01:06 [4-1] LOG:  connection received: host=[local]
  44. Feb  6 00:01:06 [5-1] LOG:  connection authorized: user=davical_app database=davical
  45. Feb  6 00:01:06 [6-1] LOG:  execute pdo_stmt_00000001: SELECT version()
  46. Feb  6 00:01:06 [7-1] LOG:  statement: DEALLOCATE pdo_stmt_00000001
  47. Feb  6 00:01:06 [8-1] LOG:  execute pdo_stmt_00000002: SELECT schema_major, schema_minor, schema_patch FROM awl_db_revision ORDER BY schema_id DESC LIMIT 1;
  48. Feb  6 00:01:06 [9-1] LOG:  statement: DEALLOCATE pdo_stmt_00000002
  49. Feb  6 00:01:06 [10-1] LOG:  execute pdo_stmt_00000003: SET TIMEZONE TO 'Europe/Copenhagen'
  50. Feb  6 00:01:06 [4-1] LOG:  connection received: host=[local]
  51. Feb  6 00:01:06 [4-1] LOG:  connection received: host=[local]
  52. Feb  6 00:01:06 [4-1] LOG:  connection received: host=[local]
  53. Feb  6 00:01:06 [5-1] LOG:  connection authorized: user=davical_app database=davical
  54. Feb  6 00:01:06 [5-1] LOG:  connection authorized: user=davical_app database=davical
  55. Feb  6 00:01:06 [11-1] LOG:  execute pdo_stmt_00000004: SELECT *, 0::BIT(24) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  56. Feb  6 00:01:06 [5-1] LOG:  connection authorized: user=davical_app database=davical
  57. Feb  6 00:01:06 [12-1] LOG:  statement: DEALLOCATE pdo_stmt_00000004
  58. Feb  6 00:01:06 [6-1] LOG:  execute pdo_stmt_00000001: SELECT version()
  59. Feb  6 00:01:06 [7-1] LOG:  statement: DEALLOCATE pdo_stmt_00000001
  60. Feb  6 00:01:06 [13-1] LOG:  execute pdo_stmt_00000005: SELECT role_name FROM role_member m join roles r ON r.role_no = m.role_no WHERE user_no = 1001
  61. Feb  6 00:01:06 [14-1] LOG:  statement: DEALLOCATE pdo_stmt_00000005
  62. Feb  6 00:01:06 [6-1] LOG:  execute pdo_stmt_00000001: SELECT version()
  63. Feb  6 00:01:06 [6-1] LOG:  execute pdo_stmt_00000001: SELECT version()
  64. Feb  6 00:01:06 [7-1] LOG:  statement: DEALLOCATE pdo_stmt_00000001
  65. Feb  6 00:01:06 [7-1] LOG:  statement: DEALLOCATE pdo_stmt_00000001
  66. Feb  6 00:01:06 [8-1] LOG:  execute pdo_stmt_00000002: SELECT schema_major, schema_minor, schema_patch FROM awl_db_revision ORDER BY schema_id DESC LIMIT 1;
  67. Feb  6 00:01:06 [9-1] LOG:  statement: DEALLOCATE pdo_stmt_00000002
  68. Feb  6 00:01:06 [10-1] LOG:  execute pdo_stmt_00000003: SET TIMEZONE TO 'Europe/Copenhagen'
  69. Feb  6 00:01:06 [8-1] LOG:  execute pdo_stmt_00000002: SELECT schema_major, schema_minor, schema_patch FROM awl_db_revision ORDER BY schema_id DESC LIMIT 1;
  70. Feb  6 00:01:06 [15-1] LOG:  execute pdo_stmt_00000006: SELECT *, pprivs(2::int8,principal_id,2::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  71. Feb  6 00:01:06 [8-1] LOG:  execute pdo_stmt_00000002: SELECT schema_major, schema_minor, schema_patch FROM awl_db_revision ORDER BY schema_id DESC LIMIT 1;
  72. Feb  6 00:01:06 [9-1] LOG:  statement: DEALLOCATE pdo_stmt_00000002
  73. Feb  6 00:01:06 [9-1] LOG:  statement: DEALLOCATE pdo_stmt_00000002
  74. Feb  6 00:01:06 [10-1] LOG:  execute pdo_stmt_00000003: SET TIMEZONE TO 'Europe/Copenhagen'
  75. Feb  6 00:01:06 [10-1] LOG:  execute pdo_stmt_00000003: SET TIMEZONE TO 'Europe/Copenhagen'
  76. Feb  6 00:01:06 [16-1] LOG:  statement: DEALLOCATE pdo_stmt_00000006
  77. Feb  6 00:01:06 [17-1] LOG:  execute pdo_stmt_00000007: SELECT * FROM collection WHERE dav_name = '/' ORDER BY LENGTH(dav_name) DESC LIMIT 1
  78. Feb  6 00:01:06 [18-1] LOG:  execute pdo_stmt_00000008: SELECT *, pprivs(2::int8,principal_id,2::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  79. Feb  6 00:01:06 [19-1] LOG:  statement: DEALLOCATE pdo_stmt_00000008
  80. Feb  6 00:01:06 [11-1] LOG:  execute pdo_stmt_00000004: SELECT *, 0::BIT(24) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  81. Feb  6 00:01:06 [12-1] LOG:  statement: DEALLOCATE pdo_stmt_00000004
  82. Feb  6 00:01:06 [13-1] LOG:  execute pdo_stmt_00000005: SELECT role_name FROM role_member m join roles r ON r.role_no = m.role_no WHERE user_no = 1001
  83. Feb  6 00:01:06 [14-1] LOG:  statement: DEALLOCATE pdo_stmt_00000005
  84. Feb  6 00:01:06 [11-1] LOG:  execute pdo_stmt_00000004: SELECT *, 0::BIT(24) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  85. Feb  6 00:01:06 [11-1] LOG:  execute pdo_stmt_00000004: SELECT *, 0::BIT(24) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  86. Feb  6 00:01:06 [12-1] LOG:  statement: DEALLOCATE pdo_stmt_00000004
  87. Feb  6 00:01:06 [12-1] LOG:  statement: DEALLOCATE pdo_stmt_00000004
  88. Feb  6 00:01:06 [20-1] LOG:  execute pdo_stmt_00000009: SELECT usr.username FROM group_member JOIN principal ON (principal_id=group_id) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 UNION SELECT usr.username FROM group_member LEFT JOIN grants ON (to_principal=group_id) JOIN principal ON (principal_id=by_principal) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 and by_principal != member_id ORDER BY 1
  89. Feb  6 00:01:06 [13-1] LOG:  execute pdo_stmt_00000005: SELECT role_name FROM role_member m join roles r ON r.role_no = m.role_no WHERE user_no = 1001
  90. Feb  6 00:01:06 [15-1] LOG:  execute pdo_stmt_00000006: SELECT *, pprivs(2::int8,principal_id,2::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  91. Feb  6 00:01:06 [14-1] LOG:  statement: DEALLOCATE pdo_stmt_00000005
  92. Feb  6 00:01:06 [21-1] LOG:  statement: DEALLOCATE pdo_stmt_00000009
  93. Feb  6 00:01:06 [13-1] LOG:  execute pdo_stmt_00000005: SELECT role_name FROM role_member m join roles r ON r.role_no = m.role_no WHERE user_no = 1001
  94. Feb  6 00:01:06 [22-1] LOG:  statement: DEALLOCATE pdo_stmt_00000007
  95. Feb  6 00:01:06 [14-1] LOG:  statement: DEALLOCATE pdo_stmt_00000005
  96. Feb  6 00:01:06 [15-1] LOG:  execute pdo_stmt_00000006: SELECT *, pprivs(2::int8,principal_id,2::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  97. Feb  6 00:01:06 [16-1] LOG:  statement: DEALLOCATE pdo_stmt_00000006
  98. Feb  6 00:01:06 [15-1] LOG:  execute pdo_stmt_00000006: SELECT *, pprivs(2::int8,principal_id,2::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  99. Feb  6 00:01:06 [16-1] LOG:  statement: DEALLOCATE pdo_stmt_00000006
  100. Feb  6 00:01:06 [17-1] LOG:  execute pdo_stmt_00000007: SELECT * FROM collection WHERE dav_name = '/' ORDER BY LENGTH(dav_name) DESC LIMIT 1
  101. Feb  6 00:01:06 [23-1] LOG:  execute pdo_stmt_0000000a: SELECT collection.*, path_privs(2::int8, collection.dav_name,2::int), p.principal_id, p.type_id AS principal_type_id, p.displayname AS principal_displayname, p.default_privileges AS principal_default_privileges, timezones.vtimezone FROM collection LEFT JOIN principal p USING (user_no) LEFT JOIN timezones ON (collection.timezone=timezones.tzid) WHERE collection.dav_name = '/' ORDER BY LENGTH(collection.dav_name) DESC LIMIT 1
  102. Feb  6 00:01:06 [24-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000a
  103. Feb  6 00:01:06 [16-1] LOG:  statement: DEALLOCATE pdo_stmt_00000006
  104. Feb  6 00:01:06 [17-1] LOG:  execute pdo_stmt_00000007: SELECT * FROM collection WHERE dav_name = '/' ORDER BY LENGTH(dav_name) DESC LIMIT 1
  105. Feb  6 00:01:06 [18-1] LOG:  execute pdo_stmt_00000008: SELECT *, pprivs(2::int8,principal_id,2::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  106. Feb  6 00:01:06 [25-1] LOG:  execute pdo_stmt_0000000b: SELECT property_name, property_value FROM property WHERE dav_name= '/'
  107. Feb  6 00:01:06 [17-1] LOG:  execute pdo_stmt_00000007: SELECT * FROM collection WHERE dav_name = '/' ORDER BY LENGTH(dav_name) DESC LIMIT 1
  108. Feb  6 00:01:06 [19-1] LOG:  statement: DEALLOCATE pdo_stmt_00000008
  109. Feb  6 00:01:06 [26-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000b
  110. Feb  6 00:01:06 [18-1] LOG:  execute pdo_stmt_00000008: SELECT *, pprivs(2::int8,principal_id,2::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  111. Feb  6 00:01:06 [19-1] LOG:  statement: DEALLOCATE pdo_stmt_00000008
  112. Feb  6 00:01:06 [18-1] LOG:  execute pdo_stmt_00000008: SELECT *, pprivs(2::int8,principal_id,2::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  113. Feb  6 00:01:06 [27-1] LOG:  execute pdo_stmt_0000000c: SELECT *, pprivs(2::int8,principal_id,2::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  114. Feb  6 00:01:06 [19-1] LOG:  statement: DEALLOCATE pdo_stmt_00000008
  115. Feb  6 00:01:06 [28-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000c
  116. Feb  6 00:01:06 [20-1] LOG:  execute pdo_stmt_00000009: SELECT usr.username FROM group_member JOIN principal ON (principal_id=group_id) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 UNION SELECT usr.username FROM group_member LEFT JOIN grants ON (to_principal=group_id) JOIN principal ON (principal_id=by_principal) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 and by_principal != member_id ORDER BY 1
  117. Feb  6 00:01:06 [21-1] LOG:  statement: DEALLOCATE pdo_stmt_00000009
  118. Feb  6 00:01:06 [22-1] LOG:  statement: DEALLOCATE pdo_stmt_00000007
  119. Feb  6 00:01:06 [29-1] LOG:  execute pdo_stmt_0000000d: SELECT usr.username FROM group_member JOIN principal ON (principal_id=group_id) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 UNION SELECT usr.username FROM group_member LEFT JOIN grants ON (to_principal=group_id) JOIN principal ON (principal_id=by_principal) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 and by_principal != member_id ORDER BY 1
  120. Feb  6 00:01:06 [30-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000d
  121. Feb  6 00:01:06 [20-1] LOG:  execute pdo_stmt_00000009: SELECT usr.username FROM group_member JOIN principal ON (principal_id=group_id) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 UNION SELECT usr.username FROM group_member LEFT JOIN grants ON (to_principal=group_id) JOIN principal ON (principal_id=by_principal) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 and by_principal != member_id ORDER BY 1
  122. Feb  6 00:01:06 [20-1] LOG:  execute pdo_stmt_00000009: SELECT usr.username FROM group_member JOIN principal ON (principal_id=group_id) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 UNION SELECT usr.username FROM group_member LEFT JOIN grants ON (to_principal=group_id) JOIN principal ON (principal_id=by_principal) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 and by_principal != member_id ORDER BY 1
  123. Feb  6 00:01:06 [21-1] LOG:  statement: DEALLOCATE pdo_stmt_00000009
  124. Feb  6 00:01:06 [22-1] LOG:  statement: DEALLOCATE pdo_stmt_00000007
  125. Feb  6 00:01:06 [21-1] LOG:  statement: DEALLOCATE pdo_stmt_00000009
  126. Feb  6 00:01:06 [31-1] LOG:  statement: DEALLOCATE pdo_stmt_00000003
  127. Feb  6 00:01:06 [22-1] LOG:  statement: DEALLOCATE pdo_stmt_00000007
  128. Feb  6 00:01:06 [32-1] LOG:  disconnection: session time: 0:00:00.032 user=davical_app database=davical host=[local]
  129. Feb  6 00:01:06 [23-1] LOG:  execute pdo_stmt_0000000a: SELECT collection.*, path_privs(2::int8, collection.dav_name,2::int), p.principal_id, p.type_id AS principal_type_id, p.displayname AS principal_displayname, p.default_privileges AS principal_default_privileges, timezones.vtimezone FROM collection LEFT JOIN principal p USING (user_no) LEFT JOIN timezones ON (collection.timezone=timezones.tzid) WHERE collection.dav_name = '/' ORDER BY LENGTH(collection.dav_name) DESC LIMIT 1
  130. Feb  6 00:01:06 [24-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000a
  131. Feb  6 00:01:06 [23-1] LOG:  execute pdo_stmt_0000000a: SELECT collection.*, path_privs(2::int8, collection.dav_name,2::int), p.principal_id, p.type_id AS principal_type_id, p.displayname AS principal_displayname, p.default_privileges AS principal_default_privileges, timezones.vtimezone FROM collection LEFT JOIN principal p USING (user_no) LEFT JOIN timezones ON (collection.timezone=timezones.tzid) WHERE collection.dav_name = '/' ORDER BY LENGTH(collection.dav_name) DESC LIMIT 1
  132. Feb  6 00:01:06 [24-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000a
  133. Feb  6 00:01:06 [23-1] LOG:  execute pdo_stmt_0000000a: SELECT collection.*, path_privs(2::int8, collection.dav_name,2::int), p.principal_id, p.type_id AS principal_type_id, p.displayname AS principal_displayname, p.default_privileges AS principal_default_privileges, timezones.vtimezone FROM collection LEFT JOIN principal p USING (user_no) LEFT JOIN timezones ON (collection.timezone=timezones.tzid) WHERE collection.dav_name = '/' ORDER BY LENGTH(collection.dav_name) DESC LIMIT 1
  134. Feb  6 00:01:06 [25-1] LOG:  execute pdo_stmt_0000000b: SELECT property_name, property_value FROM property WHERE dav_name= '/'
  135. Feb  6 00:01:06 [24-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000a
  136. Feb  6 00:01:06 [26-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000b
  137. Feb  6 00:01:06 [25-1] LOG:  execute pdo_stmt_0000000b: SELECT property_name, property_value FROM property WHERE dav_name= '/'
  138. Feb  6 00:01:06 [26-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000b
  139. Feb  6 00:01:06 [25-1] LOG:  execute pdo_stmt_0000000b: SELECT property_name, property_value FROM property WHERE dav_name= '/'
  140. Feb  6 00:01:06 [27-1] LOG:  execute pdo_stmt_0000000c: SELECT *, pprivs(2::int8,principal_id,2::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  141. Feb  6 00:01:06 [26-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000b
  142. Feb  6 00:01:06 [28-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000c
  143. Feb  6 00:01:06 [27-1] LOG:  execute pdo_stmt_0000000c: SELECT *, pprivs(2::int8,principal_id,2::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  144. Feb  6 00:01:06 [27-1] LOG:  execute pdo_stmt_0000000c: SELECT *, pprivs(2::int8,principal_id,2::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  145. Feb  6 00:01:06 [28-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000c
  146. Feb  6 00:01:06 [28-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000c
  147. Feb  6 00:01:06 [29-1] LOG:  execute pdo_stmt_0000000d: SELECT usr.username FROM group_member JOIN principal ON (principal_id=group_id) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 UNION SELECT usr.username FROM group_member LEFT JOIN grants ON (to_principal=group_id) JOIN principal ON (principal_id=by_principal) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 and by_principal != member_id ORDER BY 1
  148. Feb  6 00:01:06 [30-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000d
  149. Feb  6 00:01:06 [29-1] LOG:  execute pdo_stmt_0000000d: SELECT usr.username FROM group_member JOIN principal ON (principal_id=group_id) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 UNION SELECT usr.username FROM group_member LEFT JOIN grants ON (to_principal=group_id) JOIN principal ON (principal_id=by_principal) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 and by_principal != member_id ORDER BY 1
  150. Feb  6 00:01:06 [29-1] LOG:  execute pdo_stmt_0000000d: SELECT usr.username FROM group_member JOIN principal ON (principal_id=group_id) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 UNION SELECT usr.username FROM group_member LEFT JOIN grants ON (to_principal=group_id) JOIN principal ON (principal_id=by_principal) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 and by_principal != member_id ORDER BY 1
  151. Feb  6 00:01:06 [30-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000d
  152. Feb  6 00:01:06 [30-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000d
  153. Feb  6 00:01:06 [31-1] LOG:  statement: DEALLOCATE pdo_stmt_00000003
  154. Feb  6 00:01:06 [32-1] LOG:  disconnection: session time: 0:00:00.031 user=davical_app database=davical host=[local]
  155. Feb  6 00:01:06 [31-1] LOG:  statement: DEALLOCATE pdo_stmt_00000003
  156. Feb  6 00:01:06 [32-1] LOG:  disconnection: session time: 0:00:00.031 user=davical_app database=davical host=[local]
  157. Feb  6 00:01:06 [31-1] LOG:  statement: DEALLOCATE pdo_stmt_00000003
  158. Feb  6 00:01:06 [32-1] LOG:  disconnection: session time: 0:00:00.032 user=davical_app database=davical host=[local]
  159. Feb  6 00:01:06 [4-1] LOG:  connection received: host=[local]
  160. Feb  6 00:01:06 [5-1] LOG:  connection authorized: user=davical_app database=davical
  161. Feb  6 00:01:06 [4-1] LOG:  connection received: host=[local]
  162. Feb  6 00:01:06 [4-1] LOG:  connection received: host=[local]
  163. Feb  6 00:01:06 [4-1] LOG:  connection received: host=[local]
  164. Feb  6 00:01:06 [5-1] LOG:  connection authorized: user=davical_app database=davical
  165. Feb  6 00:01:06 [5-1] LOG:  connection authorized: user=davical_app database=davical
  166. Feb  6 00:01:06 [6-1] LOG:  execute pdo_stmt_00000001: SELECT version()
  167. Feb  6 00:01:06 [7-1] LOG:  statement: DEALLOCATE pdo_stmt_00000001
  168. Feb  6 00:01:06 [5-1] LOG:  connection authorized: user=davical_app database=davical
  169. Feb  6 00:01:06 [6-1] LOG:  execute pdo_stmt_00000001: SELECT version()
  170. Feb  6 00:01:06 [8-1] LOG:  execute pdo_stmt_00000002: SELECT schema_major, schema_minor, schema_patch FROM awl_db_revision ORDER BY schema_id DESC LIMIT 1;
  171. Feb  6 00:01:06 [7-1] LOG:  statement: DEALLOCATE pdo_stmt_00000001
  172. Feb  6 00:01:06 [9-1] LOG:  statement: DEALLOCATE pdo_stmt_00000002
  173. Feb  6 00:01:06 [10-1] LOG:  execute pdo_stmt_00000003: SET TIMEZONE TO 'Europe/Copenhagen'
  174. Feb  6 00:01:06 [6-1] LOG:  execute pdo_stmt_00000001: SELECT version()
  175. Feb  6 00:01:06 [7-1] LOG:  statement: DEALLOCATE pdo_stmt_00000001
  176. Feb  6 00:01:06 [6-1] LOG:  execute pdo_stmt_00000001: SELECT version()
  177. Feb  6 00:01:06 [7-1] LOG:  statement: DEALLOCATE pdo_stmt_00000001
  178. Feb  6 00:01:06 [8-1] LOG:  execute pdo_stmt_00000002: SELECT schema_major, schema_minor, schema_patch FROM awl_db_revision ORDER BY schema_id DESC LIMIT 1;
  179. Feb  6 00:01:06 [9-1] LOG:  statement: DEALLOCATE pdo_stmt_00000002
  180. Feb  6 00:01:06 [8-1] LOG:  execute pdo_stmt_00000002: SELECT schema_major, schema_minor, schema_patch FROM awl_db_revision ORDER BY schema_id DESC LIMIT 1;
  181. Feb  6 00:01:06 [10-1] LOG:  execute pdo_stmt_00000003: SET TIMEZONE TO 'Europe/Copenhagen'
  182. Feb  6 00:01:06 [9-1] LOG:  statement: DEALLOCATE pdo_stmt_00000002
  183. Feb  6 00:01:06 [8-1] LOG:  execute pdo_stmt_00000002: SELECT schema_major, schema_minor, schema_patch FROM awl_db_revision ORDER BY schema_id DESC LIMIT 1;
  184. Feb  6 00:01:06 [10-1] LOG:  execute pdo_stmt_00000003: SET TIMEZONE TO 'Europe/Copenhagen'
  185. Feb  6 00:01:06 [9-1] LOG:  statement: DEALLOCATE pdo_stmt_00000002
  186. Feb  6 00:01:06 [10-1] LOG:  execute pdo_stmt_00000003: SET TIMEZONE TO 'Europe/Copenhagen'
  187. Feb  6 00:01:06 [11-1] LOG:  execute pdo_stmt_00000004: SELECT *, 0::BIT(24) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  188. Feb  6 00:01:06 [12-1] LOG:  statement: DEALLOCATE pdo_stmt_00000004
  189. Feb  6 00:01:06 [13-1] LOG:  execute pdo_stmt_00000005: SELECT role_name FROM role_member m join roles r ON r.role_no = m.role_no WHERE user_no = 1001
  190. Feb  6 00:01:06 [14-1] LOG:  statement: DEALLOCATE pdo_stmt_00000005
  191. Feb  6 00:01:06 [11-1] LOG:  execute pdo_stmt_00000004: SELECT *, 0::BIT(24) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  192. Feb  6 00:01:06 [15-1] LOG:  execute pdo_stmt_00000006: SELECT *, pprivs(2::int8,principal_id,2::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  193. Feb  6 00:01:06 [12-1] LOG:  statement: DEALLOCATE pdo_stmt_00000004
  194. Feb  6 00:01:06 [11-1] LOG:  execute pdo_stmt_00000004: SELECT *, 0::BIT(24) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  195. Feb  6 00:01:06 [11-1] LOG:  execute pdo_stmt_00000004: SELECT *, 0::BIT(24) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  196. Feb  6 00:01:06 [12-1] LOG:  statement: DEALLOCATE pdo_stmt_00000004
  197. Feb  6 00:01:06 [12-1] LOG:  statement: DEALLOCATE pdo_stmt_00000004
  198. Feb  6 00:01:06 [13-1] LOG:  execute pdo_stmt_00000005: SELECT role_name FROM role_member m join roles r ON r.role_no = m.role_no WHERE user_no = 1001
  199. Feb  6 00:01:06 [14-1] LOG:  statement: DEALLOCATE pdo_stmt_00000005
  200. Feb  6 00:01:06 [13-1] LOG:  execute pdo_stmt_00000005: SELECT role_name FROM role_member m join roles r ON r.role_no = m.role_no WHERE user_no = 1001
  201. Feb  6 00:01:06 [16-1] LOG:  statement: DEALLOCATE pdo_stmt_00000006
  202. Feb  6 00:01:06 [14-1] LOG:  statement: DEALLOCATE pdo_stmt_00000005
  203. Feb  6 00:01:06 [13-1] LOG:  execute pdo_stmt_00000005: SELECT role_name FROM role_member m join roles r ON r.role_no = m.role_no WHERE user_no = 1001
  204. Feb  6 00:01:06 [14-1] LOG:  statement: DEALLOCATE pdo_stmt_00000005
  205. Feb  6 00:01:06 [15-1] LOG:  execute pdo_stmt_00000006: SELECT *, pprivs(2::int8,principal_id,2::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  206. Feb  6 00:01:06 [17-1] LOG:  execute pdo_stmt_00000007: SELECT * FROM collection WHERE dav_name = '/jtheilnielsen/' ORDER BY LENGTH(dav_name) DESC LIMIT 1
  207. Feb  6 00:01:06 [15-1] LOG:  execute pdo_stmt_00000006: SELECT *, pprivs(2::int8,principal_id,2::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  208. Feb  6 00:01:06 [15-1] LOG:  execute pdo_stmt_00000006: SELECT *, pprivs(2::int8,principal_id,2::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  209. Feb  6 00:01:06 [16-1] LOG:  statement: DEALLOCATE pdo_stmt_00000006
  210. Feb  6 00:01:06 [18-1] LOG:  execute pdo_stmt_00000008: SELECT *, pprivs(2::int8,principal_id,2::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  211. Feb  6 00:01:06 [19-1] LOG:  statement: DEALLOCATE pdo_stmt_00000008
  212. Feb  6 00:01:06 [16-1] LOG:  statement: DEALLOCATE pdo_stmt_00000006
  213. Feb  6 00:01:06 [16-1] LOG:  statement: DEALLOCATE pdo_stmt_00000006
  214. Feb  6 00:01:06 [17-1] LOG:  execute pdo_stmt_00000007: SELECT * FROM collection WHERE dav_name = '/jtheilnielsen/' ORDER BY LENGTH(dav_name) DESC LIMIT 1
  215. Feb  6 00:01:06 [17-1] LOG:  execute pdo_stmt_00000007: SELECT * FROM collection WHERE dav_name = '/jtheilnielsen/' ORDER BY LENGTH(dav_name) DESC LIMIT 1
  216. Feb  6 00:01:06 [17-1] LOG:  execute pdo_stmt_00000007: SELECT * FROM collection WHERE dav_name = '/jtheilnielsen/' ORDER BY LENGTH(dav_name) DESC LIMIT 1
  217. Feb  6 00:01:06 [18-1] LOG:  execute pdo_stmt_00000008: SELECT *, pprivs(2::int8,principal_id,2::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  218. Feb  6 00:01:06 [19-1] LOG:  statement: DEALLOCATE pdo_stmt_00000008
  219. Feb  6 00:01:06 [18-1] LOG:  execute pdo_stmt_00000008: SELECT *, pprivs(2::int8,principal_id,2::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  220. Feb  6 00:01:06 [18-1] LOG:  execute pdo_stmt_00000008: SELECT *, pprivs(2::int8,principal_id,2::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  221. Feb  6 00:01:06 [19-1] LOG:  statement: DEALLOCATE pdo_stmt_00000008
  222. Feb  6 00:01:06 [20-1] LOG:  execute pdo_stmt_00000009: SELECT usr.username FROM group_member JOIN principal ON (principal_id=group_id) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 UNION SELECT usr.username FROM group_member LEFT JOIN grants ON (to_principal=group_id) JOIN principal ON (principal_id=by_principal) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 and by_principal != member_id ORDER BY 1
  223. Feb  6 00:01:06 [19-1] LOG:  statement: DEALLOCATE pdo_stmt_00000008
  224. Feb  6 00:01:06 [21-1] LOG:  statement: DEALLOCATE pdo_stmt_00000009
  225. Feb  6 00:01:06 [22-1] LOG:  statement: DEALLOCATE pdo_stmt_00000007
  226. Feb  6 00:01:06 [20-1] LOG:  execute pdo_stmt_00000009: SELECT usr.username FROM group_member JOIN principal ON (principal_id=group_id) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 UNION SELECT usr.username FROM group_member LEFT JOIN grants ON (to_principal=group_id) JOIN principal ON (principal_id=by_principal) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 and by_principal != member_id ORDER BY 1
  227. Feb  6 00:01:06 [21-1] LOG:  statement: DEALLOCATE pdo_stmt_00000009
  228. Feb  6 00:01:06 [20-1] LOG:  execute pdo_stmt_00000009: SELECT usr.username FROM group_member JOIN principal ON (principal_id=group_id) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 UNION SELECT usr.username FROM group_member LEFT JOIN grants ON (to_principal=group_id) JOIN principal ON (principal_id=by_principal) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 and by_principal != member_id ORDER BY 1
  229. Feb  6 00:01:06 [23-1] LOG:  execute pdo_stmt_0000000a: SELECT collection.*, path_privs(2::int8, collection.dav_name,2::int), p.principal_id, p.type_id AS principal_type_id, p.displayname AS principal_displayname, p.default_privileges AS principal_default_privileges, timezones.vtimezone FROM collection LEFT JOIN principal p USING (user_no) LEFT JOIN timezones ON (collection.timezone=timezones.tzid) WHERE collection.dav_name = '/jtheilnielsen/' ORDER BY LENGTH(collection.dav_name) DESC LIMIT 1
  230. Feb  6 00:01:06 [22-1] LOG:  statement: DEALLOCATE pdo_stmt_00000007
  231. Feb  6 00:01:06 [21-1] LOG:  statement: DEALLOCATE pdo_stmt_00000009
  232. Feb  6 00:01:06 [20-1] LOG:  execute pdo_stmt_00000009: SELECT usr.username FROM group_member JOIN principal ON (principal_id=group_id) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 UNION SELECT usr.username FROM group_member LEFT JOIN grants ON (to_principal=group_id) JOIN principal ON (principal_id=by_principal) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 and by_principal != member_id ORDER BY 1
  233. Feb  6 00:01:06 [22-1] LOG:  statement: DEALLOCATE pdo_stmt_00000007
  234. Feb  6 00:01:06 [21-1] LOG:  statement: DEALLOCATE pdo_stmt_00000009
  235. Feb  6 00:01:06 [24-1] LOG:  execute pdo_stmt_0000000b: SELECT *, pprivs(2::int8,principal_id,2::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  236. Feb  6 00:01:06 [22-1] LOG:  statement: DEALLOCATE pdo_stmt_00000007
  237. Feb  6 00:01:06 [25-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000b
  238. Feb  6 00:01:06 [23-1] LOG:  execute pdo_stmt_0000000a: SELECT collection.*, path_privs(2::int8, collection.dav_name,2::int), p.principal_id, p.type_id AS principal_type_id, p.displayname AS principal_displayname, p.default_privileges AS principal_default_privileges, timezones.vtimezone FROM collection LEFT JOIN principal p USING (user_no) LEFT JOIN timezones ON (collection.timezone=timezones.tzid) WHERE collection.dav_name = '/jtheilnielsen/' ORDER BY LENGTH(collection.dav_name) DESC LIMIT 1
  239. Feb  6 00:01:06 [23-1] LOG:  execute pdo_stmt_0000000a: SELECT collection.*, path_privs(2::int8, collection.dav_name,2::int), p.principal_id, p.type_id AS principal_type_id, p.displayname AS principal_displayname, p.default_privileges AS principal_default_privileges, timezones.vtimezone FROM collection LEFT JOIN principal p USING (user_no) LEFT JOIN timezones ON (collection.timezone=timezones.tzid) WHERE collection.dav_name = '/jtheilnielsen/' ORDER BY LENGTH(collection.dav_name) DESC LIMIT 1
  240. Feb  6 00:01:06 [23-1] LOG:  execute pdo_stmt_0000000a: SELECT collection.*, path_privs(2::int8, collection.dav_name,2::int), p.principal_id, p.type_id AS principal_type_id, p.displayname AS principal_displayname, p.default_privileges AS principal_default_privileges, timezones.vtimezone FROM collection LEFT JOIN principal p USING (user_no) LEFT JOIN timezones ON (collection.timezone=timezones.tzid) WHERE collection.dav_name = '/jtheilnielsen/' ORDER BY LENGTH(collection.dav_name) DESC LIMIT 1
  241. Feb  6 00:01:06 [26-1] LOG:  execute pdo_stmt_0000000c: SELECT usr.username FROM group_member JOIN principal ON (principal_id=group_id) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 UNION SELECT usr.username FROM group_member LEFT JOIN grants ON (to_principal=group_id) JOIN principal ON (principal_id=by_principal) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 and by_principal != member_id ORDER BY 1
  242. Feb  6 00:01:06 [27-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000c
  243. Feb  6 00:01:06 [24-1] LOG:  execute pdo_stmt_0000000b: SELECT *, pprivs(2::int8,principal_id,2::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  244. Feb  6 00:01:06 [24-1] LOG:  execute pdo_stmt_0000000b: SELECT *, pprivs(2::int8,principal_id,2::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  245. Feb  6 00:01:06 [28-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000a
  246. Feb  6 00:01:06 [25-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000b
  247. Feb  6 00:01:06 [25-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000b
  248. Feb  6 00:01:06 [24-1] LOG:  execute pdo_stmt_0000000b: SELECT *, pprivs(2::int8,principal_id,2::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text('jtheilnielsen'))
  249. Feb  6 00:01:06 [29-1] LOG:  statement: DEALLOCATE pdo_stmt_00000003
  250. Feb  6 00:01:06 [30-1] LOG:  disconnection: session time: 0:00:00.029 user=davical_app database=davical host=[local]
  251. Feb  6 00:01:06 [25-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000b
  252. Feb  6 00:01:06 [26-1] LOG:  execute pdo_stmt_0000000c: SELECT usr.username FROM group_member JOIN principal ON (principal_id=group_id) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 UNION SELECT usr.username FROM group_member LEFT JOIN grants ON (to_principal=group_id) JOIN principal ON (principal_id=by_principal) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 and by_principal != member_id ORDER BY 1
  253. Feb  6 00:01:06 [26-1] LOG:  execute pdo_stmt_0000000c: SELECT usr.username FROM group_member JOIN principal ON (principal_id=group_id) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 UNION SELECT usr.username FROM group_member LEFT JOIN grants ON (to_principal=group_id) JOIN principal ON (principal_id=by_principal) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 and by_principal != member_id ORDER BY 1
  254. Feb  6 00:01:06 [27-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000c
  255. Feb  6 00:01:06 [28-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000a
  256. Feb  6 00:01:06 [27-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000c
  257. Feb  6 00:01:06 [28-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000a
  258. Feb  6 00:01:06 [26-1] LOG:  execute pdo_stmt_0000000c: SELECT usr.username FROM group_member JOIN principal ON (principal_id=group_id) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 UNION SELECT usr.username FROM group_member LEFT JOIN grants ON (to_principal=group_id) JOIN principal ON (principal_id=by_principal) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = 2 and by_principal != member_id ORDER BY 1
  259. Feb  6 00:01:06 [27-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000c
  260. Feb  6 00:01:06 [29-1] LOG:  statement: DEALLOCATE pdo_stmt_00000003
  261. Feb  6 00:01:06 [29-1] LOG:  statement: DEALLOCATE pdo_stmt_00000003
  262. Feb  6 00:01:06 [28-1] LOG:  statement: DEALLOCATE pdo_stmt_0000000a
  263. Feb  6 00:01:06 [30-1] LOG:  disconnection: session time: 0:00:00.030 user=davical_app database=davical host=[local]
  264. Feb  6 00:01:06 [30-1] LOG:  disconnection: session time: 0:00:00.028 user=davical_app database=davical host=[local]
  265. Feb  6 00:01:06 [29-1] LOG:  statement: DEALLOCATE pdo_stmt_00000003
  266. Feb  6 00:01:06 [30-1] LOG:  disconnection: session time: 0:00:00.030 user=davical_app database=davical host=[local]
  267. Feb  6 00:01:19 [4-1] LOG:  connection received: host=127.0.0.1 port=28399
  268. Feb  6 00:01:19 [5-1] LOG:  connection authorized: user=root database=root
  269. Feb  6 00:01:19 [6-1] LOG:  disconnection: session time: 0:00:00.003 user=root database=root host=127.0.0.1 port=28399
  270. Feb  6 00:01:19 [4-1] LOG:  connection received: host=[local]
  271. Feb  6 00:01:19 [5-1] LOG:  connection authorized: user=root database=root
  272. Feb  6 00:01:19 [6-1] LOG:  disconnection: session time: 0:00:00.003 user=root database=root host=[local]
  273. Feb  6 00:01:34 [4-1] LOG:  connection received: host=127.0.0.1 port=28404
  274. Feb  6 00:01:34 [5-1] LOG:  connection authorized: user=root database=root
  275. Feb  6 00:01:34 [6-1] LOG:  disconnection: session time: 0:00:00.003 user=root database=root host=127.0.0.1 port=28404
  276. Feb  6 00:01:34 [4-1] LOG:  connection received: host=[local]
  277. Feb  6 00:01:34 [5-1] LOG:  connection authorized: user=root database=root
  278. Feb  6 00:01:34 [6-1] LOG:  disconnection: session time: 0:00:00.003 user=root database=root host=[local]
  279. Feb  6 00:01:49 [4-1] LOG:  connection received: host=127.0.0.1 port=28409
  280. Feb  6 00:01:49 [5-1] LOG:  connection authorized: user=root database=root
  281. Feb  6 00:01:49 [6-1] LOG:  disconnection: session time: 0:00:00.003 user=root database=root host=127.0.0.1 port=28409
  282. Feb  6 00:01:49 [4-1] LOG:  connection received: host=[local]
  283. Feb  6 00:01:49 [5-1] LOG:  connection authorized: user=root database=root
  284. Feb  6 00:01:49 [6-1] LOG:  disconnection: session time: 0:00:00.003 user=root database=root host=[local]
  285. Feb  6 00:02:04 [4-1] LOG:  connection received: host=127.0.0.1 port=28415
  286. Feb  6 00:02:04 [5-1] LOG:  connection authorized: user=root database=root
  287. Feb  6 00:02:04 [6-1] LOG:  disconnection: session time: 0:00:00.003 user=root database=root host=127.0.0.1 port=28415
  288. Feb  6 00:02:04 [4-1] LOG:  connection received: host=[local]
  289. Feb  6 00:02:04 [5-1] LOG:  connection authorized: user=root database=root
  290. Feb  6 00:02:04 [6-1] LOG:  disconnection: session time: 0:00:00.003 user=root database=root host=[local]
  291. Feb  6 00:02:20 [4-1] LOG:  connection received: host=127.0.0.1 port=47867
  292. Feb  6 00:02:20 [5-1] LOG:  connection authorized: user=root database=root
  293. Feb  6 00:02:20 [6-1] LOG:  disconnection: session time: 0:00:00.003 user=root database=root host=127.0.0.1 port=47867
  294. Feb  6 00:02:20 [4-1] LOG:  connection received: host=[local]
  295. Feb  6 00:02:20 [5-1] LOG:  connection authorized: user=root database=root
  296. Feb  6 00:02:20 [6-1] LOG:  disconnection: session time: 0:00:00.003 user=root database=root host=[local]
  297. Feb  6 00:02:35 [4-1] LOG:  connection received: host=127.0.0.1 port=45230
  298. Feb  6 00:02:35 [5-1] LOG:  connection authorized: user=root database=root
  299. Feb  6 00:02:35 [6-1] LOG:  disconnection: session time: 0:00:00.003 user=root database=root host=127.0.0.1 port=45230
  300. Feb  6 00:02:35 [4-1] LOG:  connection received: host=[local]
  301. Feb  6 00:02:35 [5-1] LOG:  connection authorized: user=root database=root
  302. Feb  6 00:02:35 [6-1] LOG:  disconnection: session time: 0:00:00.003 user=root database=root host=[local]
  303. Feb  6 00:02:50 [4-1] LOG:  connection received: host=127.0.0.1 port=16869
  304. Feb  6 00:02:50 [5-1] LOG:  connection authorized: user=root database=root
  305. Feb  6 00:02:50 [6-1] LOG:  disconnection: session time: 0:00:00.003 user=root database=root host=127.0.0.1 port=16869
  306. Feb  6 00:02:50 [4-1] LOG:  connection received: host=[local]
  307. Feb  6 00:02:50 [5-1] LOG:  connection authorized: user=root database=root
  308. Feb  6 00:02:50 [6-1] LOG:  disconnection: session time: 0:00:00.003 user=root database=root host=[local]
  309. Feb  6 00:03:05 [4-1] LOG:  connection received: host=127.0.0.1 port=12993
  310. Feb  6 00:03:05 [5-1] LOG:  connection authorized: user=root database=root
  311. Feb  6 00:03:05 [6-1] LOG:  disconnection: session time: 0:00:00.003 user=root database=root host=127.0.0.1 port=12993
  312. Feb  6 00:03:05 [4-1] LOG:  connection received: host=[local]
  313. Feb  6 00:03:05 [5-1] LOG:  connection authorized: user=root database=root
  314. Feb  6 00:03:05 [6-1] LOG:  disconnection: session time: 0:00:00.003 user=root database=root host=[local]
  315. Feb  6 00:03:20 [4-1] LOG:  connection received: host=127.0.0.1 port=12999
  316. Feb  6 00:03:20 [5-1] LOG:  connection authorized: user=root database=root
  317. Feb  6 00:03:20 [6-1] LOG:  disconnection: session time: 0:00:00.003 user=root database=root host=127.0.0.1 port=12999
  318. Feb  6 00:03:20 [4-1] LOG:  connection received: host=[local]
  319. Feb  6 00:03:20 [5-1] LOG:  connection authorized: user=root database=root
  320. Feb  6 00:03:20 [6-1] LOG:  disconnection: session time: 0:00:00.003 user=root database=root host=[local]
  321. Feb  6 00:03:35 [4-1] LOG:  connection received: host=127.0.0.1 port=13004
  322. Feb  6 00:03:35 [5-1] LOG:  connection authorized: user=root database=root
  323. Feb  6 00:03:35 [6-1] LOG:  disconnection: session time: 0:00:00.003 user=root database=root host=127.0.0.1 port=13004
  324. Feb  6 00:03:35 [4-1] LOG:  connection received: host=[local]
  325. Feb  6 00:03:35 [5-1] LOG:  connection authorized: user=root database=root
  326. Feb  6 00:03:35 [6-1] LOG:  disconnection: session time: 0:00:00.003 user=root database=root host=[local]
  327. Feb  6 00:03:50 [4-1] LOG:  connection received: host=127.0.0.1 port=31378
  328. Feb  6 00:03:50 [5-1] LOG:  connection authorized: user=root database=root
  329. Feb  6 00:03:50 [6-1] LOG:  disconnection: session time: 0:00:00.003 user=root database=root host=127.0.0.1 port=31378
  330. Feb  6 00:03:50 [4-1] LOG:  connection received: host=[local]
  331. Feb  6 00:03:50 [5-1] LOG:  connection authorized: user=root database=root
  332. Feb  6 00:03:50 [6-1] LOG:  disconnection: session time: 0:00:00.003 user=root database=root host=[local]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement