You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cloudstack.apache.org by John Burwell <jb...@basho.com> on 2012/11/02 20:12:20 UTC

Re: Package Build Procedure

Edison,

I have been working to implement this workaround in our integration environment.  However, when I deploy the WAR and start Tomcat, I am getting the following stack trace indicating the JDBC can not find the MySQL driver:

INFO  [cloud.upgrade.DatabaseIntegrityChecker] (main:) Grabbing lock to check for database integrity.
ERROR [db.Transaction.Transaction] (main:) Unexpected exception: 
java.sql.SQLException: No suitable driver found for jdbc:mysql://192.168.123.200:3306/cloud?autoReconnect=true&prepStmtCacheSize=517&cachePrepStmts=true
        at java.sql.DriverManager.getConnection(DriverManager.java:640)
        at java.sql.DriverManager.getConnection(DriverManager.java:200)
        at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75)
        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
        at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1188)
        at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
        at com.cloud.utils.db.Transaction.getStandaloneConnectionWithException(Transaction.java:200)
        at com.cloud.utils.db.Transaction.getStandaloneConnection(Transaction.java:209)
        at com.cloud.utils.db.DbUtil.getConnectionForGlobalLocks(DbUtil.java:58)
        at com.cloud.utils.db.DbUtil.getGlobalLock(DbUtil.java:203)
        at com.cloud.utils.db.GlobalLock.lock(GlobalLock.java:159)
        at com.cloud.upgrade.DatabaseIntegrityChecker.check(DatabaseIntegrityChecker.java:228)
        at com.cloud.utils.component.ComponentLocator.runCheckers(ComponentLocator.java:304)
        at com.cloud.utils.component.ComponentLocator.parse(ComponentLocator.java:276)
        at com.cloud.utils.component.ComponentLocator.getLocatorInternal(ComponentLocator.java:867)
        at com.cloud.utils.component.ComponentLocator.getLocator(ComponentLocator.java:905)
        at com.cloud.utils.component.ComponentLocator.getComponent(ComponentLocator.java:447)
        at com.cloud.utils.component.ComponentLocator.getComponent(ComponentLocator.java:440)
        at com.cloud.servlet.CloudStartupServlet.init(CloudStartupServlet.java:44)
        at javax.servlet.GenericServlet.init(GenericServlet.java:212)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1206)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1026)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4421)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4734)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:943)
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:778)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:504)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
        at org.apache.catalina.core.StandardService.start(StandardService.java:525)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
ERROR [utils.db.DbUtil] (main:) Unable to acquire DB connection for global lock system

I have tried moving the mysql JAR from the WEB-INF/lib directory to Tomcat's lib directory with no success.  I have also tried replacing the mysql-connector-java-5.1.7.jar with the cloud-mysql-connector-java-5.1.7.jar from devcloud also with no success.  The following is the deployment environment version information:

Ubuntu 12.04.1
Tomcat 6.0.35 (installed via the Ubuntu tomcat6 package)
OpenJDK 6 (OpenJDK Runtime Environment (IcedTea6 1.11.5) (6b24-1.11.5-0ubuntu1~12.04.1))

Also, for your reference, I have attached the catalina.out and vmops.log logs.

Thank you for your assistance,
-John


On Oct 29, 2012, at 4:46 PM, Edison Su <Ed...@citrix.com> wrote:

