Vitaly Brodetskyi created AMBARI-4125:
-----------------------------------------
Summary: Ambari MySQL should not configure schema automatically
Key: AMBARI-4125
URL: https://issues.apache.org/jira/browse/AMBARI-4125
Project: Ambari
Issue Type: Task
Components: agent
Reporter: Vitaly Brodetskyi
*STR:*
1. Install and start MySQL server on first host of cluster.
2. Create MySQL DB:
{code}
mysql -u root
CREATE DATABASE testdb;
quit
{code}
3. Create user and grant all privileges to him:
{code}
mysql -u root
CREATE USER 'someuser'@'localhost' IDENTIFIED BY 'somepassword';
GRANT ALL PRIVILEGES ON *.* TO 'someuser'@'c6401.ambari.apache.org';
FLUSH PRIVILEGES;
quit
{code}
4. Install Ambari server.
5. Install mysql-connector-java.
6. Perform ambari-server setup.
During setup, when user selects...
- Advanced database configuration = y
- Option 3 for MySQL
- After entering host, port, schema, user, password, ambari setup should
validate those entries by connecting to the mysql database, confirm schema has
been created (do NOT create automatically) and then save the connection
properties and continue setup
*Actual result:*
{code}
[root@c6401 ~]# ambari-server setup
Using python /usr/bin/python2.6
Setup ambari-server
Checking SELinux...
SELinux status is 'disabled'
Ambari-server daemon is configured to run under user 'root'. Change this
setting [y/n] (n)? n
Adjusting ambari-server permissions and ownership...
Checking iptables...
Checking JDK...
JCE Policy archive already exists, using
/var/lib/ambari-server/resources/jce_policy-6.zip
Completing setup...
Configuring database...
Enter advanced database configuration [y/n] (n)? y
==============================================================================
Choose one of the following options:
[1] - PostgreSQL (Embedded)
[2] - Oracle
[3] - MySQL
==============================================================================
Enter choice (1): 3
Hostname (localhost): localhost
Port (3306):
Schema Name (ambari): testdb
Username (ambari): someuser
Enter Database Password (bigdata): ***********
Re-enter password: **********
Copying JDBC drivers to server resources...
Configuring remote database connection properties...
ERROR 1049 (42000) at line 55 in file:
'/var/lib/ambari-server/resources/Ambari-DDL-MySQL-CREATE.sql': Unknown
database 'ambari'
ERROR: Database bootstrap failed. Please, provide correct connection properties.
ERROR: Exiting with exit code 1. Reason: Error while configuring connection
properties. Exiting
{code}
--
This message was sent by Atlassian JIRA
(v6.1.4#6159)
