|
»
»
Can't set MySQL persistence adapter on startup
|
View:
New views
13 Messages
—
Rating Filter:
Alert me
|
 |
Can't set MySQL persistence adapter on startup
by phpslacker
::
Rate this Message:
Hey guys,
I'm having trouble starting activemq with mysql persistence adapter. Activemq won't start up instead it bombs out a gazillion exceptions Below is my activemq conf file and the output of trying to start activemq with this conf exceptions.log activemq.xml I use the following command to start activemq: root@qbuntu:/opt/activemq/bin# ./activemq xbean:file:/var/www/mobilesns/conf/activemq.xml Some more details about my env: ActiveMQ 5.2.0 Ubuntu Hardy LTS Server (Linux qbuntu 2.6.24-16-server #1 SMP Thu Apr 10 13:58:00 UTC 2008 i686 GNU/Linux) root@qbuntu:/opt/activemq/bin# java -version java version "1.5.0_16" Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_16-b02) Java HotSpot(TM) Client VM (build 1.5.0_16-b02, mixed mode, sharing) Hope thats all the info needed? Would appreciate some feedback/ideas on this. I must be doing something wrong?!?!? phpslacker |
|
|
Re: Can't set MySQL persistence adapter on startup
by bsnyder
::
Rate this Message:
On Mon, Jul 6, 2009 at 2:33 PM, phpslacker<quintonparker@...> wrote:
> > Hey guys, > > I'm having trouble starting activemq with mysql persistence adapter. > Activemq won't start up instead it bombs out a gazillion exceptions > > Below is my activemq conf file and the output of trying to start activemq > with this conf > > http://www.nabble.com/file/p24362359/exceptions.log exceptions.log > http://www.nabble.com/file/p24362359/activemq.xml activemq.xml > > I use the following command to start activemq: > > root@qbuntu:/opt/activemq/bin# ./activemq > xbean:file:/var/www/mobilesns/conf/activemq.xml > > Some more details about my env: > > ActiveMQ 5.2.0 > Ubuntu Hardy LTS Server (Linux qbuntu 2.6.24-16-server #1 SMP Thu Apr 10 > 13:58:00 UTC 2008 i686 GNU/Linux) > > root@qbuntu:/opt/activemq/bin# java -version > java version "1.5.0_16" > Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_16-b02) > Java HotSpot(TM) Client VM (build 1.5.0_16-b02, mixed mode, sharing) > > Hope thats all the info needed? > > Would appreciate some feedback/ideas on this. I must be doing something > wrong?!?!? If that's truly your activemq.xml, then I'm not surprised that you're having trouble since the only contents of that file is the following: file:///${activemq.base}/conf/credentials.properties org.foo.bar To use MySQL for persistence using the default activemq.xml config file, follow these steps: 1) Uncomment the MySQL DataSource Sample Setup bean definition near the end of the file 2) Comment out the amqPersistenceAdapter 3) Uncomment the journaledJDBC adapter 4) Change the #postgres-ds to #mysql-ds 5) Drop the appropriate MySQL JDBC driver jar into the ActiveMQ lib dir: http://repo2.maven.org/maven2/mysql/mysql-connector-java/ Bruce -- perl -e 'print unpack("u30","D0G)U8V4\@4VYY9&5R\"F)R=6-E+G-N>61E<D\!G;6%I;\"YC;VT*" );' ActiveMQ in Action: http://bit.ly/2je6cQ Blog: http://bruceblog.org/ Twitter: http://twitter.com/brucesnyder |
|
|
Re: Can't set MySQL persistence adapter on startup
by phpslacker
::
Rate this Message:
Hi Bruce Thanks for that BUT there must be a misunderstanding here. I did exactly those things you listed above. I'm gonna upload that conf file again: activemq.xml It definitely contains more than just this line: file:///${activemq.base}/conf/credentials.properties org.foo.bar |
|
|
Re: Can't set MySQL persistence adapter on startup
by bsnyder
::
Rate this Message:
On Tue, Jul 7, 2009 at 12:11 AM, phpslacker<quintonparker@...> wrote:
> Thanks for that BUT there must be a misunderstanding here. I did exactly > those things you listed above. I'm gonna upload that conf file again: > > http://www.nabble.com/file/p24367713/activemq.xml activemq.xml Yep, that file contains all the proper configuration. In fact, I added my database password to it, dropped the MySQL and DBCP jars into the ActiveMQ lib directory and ActiveMQ started up just fine using that configuration file. This tells me that there's nothing wrong with the configuration. If the activemq.xml file resides in the conf directory, then you should be able to start up ActiveMQ using the bin/activemq startup script. Is this how you are starting up ActiveMQ? Bruce -- perl -e 'print unpack("u30","D0G)U8V4\@4VYY9&5R\"F)R=6-E+G-N>61E<D\!G;6%I;\"YC;VT*" );' ActiveMQ in Action: http://bit.ly/2je6cQ Blog: http://bruceblog.org/ Twitter: http://twitter.com/brucesnyder |
|
|
Re: Can't set MySQL persistence adapter on startup
by phpslacker
::
Rate this Message:
Hey bruce, I've been starting up like this: root@qbuntu:/opt/apache-activemq-5.2.0/bin# ./activemq xbean:file:/somewhere-else/conf/activemq.xml I've also tried the method you describe above but I still get the same result. Which MySQL and DBCP jars did you use? Listing of my lib/optional directory: root@qbuntu:/opt/apache-activemq-5.2.0/lib/optional# ls -lta total 13864 drwxr-xr-x 2 root root 4096 Jul 7 08:13 . -rw-r--r-- 1 root root 703265 Jul 7 08:13 mysql-connector-java-5.1.6.jar -rw-r--r-- 1 root root 174864 Nov 6 2008 activemq-xmpp-5.2.0.jar -rw-r--r-- 1 root root 6631615 Nov 6 2008 activemq-rar-5.2.0.rar -rw-r--r-- 1 root root 78153 Nov 6 2008 activemq-optional-5.2.0.jar -rw-r--r-- 1 root root 38313 Nov 6 2008 activemq-pool-5.2.0.jar -rw-r--r-- 1 root root 81146 Nov 6 2008 activemq-jmdns_1.0-5.2.0.jar drwxr-xr-x 4 root root 4096 Nov 6 2008 .. -rw-r--r-- 1 root root 130203 Aug 8 2008 xbean-spring-3.4.jar -rw-r--r-- 1 root root 34409 Aug 8 2008 jetty-client-6.1.11.jar -rw-r--r-- 1 root root 188974 Aug 7 2008 spring-jms-2.5.5.jar -rw-r--r-- 1 root root 231371 Jul 30 2008 spring-tx-2.5.5.jar -rw-r--r-- 1 root root 411090 Jul 30 2008 xstream-1.3.jar -rw-r--r-- 1 root root 473406 Jul 30 2008 spring-context-2.5.5.jar -rw-r--r-- 1 root root 287288 Jul 30 2008 spring-core-2.5.5.jar -rw-r--r-- 1 root root 485785 Jul 30 2008 spring-beans-2.5.5.jar -rw-r--r-- 1 root root 326392 Jul 30 2008 spring-aop-2.5.5.jar -rw-r--r-- 1 root root 102837 Jul 24 2008 commons-dbcp-1.2.jar -rw-r--r-- 1 root root 118726 Jul 24 2008 commons-beanutils-1.6.1.jar -rw-r--r-- 1 root root 224754 Jul 24 2008 commons-httpclient-2.0.1.jar -rw-r--r-- 1 root root 24544 Jul 24 2008 xmlpull-1.1.3.4d_b4_min.jar -rw-r--r-- 1 root root 37477 Jul 24 2008 geronimo-j2ee-connector_1.5_spec-2.0.0.jar -rw-r--r-- 1 root root 367444 Jul 24 2008 log4j-1.2.14.jar -rw-r--r-- 1 root root 2141382 Jul 24 2008 derby-10.1.3.1.jar -rw-r--r-- 1 root root 87077 Jul 24 2008 commons-pool-1.4.jar -rw-r--r-- 1 root root 103896 Jul 24 2008 activeio-core-3.1.0.jar -rw-r--r-- 1 root root 559366 Jul 24 2008 commons-collections-3.1.jar Thanks again, appreciate the help |
|
|
Re: Can't set MySQL persistence adapter on startup
by Dejan Bosanac
::
Rate this Message:
As far as I can see, you have two <persistanceAdapter> tags in your config
file. Didn't test it, but can you leave only one that uses mysql and try it out? Cheers -- Dejan Bosanac Open Source Integration - http://fusesource.com/ ActiveMQ in Action - http://www.manning.com/snyder/ Blog - http://www.nighttale.net On Tue, Jul 7, 2009 at 9:23 AM, phpslacker <quintonparker@...> wrote: > > > > bsnyder wrote: > > > > If the activemq.xml file resides in the conf directory, then you > > should be able to start up ActiveMQ using the bin/activemq startup > > script. Is this how you are starting up ActiveMQ? > > > > Bruce > > -- > > perl -e 'print > > unpack("u30","D0G)U8V4\@4VYY9&5R\"F)R=6-E+G-N>61E<D\!G;6%I;\"YC;VT*" > > );' > > > > ActiveMQ in Action: http://bit.ly/2je6cQ > > Blog: http://bruceblog.org/ > > Twitter: http://twitter.com/brucesnyder > > > > > > Hey bruce, > > I've been starting up like this: > > root@qbuntu:/opt/apache-activemq-5.2.0/bin# ./activemq > xbean:file:/somewhere-else/conf/activemq.xml > > I've also tried the method you describe above but I still get the same > result. Which MySQL and DBCP jars did you use? Listing of my lib/optional > directory: > > root@qbuntu:/opt/apache-activemq-5.2.0/lib/optional# ls -lta > total 13864 > drwxr-xr-x 2 root root 4096 Jul 7 08:13 . > -rw-r--r-- 1 root root 703265 Jul 7 08:13 mysql-connector-java-5.1.6.jar > -rw-r--r-- 1 root root 174864 Nov 6 2008 activemq-xmpp-5.2.0.jar > -rw-r--r-- 1 root root 6631615 Nov 6 2008 activemq-rar-5.2.0.rar > -rw-r--r-- 1 root root 78153 Nov 6 2008 activemq-optional-5.2.0.jar > -rw-r--r-- 1 root root 38313 Nov 6 2008 activemq-pool-5.2.0.jar > -rw-r--r-- 1 root root 81146 Nov 6 2008 activemq-jmdns_1.0-5.2.0.jar > drwxr-xr-x 4 root root 4096 Nov 6 2008 .. > -rw-r--r-- 1 root root 130203 Aug 8 2008 xbean-spring-3.4.jar > -rw-r--r-- 1 root root 34409 Aug 8 2008 jetty-client-6.1.11.jar > -rw-r--r-- 1 root root 188974 Aug 7 2008 spring-jms-2.5.5.jar > -rw-r--r-- 1 root root 231371 Jul 30 2008 spring-tx-2.5.5.jar > -rw-r--r-- 1 root root 411090 Jul 30 2008 xstream-1.3.jar > -rw-r--r-- 1 root root 473406 Jul 30 2008 spring-context-2.5.5.jar > -rw-r--r-- 1 root root 287288 Jul 30 2008 spring-core-2.5.5.jar > -rw-r--r-- 1 root root 485785 Jul 30 2008 spring-beans-2.5.5.jar > -rw-r--r-- 1 root root 326392 Jul 30 2008 spring-aop-2.5.5.jar > -rw-r--r-- 1 root root 102837 Jul 24 2008 commons-dbcp-1.2.jar > -rw-r--r-- 1 root root 118726 Jul 24 2008 commons-beanutils-1.6.1.jar > -rw-r--r-- 1 root root 224754 Jul 24 2008 commons-httpclient-2.0.1.jar > -rw-r--r-- 1 root root 24544 Jul 24 2008 xmlpull-1.1.3.4d_b4_min.jar > -rw-r--r-- 1 root root 37477 Jul 24 2008 > geronimo-j2ee-connector_1.5_spec-2.0.0.jar > -rw-r--r-- 1 root root 367444 Jul 24 2008 log4j-1.2.14.jar > -rw-r--r-- 1 root root 2141382 Jul 24 2008 derby-10.1.3.1.jar > -rw-r--r-- 1 root root 87077 Jul 24 2008 commons-pool-1.4.jar > -rw-r--r-- 1 root root 103896 Jul 24 2008 activeio-core-3.1.0.jar > -rw-r--r-- 1 root root 559366 Jul 24 2008 commons-collections-3.1.jar > > > Thanks again, appreciate the help > > > > > > > -- > View this message in context: > http://www.nabble.com/Can%27t-set-MySQL-persistence-adapter-on-startup-tp24362359p24368380.html > Sent from the ActiveMQ - User mailing list archive at Nabble.com. > > Dejan Bosanac
Open Source Integration - http://fusesource.com/ ActiveMQ in Action - http://www.manning.com/snyder/ Blog - http://www.nighttale.net |
|
|
Re: Can't set MySQL persistence adapter on startup
by phpslacker
::
Rate this Message:
Hi Dejan, I saw that too *blush* I did comment out the amq persistenceAdapter tag But i still can't start activemq |
|
|
Re: Can't set MySQL persistence adapter on startup
by bsnyder
::
Rate this Message:
On Tue, Jul 7, 2009 at 1:23 AM, phpslacker<quintonparker@...> wrote:
> I've been starting up like this: > > root@qbuntu:/opt/apache-activemq-5.2.0/bin# ./activemq > xbean:file:/somewhere-else/conf/activemq.xml > > I've also tried the method you describe above but I still get the same > result. Which MySQL and DBCP jars did you use? Listing of my lib/optional > directory: > > root@qbuntu:/opt/apache-activemq-5.2.0/lib/optional# ls -lta > total 13864 > drwxr-xr-x 2 root root 4096 Jul 7 08:13 . > -rw-r--r-- 1 root root 703265 Jul 7 08:13 mysql-connector-java-5.1.6.jar > -rw-r--r-- 1 root root 174864 Nov 6 2008 activemq-xmpp-5.2.0.jar > -rw-r--r-- 1 root root 6631615 Nov 6 2008 activemq-rar-5.2.0.rar > -rw-r--r-- 1 root root 78153 Nov 6 2008 activemq-optional-5.2.0.jar > -rw-r--r-- 1 root root 38313 Nov 6 2008 activemq-pool-5.2.0.jar > -rw-r--r-- 1 root root 81146 Nov 6 2008 activemq-jmdns_1.0-5.2.0.jar > drwxr-xr-x 4 root root 4096 Nov 6 2008 .. > -rw-r--r-- 1 root root 130203 Aug 8 2008 xbean-spring-3.4.jar > -rw-r--r-- 1 root root 34409 Aug 8 2008 jetty-client-6.1.11.jar > -rw-r--r-- 1 root root 188974 Aug 7 2008 spring-jms-2.5.5.jar > -rw-r--r-- 1 root root 231371 Jul 30 2008 spring-tx-2.5.5.jar > -rw-r--r-- 1 root root 411090 Jul 30 2008 xstream-1.3.jar > -rw-r--r-- 1 root root 473406 Jul 30 2008 spring-context-2.5.5.jar > -rw-r--r-- 1 root root 287288 Jul 30 2008 spring-core-2.5.5.jar > -rw-r--r-- 1 root root 485785 Jul 30 2008 spring-beans-2.5.5.jar > -rw-r--r-- 1 root root 326392 Jul 30 2008 spring-aop-2.5.5.jar > -rw-r--r-- 1 root root 102837 Jul 24 2008 commons-dbcp-1.2.jar > -rw-r--r-- 1 root root 118726 Jul 24 2008 commons-beanutils-1.6.1.jar > -rw-r--r-- 1 root root 224754 Jul 24 2008 commons-httpclient-2.0.1.jar > -rw-r--r-- 1 root root 24544 Jul 24 2008 xmlpull-1.1.3.4d_b4_min.jar > -rw-r--r-- 1 root root 37477 Jul 24 2008 > geronimo-j2ee-connector_1.5_spec-2.0.0.jar > -rw-r--r-- 1 root root 367444 Jul 24 2008 log4j-1.2.14.jar > -rw-r--r-- 1 root root 2141382 Jul 24 2008 derby-10.1.3.1.jar > -rw-r--r-- 1 root root 87077 Jul 24 2008 commons-pool-1.4.jar > -rw-r--r-- 1 root root 103896 Jul 24 2008 activeio-core-3.1.0.jar > -rw-r--r-- 1 root root 559366 Jul 24 2008 commons-collections-3.1.jar Those versions of the jars should be fine. Just out of curiousity, what version of MySQL are you using? Are you still seeing the same exceptions that you posted originally or have they changed since then? Bruce -- perl -e 'print unpack("u30","D0G)U8V4\@4VYY9&5R\"F)R=6-E+G-N>61E<D\!G;6%I;\"YC;VT*" );' ActiveMQ in Action: http://bit.ly/2je6cQ Blog: http://bruceblog.org/ Twitter: http://twitter.com/brucesnyder |
|
|
Re: Can't set MySQL persistence adapter on startup
by phpslacker
::
Rate this Message:
Hey bruce/dejan
I've edited my conf file so many times i think it best to start from scratch So i'll try a completely fresh installation of activemq Lets see if that works |
|
|
Re: Can't set MySQL persistence adapter on startup
by phpslacker
::
Rate this Message:
quinton@qbuntu:/opt/activemq/bin$ mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3144 Server version: 5.0.51a-3ubuntu5 (Ubuntu) Same exceptions :-( |
|
|
Re: Can't set MySQL persistence adapter on startup
by phpslacker
::
Rate this Message:
Hey bruce, Good news. I decided to start from a completely fresh installation and follower your instructions above and she worked. yay! In case you're interested i've attached a diff between the new and old xml conf to this post diff.txt (the old conf is second in the diff) Thanks you guys |
|
|
Re: Can't set MySQL persistence adapter on startup
by Dejan Bosanac
::
Rate this Message:
You can also try dropping activemq database in your MySQL server.
Cheers -- Dejan Bosanac Open Source Integration - http://fusesource.com/ ActiveMQ in Action - http://www.manning.com/snyder/ Blog - http://www.nighttale.net On Tue, Jul 7, 2009 at 9:54 AM, phpslacker <quintonparker@...> wrote: > > > > bsnyder wrote: > > > > what version of MySQL are you using? > > > > quinton@qbuntu:/opt/activemq/bin$ mysql -u root > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 3144 > Server version: 5.0.51a-3ubuntu5 (Ubuntu) > > > bsnyder wrote: > > > > > > Are you still seeing the same exceptions that you posted originally or > > have they changed since then? > > > > Same exceptions :-( > -- > View this message in context: > http://www.nabble.com/Can%27t-set-MySQL-persistence-adapter-on-startup-tp24362359p24368731.html > Sent from the ActiveMQ - User mailing list archive at Nabble.com. > > Dejan Bosanac
Open Source Integration - http://fusesource.com/ ActiveMQ in Action - http://www.manning.com/snyder/ Blog - http://www.nighttale.net |
|
|
Re: Can't set MySQL persistence adapter on startup
by bsnyder
::
Rate this Message:
On Tue, Jul 7, 2009 at 2:07 AM, phpslacker<quintonparker@...> wrote:
> Good news. I decided to start from a completely fresh installation and > follower your instructions above and she worked. yay! > > In case you're interested i've attached a diff between the new and old xml > conf to this post > > http://www.nabble.com/file/p24368882/diff.txt diff.txt > > (the old conf is second in the diff) Not much difference it seems, but I'm glad it's working. Bruce -- perl -e 'print unpack("u30","D0G)U8V4\@4VYY9&5R\"F)R=6-E+G-N>61E<D\!G;6%I;\"YC;VT*" );' ActiveMQ in Action: http://bit.ly/2je6cQ Blog: http://bruceblog.org/ Twitter: http://twitter.com/brucesnyder |
| Free embeddable forum powered by Nabble | Forum Help |
