Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 33BBD200CFD for ; Wed, 6 Sep 2017 20:40:16 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 324B81609C5; Wed, 6 Sep 2017 18:40:16 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 78B091609BB for ; Wed, 6 Sep 2017 20:40:15 +0200 (CEST) Received: (qmail 51685 invoked by uid 500); 6 Sep 2017 18:40:13 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 51675 invoked by uid 99); 6 Sep 2017 18:40:13 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Sep 2017 18:40:13 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id B8193181273 for ; Wed, 6 Sep 2017 18:40:12 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -2.401 X-Spam-Level: X-Spam-Status: No, score=-2.401 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-2.8, RCVD_IN_SORBS_SPAM=0.5, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id njfBGgwjNM1S for ; Wed, 6 Sep 2017 18:40:07 +0000 (UTC) Received: from mail-pf0-f169.google.com (mail-pf0-f169.google.com [209.85.192.169]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 637CE60D53 for ; Wed, 6 Sep 2017 18:40:07 +0000 (UTC) Received: by mail-pf0-f169.google.com with SMTP id e199so14051392pfh.3 for ; Wed, 06 Sep 2017 11:40:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:content-transfer-encoding:mime-version:subject:date:references :to:in-reply-to:message-id; bh=yL79fDNsBbsgXwh6oI3xzpiqqFo2op8wD6HUw44z410=; b=Qtklhj2OoppKxhSEJR7l2dNiOsAYhkfQi2gy4cySzfKY7fZUwNCPMeTjaPsay35PyU rcPhDZn+w4SElzo9B0MTUEwdwODVO54vx2txCD2uN0IWITbkxz6aAfYh2EalINMOd9lL HtrbHNMJCIMyjkPvk+TzGrL8Y0rTgpC0a5pX8hLoBj97rYNkUHyH7WRsXXZU0JVDSKJC k0AnIlWdNaN1lqjnC7iWtvCuRsOzHdh4rf25sWvPP0K6ktzPfw7jUC3or1jFBPKlqIO8 p72x4OlTs4F3WPedi0qzWNn6RyGZFzgCVp+zNDlq4K0MHAZmtw4+cbJCPRTU5gDVxFRZ SkgA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:content-transfer-encoding:mime-version :subject:date:references:to:in-reply-to:message-id; bh=yL79fDNsBbsgXwh6oI3xzpiqqFo2op8wD6HUw44z410=; b=dwvTuUxGv824i2l9GTi1epElio+RH4cQ6WojG6PfyUGkCLrzb1wJ+LbBIembRu+ixU RTSf1YgX8YR5lZoVNTDgg8xNbs/UPhdCJQaFW4Vk8PkuCZR4YurCS0ntyzITkX2iK4pr ZIwlkZdhP95KdTYpQJDE/X+xlbuWzNP0yjWl8Ty4ZgbnglWUfI2V6TqWi+IYZnTa0AIK iXoFCs8rEjxr3DYf9mcaSnziLtAq5JuqWfO0zJoIc4JWexRW0jLVJSqlyYtjHp1Nz3bi 4TeZjr33aO2R0H+/9R1U8U315ZIPr6FiwW6qUR2OU7olS00EsSDsNJVp474m/iqaFQCM ISGw== X-Gm-Message-State: AHPjjUh2AhamnPSpbxwqYge+zg5RggDGsT4iScrsXim8EBYyWhlgwC/N XYYnL8uuX7vpTMu1i1k= X-Google-Smtp-Source: ADKCNb6R5eLnzBEH6NPvWm9rYuF4BMyqYjICLlxEg2VXxciM307TLAKPxON3xjswMxPUobMaOUMiQQ== X-Received: by 10.99.8.3 with SMTP id 3mr123181pgi.6.1504723205518; Wed, 06 Sep 2017 11:40:05 -0700 (PDT) Received: from rustyrazorblade.fios-router.home ([47.144.153.239]) by smtp.gmail.com with ESMTPSA id q6sm486344pgp.58.2017.09.06.11.40.04 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Wed, 06 Sep 2017 11:40:04 -0700 (PDT) From: Jon Haddad Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Mac OS X Mail 10.3 \(3273\)) Subject: Re: C* 3 node issue -Urgent Date: Wed, 6 Sep 2017 11:40:02 -0700 References: <051D8450D5E7B340978CDEAEB0AEC843941B5A@EUSLMBX01.ldnoffice.tradeweb.com> <051D8450D5E7B340978CDEAEB0AEC843941BF8@EUSLMBX01.ldnoffice.tradeweb.com> <051D8450D5E7B340978CDEAEB0AEC843941EFA@EUSLMBX01.ldnoffice.tradeweb.com> <40331CDD-E92A-4821-B678-D5A2B7329959@gmail.com> <95710aa5-27cd-0e72-0e6c-7de621708996@sapo.pt> To: user@cassandra.apache.org In-Reply-To: <95710aa5-27cd-0e72-0e6c-7de621708996@sapo.pt> Message-Id: X-Mailer: Apple Mail (2.3273) archived-at: Wed, 06 Sep 2017 18:40:16 -0000 I wouldn=E2=80=99t worry about being meticulous about keeping RF =3D N = as the cluster grows. If you had 60 nodes and your auth data was only = on 9 you=E2=80=99d be completely fine. =20 > On Sep 6, 2017, at 11:36 AM, Cogumelos Maravilha = wrote: >=20 > After insert a new node we should: >=20 > ALTER KEYSPACE system_auth WITH REPLICATION =3D { 'class' : ... > 'replication_factor' : x }; >=20 > x =3D number of nodes in dc >=20 > The default user and password should work: > -u cassandra -p cassandra >=20 > Cheers. >=20 > On 23-08-2017 11:14, kurt greaves wrote: >> The cassandra user requires QUORUM consistency to be achieved for >> authentication. Normal users only require ONE. I suspect your >> system_auth keyspace has an RF of 1, and the node that owns the >> cassandra users data is down. >>=20 >> Steps to recover: >> 1. Turn off authentication on all the nodes >> 2. Restart the nodes and make sure they are UN >> 3. Alter system_auth to have a higher RF than 1 (3 is probably >> appropriate) >> 4. Turn auth back on and restart >> 5. Create a new user and use that from now on. >>=20 >> =E2=80=8B >=20 >=20 > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org > For additional commands, e-mail: user-help@cassandra.apache.org >=20 --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org For additional commands, e-mail: user-help@cassandra.apache.org