[jira] [Created] (CLOUDSTACK-9444) ERROR c.c.u.d.DriverLoader DB driver type null is not supported (during migration from 4.7.1 to 4.9)

["Milamber (JIRA)" <ji...@apache.org>]

Milamber created CLOUDSTACK-9444:
------------------------------------

             Summary: ERROR c.c.u.d.DriverLoader DB driver type null is not supported (during migration from 4.7.1 to 4.9)
                 Key: CLOUDSTACK-9444
                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-9444
             Project: CloudStack
          Issue Type: Bug
      Security Level: Public (Anyone can view this level - this is the default.)
          Components: Install and Setup
    Affects Versions: 4.9.0, 4.8.0, 4.7.1, 4.8.1
         Environment: Ubuntu 14.04 + KVM + CS 4.7.1
            Reporter: Milamber
            Assignee: Milamber
            Priority: Minor
             Fix For: 4.9.1


The PR #1610 has been include with the latest CS 4.9.0, unfortunately if the last line of the db.properties file hasn't a EOL character, the first line of your patch from #1610 (db.cloud.driver=jdbc:mysql) will be concatenate to the last line:

example:
db.cloud.secondsBeforeRetryMaster=3600db.cloud.driver=jdbc:mysql
db.usage.driver=jdbc:mysql
db.simulator.driver=jdbc:mysql

And after the migration, the management service don't start correctly.

The error messages:

2016-07-31 15:05:10,684 ERROR c.c.u.d.DriverLoader DB driver type null is not supported!
2016-07-31 15:05:10,709 WARN c.c.u.d.T.Transaction Unable to load db configuration, using defaults with 5 connections. Falling back on assumed datasource on localhost:3306 using username:password=cloud:cloud. Please check your configuration
com.cloud.utils.exception.CloudRuntimeException: DB driver type null is not supported!
[...]
2016-07-31 15:05:10,979 ERROR c.c.u.d.Merovingian2 Unable to get a new db connection
java.sql.SQLException: Access denied for user 'cloud'@'localhost' (using password: YES)
[...]


===

The workaround is to edit the /etc/cloudstack/management/db.properties file and insert a line return before "db.cloud.driver=jdbc:mysql"
and restart the cloudstack-management service






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)