The plot thickens!
MariaDB [xcatdb]> show grants for xcatadmin@10.4.0.2;
ERROR 1141 (42000): There is no such grant defined for user 'xcatadmin' on
host '10.4.0.2'
But shouldn't this cover it:
MariaDB [xcatdb]> show grants for xcatadmin
-> ;
+----------------------------------------------------------------------------------------------------------+
| Grants for xcatadmin@%
|
+----------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'xcatadmin'@'%' IDENTIFIED BY PASSWORD
'*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19' |
+----------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
On Mon, Oct 22, 2018 at 5:21 PM Kevin Keane <kke...@sandiego.edu> wrote:
> I might also try "show grants for xcatadmin@10.4.0.2" - the show grants
> you used will only tell you what permissions the MN has, but you are
> interested in the service node.
>
> _______________________________________________________________________
> Kevin Keane | Systems Architect | University of San Diego ITS |
> kke...@sandiego.edu
> Maher Hall, 192 |5998 Alcalá Park | San Diego, CA 92110-2492 |
> 619.260.6859
>
> *REMEMBER! **No one from IT at USD will ever ask to confirm or supply
> your password*.
> These messages are an attempt to steal your username and password. Please
> do not reply to, click the links within, or open the attachments of these
> messages. Delete them!
>
>
>
>
> On Mon, Oct 22, 2018 at 3:06 PM Brian Joiner <martinitime1...@gmail.com>
> wrote:
>
>> 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
>>
> _______________________________________________
> 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
