Re: [xcat-user] New Service node cannot connect to Mariadb when starting xcatd

Bin XA Xu Sun, 21 Oct 2018 20:41:08 -0700

Okay, it means you cannot access your mariadb server on MN from this service node.

You can use `mysql -h 10.3.5.20 -u xcatadmin -D xcatdb -p` to verify it.

Are you configure your mariadb well to GRANT your service node IPs? (https://xcat-docs.readthedocs.io/en/stable/advanced/hierarchy/databases/mysql_configure.html?highlight=mysqlsetup)

You can use below command in mariadb shell to query the GRANT:

```

show grants for [email protected];
+------------------------------------------------------------------------------------------------------------------+
| Grants for [email protected] |
+------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'xcatadmin'@'10.3.5.20' IDENTIFIED BY PASSWORD '*359860933C260AB0F1316209DC2846250BAD59E3' |
| GRANT ALL PRIVILEGES ON `xcatdb`.* TO 'xcatadmin'@'10.3.5.20' |
+------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

```

You can use `mysqlsetup -u -f <clientip_list filename>` to add your service nodes, you just follow the mysql steps to do that.

Bin Xu

HPC Software Development
Software Defined Infrastructure, IBM Systems

Phone: 86-010-82454067

E-mail: [email protected]

----- Original message -----
From: Brian Joiner <[email protected]>
To: xCAT Users Mailing list <[email protected]>
Cc:
Subject: Re: [xcat-user] New Service node cannot connect to Mariadb when starting xcatd
Date: Fri, Oct 19, 2018 11:27 PM

Bin, heres the output:

[root@service01 ~]# XCATBYPASS=1 lsxcatd -a

Could not connect to the database. Database handle not defined.

Could not read the site table

Could not connect to the database. Database handle not defined.

Could not read the site table

Could not connect to the database. Database handle not defined.

Could not read the site table

Could not connect to the database. Database handle not defined.

Could not read the site table

Could not connect to the database. Database handle not defined.

Could not read the site table

Could not connect to the database. Database handle not defined.

Could not read the site table

Could not connect to the database. Database handle not defined.

Could not read the site table

Could not connect to the database. Database handle not defined.

Could not read the site table

Could not connect to the database. Database handle not defined.

Could not read the site table

Could not connect to the database. Database handle not defined.

Error loading module /opt/xcat/lib/perl/xCAT_plugin/zvmdiscovery.pm ...skipping

Could not connect to the database. Database handle not defined.

ERROR: Unable to open basic site table for configuration

Version 2.14.1 (git commit 70d6e7f93cc9714a127c22df2e7ca53d4996a34c, built Fri Jun 1 03:00:53 EDT 2018)

This is a Service Node

cfgloc=mysql:dbname=xcatdb;host=10.4.0.1|xcatadmin

dbengine=mysql

dbname=xcatdb

dbhost=10.4.0.1

dbadmin=xcatadmin

On Thu, Oct 18, 2018 at 9:34 PM Bin XA Xu <[email protected]> wrote:

could you run `XCATBYPASS=1 lsxcatd -a` on your service node and paste the output here?

Bin Xu

HPC Software Development
Software Defined Infrastructure, IBM Systems

Phone: 86-010-82454067

E-mail: [email protected]

----- Original message -----
From: Brian Joiner <[email protected]>
To: xCAT Users Mailing list <[email protected]>
Cc:
Subject: [xcat-user] New Service node cannot connect to Mariadb when starting xcatd
Date: Fri, Oct 19, 2018 5:45 AM

Hello,

I have deployed a service node, to the best of my knowledge, using the online documentation. I've decided to rsync the install and tftpboot folders to deploy nodes directly from it. rpm -qa shows the service node rpm was applied

Attempting to start the xcatd daemon on the service node hangs, the errors being

"Oct 18 16:22:18 service01 xcat[7109]: Could not connect to the database. Database handle not defined."

headnode hostname: xcat (I know, super original) 10.4.0.1/24

service node hostname: service01 10.4.0.2/24

I have verified:

Mariadb table setup is correct

I can connect manually to the database from the service node and update tables (using xcatadmin account)

DNS works

/etc/xcat/cfgloc file exactly the same as head node

tcpdump on port 3006 (on head node) shows no activity when starting xcatd on service node, but does show activity on above mentioned manual test

/etc/xCATSN exists

[root@xcat ~]# lsxcatd -d

cfgloc=mysql:dbname=xcatdb;host=10.4.0.1|xcatadmin

dbengine=mysql

dbname=xcatdb

dbhost=10.4.0.1

dbadmin=xcatadmin

What am I missing? Let me know if you need to see my tables.
--
Brian Joiner

_______________________________________________
xCAT-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/xcat-user

_______________________________________________
xCAT-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/xcat-user

--
Brian Joiner

_______________________________________________
xCAT-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/xcat-user

_______________________________________________
xCAT-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/xcat-user

Re: [xcat-user] New Service node cannot connect to Mariadb when starting xcatd

Reply via email to