Unable to create a 'ccrpc' user! Please check your s9s command line installation!
I am facing this error while installing clustercontrol.
Error:
Applying modifications from 'cmon_db.sql,cmon_db_mods_hotfix.sql,cmon_data.sql'.
Schema creation succeed (version 109073).
Verifying connection...
Initializing the user manager.
User manager is creating system users.
Checking that the system users exist.
Creating system groups: admins
Creating system groups: users
Creating system groups: nobody
Creating system user.
Creating nobody user.
Creating admin user.
Writing the configuration file.
2024-01-30 14:34:51 CET -- Starting the Controller process.
Synchronizing state of cmon.service with SysV service script with /lib/systemd/systemd-sysv-install.
Executing: /lib/systemd/systemd-sysv-install enable cmon
Reading package lists... Done
Building dependency tree
Reading state information... Done
s9s-tools is already the newest version (1.9.2023112922-release1).
0 upgraded, 0 newly installed, 0 to remove and 91 not upgraded.
2024-01-30 14:35:02 CET -- Create ccrpc user ...
Username or password is incorrect.
2024-01-30 14:35:02 CET -- *** Unable to create a 'ccrpc' user! Please check your s9s command line installation! ***
2024-01-30 14:35:02 CET -- *** Please see https://docs.severalnines.com/docs/clustercontrol/troubleshooting/common-issues/#clustercontrol-controller-cmon on how fix a suspended s9s admin user.
2024-01-30 14:35:02 CET -- *** Re-install the ClusterControl package again after checking the s9s command line installation.
Please contact Severalnines support at http://support.severalnines.com if you have installation issues that cannot be resolved.
Steps already followed:
root@cladev-dd01-mg:~# mv ~/.s9s/s9s.conf ~/.s9s/s9s.conf.bak
mv: cannot stat '/root/.s9s/s9s.conf': No such file or directory
root@cladev-dd01-mg:~# mv /etc/s9s.conf /etc/s9s.conf.bak
root@cladev-dd01-mg:~# s9s user --create --generate-key --controller="https://localhost:9501" --group=admins dba
Username or password is incorrect.
root@cladev-dd01-mg:~# s9s user --create --new-password=89b89da5623f92efaaea7bd3b380976ed1141c4c --generate-key --private-key-file==$HOME/.s9s/ccrpc.key --group=admins --controller=https://localhost:9501 ccrpc
Grant user 'ccrpc' succeeded.
root@cladev-dd01-mg:~# s9s user --set --first-name=RPC --last-name=API --cmon-user=ccrpc &>/dev/null
root@cladev-dd01-mg:~# ps -ef | grep cmon
root 3610347 1 88 14:34 ? 00:21:36 /usr/sbin/cmon --rpc-port=9500 --bind-addr= --events-client=http://127.0.0.1:9510 --cloud-service=http://127.0.0.1:9518
root 3612845 3597498 0 14:59 pts/0 00:00:00 grep --color=auto cmon
root@cladev-dd01-mg:~# ps -ef | grep mysql
mysql 2363983 1 0 Jan22 ? 01:23:38 /usr/sbin/mysqld
root 3612866 3597498 0 14:59 pts/0 00:00:00 grep --color=auto mysql
root@cladev-dd01-mg:~# netstat -pltn
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 127.0.0.1:27017 0.0.0.0:* LISTEN 533/mongod
tcp 0 0 10.130.0.219:27017 0.0.0.0:* LISTEN 533/mongod
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 2363983/mysqld
tcp 0 0 127.0.0.53:53 0.0.0.0:* LISTEN 499/systemd-resolve
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 547/sshd: /usr/sbin
tcp 0 0 127.0.0.1:9500 0.0.0.0:* LISTEN 3610347/cmon
tcp 0 0 127.0.0.1:9501 0.0.0.0:* LISTEN 3610347/cmon
tcp 0 0 10.130.0.219:10050 0.0.0.0:* LISTEN 1782975/zabbix_agen
tcp 0 0 127.0.0.1:33060 0.0.0.0:* LISTEN 2363983/mysqld
tcp6 0 0 :::80 :::* LISTEN 3443228/apache2
tcp6 0 0 :::22 :::* LISTEN 547/sshd: /usr/sbin
tcp6 0 0 :::443 :::* LISTEN 3443228/apache2
cmon.log Logs :
2024-01-30T14:34:51.236+01:00 : (INFO) Additional RPC URL for events: 'http://127.0.0.1:9510'
4559 2024-01-30T14:34:51.236+01:00 : (INFO) The Cmon Controller is initializing.
4560 2024-01-30T14:34:55.494+01:00 : (INFO) Thread EventLoop is running (LWP 3610348).
4561 2024-01-30T14:34:55.494+01:00 : (INFO) Thread Logger is running (LWP 3610349).
4562 2024-01-30T14:34:55.494+01:00 : (INFO) Loading configuration file '/etc/cmon.cnf'.
4563 2024-01-30T14:34:56.349+01:00 : (INFO) Found 0 CmonHA log files.
4564 2024-01-30T14:34:56.349+01:00 : (INFO) Scanning CmonHa log entries.
4565 2024-01-30T14:34:56.349+01:00 : (INFO) Scanning log entries (100%).
4566 2024-01-30T14:34:56.350+01:00 : (INFO) Configuration loaded.
4567 2024-01-30T14:34:56.351+01:00 : (INFO) CmonHA is not active, not starting cluster for '/etc/cmon.cnf'.
4568 2024-01-30T14:34:56.351+01:00 : (INFO) Loaded configuration file '/etc/cmon.cnf'.
4569 2024-01-30T14:34:56.355+01:00 : (INFO) Checking if CmonDb access is working properly.
4570 2024-01-30T14:34:56.357+01:00 : (INFO) Connection to CmonDb is working.
4571 2024-01-30T14:34:56.357+01:00 : (INFO) Initializing the user manager.
4572 2024-01-30T14:34:56.357+01:00 : (INFO) User manager is creating system users.
4573 2024-01-30T14:34:56.357+01:00 : (INFO) Checking that the system users exist.
4574 2024-01-30T14:34:56.360+01:00 : (INFO) Starting user manager thread.
4575 2024-01-30T14:34:56.361+01:00 : (INFO) CmonRpcServerPrivate::log()
4576 2024-01-30T14:34:56.361+01:00 : (INFO) Server started at tcp://127.0.0.1:9500
4577 2024-01-30T14:34:56.362+01:00 : (INFO) CmonRpcServerPrivate::log()
4578 2024-01-30T14:34:56.362+01:00 : (INFO) Server started at tls://127.0.0.1:9501
4579 2024-01-30T14:34:56.362+01:00 : (INFO) Thread RpcServer:9500 is running (LWP 3610393).
4580 2024-01-30T14:34:56.362+01:00 : (INFO) Thread RpcServer:9501 is running (LWP 3610394).
4581 2024-01-30T14:34:56.362+01:00 : (INFO) Checking command handler.
4582 2024-01-30T14:34:56.363+01:00 : (INFO) Thread UserManager is running (LWP 3610392).
4583 2024-01-30T14:34:56.370+01:00 : (INFO) CDT entry '/.runtime/controller_clock' found.
4584 2024-01-30T14:34:58.984+01:00 : (INFO) Checking Zip requirement: zip
4585 2024-01-30T14:34:59.834+01:00 : (INFO) Starting main loop.
4586 2024-01-30T14:34:59.834+01:00 : (INFO) Initializing controller manager.
4587 2024-01-30T14:34:59.836+01:00 : (INFO) Cmon HA is disabled, running in single mode.
4588 2024-01-30T14:34:59.837+01:00 : (INFO) : Controller state change from CmonControllerStarting to CmonControllerStandalone with message 'Starting without any controller host object.'.
4589 2024-01-30T14:34:59.837+01:00 : (INFO) Starting the command handler.
4590 2024-01-30T14:34:59.837+01:00 : (INFO) s9s_thread_func is running (LWP 3610435) (CID 0).
4591 2024-01-30T14:34:59.837+01:00 : (INFO) : Controller is standalone state now.
4592 2024-01-30T14:34:59.837+01:00 : (INFO) Thread CommandHandler is running (LWP 3610436).
4593 2024-01-30T14:34:59.838+01:00 : (INFO) Starting main loop.
4594 2024-01-30T14:34:59.838+01:00 : (INFO) Starting CmonCommandHandler.
4595 2024-01-30T14:34:59.839+01:00 : (INFO) The Cmon version is 1.9.7.7465.
4596 2024-01-30T14:34:59.847+01:00 : (INFO) CmonDb database is 'cmon' with schema version 109073.
4597 2024-01-30T14:34:59.847+01:00 : (INFO) Running cmon schema hot-fixes.
4598 2024-01-30T14:34:59.848+01:00 : (INFO) Applying modifications from 'cmon_db_mods-1.9.6-1.9.7.sql,cmon_db_mods_hotfix.sql'.
4599 2024-01-30T14:35:03.376+01:00 : (INFO) Schema auto-upgrade succeed (version 109073).
4600 2024-01-30T14:35:03.405+01:00 : (INFO) Checked tables - everything is ok.
4601 2024-01-30T14:35:03.428+01:00 : (INFO) License is community version.
4602 2024-01-30T14:35:03.429+01:00 : (INFO) CmonCommandHandler started, will execute jobs.
4603 2024-01-30T14:35:03.429+01:00 : (INFO) Aborting DEQUEUED, RUNNING and DEFINED jobs.
4604 2024-01-30T14:37:48.162+01:00 : (INFO) Creating new cmon user 'ccrpc'.
-
Official comment
Hi,
Sorry for this issue. It's a known issue and you can run this script to fix it:
/var/www/html/clustercontrol/app/tools/reset-ccrpc.sh
If it doesn't solve the problem or you don't have the script, you can run the following commands to fix it manually:
- Move s9s.conf:
$ mv /etc/s9s.conf ~/.s9s/s9s.conf /tmp
- Re-create admin user:
$ s9s user --create --generate-key --controller="https://localhost:9501" --group=admins admin
- Then create ccrpc user
$ s9s user --create --generate-key --group=admins --controller=https://localhost:9501 ccrpc
Also, please, check if you have all the ClusterControl packages in place. You should have something like this:
- clustercontrol 1.9.7-8653
- clustercontrol-cloud 1.9.7-395
- clustercontrol-clud 1.9.7-395
- clustercontrol-controller 1.9.7-7128
- clustercontrol-notifications 1.9.7-339
- clustercontrol-ssh 1.9.7-151
- clustercontrol2 2.0.0-1135
If yes, you should be able to access the ClusterControl UI in a web browser. Otherwise, you can create a support ticket and somebody from the Severalnines support team will help you to make it work.
Regards,
Sebastian.
Comment actions -
I tried but it still unable to open clustercontrol UI from browser
root@cladev-dd01-mg:~#
root@cladev-dd01-mg:~# sh /var/www/html/clustercontrol/app/tools/reset-ccrpc.sh
sh: /var/www/html/clustercontrol/app/tools/reset-ccrpc.sh: No such file or direc tory
root@cladev-dd01-mg:~# mv /etc/s9s.conf ~/.s9s/s9s.conf /tmp
mv: cannot stat '/etc/s9s.conf': No such file or directory
mv: cannot stat '/root/.s9s/s9s.conf': No such file or directory
root@cladev-dd01-mg:~# s9s user --create --generate-key --controller="https://l ocalhost:9501" --group=admins admin
Grant user 'admin' succeeded.
root@cladev-dd01-mg:~# s9s user --create --generate-key --group=admins --control ler=https://localhost:9501 ccrpc
User 'ccrpc' already exists.
root@cladev-dd01-mg:~# apt-get list | grep -i clustercontrol
E: Invalid operation list
root@cladev-dd01-mg:~# apt list | grep -i clustercontrolWARNING: apt does not have a stable CLI interface. Use with caution in scripts.
clustercontrol-cloud/ubuntu,now 1.9.7-395 amd64 [installed,automatic]
clustercontrol-clud/ubuntu,now 1.9.7-395 amd64 [installed,automatic]
clustercontrol-controller-dbg/ubuntu 1.9.7-7465 amd64
clustercontrol-controller/ubuntu,now 1.9.7-7465 amd64 [installed]
clustercontrol-nodejs/ubuntu 1.4.1-86 amd64
clustercontrol-notifications/ubuntu,now 1.9.7-339 amd64 [installed,automatic]
clustercontrol-ssh/ubuntu,now 1.9.7-151 amd64 [installed,automatic]
clustercontrol2/ubuntu,now 2.0.0-1161 amd64 [installed]
clustercontrol/ubuntu,now 1.9.7-8653 amd64 [residual-config]
root@cladev-dd01-mg:~# -
Hi,
Sorry for the delay.
Can you open a ticket with us here, please? https://severalnines.zendesk.com/hc/en-us/requests/new
Also, please add the output of the following command on that ticket:
$ netstat -pltn
Thank you.
-
root@cladev-dd01-mg:~# netstat -pltn
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 127.0.0.1:27017 0.0.0.0:* LISTEN 533/mongod
tcp 0 0 10.130.0.219:27017 0.0.0.0:* LISTEN 533/mongod
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 2363983/mysqld
tcp 0 0 127.0.0.53:53 0.0.0.0:* LISTEN 499/systemd-resolve
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 547/sshd: /usr/sbin
tcp 0 0 127.0.0.1:9500 0.0.0.0:* LISTEN 3624167/cmon
tcp 0 0 127.0.0.1:9501 0.0.0.0:* LISTEN 3624167/cmon
tcp 0 0 10.130.0.219:10050 0.0.0.0:* LISTEN 280610/zabbix_agent
tcp 0 0 127.0.0.1:33060 0.0.0.0:* LISTEN 2363983/mysqld
tcp6 0 0 :::80 :::* LISTEN 654361/apache2
tcp6 0 0 :::22 :::* LISTEN 547/sshd: /usr/sbin
tcp6 0 0 :::443 :::* LISTEN 654361/apache2
root@cladev-dd01-mg:~#
Please sign in to leave a comment.
Comments
4 comments