You can probably ignore this, since we need to fix & rewrite the ipsec stuff at some point.

adam.

On 08/02/2016 01:46:20, peter.hine@familycourt.gov.au <peter.hine@familycourt.gov.au> wrote:


turned of the STRICT setting like a previous post, now getting

[2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 -
Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO
`ipsec_tunnels` (`device_id`
,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','')
[2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 -
Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO
`ipsec_tunnels` (`device_id`
,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','')
[2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 -
Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO
`ipsec_tunnels` (`device_id`
,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','')
[2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 -
Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO
`ipsec_tunnels` (`device_id`
,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','')
[2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 -
Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO
`ipsec_tunnels` (`device_id`
,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','')
[2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 -
Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO
`ipsec_tunnels` (`device_id`
,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','')
[2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 -
Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO
`ipsec_tunnels` (`device_id`
,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','')
[2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 -
Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO
`ipsec_tunnels` (`device_id`
,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','')
[2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 -
Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO
`ipsec_tunnels` (`device_id`
,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','')
[2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 -
Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO
`ipsec_tunnels` (`device_id`
,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','')
[2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 -
Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO
`ipsec_tunnels` (`device_id`
,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','')

device_id appears to be a unique index but it appears multiple times in the
table.
(Embedded image moved to file: pic25943.gif)
(Embedded image moved to file: pic03133.gif)

thanks

Peter Hine
Senior Technical Support Engineer (Servers)
FCoA ITS
peter.hine@familycourt.gov.au

**********************************************************************
The information contained in this e-mail (including any attachments)
is for the exclusive use of the addressee. If you are not the intended
recipient please notify the sender immediately and delete this e-mail.
It is noted that legal privilege is not waived because you have read
this e-mail.
**********************************************************************

_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium