Problems with jackrabbit configuration and remote MySql database

I'm trying to configure jackrabbit to work with a remote mysql database. I have changed JackRabbit to work with MySql instead of the default derby by adding a Versioning and Workspace configuration for mysql. This same configuration works on a local mysql database (ofbiz and mysql on same

Re: Problems with jackrabbit configuration and remote MySql database

and restarted the server and everything came up all right after that. Brett On Mon, Oct 8, 2012 at 10:43 AM, Brett Palmer brettgpal...@gmail.comwrote: I'm trying to configure jackrabbit to work with a remote mysql database. I have changed JackRabbit to work with MySql instead of the default

Re: Does ofbiz support regular query for mysql database?

/entity.html Cheers Paul Foxworthy zhiyongcui wrote Does ofbiz support regular query for mysql database? - -- Coherent Software Australia Pty Ltd http://www.cohsoft.com.au/ Bonsai ERP, the all-inclusive ERP system http://www.bonsaierp.com.au/ -- View this message in context: http://ofbiz.135035

Mysql database

That ofbiz.visual_theme database is not available is what I get when configure ofbiz with mysql.What should i do ? Thanks in advance

Re: Mysql database

What url are you trying? What version of ofbiz are you using? Have you installed the demo or seed data? If you have just installed seed and not demo data, try using the ofbizsetup That ofbiz.visual_theme database is not available is what I get when configure ofbiz with mysql.What should i do

Re: Mysql database

On Wed, Apr 21, 2010 at 8:15 PM, Chris Snow sno...@snowconsulting.co.ukwrote: What url are you trying? What version of ofbiz are you using? Have you installed the demo or seed data? If you have just installed seed and not demo data, try using the ofbizsetup That ofbiz.visual_theme

Re: Mysql database

On Wed, Apr 21, 2010 at 8:15 PM, Chris Snow sno...@snowconsulting.co.ukwrote: What url are you trying? What version of ofbiz are you using? Have you installed the demo or seed data? If you have just installed seed and not demo data, try using the ofbizsetup That ofbiz.visual_theme

Error when using mysql database instead of derby

Hi All! I am still new to Ofbiz... Not sure why this is happening but all I did after creating the mysql database and getting the latest mysql driver, was to go in and change the entityengine.xml file to point to the mysql database. The entity engine did its thing recreating new tables

MySQL database automatic periodic backup

Hi list, I would like to have OFBiz automatically backup its own database at regular time intervals. Has someone already done something similar or could offer me some idea on the best way to implement it? Many thanks, -Bruno

Re: MySQL database automatic periodic backup

if you talking about the actual database no. this would require a class that is specific to each database that would be specified in the entityengine.xml however if you look at webtools, you can export the data as entities. using that as a model you can export and add date-time to the files. this

Re: MySQL database automatic periodic backup

Hi BJ, sometime I read in the list that the OFBiz export fuctionality was not intended to be used to perform a system administration database backup. I was thinking to run through an OFBiz re-occurring service an external mysql dump command or similar. Are somewhere examples of running similar

Re: MySQL database automatic periodic backup

Each database has a different way to back up. so yes, if you write the low level database dependent class then write a general back service that call the back up class that has been loaded for that database, you could do this. Bruno Busco sent the following on 12/7/2008 10:26 AM: Hi BJ,

Re: MySQL database automatic periodic backup

It sounds like it would be better to keep this out of OFBiz if you don't want the data running through the Entity Engine and the applications. Yes, the service engine supports scheduled services and you can use hack-ish things to call command-line programs, but cron is way more direct

Re: MySQL database automatic periodic backup

Agree on not putting the backup inside the backuped system. Run it either cold or hot, I run mysqldump every day and the backups are nicely restored with load (set constraints off, load, set constraints on). Regards, Sven 2008/12/7 David E Jones [EMAIL PROTECTED] It sounds like it would be

Re: MySQL database automatic periodic backup

Many thanks for the clarification. I will definitively go with cron. -Bruno 2008/12/7 Sven Wesley [EMAIL PROTECTED] Agree on not putting the backup inside the backuped system. Run it either cold or hot, I run mysqldump every day and the backups are nicely restored with load (set constraints