Hi Noam,
Thanks for the reply. This is NOT a production-system, I just wanted to
show a customer a couple of things.
I was going to try your second option, but I am not sure on what I
should delete from the WAR-files and add in Tomcat. Would just the
derby-* libraries do, or is there more to derby that needs to be excluded?
Thanks!
Roland
On 11-11-10 15:18, Noam Tenne [via Artifactory] wrote:
> Hi Roland,
>
> First off, I'd like to recommend that for production purposes, you
> switch Artifactory from Derby to filesystem-mysql, as it results in much
> improved performance.
>
> Running out-of-the-box Artifactory in conjunction with Sonar on the same
> Tomcat will cause the clash you experienced since you should not run 2
> embedded Derby instances on the same JVM.
>
> If you'd like to run this setup anyway, there are two (kinda-hackish)
> ways to do so.
> Upon using any of these methods, you should first remove all the Derby
> dependencies from the Sonar and Artifactory WAR files and put them into
> Tomcat's lib folder so that they won't clash in cases of different versions.
>
> First option:
> This method requires Artifactory to be initialized by Tomcat
> *after* Sonar, since Sonar requires Derby for authentication.
> When Artifactory will be loaded after Sonar, it will cancel Sonar's
> prior declaration that requires authentication.
> To do this:
>
> 1. Simply add "derby.connection.requireAuthentication=false" to the
> artifactory.system.properties file in $ARTIFACTORY_HOME/etc.
> 2. Restart.
>
>
> Second method:
> This method requires you to start from a clean data folder (that is,
> completely remove the data folder from $ARTIFACTORY_HOME).
> Sonar connects to Derby via port 1527 with the credentials sonar:sonar
> as opposed to Artifactory which connects directly to the file system
> with no authentication.
> We can modify Artifactory to connect to the same port and use the same
> credentials defined by Sonar.
> To do this:
>
> 1. Edit the artifactory.system.properties file in
> $ARTIFACTORY_HOME/etc to uncomment "artifactory.jcr.configDir and
> point it to repo/filesystem-derby configuration.
> 2. edit the repo.xml file in
> $ARTIFACTORY_HOME/etc/repo/filesystem-derby and in all three
> blocks of the DataSources element (rep_ds, store_ds, db_ds)
> replace the "${repo.home}" part of the URL to "localhost:1527",
> and change to the username and password parameters to "sonar".
> 3. Restart.
>
> HTH and have fun,
> Noam
>
> On Thu, Nov 11, 2010 at 11:35 AM, Asmann, Roland <[hidden email]
> </user/SendEmail.jtp?type=node&node=5728771&i=0>> wrote:
>
> Hi all,
>
> I'm trying to set up a demo-computer to take to a customer, but I seem
> to have problems with the derby-db. I have Sonar running on this
> computer (which uses Derby) and I'm not sure if both are trying to
> connect to the same DB/use the same port!
>
> I'm using Tomcat to deploy both projects in, and initially it seems to
> run without problems. However, after stopping Tomcat and restarting it,
> I get an error from Sonar telling me 'Connection authentication failure
> occurred. Reason: Invalid authentication..'
>
> I already posted on the Sonar mailing-list, but they tell me it is
> impossible to change the port Derby is running on in Sonar. Is there
> something I can change on the side of Artifactory?
>
> --
> Roland Asmann
> Senior Software Engineer
>
> adesso Austria GmbH
> Floridotower 26. Stock T +43 1 2198790-27
> Floridsdorfer Hauptstr. 1 F +43 1 2198790-927
> A-1210 Wien M +43 664 88657566
> E [hidden email]
> </user/SendEmail.jtp?type=node&node=5728771&i=1>
> W www.adesso.at
> <http://www.adesso.at?by-user=t>
>
> -------------------------------------------------------------
> >>> business. people. technology. <<<
> -------------------------------------------------------------
>
>
> ------------------------------------------------------------------------------
> Centralized Desktop Delivery: Dell and VMware Reference Architecture
> Simplifying enterprise desktop deployment and management using
> Dell EqualLogic storage and VMware View: A highly scalable, end-to-end
> client virtualization framework. Read more!
> http://p.sf.net/sfu/dell-eql-dev2dev
> _______________________________________________
> Artifactory-users mailing list
> [hidden email] </user/SendEmail.jtp?type=node&node=5728771&i=2>
> https://lists.sourceforge.net/lists/listinfo/artifactory-users
>
>
>
> ------------------------------------------------------------------------------
>
> Centralized Desktop Delivery: Dell and VMware Reference Architecture
> Simplifying enterprise desktop deployment and management using
> Dell EqualLogic storage and VMware View: A highly scalable, end-to-end
> client virtualization framework. Read more!
> http://p.sf.net/sfu/dell-eql-dev2dev
> _______________________________________________
> Artifactory-users mailing list
> [hidden email] </user/SendEmail.jtp?type=node&node=5728771&i=3>
> https://lists.sourceforge.net/lists/listinfo/artifactory-users
>
>
> ------------------------------------------------------------------------
> View message @
> http://forums.jfrog.org/Problems-with-Derby-tp5728179p5728771.html
> To start a new topic under Artifactory - Users, email
> [email protected]
> To unsubscribe from Artifactory - Users, click here
> <http://forums.jfrog.org/template/TplServlet.jtp?tpl=unsubscribe_by_code&node=2377369&code=cm9sYW5kLmFzbWFubkBhZGVzc28uYXR8MjM3NzM2OXwtMjAyMTk2NzUyNA==>.
>
>
--
Roland Asmann
Senior Software Engineer
adesso Austria GmbH
Floridotower 26. Stock T +43 1 2198790-27
Floridsdorfer Hauptstr. 1 F +43 1 2198790-927
A-1210 Wien M +43 664 88657566
E [email protected]
W www.adesso.at
-------------------------------------------------------------
>>> business. people. technology. <<<
-------------------------------------------------------------
--
View this message in context:
http://forums.jfrog.org/Problems-with-Derby-tp5728179p5729091.html
Sent from the Artifactory - Users mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Centralized Desktop Delivery: Dell and VMware Reference Architecture
Simplifying enterprise desktop deployment and management using
Dell EqualLogic storage and VMware View: A highly scalable, end-to-end
client virtualization framework. Read more!
http://p.sf.net/sfu/dell-eql-dev2dev
_______________________________________________
Artifactory-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/artifactory-users
