ca0 rpki-ca 0.6189 some daemons do not start

[sraustein]

installed 0.6189 restarted mysql-server stopped all rpki-ca daemons only irbdb and rootd will start

{{{ ca0.rpki.net:/root# service rpki-ca start ca0.rpki.net:/root# psg rpki.conf root 93024 0.7 3.8 166720 39128 - Ss 9:54PM 0:00.24 /usr/local/bin/python2.7 /usr/local/libexec/irdbd --config /usr/local/etc/rpki.conf --log-level warning --log-syslog daemon root 93030 0.3 2.5 138756 25868 - Ss 9:54PM 0:00.00 /usr/local/bin/python2.7 /usr/local/libexec/rootd --config /usr/local/etc/rpki.conf --log-level warning --log-syslog daemon }}}

Trac ticket #781 component rpkid priority critical, owner sra, created by randy on 2015-11-23T21:57:58Z, last modified 2015-11-24T09:33:56Z

[sraustein]

only irbdb and rootd will start

And the logs say...?

Trac comment by sra on 2015-11-23T22:15:11Z

[sraustein]

{{{ ca0.rpki.net:/root# /usr/local/libexec/pubd --config /usr/local/etc/rpki.conf --log-level debug --log-stderr --foreground Traceback (most recent call last): File "/usr/local/libexec/pubd", line 21, in rpki.pubd.main() File "/usr/local/lib/python2.7/site-packages/rpki/pubd.py", line 86, in init self.main() File "/usr/local/lib/python2.7/site-packages/rpki/pubd.py", line 93, in main self.sql = rpki.sql.session(self.cfg) File "/usr/local/lib/python2.7/site-packages/rpki/sql.py", line 73, in init self.connect() File "/usr/local/lib/python2.7/site-packages/rpki/sql.py", line 85, in connect self.execute("charset = latin1") File "/usr/local/lib/python2.7/site-packages/rpki/sql.py", line 108, in execute return self._wrap_execute(self.cur.execute, query, args) File "/usr/local/lib/python2.7/site-packages/rpki/sql.py", line 101, in _wrap_execute return func(query, args) File "/usr/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute self.errorhandler(self, exc, value) File "/usr/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue _mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'charset = latin1' at line 1")

ca0.rpki.net:/root# pkg info mysql* mysql55-client-5.5.46 mysql55-server-5.5.46 }}}

So the syntax which works in MySQL 5.6 (at least, it seemed to work when I tried it a few hours ago, will re-test) to suppress the UTF8 errors causes MySQL 5.5 to blow the connection. Lovely.

Trac comment by sra on 2015-11-23T22:21:30Z

[sraustein]

In [changeset:"6190" 6190]: {{{

!CommitTicketReference repository="" revision="6190"

Kludge that works around characterset madness with MySQL 5.6 breaks MySQL 5.5, so try the kludge, whine if it fails, then blunder ahead. Fixes #781. }}}

Trac comment by sra on 2015-11-23T22:31:50Z

[sraustein]

{{{ ca0.rpki.net:/root# psg rpki.conf root 71502 2.3 3.9 166720 39504 - Ss 9:30AM 0:00.25 /usr/local/bin/python2.7 /usr/local/libexec/irdbd --config /usr/local/etc/rpki.conf --log-level warning --log-syslog daemon root 71504 1.1 2.6 138768 26460 - Ss 9:30AM 0:00.01 /usr/local/bin/python2.7 /usr/local/libexec/rpkid --config /usr/local/etc/rpki.conf --log-level warning --log-syslog daemon root 71506 1.1 2.5 138244 25964 - Ss 9:30AM 0:00.01 /usr/local/bin/python2.7 /usr/local/libexec/pubd --config /usr/local/etc/rpki.conf --log-level warning --log-syslog daemon root 71508 1.1 2.6 138756 26232 - Ss 9:30AM 0:00.00 /usr/local/bin/python2.7 /usr/local/libexec/rootd --config /usr/local/etc/rpki.conf --log-level warning --log-syslog daemon }}}

Trac comment by randy on 2015-11-24T09:33:56Z

[sraustein]

Closed with resolution fixed