<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=iso-8859-2"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.E-mailStlus17
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.E-mailStlus18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=HU link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D'>Found the issue… if you specify just one <i>contact_point</i>(s) and it’s not 127.0.0.1, than you must set <i>consistency</i> to ’one’, instead of the default ’quorum’.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='mso-fareast-language:HU'>From:</span></b><span style='mso-fareast-language:HU'> Kea-users [mailto:kea-users-bounces@lists.isc.org] <b>On Behalf Of </b>Dajka Tamás<br><b>Sent:</b> Monday, January 6, 2020 9:15 AM<br><b>To:</b> Kea-users@lists.isc.org<br><b>Subject:</b> [Kea-users] Cassandra broken in latest?<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Hi all,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’ve built latest KEA from source (github), but connecting to Cassandra seems to be broken. Error message:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>2020-01-06 08:57:17.544 ERROR [kea-dhcp6.dhcp6/28607] DHCP6_CONFIG_LOAD_FAIL configuration error using file: /etc/kea/kea-dhcp6.conf, reason: Unable to open database: Statement GET_VERSION failed, Kea error: CqlExchange::executeSelect(): cass_session_execute() != CASS_OK, Cassandra error code: Read timeout, Cassandra future error: Operation timed out - received only 1 responses.<o:p></o:p></p><p class=MsoNormal>2020-01-06 08:57:17.545 ERROR [kea-dhcp6.dhcp6/28607] DHCP6_INIT_FAIL failed to initialize Kea server: configuration error using file '/etc/kea/kea-dhcp6.conf': Unable to open database: Statement GET_VERSION failed, Kea error: CqlExchange::executeSelect(): cass_session_execute() != CASS_OK, Cassandra error code: Read timeout, Cassandra future error: Operation timed out - received only 1 responses.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Keyspace is there, I’ve initialized/upgraded tables with kea-admin; cqlsh from KEA host to remote Cassandra host works:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>[cqlsh 5.0.1 | Cassandra 3.11.5 | CQL spec 3.4.4 | Native protocol v4]<o:p></o:p></p><p class=MsoNormal>Use HELP for help.<o:p></o:p></p><p class=MsoNormal>cqlsh> use keadhcpv6;<o:p></o:p></p><p class=MsoNormal>cqlsh:keadhcpv6> SELECT version, minor FROM schema_version;<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>version | minor<o:p></o:p></p><p class=MsoNormal>---------+-------<o:p></o:p></p><p class=MsoNormal> 5 | 0<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>(1 rows)<o:p></o:p></p><p class=MsoNormal>cqlsh:keadhcpv6><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>DataStax driver used 2.14.1.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>After doing some tcpdump, it seems that the statement „SELECT version, minor FROM schema_version;” is sent to Cassandra, but only PREPARED (and not executed afterwards). (Cassandra responses prepared (4) to query, but only noop is sent by KEA afterwards)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Did I miss something or just misconfigured?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> Tom<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>