It looks like everything is setup correctly:
[root@service01 ~]# mysql -h 10.4.0.1 -u xcatadmin -D xcatdb -p
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 5
Server version: 5.5.56-MariaDB MariaDB Server
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
MariaDB [xcatdb]> show grants for xcatadmin@10.4.0.1
-> ;
+-----------------------------------------------------------------------------------------------------------------+
| Grants for xcatadmin@10.4.0.1
|
+-----------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'xcatadmin'@'10.4.0.1' IDENTIFIED BY PASSWORD
'*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19' |
| GRANT ALL PRIVILEGES ON `xcatdb`.* TO 'xcatadmin'@'10.4.0.1'
|
+-----------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
MariaDB [xcatdb]>
On Sun, Oct 21, 2018 at 10:40 PM Bin XA Xu <bx...@cn.ibm.com> wrote:
> 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 xcatadmin@10.3.5.20;
>
> +------------------------------------------------------------------------------------------------------------------+
> | Grants for xcatadmin@10.3.5.20
> |
>
> +------------------------------------------------------------------------------------------------------------------+
> | 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: bx...@cn.ibm.com
>
>
>
> ----- Original message -----
> From: Brian Joiner <martinitime1...@gmail.com>
> To: xCAT Users Mailing list <xcat-user@lists.sourceforge.net>
> 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 <bx...@cn.ibm.com> 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: bx...@cn.ibm.com
>
>
>
> ----- Original message -----
> From: Brian Joiner <martinitime1...@gmail.com>
> To: xCAT Users Mailing list <xcat-user@lists.sourceforge.net>
> 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
> xCAT-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/xcat-user
>
>
>
> _______________________________________________
> xCAT-user mailing list
> xCAT-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/xcat-user
>
>
>
> --
> Brian Joiner
> _______________________________________________
> xCAT-user mailing list
> xCAT-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/xcat-user
>
>
>
> _______________________________________________
> xCAT-user mailing list
> xCAT-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/xcat-user
>
--
Brian Joiner
_______________________________________________
xCAT-user mailing list
xCAT-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/xcat-user
