[
https://issues.apache.org/jira/browse/AMBARI-4125?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dmitry Lysnichenko resolved AMBARI-4125.
----------------------------------------
Resolution: Fixed
Committed to 1.4.3 and to trunk
> 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
> Affects Versions: 1.4.3
> Reporter: Vitaly Brodetskyi
> Assignee: Vitaly Brodetskyi
> Fix For: 1.4.3
>
> Attachments: AMBARI-4125_branch-1.4.3.patch,
> AMBARI-4125_branch-1.4.3_part2.patch, AMBARI-4125_trunk.patch
>
>
> *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'@'localhost';
> 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.5#6160)
