Ask Your Question
0

HP Helion mysql password

asked 2014-08-07 04:48:51 -0500

Sarbajit gravatar image

I want to check database tables for nova (overcloud) for some development work. But can't find the MySQL password. I am using HP Helion Community Edition 1.3.0.

Where can I find the MySQL password for Helion overcloud?

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted
0

answered 2014-08-07 09:37:29 -0500

SQL passwords are generated. You can have a look at respective conf file. e.g seed keystone mysql password can be found at /etc/keystone/keystone.conf file

If you want root password, check the password file which is part of distribution. There will be a password file for overcloud and undercloud

edit flag offensive delete link more

Comments

I could find the keystone password from the file you have mentioned. But, there is no MySQL password entry in tripleo-overcloud-passwords or tripleo-undercloud-passwords file. Where the root password can be found?

Sarbajit gravatar imageSarbajit ( 2014-08-07 11:52:20 -0500 )edit
In  conf file there is a section for sql connection, which will have sql password.

e.g
[sql]
connection = mysql:// <username>:<password>@localhost/keystone

This is true for all the services. You can check nova's password in nova.conf

I thought you will have root password  in password file, Can you  do grep -i  mysql in the password file?
Haneef Ali gravatar imageHaneef Ali ( 2014-08-07 12:59:25 -0500 )edit

I did a grep on whole triplo directory for "mysql", as you mentioned. But, no occurrences has listed root password. There are entries like

mysql:// <username>:<password>@localhost/<service name>

for each OpenStack service. All passwords for service databases are visible but, not the root.

Sarbajit gravatar imageSarbajit ( 2014-08-07 13:45:42 -0500 )edit

Can you check one more thing?

Login to seed and check there 
$ssh root@192.0.2.1
$cd /root/tripleo
$ // There should be a password file here and most probably the root password will be there

Haneef Ali gravatar imageHaneef Ali ( 2014-08-07 15:52:24 -0500 )edit

I checked tripleo-overcloud-passwords and tripleo-undercloud-passwords file present in /root/triplo of seed machine, it does not have any root password.

Which other file I can check?

Sarbajit gravatar imageSarbajit ( 2014-08-08 01:53:28 -0500 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

Stats

Asked: 2014-08-07 04:48:51 -0500

Seen: 480 times

Last updated: Aug 07 '14