upgrade issue

[1000camels]

as a followup to the last post, when i start tomcat, razuna creates
this directory in the directory in which i started tomcat, and it
includes a lock file: razuna_default.lock.db

C:\razuna_tomcat_1_4_6\tomcat\webapps\razuna\db

this is a single directory, not a series of directories

[1000camels]

i've copied my my backup db to the new RC version and after starting
tomcat, i get this error:

Error opening database: "Could not load properties /home/razuna/C:
\razuna_tomcat_1_4_6\tomcat\webapps\razuna\db/
razuna_default.lock.db" [8000-147]


i'm running on unix, so the windows style path looks bad to me - is
this hard-coded somewhere?

[Nitai @ Razuna]

You are not supposed to copy over your db from 1.4.5 top the db folder.

Please do a backup in 1.4.5, copy the backup to the admin/backup folder of 1.4.6 and run the first time installer and import.

Our wiki upgrade guide outlines this in more detail.

> --
> You received this message because you are subscribed to the Google Groups "razuna-testers" group.
> To post to this group, send email to razuna-...@googlegroups.com.
> To unsubscribe from this group, send email to razuna-tester...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/razuna-testers?hl=en.
>

[darcy w. christ]

i figured i was doing something wrong.

i'm confused about a few things.

i am doing a backup through the UI. i am then copying razuna_backup.h2.db, razuna_backup.lobs.db, razuna_backup.trace.db from 1.4.5/admin/backup to 1.4.6/admin/backup

is that not correct?

also, why would the windows style reference (C:\razuna_tomcat_1_4_6\tomcat\webapps\razuna\db) appear anywhere on my ubuntu

~/darcy w. christ
@1000camels

[Nitai @ Razuna]

Your previous message said you copied the backup (or even the dbs in the razuna/db folder) to the db folder, no?

That is why you got an error. As outlined in our wiki upgrade guide (wiki.razuna.com) you should follow another path. I kindly ask you to follow that guide.

(since we not only support one database we had to do things a bit different when it comes to backup and import)

Not sure why you got windows path names in there, but I wouldn't worry about it. It is clearly something in the engine and had nothing to do with razuna or your system.

[Thomas Johnson]

I'm seeing similar issues on a fresh install of Razuna 1.4.6 RC1. In fact, I'm seeing the exact same windows paths embedded in my unix paths:

Error opening database: "Could not load properties /usr/local/razuna/razuna_tomcat_1_4_6/tomcat/bin/C:\razuna_tomcat_1_4_6\tomcat\webapps\razuna\db/razuna_default.lock.db" [8000-147]

Running grep -ri 'C:\\' razuna_tomcat_1_4_6 turns up several hard-coded windows paths, which seems a little bit unusual:

webapps/razuna/WEB-INF/bluedragon/bluedragon.xml:      <path>C:\razuna_tomcat_1_4_6\tomcat\webapps\razuna\WEB-INF\bluedragon\work\cfcollection</path>

webapps/razuna/WEB-INF/bluedragon/bluedragon.xml:    <dirs>C:\Windows\Fonts</dirs>

(snipped for brevity)

A similar search on 1.4.5 shows a smaller number of matches belonging mostly to html and text files.

Additionally, the presence of webapps/razuna/WEB-INF/bluedragon/bluedragon.xml.bak.6 in the filelist strikes me as anomalous. A fresh install of 1.4.5 on the same machine seems to land me at the setup wizard as expected.

[Nitai @ Razuna]

The different backup files are normal.

Right, so please go into the bluedragon.xml file and remove any path
value that looks like Windows. Start up Tomcat again and then you
should be at the first time wizard. Also remove the "DB" folder in the
"razuna" folder.

Kind Regards,
Nitai

> --
> You received this message because you are subscribed to the Google Groups
> "razuna-testers" group.

> To view this discussion on the web visit
> https://groups.google.com/d/msg/razuna-testers/-/BQsQPIj2imsJ.

> To post to this group, send email to razuna-...@googlegroups.com.
> To unsubscribe from this group, send email to
> razuna-tester...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/razuna-testers?hl=en.
>

--
See for yourself how easy it is to manage files today. Join the revolution!

Razuna SaaS On-Demand - Hosted Digital Asset Management Solution
http://www.razuna.com/

Razuna - Open Source Digital Asset Management
http://www.razuna.org/

Follow us on Twitter
http://twitter.com/razunahq

[Nitai @ Razuna]

Hi guys,

I'm seeing what went wrong in the distribution. Until I update it,
please use the attached "bluedragon.zip" folder and copy/overwrite the
existing one in the "WEB-INF" folder. Sorry about that.

Please let me know if it works now.

Kind Regards,
Nitai

[Nitai @ Razuna]

Ok, I updated the distribution file online. But if you have a chance
please take the files from my last message and tell me if it works.
Again I apologize on this.

Kind Regards,
Nitai

[darcy w. christ]

thanks for the quick fix.

upon restoring from a mysql backup, i ran into some similar errors to what i experienced a month ago. this was fixed. i cannot be certain it is the same error, but it is certainly similar.

A error occured during import on table raz1_images_text!
Database reported: Cannot add or update a child row: a foreign key constraint fails (`razuna/raz1_images_text`, CONSTRAINT `raz1_images_text_ibfk_1` FOREIGN KEY (`IMG_ID_R`) REFERENCES `raz1_images` (`IMG_ID`) ON DELETE CASCADE)

A error occured during import on table raz1_images_text!
Database reported: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') VALUES( 2 ' at line 2
(this last line is repeated multiple times, presumably for each record being inserted into that table)

~/darcy w. christ
@1000camels

[Nitai @ Razuna]

This is an error that comes up during importing of the database. That
is because Razuna was not able to delete your foreign key while
"cleaning" the database.

Remedy is to import again. I know of this issue and it comes up from
time to time. Still have to figure out why it is so.

Kind Regards,
Nitai