> People are planning to work on the deb build(http://markmail.org/message/lsjigqvnbkjtbl4y), don't know the status though.
> For current master, the shortest cut is using WAR(~/.m2/repository/org/apache/cloudstack/cloud-client-ui/4.1.0-SNAPSHOT/cloud-client-ui-4.1.0-SNAPSHOT.war)
> 
>> -----Original Message-----
>> From: John Burwell [mailto:jburwell@basho.com]
>> Sent: Monday, October 29, 2012 1:18 PM
>> To: cloudstack-dev@incubator.apache.org
>> Subject: Re: Package Build Procedure
>> 
>> Edison,
>> 
>> Is there an ETA for landing those changes into master?  Also, how do you
>> recommend packaging current master for deployment into an integration
>> test environment?  We working under the (false) assumption that building
>> Debian packages would be the shortest path.
>> 
>> Thanks,
>> -John
>> 
>> On Oct 29, 2012, at 4:11 PM, Edison Su <Ed...@citrix.com> wrote:
>> 
>>> Packaging doesn't work on master branch, this is a known issue, unless we
>> merged hugo's maven-to-rpm branch into master.
>>> 
>>>> -----Original Message-----
>>>> From: Rohit Yadav [mailto:rohit.yadav@citrix.com]
>>>> Sent: Monday, October 29, 2012 1:01 PM
>>>> To: cloudstack-dev@incubator.apache.org
>>>> Subject: RE: Package Build Procedure
>>>> 
>>>> Edison, building not much problem as packaging, from what I follow
>>>> John is trying to do dpkg-buildpackage which fails.
>>>> Updates, progress on packaging, rpm, debian?
>>>> ________________________________________
>>>> From: Edison Su [Edison.su@citrix.com]
>>>> Sent: Tuesday, October 30, 2012 1:27 AM
>>>> To: cloudstack-dev@incubator.apache.org
>>>> Subject: RE: Package Build Procedure
>>>> 
>>>> Are you using the latest master or can you try it on latest master(HEAD:
>>>> a2d50c7e43f7e7fe1493972646c6f776af9d8143)?
>>>> The build works for me: mvn clean install -P developer
>>>> 
>>>>> -----Original Message-----
>>>>> From: John Burwell [mailto:jburwell@basho.com]
>>>>> Sent: Monday, October 29, 2012 11:37 AM
>>>>> To: cloudstack-dev@incubator.apache.org
>>>>> Subject: Re: Package Build Procedure
>>>>> 
>>>>> Edison and Rohit,
>>>>> 
>>>>> Attached is the output mvm -X -P developer -pl tools/apidoc.
>>>>> 
>>>>> Thank you for your help,
>>>>> -John
>>> 
> 


Re: Package Build Procedure

Posted by John Burwell <jb...@basho.com>.
All,

Thanks for your help.  The downgrade to Apache 6.0.33 worked.

Thanks again,
-John

On Nov 6, 2012, at 11:25 AM, Chip Childers <ch...@sungard.com> wrote:

> On Tue, Nov 6, 2012 at 11:21 AM, John Burwell <jb...@basho.com> wrote:
>> Chiradeep,
>> 
>> The URL below yields a 404.  Could you please resend?
> 
> Here's another link to the same email:
> http://markmail.org/thread/fyy32aitwvd7poqy
> 
> 
>> Thanks for your help,
>> -John
>> 
>> On Nov 5, 2012, at 5:04 PM, Chiradeep Vittal <Ch...@citrix.com> wrote:
>> 
>>> http://s.apache.org/me
>>> "Avoid tomcat6.0.35 (java.sql.SQLException: No suitable driver"
>>> 
>>> On 11/5/12 12:15 PM, "John Burwell" <jb...@basho.com> wrote:
>>> 
>>>> All,
>>>> 
>>>> As part of further debugging attempts, I have run CloudStack under the
>>>> Sun JDK, as well as, re-verified that I can connect to the MySQL database
>>>> from the command line of the machine running CloudStack.  I also found
>>>> this defect and placed the mysql-connector jar per its instructions with
>>>> no success.  Is anyone experiencing this issue when deploying only the
>>>> WAR into Tomcat 6.0.35?
>>>> 
>>>> Thank you for your help,
>>>> -John
>>>> 
>>>> On Nov 2, 2012, at 3:12 PM, John Burwell <jb...@basho.com> wrote:
>>>> 
>>>>> Edison,
>>>>> 
>>>>> I have been working to implement this workaround in our integration
>>>>> environment.  However, when I deploy the WAR and start Tomcat, I am
>>>>> getting the following stack trace indicating the JDBC can not find the
>>>>> MySQL driver:
>>>>> 
>>>>> INFO  [cloud.upgrade.DatabaseIntegrityChecker] (main:) Grabbing lock to
>>>>> check for database integrity.
>>>>> ERROR [db.Transaction.Transaction] (main:) Unexpected exception:
>>>>> java.sql.SQLException: No suitable driver found for
>>>>> jdbc:mysql://192.168.123.200:3306/cloud?autoReconnect=true&prepStmtCacheS
>>>>> ize=517&cachePrepStmts=true
>>>>>       at java.sql.DriverManager.getConnection(DriverManager.java:640)
>>>>>       at java.sql.DriverManager.getConnection(DriverManager.java:200)
>>>>>       at
>>>>> org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(D
>>>>> riverManagerConnectionFactory.java:75)
>>>>>       at
>>>>> org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConn
>>>>> ectionFactory.java:582)
>>>>>       at
>>>>> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObject
>>>>> Pool.java:1188)
>>>>>       at
>>>>> org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource
>>>>> .java:106)
>>>>>       at
>>>>> com.cloud.utils.db.Transaction.getStandaloneConnectionWithException(Trans
>>>>> action.java:200)
>>>>>       at
>>>>> com.cloud.utils.db.Transaction.getStandaloneConnection(Transaction.java:2
>>>>> 09)
>>>>>       at
>>>>> com.cloud.utils.db.DbUtil.getConnectionForGlobalLocks(DbUtil.java:58)
>>>>>       at com.cloud.utils.db.DbUtil.getGlobalLock(DbUtil.java:203)
>>>>>       at com.cloud.utils.db.GlobalLock.lock(GlobalLock.java:159)
>>>>>       at
>>>>> com.cloud.upgrade.DatabaseIntegrityChecker.check(DatabaseIntegrityChecker
>>>>> .java:228)
>>>>>       at
>>>>> com.cloud.utils.component.ComponentLocator.runCheckers(ComponentLocator.j
>>>>> ava:304)
>>>>>       at
>>>>> com.cloud.utils.component.ComponentLocator.parse(ComponentLocator.java:27
>>>>> 6)
>>>>>       at
>>>>> com.cloud.utils.component.ComponentLocator.getLocatorInternal(ComponentLo
>>>>> cator.java:867)
>>>>>       at
>>>>> com.cloud.utils.component.ComponentLocator.getLocator(ComponentLocator.ja
>>>>> va:905)
>>>>>       at
>>>>> com.cloud.utils.component.ComponentLocator.getComponent(ComponentLocator.
>>>>> java:447)
>>>>>       at
>>>>> com.cloud.utils.component.ComponentLocator.getComponent(ComponentLocator.
>>>>> java:440)
>>>>>       at
>>>>> com.cloud.servlet.CloudStartupServlet.init(CloudStartupServlet.java:44)
>>>>>       at javax.servlet.GenericServlet.init(GenericServlet.java:212)
>>>>>       at
>>>>> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java
>>>>> :1206)
>>>>>       at
>>>>> org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1026)
>>>>>       at
>>>>> org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.ja
>>>>> va:4421)
>>>>>       at
>>>>> org.apache.catalina.core.StandardContext.start(StandardContext.java:4734)
>>>>>       at
>>>>> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.jav
>>>>> a:799)
>>>>>       at
>>>>> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
>>>>>       at
>>>>> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
>>>>>       at
>>>>> org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:943)
>>>>>       at
>>>>> org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:778)
>>>>>       at
>>>>> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:504)
>>>>>       at
>>>>> org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
>>>>>       at
>>>>> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324
>>>>> )
>>>>>       at
>>>>> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSup
>>>>> port.java:142)
>>>>>       at
>>>>> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
>>>>>       at
>>>>> org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
>>>>>       at
>>>>> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
>>>>>       at
>>>>> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
>>>>>       at
>>>>> org.apache.catalina.core.StandardService.start(StandardService.java:525)
>>>>>       at
>>>>> org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
>>>>>       at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
>>>>>       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>>>       at
>>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java
>>>>> :57)
>>>>>       at
>>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI
>>>>> mpl.java:43)
>>>>>       at java.lang.reflect.Method.invoke(Method.java:616)
>>>>>       at
>>>>> org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
>>>>>       at
>>>>> org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
>>>>> ERROR [utils.db.DbUtil] (main:) Unable to acquire DB connection for
>>>>> global lock system
>>>>> 
>>>>> I have tried moving the mysql JAR from the WEB-INF/lib directory to
>>>>> Tomcat's lib directory with no success.  I have also tried replacing the
>>>>> mysql-connector-java-5.1.7.jar with the
>>>>> cloud-mysql-connector-java-5.1.7.jar from devcloud also with no success.
>>>>> The following is the deployment environment version information:
>>>>> 
>>>>> Ubuntu 12.04.1
>>>>> Tomcat 6.0.35 (installed via the Ubuntu tomcat6 package)
>>>>> OpenJDK 6 (OpenJDK Runtime Environment (IcedTea6 1.11.5)
>>>>> (6b24-1.11.5-0ubuntu1~12.04.1))
>>>>> 
>>>>> Also, for your reference, I have attached the catalina.out and
>>>>> vmops.log logs.
>>>>> 
>>>>> Thank you for your assistance,
>>>>> -John
>>>>> 
>>>>> <vmops.log>
>>>>> <catalina.out>
>>>>> 
>>>>> On Oct 29, 2012, at 4:46 PM, Edison Su <Ed...@citrix.com> wrote:
>>>>> 
>>>>>> People are planning to work on the deb
>>>>>> build(http://markmail.org/message/lsjigqvnbkjtbl4y), don't know the
>>>>>> status though.
>>>>>> For current master, the shortest cut is using
>>>>>> WAR(~/.m2/repository/org/apache/cloudstack/cloud-client-ui/4.1.0-SNAPSHO
>>>>>> T/cloud-client-ui-4.1.0-SNAPSHOT.war)
>>>>>> 
>>>>>>> -----Original Message-----
>>>>>>> From: John Burwell [mailto:jburwell@basho.com]
>>>>>>> Sent: Monday, October 29, 2012 1:18 PM
>>>>>>> To: cloudstack-dev@incubator.apache.org
>>>>>>> Subject: Re: Package Build Procedure
>>>>>>> 
>>>>>>> Edison,
>>>>>>> 
>>>>>>> Is there an ETA for landing those changes into master?  Also, how do
>>>>>>> you
>>>>>>> recommend packaging current master for deployment into an integration
>>>>>>> test environment?  We working under the (false) assumption that
>>>>>>> building
>>>>>>> Debian packages would be the shortest path.
>>>>>>> 
>>>>>>> Thanks,
>>>>>>> -John
>>>>>>> 
>>>>>>> On Oct 29, 2012, at 4:11 PM, Edison Su <Ed...@citrix.com> wrote:
>>>>>>> 
>>>>>>>> Packaging doesn't work on master branch, this is a known issue,
>>>>>>>> unless we
>>>>>>> merged hugo's maven-to-rpm branch into master.
>>>>>>>> 
>>>>>>>>> -----Original Message-----
>>>>>>>>> From: Rohit Yadav [mailto:rohit.yadav@citrix.com]
>>>>>>>>> Sent: Monday, October 29, 2012 1:01 PM
>>>>>>>>> To: cloudstack-dev@incubator.apache.org
>>>>>>>>> Subject: RE: Package Build Procedure
>>>>>>>>> 
>>>>>>>>> Edison, building not much problem as packaging, from what I follow
>>>>>>>>> John is trying to do dpkg-buildpackage which fails.
>>>>>>>>> Updates, progress on packaging, rpm, debian?
>>>>>>>>> ________________________________________
>>>>>>>>> From: Edison Su [Edison.su@citrix.com]
>>>>>>>>> Sent: Tuesday, October 30, 2012 1:27 AM
>>>>>>>>> To: cloudstack-dev@incubator.apache.org
>>>>>>>>> Subject: RE: Package Build Procedure
>>>>>>>>> 
>>>>>>>>> Are you using the latest master or can you try it on latest
>>>>>>>>> master(HEAD:
>>>>>>>>> a2d50c7e43f7e7fe1493972646c6f776af9d8143)?
>>>>>>>>> The build works for me: mvn clean install -P developer
>>>>>>>>> 
>>>>>>>>>> -----Original Message-----
>>>>>>>>>> From: John Burwell [mailto:jburwell@basho.com]
>>>>>>>>>> Sent: Monday, October 29, 2012 11:37 AM
>>>>>>>>>> To: cloudstack-dev@incubator.apache.org
>>>>>>>>>> Subject: Re: Package Build Procedure
>>>>>>>>>> 
>>>>>>>>>> Edison and Rohit,
>>>>>>>>>> 
>>>>>>>>>> Attached is the output mvm -X -P developer -pl tools/apidoc.
>>>>>>>>>> 
>>>>>>>>>> Thank you for your help,
>>>>>>>>>> -John
>>>>>>>> 
>>>>>> 
>>>>> 
>>>> 
>>> 
>> 
>> 


Re: Package Build Procedure

Posted by Chip Childers <ch...@sungard.com>.
On Tue, Nov 6, 2012 at 11:21 AM, John Burwell <jb...@basho.com> wrote:
> Chiradeep,
>
> The URL below yields a 404.  Could you please resend?

Here's another link to the same email:
http://markmail.org/thread/fyy32aitwvd7poqy


> Thanks for your help,
> -John
>
> On Nov 5, 2012, at 5:04 PM, Chiradeep Vittal <Ch...@citrix.com> wrote:
>
>> http://s.apache.org/me
>> "Avoid tomcat6.0.35 (java.sql.SQLException: No suitable driver"
>>
>> On 11/5/12 12:15 PM, "John Burwell" <jb...@basho.com> wrote:
>>
>>> All,
>>>
>>> As part of further debugging attempts, I have run CloudStack under the
>>> Sun JDK, as well as, re-verified that I can connect to the MySQL database
>>> from the command line of the machine running CloudStack.  I also found
>>> this defect and placed the mysql-connector jar per its instructions with
>>> no success.  Is anyone experiencing this issue when deploying only the
>>> WAR into Tomcat 6.0.35?
>>>
>>> Thank you for your help,
>>> -John
>>>
>>> On Nov 2, 2012, at 3:12 PM, John Burwell <jb...@basho.com> wrote:
>>>
>>>> Edison,
>>>>
>>>> I have been working to implement this workaround in our integration
>>>> environment.  However, when I deploy the WAR and start Tomcat, I am
>>>> getting the following stack trace indicating the JDBC can not find the
>>>> MySQL driver:
>>>>
>>>> INFO  [cloud.upgrade.DatabaseIntegrityChecker] (main:) Grabbing lock to
>>>> check for database integrity.
>>>> ERROR [db.Transaction.Transaction] (main:) Unexpected exception:
>>>> java.sql.SQLException: No suitable driver found for
>>>> jdbc:mysql://192.168.123.200:3306/cloud?autoReconnect=true&prepStmtCacheS
>>>> ize=517&cachePrepStmts=true
>>>>        at java.sql.DriverManager.getConnection(DriverManager.java:640)
>>>>        at java.sql.DriverManager.getConnection(DriverManager.java:200)
>>>>        at
>>>> org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(D
>>>> riverManagerConnectionFactory.java:75)
>>>>        at
>>>> org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConn
>>>> ectionFactory.java:582)
>>>>        at
>>>> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObject
>>>> Pool.java:1188)
>>>>        at
>>>> org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource
>>>> .java:106)
>>>>        at
>>>> com.cloud.utils.db.Transaction.getStandaloneConnectionWithException(Trans
>>>> action.java:200)
>>>>        at
>>>> com.cloud.utils.db.Transaction.getStandaloneConnection(Transaction.java:2
>>>> 09)
>>>>        at
>>>> com.cloud.utils.db.DbUtil.getConnectionForGlobalLocks(DbUtil.java:58)
>>>>        at com.cloud.utils.db.DbUtil.getGlobalLock(DbUtil.java:203)
>>>>        at com.cloud.utils.db.GlobalLock.lock(GlobalLock.java:159)
>>>>        at
>>>> com.cloud.upgrade.DatabaseIntegrityChecker.check(DatabaseIntegrityChecker
>>>> .java:228)
>>>>        at
>>>> com.cloud.utils.component.ComponentLocator.runCheckers(ComponentLocator.j
>>>> ava:304)
>>>>        at
>>>> com.cloud.utils.component.ComponentLocator.parse(ComponentLocator.java:27
>>>> 6)
>>>>        at
>>>> com.cloud.utils.component.ComponentLocator.getLocatorInternal(ComponentLo
>>>> cator.java:867)
>>>>        at
>>>> com.cloud.utils.component.ComponentLocator.getLocator(ComponentLocator.ja
>>>> va:905)
>>>>        at
>>>> com.cloud.utils.component.ComponentLocator.getComponent(ComponentLocator.
>>>> java:447)
>>>>        at
>>>> com.cloud.utils.component.ComponentLocator.getComponent(ComponentLocator.
>>>> java:440)
>>>>        at
>>>> com.cloud.servlet.CloudStartupServlet.init(CloudStartupServlet.java:44)
>>>>        at javax.servlet.GenericServlet.init(GenericServlet.java:212)
>>>>        at
>>>> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java
>>>> :1206)
>>>>        at
>>>> org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1026)
>>>>        at
>>>> org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.ja
>>>> va:4421)
>>>>        at
>>>> org.apache.catalina.core.StandardContext.start(StandardContext.java:4734)
>>>>        at
>>>> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.jav
>>>> a:799)
>>>>        at
>>>> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
>>>>        at
>>>> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
>>>>        at
>>>> org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:943)
>>>>        at
>>>> org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:778)
>>>>        at
>>>> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:504)
>>>>        at
>>>> org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
>>>>        at
>>>> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324
>>>> )
>>>>        at
>>>> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSup
>>>> port.java:142)
>>>>        at
>>>> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
>>>>        at
>>>> org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
>>>>        at
>>>> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
>>>>        at
>>>> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
>>>>        at
>>>> org.apache.catalina.core.StandardService.start(StandardService.java:525)
>>>>        at
>>>> org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
>>>>        at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
>>>>        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>>        at
>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java
>>>> :57)
>>>>        at
>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI
>>>> mpl.java:43)
>>>>        at java.lang.reflect.Method.invoke(Method.java:616)
>>>>        at
>>>> org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
>>>>        at
>>>> org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
>>>> ERROR [utils.db.DbUtil] (main:) Unable to acquire DB connection for
>>>> global lock system
>>>>
>>>> I have tried moving the mysql JAR from the WEB-INF/lib directory to
>>>> Tomcat's lib directory with no success.  I have also tried replacing the
>>>> mysql-connector-java-5.1.7.jar with the
>>>> cloud-mysql-connector-java-5.1.7.jar from devcloud also with no success.
>>>> The following is the deployment environment version information:
>>>>
>>>> Ubuntu 12.04.1
>>>> Tomcat 6.0.35 (installed via the Ubuntu tomcat6 package)
>>>> OpenJDK 6 (OpenJDK Runtime Environment (IcedTea6 1.11.5)
>>>> (6b24-1.11.5-0ubuntu1~12.04.1))
>>>>
>>>> Also, for your reference, I have attached the catalina.out and
>>>> vmops.log logs.
>>>>
>>>> Thank you for your assistance,
>>>> -John
>>>>
>>>> <vmops.log>
>>>> <catalina.out>
>>>>
>>>> On Oct 29, 2012, at 4:46 PM, Edison Su <Ed...@citrix.com> wrote:
>>>>
>>>>> People are planning to work on the deb
>>>>> build(http://markmail.org/message/lsjigqvnbkjtbl4y), don't know the
>>>>> status though.
>>>>> For current master, the shortest cut is using
>>>>> WAR(~/.m2/repository/org/apache/cloudstack/cloud-client-ui/4.1.0-SNAPSHO
>>>>> T/cloud-client-ui-4.1.0-SNAPSHOT.war)
>>>>>
>>>>>> -----Original Message-----
>>>>>> From: John Burwell [mailto:jburwell@basho.com]
>>>>>> Sent: Monday, October 29, 2012 1:18 PM
>>>>>> To: cloudstack-dev@incubator.apache.org
>>>>>> Subject: Re: Package Build Procedure
>>>>>>
>>>>>> Edison,
>>>>>>
>>>>>> Is there an ETA for landing those changes into master?  Also, how do
>>>>>> you
>>>>>> recommend packaging current master for deployment into an integration
>>>>>> test environment?  We working under the (false) assumption that
>>>>>> building
>>>>>> Debian packages would be the shortest path.
>>>>>>
>>>>>> Thanks,
>>>>>> -John
>>>>>>
>>>>>> On Oct 29, 2012, at 4:11 PM, Edison Su <Ed...@citrix.com> wrote:
>>>>>>
>>>>>>> Packaging doesn't work on master branch, this is a known issue,
>>>>>>> unless we
>>>>>> merged hugo's maven-to-rpm branch into master.
>>>>>>>
>>>>>>>> -----Original Message-----
>>>>>>>> From: Rohit Yadav [mailto:rohit.yadav@citrix.com]
>>>>>>>> Sent: Monday, October 29, 2012 1:01 PM
>>>>>>>> To: cloudstack-dev@incubator.apache.org
>>>>>>>> Subject: RE: Package Build Procedure
>>>>>>>>
>>>>>>>> Edison, building not much problem as packaging, from what I follow
>>>>>>>> John is trying to do dpkg-buildpackage which fails.
>>>>>>>> Updates, progress on packaging, rpm, debian?
>>>>>>>> ________________________________________
>>>>>>>> From: Edison Su [Edison.su@citrix.com]
>>>>>>>> Sent: Tuesday, October 30, 2012 1:27 AM
>>>>>>>> To: cloudstack-dev@incubator.apache.org
>>>>>>>> Subject: RE: Package Build Procedure
>>>>>>>>
>>>>>>>> Are you using the latest master or can you try it on latest
>>>>>>>> master(HEAD:
>>>>>>>> a2d50c7e43f7e7fe1493972646c6f776af9d8143)?
>>>>>>>> The build works for me: mvn clean install -P developer
>>>>>>>>
>>>>>>>>> -----Original Message-----
>>>>>>>>> From: John Burwell [mailto:jburwell@basho.com]
>>>>>>>>> Sent: Monday, October 29, 2012 11:37 AM
>>>>>>>>> To: cloudstack-dev@incubator.apache.org
>>>>>>>>> Subject: Re: Package Build Procedure
>>>>>>>>>
>>>>>>>>> Edison and Rohit,
>>>>>>>>>
>>>>>>>>> Attached is the output mvm -X -P developer -pl tools/apidoc.
>>>>>>>>>
>>>>>>>>> Thank you for your help,
>>>>>>>>> -John
>>>>>>>
>>>>>
>>>>
>>>
>>
>
>

Re: Package Build Procedure

Posted by John Burwell <jb...@basho.com>.
Chiradeep,

The URL below yields a 404.  Could you please resend?

Thanks for your help,
-John

On Nov 5, 2012, at 5:04 PM, Chiradeep Vittal <Ch...@citrix.com> wrote:

> http://s.apache.org/me
> "Avoid tomcat6.0.35 (java.sql.SQLException: No suitable driver"
> 
> On 11/5/12 12:15 PM, "John Burwell" <jb...@basho.com> wrote:
> 
>> All,
>> 
>> As part of further debugging attempts, I have run CloudStack under the
>> Sun JDK, as well as, re-verified that I can connect to the MySQL database
>> from the command line of the machine running CloudStack.  I also found
>> this defect and placed the mysql-connector jar per its instructions with
>> no success.  Is anyone experiencing this issue when deploying only the
>> WAR into Tomcat 6.0.35?
>> 
>> Thank you for your help,
>> -John
>> 
>> On Nov 2, 2012, at 3:12 PM, John Burwell <jb...@basho.com> wrote:
>> 
>>> Edison,
>>> 
>>> I have been working to implement this workaround in our integration
>>> environment.  However, when I deploy the WAR and start Tomcat, I am
>>> getting the following stack trace indicating the JDBC can not find the
>>> MySQL driver:
>>> 
>>> INFO  [cloud.upgrade.DatabaseIntegrityChecker] (main:) Grabbing lock to
>>> check for database integrity.
>>> ERROR [db.Transaction.Transaction] (main:) Unexpected exception:
>>> java.sql.SQLException: No suitable driver found for
>>> jdbc:mysql://192.168.123.200:3306/cloud?autoReconnect=true&prepStmtCacheS
>>> ize=517&cachePrepStmts=true
>>>        at java.sql.DriverManager.getConnection(DriverManager.java:640)
>>>        at java.sql.DriverManager.getConnection(DriverManager.java:200)
>>>        at 
>>> org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(D
>>> riverManagerConnectionFactory.java:75)
>>>        at 
>>> org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConn
>>> ectionFactory.java:582)
>>>        at 
>>> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObject
>>> Pool.java:1188)
>>>        at 
>>> org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource
>>> .java:106)
>>>        at 
>>> com.cloud.utils.db.Transaction.getStandaloneConnectionWithException(Trans
>>> action.java:200)
>>>        at 
>>> com.cloud.utils.db.Transaction.getStandaloneConnection(Transaction.java:2
>>> 09)
>>>        at 
>>> com.cloud.utils.db.DbUtil.getConnectionForGlobalLocks(DbUtil.java:58)
>>>        at com.cloud.utils.db.DbUtil.getGlobalLock(DbUtil.java:203)
>>>        at com.cloud.utils.db.GlobalLock.lock(GlobalLock.java:159)
>>>        at 
>>> com.cloud.upgrade.DatabaseIntegrityChecker.check(DatabaseIntegrityChecker
>>> .java:228)
>>>        at 
>>> com.cloud.utils.component.ComponentLocator.runCheckers(ComponentLocator.j
>>> ava:304)
>>>        at 
>>> com.cloud.utils.component.ComponentLocator.parse(ComponentLocator.java:27
>>> 6)
>>>        at 
>>> com.cloud.utils.component.ComponentLocator.getLocatorInternal(ComponentLo
>>> cator.java:867)
>>>        at 
>>> com.cloud.utils.component.ComponentLocator.getLocator(ComponentLocator.ja
>>> va:905)
>>>        at 
>>> com.cloud.utils.component.ComponentLocator.getComponent(ComponentLocator.
>>> java:447)
>>>        at 
>>> com.cloud.utils.component.ComponentLocator.getComponent(ComponentLocator.
>>> java:440)
>>>        at 
>>> com.cloud.servlet.CloudStartupServlet.init(CloudStartupServlet.java:44)
>>>        at javax.servlet.GenericServlet.init(GenericServlet.java:212)
>>>        at 
>>> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java
>>> :1206)
>>>        at 
>>> org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1026)
>>>        at 
>>> org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.ja
>>> va:4421)
>>>        at 
>>> org.apache.catalina.core.StandardContext.start(StandardContext.java:4734)
>>>        at 
>>> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.jav
>>> a:799)
>>>        at 
>>> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
>>>        at 
>>> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
>>>        at 
>>> org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:943)
>>>        at 
>>> org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:778)
>>>        at 
>>> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:504)
>>>        at 
>>> org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
>>>        at 
>>> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324
>>> )
>>>        at 
>>> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSup
>>> port.java:142)
>>>        at 
>>> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
>>>        at 
>>> org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
>>>        at 
>>> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
>>>        at 
>>> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
>>>        at 
>>> org.apache.catalina.core.StandardService.start(StandardService.java:525)
>>>        at 
>>> org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
>>>        at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
>>>        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>        at 
>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java
>>> :57)
>>>        at 
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI
>>> mpl.java:43)
>>>        at java.lang.reflect.Method.invoke(Method.java:616)
>>>        at 
>>> org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
>>>        at 
>>> org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
>>> ERROR [utils.db.DbUtil] (main:) Unable to acquire DB connection for
>>> global lock system
>>> 
>>> I have tried moving the mysql JAR from the WEB-INF/lib directory to
>>> Tomcat's lib directory with no success.  I have also tried replacing the
>>> mysql-connector-java-5.1.7.jar with the
>>> cloud-mysql-connector-java-5.1.7.jar from devcloud also with no success.
>>> The following is the deployment environment version information:
>>> 
>>> Ubuntu 12.04.1
>>> Tomcat 6.0.35 (installed via the Ubuntu tomcat6 package)
>>> OpenJDK 6 (OpenJDK Runtime Environment (IcedTea6 1.11.5)
>>> (6b24-1.11.5-0ubuntu1~12.04.1))
>>> 
>>> Also, for your reference, I have attached the catalina.out and
>>> vmops.log logs.
>>> 
>>> Thank you for your assistance,
>>> -John
>>> 
>>> <vmops.log>
>>> <catalina.out>
>>> 
>>> On Oct 29, 2012, at 4:46 PM, Edison Su <Ed...@citrix.com> wrote:
>>> 
>>>> People are planning to work on the deb
>>>> build(http://markmail.org/message/lsjigqvnbkjtbl4y), don't know the
>>>> status though.
>>>> For current master, the shortest cut is using
>>>> WAR(~/.m2/repository/org/apache/cloudstack/cloud-client-ui/4.1.0-SNAPSHO
>>>> T/cloud-client-ui-4.1.0-SNAPSHOT.war)
>>>> 
>>>>> -----Original Message-----
>>>>> From: John Burwell [mailto:jburwell@basho.com]
>>>>> Sent: Monday, October 29, 2012 1:18 PM
>>>>> To: cloudstack-dev@incubator.apache.org
>>>>> Subject: Re: Package Build Procedure
>>>>> 
>>>>> Edison,
>>>>> 
>>>>> Is there an ETA for landing those changes into master?  Also, how do
>>>>> you
>>>>> recommend packaging current master for deployment into an integration
>>>>> test environment?  We working under the (false) assumption that
>>>>> building
>>>>> Debian packages would be the shortest path.
>>>>> 
>>>>> Thanks,
>>>>> -John
>>>>> 
>>>>> On Oct 29, 2012, at 4:11 PM, Edison Su <Ed...@citrix.com> wrote:
>>>>> 
>>>>>> Packaging doesn't work on master branch, this is a known issue,
>>>>>> unless we
>>>>> merged hugo's maven-to-rpm branch into master.
>>>>>> 
>>>>>>> -----Original Message-----
>>>>>>> From: Rohit Yadav [mailto:rohit.yadav@citrix.com]
>>>>>>> Sent: Monday, October 29, 2012 1:01 PM
>>>>>>> To: cloudstack-dev@incubator.apache.org
>>>>>>> Subject: RE: Package Build Procedure
>>>>>>> 
>>>>>>> Edison, building not much problem as packaging, from what I follow
>>>>>>> John is trying to do dpkg-buildpackage which fails.
>>>>>>> Updates, progress on packaging, rpm, debian?
>>>>>>> ________________________________________
>>>>>>> From: Edison Su [Edison.su@citrix.com]
>>>>>>> Sent: Tuesday, October 30, 2012 1:27 AM
>>>>>>> To: cloudstack-dev@incubator.apache.org
>>>>>>> Subject: RE: Package Build Procedure
>>>>>>> 
>>>>>>> Are you using the latest master or can you try it on latest
>>>>>>> master(HEAD:
>>>>>>> a2d50c7e43f7e7fe1493972646c6f776af9d8143)?
>>>>>>> The build works for me: mvn clean install -P developer
>>>>>>> 
>>>>>>>> -----Original Message-----
>>>>>>>> From: John Burwell [mailto:jburwell@basho.com]
>>>>>>>> Sent: Monday, October 29, 2012 11:37 AM
>>>>>>>> To: cloudstack-dev@incubator.apache.org
>>>>>>>> Subject: Re: Package Build Procedure
>>>>>>>> 
>>>>>>>> Edison and Rohit,
>>>>>>>> 
>>>>>>>> Attached is the output mvm -X -P developer -pl tools/apidoc.
>>>>>>>> 
>>>>>>>> Thank you for your help,
>>>>>>>> -John
>>>>>> 
>>>> 
>>> 
>> 
> 


Re: Package Build Procedure

Posted by Chiradeep Vittal <Ch...@citrix.com>.
http://s.apache.org/me
"Avoid tomcat6.0.35 (java.sql.SQLException: No suitable driver"

On 11/5/12 12:15 PM, "John Burwell" <jb...@basho.com> wrote:

>All,
>
>As part of further debugging attempts, I have run CloudStack under the
>Sun JDK, as well as, re-verified that I can connect to the MySQL database
>from the command line of the machine running CloudStack.  I also found
>this defect and placed the mysql-connector jar per its instructions with
>no success.  Is anyone experiencing this issue when deploying only the
>WAR into Tomcat 6.0.35?
>
>Thank you for your help,
>-John
>
>On Nov 2, 2012, at 3:12 PM, John Burwell <jb...@basho.com> wrote:
>
>> Edison,
>>
>> I have been working to implement this workaround in our integration
>>environment.  However, when I deploy the WAR and start Tomcat, I am
>>getting the following stack trace indicating the JDBC can not find the
>>MySQL driver:
>>
>> INFO  [cloud.upgrade.DatabaseIntegrityChecker] (main:) Grabbing lock to
>>check for database integrity.
>> ERROR [db.Transaction.Transaction] (main:) Unexpected exception:
>> java.sql.SQLException: No suitable driver found for
>>jdbc:mysql://192.168.123.200:3306/cloud?autoReconnect=true&prepStmtCacheS
>>ize=517&cachePrepStmts=true
>>         at java.sql.DriverManager.getConnection(DriverManager.java:640)
>>         at java.sql.DriverManager.getConnection(DriverManager.java:200)
>>         at 
>>org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(D
>>riverManagerConnectionFactory.java:75)
>>         at 
>>org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConn
>>ectionFactory.java:582)
>>         at 
>>org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObject
>>Pool.java:1188)
>>         at 
>>org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource
>>.java:106)
>>         at 
>>com.cloud.utils.db.Transaction.getStandaloneConnectionWithException(Trans
>>action.java:200)
>>         at 
>>com.cloud.utils.db.Transaction.getStandaloneConnection(Transaction.java:2
>>09)
>>         at 
>>com.cloud.utils.db.DbUtil.getConnectionForGlobalLocks(DbUtil.java:58)
>>         at com.cloud.utils.db.DbUtil.getGlobalLock(DbUtil.java:203)
>>         at com.cloud.utils.db.GlobalLock.lock(GlobalLock.java:159)
>>         at 
>>com.cloud.upgrade.DatabaseIntegrityChecker.check(DatabaseIntegrityChecker
>>.java:228)
>>         at 
>>com.cloud.utils.component.ComponentLocator.runCheckers(ComponentLocator.j
>>ava:304)
>>         at 
>>com.cloud.utils.component.ComponentLocator.parse(ComponentLocator.java:27
>>6)
>>         at 
>>com.cloud.utils.component.ComponentLocator.getLocatorInternal(ComponentLo
>>cator.java:867)
>>         at 
>>com.cloud.utils.component.ComponentLocator.getLocator(ComponentLocator.ja
>>va:905)
>>         at 
>>com.cloud.utils.component.ComponentLocator.getComponent(ComponentLocator.
>>java:447)
>>         at 
>>com.cloud.utils.component.ComponentLocator.getComponent(ComponentLocator.
>>java:440)
>>         at 
>>com.cloud.servlet.CloudStartupServlet.init(CloudStartupServlet.java:44)
>>         at javax.servlet.GenericServlet.init(GenericServlet.java:212)
>>         at 
>>org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java
>>:1206)
>>         at 
>>org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1026)
>>         at 
>>org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.ja
>>va:4421)
>>         at 
>>org.apache.catalina.core.StandardContext.start(StandardContext.java:4734)
>>         at 
>>org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.jav
>>a:799)
>>         at 
>>org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
>>         at 
>>org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
>>         at 
>>org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:943)
>>         at 
>>org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:778)
>>         at 
>>org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:504)
>>         at 
>>org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
>>         at 
>>org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324
>>)
>>         at 
>>org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSup
>>port.java:142)
>>         at 
>>org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
>>         at 
>>org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
>>         at 
>>org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
>>         at 
>>org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
>>         at 
>>org.apache.catalina.core.StandardService.start(StandardService.java:525)
>>         at 
>>org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
>>         at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
>>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>         at 
>>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java
>>:57)
>>         at 
>>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI
>>mpl.java:43)
>>         at java.lang.reflect.Method.invoke(Method.java:616)
>>         at 
>>org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
>>         at 
>>org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
>> ERROR [utils.db.DbUtil] (main:) Unable to acquire DB connection for
>>global lock system
>>
>> I have tried moving the mysql JAR from the WEB-INF/lib directory to
>>Tomcat's lib directory with no success.  I have also tried replacing the
>>mysql-connector-java-5.1.7.jar with the
>>cloud-mysql-connector-java-5.1.7.jar from devcloud also with no success.
>> The following is the deployment environment version information:
>>
>> Ubuntu 12.04.1
>> Tomcat 6.0.35 (installed via the Ubuntu tomcat6 package)
>> OpenJDK 6 (OpenJDK Runtime Environment (IcedTea6 1.11.5)
>>(6b24-1.11.5-0ubuntu1~12.04.1))
>>
>> Also, for your reference, I have attached the catalina.out and
>>vmops.log logs.
>>
>> Thank you for your assistance,
>> -John
>>
>> <vmops.log>
>> <catalina.out>
>>
>> On Oct 29, 2012, at 4:46 PM, Edison Su <Ed...@citrix.com> wrote:
>>
>>> People are planning to work on the deb
>>>build(http://markmail.org/message/lsjigqvnbkjtbl4y), don't know the
>>>status though.
>>> For current master, the shortest cut is using
>>>WAR(~/.m2/repository/org/apache/cloudstack/cloud-client-ui/4.1.0-SNAPSHO
>>>T/cloud-client-ui-4.1.0-SNAPSHOT.war)
>>>
>>>> -----Original Message-----
>>>> From: John Burwell [mailto:jburwell@basho.com]
>>>> Sent: Monday, October 29, 2012 1:18 PM
>>>> To: cloudstack-dev@incubator.apache.org
>>>> Subject: Re: Package Build Procedure
>>>>
>>>> Edison,
>>>>
>>>> Is there an ETA for landing those changes into master?  Also, how do
>>>>you
>>>> recommend packaging current master for deployment into an integration
>>>> test environment?  We working under the (false) assumption that
>>>>building
>>>> Debian packages would be the shortest path.
>>>>
>>>> Thanks,
>>>> -John
>>>>
>>>> On Oct 29, 2012, at 4:11 PM, Edison Su <Ed...@citrix.com> wrote:
>>>>
>>>>> Packaging doesn't work on master branch, this is a known issue,
>>>>>unless we
>>>> merged hugo's maven-to-rpm branch into master.
>>>>>
>>>>>> -----Original Message-----
>>>>>> From: Rohit Yadav [mailto:rohit.yadav@citrix.com]
>>>>>> Sent: Monday, October 29, 2012 1:01 PM
>>>>>> To: cloudstack-dev@incubator.apache.org
>>>>>> Subject: RE: Package Build Procedure
>>>>>>
>>>>>> Edison, building not much problem as packaging, from what I follow
>>>>>> John is trying to do dpkg-buildpackage which fails.
>>>>>> Updates, progress on packaging, rpm, debian?
>>>>>> ________________________________________
>>>>>> From: Edison Su [Edison.su@citrix.com]
>>>>>> Sent: Tuesday, October 30, 2012 1:27 AM
>>>>>> To: cloudstack-dev@incubator.apache.org
>>>>>> Subject: RE: Package Build Procedure
>>>>>>
>>>>>> Are you using the latest master or can you try it on latest
>>>>>>master(HEAD:
>>>>>> a2d50c7e43f7e7fe1493972646c6f776af9d8143)?
>>>>>> The build works for me: mvn clean install -P developer
>>>>>>
>>>>>>> -----Original Message-----
>>>>>>> From: John Burwell [mailto:jburwell@basho.com]
>>>>>>> Sent: Monday, October 29, 2012 11:37 AM
>>>>>>> To: cloudstack-dev@incubator.apache.org
>>>>>>> Subject: Re: Package Build Procedure
>>>>>>>
>>>>>>> Edison and Rohit,
>>>>>>>
>>>>>>> Attached is the output mvm -X -P developer -pl tools/apidoc.
>>>>>>>
>>>>>>> Thank you for your help,
>>>>>>> -John
>>>>>
>>>
>>
>


Re: Package Build Procedure

Posted by John Burwell <jb...@basho.com>.
All,

As part of further debugging attempts, I have run CloudStack under the Sun JDK, as well as, re-verified that I can connect to the MySQL database from the command line of the machine running CloudStack.  I also found this defect and placed the mysql-connector jar per its instructions with no success.  Is anyone experiencing this issue when deploying only the WAR into Tomcat 6.0.35?

Thank you for your help,
-John

On Nov 2, 2012, at 3:12 PM, John Burwell <jb...@basho.com> wrote:

> Edison,
> 
> I have been working to implement this workaround in our integration environment.  However, when I deploy the WAR and start Tomcat, I am getting the following stack trace indicating the JDBC can not find the MySQL driver:
> 
> INFO  [cloud.upgrade.DatabaseIntegrityChecker] (main:) Grabbing lock to check for database integrity.
> ERROR [db.Transaction.Transaction] (main:) Unexpected exception: 
> java.sql.SQLException: No suitable driver found for jdbc:mysql://192.168.123.200:3306/cloud?autoReconnect=true&prepStmtCacheSize=517&cachePrepStmts=true
>         at java.sql.DriverManager.getConnection(DriverManager.java:640)
>         at java.sql.DriverManager.getConnection(DriverManager.java:200)
>         at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75)
>         at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
>         at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1188)
>         at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
>         at com.cloud.utils.db.Transaction.getStandaloneConnectionWithException(Transaction.java:200)
>         at com.cloud.utils.db.Transaction.getStandaloneConnection(Transaction.java:209)
>         at com.cloud.utils.db.DbUtil.getConnectionForGlobalLocks(DbUtil.java:58)
>         at com.cloud.utils.db.DbUtil.getGlobalLock(DbUtil.java:203)
>         at com.cloud.utils.db.GlobalLock.lock(GlobalLock.java:159)
>         at com.cloud.upgrade.DatabaseIntegrityChecker.check(DatabaseIntegrityChecker.java:228)
>         at com.cloud.utils.component.ComponentLocator.runCheckers(ComponentLocator.java:304)
>         at com.cloud.utils.component.ComponentLocator.parse(ComponentLocator.java:276)
>         at com.cloud.utils.component.ComponentLocator.getLocatorInternal(ComponentLocator.java:867)
>         at com.cloud.utils.component.ComponentLocator.getLocator(ComponentLocator.java:905)
>         at com.cloud.utils.component.ComponentLocator.getComponent(ComponentLocator.java:447)
>         at com.cloud.utils.component.ComponentLocator.getComponent(ComponentLocator.java:440)
>         at com.cloud.servlet.CloudStartupServlet.init(CloudStartupServlet.java:44)
>         at javax.servlet.GenericServlet.init(GenericServlet.java:212)
>         at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1206)
>         at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1026)
>         at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4421)
>         at org.apache.catalina.core.StandardContext.start(StandardContext.java:4734)
>         at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
>         at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
>         at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
>         at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:943)
>         at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:778)
>         at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:504)
>         at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
>         at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
>         at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
>         at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
>         at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
>         at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
>         at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
>         at org.apache.catalina.core.StandardService.start(StandardService.java:525)
>         at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
>         at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:616)
>         at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
>         at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
> ERROR [utils.db.DbUtil] (main:) Unable to acquire DB connection for global lock system
> 
> I have tried moving the mysql JAR from the WEB-INF/lib directory to Tomcat's lib directory with no success.  I have also tried replacing the mysql-connector-java-5.1.7.jar with the cloud-mysql-connector-java-5.1.7.jar from devcloud also with no success.  The following is the deployment environment version information:
> 
> Ubuntu 12.04.1
> Tomcat 6.0.35 (installed via the Ubuntu tomcat6 package)
> OpenJDK 6 (OpenJDK Runtime Environment (IcedTea6 1.11.5) (6b24-1.11.5-0ubuntu1~12.04.1))
> 
> Also, for your reference, I have attached the catalina.out and vmops.log logs.
> 
> Thank you for your assistance,
> -John
> 
> <vmops.log>
> <catalina.out>
> 
> On Oct 29, 2012, at 4:46 PM, Edison Su <Ed...@citrix.com> wrote:
> 
>> People are planning to work on the deb build(http://markmail.org/message/lsjigqvnbkjtbl4y), don't know the status though.
>> For current master, the shortest cut is using WAR(~/.m2/repository/org/apache/cloudstack/cloud-client-ui/4.1.0-SNAPSHOT/cloud-client-ui-4.1.0-SNAPSHOT.war)
>> 
>>> -----Original Message-----
>>> From: John Burwell [mailto:jburwell@basho.com]
>>> Sent: Monday, October 29, 2012 1:18 PM
>>> To: cloudstack-dev@incubator.apache.org
>>> Subject: Re: Package Build Procedure
>>> 
>>> Edison,
>>> 
>>> Is there an ETA for landing those changes into master?  Also, how do you
>>> recommend packaging current master for deployment into an integration
>>> test environment?  We working under the (false) assumption that building
>>> Debian packages would be the shortest path.
>>> 
>>> Thanks,
>>> -John
>>> 
>>> On Oct 29, 2012, at 4:11 PM, Edison Su <Ed...@citrix.com> wrote:
>>> 
>>>> Packaging doesn't work on master branch, this is a known issue, unless we
>>> merged hugo's maven-to-rpm branch into master.
>>>> 
>>>>> -----Original Message-----
>>>>> From: Rohit Yadav [mailto:rohit.yadav@citrix.com]
>>>>> Sent: Monday, October 29, 2012 1:01 PM
>>>>> To: cloudstack-dev@incubator.apache.org
>>>>> Subject: RE: Package Build Procedure
>>>>> 
>>>>> Edison, building not much problem as packaging, from what I follow
>>>>> John is trying to do dpkg-buildpackage which fails.
>>>>> Updates, progress on packaging, rpm, debian?
>>>>> ________________________________________
>>>>> From: Edison Su [Edison.su@citrix.com]
>>>>> Sent: Tuesday, October 30, 2012 1:27 AM
>>>>> To: cloudstack-dev@incubator.apache.org
>>>>> Subject: RE: Package Build Procedure
>>>>> 
>>>>> Are you using the latest master or can you try it on latest master(HEAD:
>>>>> a2d50c7e43f7e7fe1493972646c6f776af9d8143)?
>>>>> The build works for me: mvn clean install -P developer
>>>>> 
>>>>>> -----Original Message-----
>>>>>> From: John Burwell [mailto:jburwell@basho.com]
>>>>>> Sent: Monday, October 29, 2012 11:37 AM
>>>>>> To: cloudstack-dev@incubator.apache.org
>>>>>> Subject: Re: Package Build Procedure
>>>>>> 
>>>>>> Edison and Rohit,
>>>>>> 
>>>>>> Attached is the output mvm -X -P developer -pl tools/apidoc.
>>>>>> 
>>>>>> Thank you for your help,
>>>>>> -John
>>>> 
>> 
>