Installation Windows/MSSQL 2012

Razuna v2 Legacy Self-Hosted
1

I’m having trouble with the finalization step of installation. It never finishes. I’ve tried the reset.cfm mentioned in another thread. I also installed using the standard installation and then tried to upgrade to MSSQL.

Below is part of the tomcat log.I see a 500 error, but not sure where to go from here.

127.0.0.1 - - [16/Sep/2014:21:42:14 -0400] “GET /razuna/admin/index.cfm?fa=c.first_time_account&path_imagemagick=C%3A%5CProgram+Files%5CImageMagick-6.8.9-Q16&path_ffmpeg=C%3A%5CFFMpeg%5Cbin&path_exiftool=C%3A%5CExiftool&path_dcraw=C%3A%5Cdcraw&path_mp4box=C%3A%5CProgram+Files+(x86)%5CGPAC&_=1410918066810 HTTP/1.1” 200 998
127.0.0.1 - - [16/Sep/2014:21:42:40 -0400] “POST /razuna/admin/index.cfm?fa=c.first_time_final HTTP/1.1” 500 4222

Dale

2

You forgot to tell us your environment, especially which Razuna version you are using.

3

Windows Server 2012 MSSQL 2014Tried both 1.6.5 and 1.7
Dale

4

For 1.6.5 this is already fixed. However, 1.7 should work too. We will look into this and will get back to you on this in the coming days.

Thank you for reporting this and making Razuna better.

5

I tried both versions and experienced the same problem.
Further troubleshooting:I checked the db and it has tables. I checked Windows Event Viewer but couldn’t find anything relative.

Dale

6

Hi Dale,
Please attach the corresponding error log that can be found under
/tomcat/webapps/razuna/WEB-INF/bluedragon/work/temp/rtelogs

It will help us debug the issue.

Thanks.

Harkirat

7

I figured out the problem. When I added the razuna user to the razuna db I made that user the owner of the db. This created a problem when executing sql statements like (select * from hosts). In query I had to use (select * from razuna.hosts) for successful execution.

The error message said that the object “hosts” did not exist in the db, when I could clearly see it in SQL Studio Manager.

I dropped the db and recreated it without giving razuna the db_owner role.

8

Glad you figured it out. The proper setup is described on our wiki at http://wiki.razuna.com/display/ecp/Setup+MSSQL+Server+for+Razuna