Can't start server on Ubuntu 22.04 - Database version error

[kc7gr]

Good day,

I'm attempting to try out Data Crow server on Ubuntu 22.04 LTS, Java ver. 17. Here's a screen dump of what I get when I try to start things up the first time.

kyrrin@crow:~/dc-server$ java -Xmx1024m -jar datacrow-server.jar -userdir:/home/kyrrin/userdir -credentials:SA/ -ip:192.168.42.116
2023-04-30 11:16:11,185 [main] INFO : Logger enabled
2023-04-30 11:16:11,192 [main] INFO : Using installation directory: /home/kyrrin/dc-server/
2023-04-30 11:16:11,193 [main] INFO : Using user directory: /home/kyrrin/userdir/
2023-04-30 11:16:11,194 [main] INFO : Using images directory: /home/kyrrin/userdir/images/
2023-04-30 11:16:11,195 [main] INFO : Using database directory: /home/kyrrin/userdir/database/
2023-04-30 11:16:11,999 [main] INFO : Data Crow 4.8.1
2023-04-30 11:16:12,000 [main] INFO : Java version: 17.0.6
2023-04-30 11:16:12,001 [main] INFO : Java vendor: Private Build
2023-04-30 11:16:12,003 [main] INFO : Operating System: Linux
2023-04-30 11:16:12,005 [main] INFO : Sun Apr 30 11:16:12 PDT 2023 Starting Data Crow Server.
2023-04-30 11:16:12,146 [main] INFO : Upgraded module movie, altered field Frames
2023-04-30 11:16:12,147 [main] INFO : Upgraded module movie, altered field Audio Bitrate
2023-04-30 11:16:12,148 [main] INFO : Upgraded module movie, altered field Audio Sample Rate
2023-04-30 11:16:12,149 [main] INFO : Upgraded module movie, altered field Audio Channels
2023-04-30 11:16:12,149 [main] INFO : Upgraded module movie, altered field Video Bitrate
2023-04-30 11:16:12,150 [main] INFO : Upgraded module movie, altered field Width
2023-04-30 11:16:12,150 [main] INFO : Upgraded module movie, altered field Height
2023-04-30 11:16:12,160 [main] INFO : Upgraded module Record Label, altered field Description
2023-04-30 11:16:12,160 [main] INFO : Upgraded module Record Label, altered field Webpage
2023-04-30 11:16:12,161 [main] INFO : Upgraded module Record Label, altered field Name
2023-04-30 11:16:12,162 [main] INFO : Upgraded module Record Label, altered field Contact Information
2023-04-30 11:16:12,170 [main] INFO : Upgraded module Music Album, altered field Record Label
The version of the database [0.0.0] is not supported by this version of Data Crow. First upgrade to version 3.12.5. After upgrading to version 3.12.5 you can use the database with this version of Data Crow. NOTE: It is always important to make backups; before and after upgrading to version 3.12.5 make a backup of Data Crow (Tools > Backup & Restore).

Server has stopped
kyrrin@crow:~/dc-server$

Web searches on this issue have been inconclusive at best. How can I correct the database error?

Thanks much.

[Robert Jan van der Waals]

Hi,

I have tried the same just now on Ubuntu, on a completely clean environment and it did actually create a new database for me and I was able to connect (same Java version, same Ubuntu version). That's unfortunate as that does not help you at all; we need to find out why it is not working in your environment.

Just to confirm, this is a completely new setup? As in, you are not upgrading an old version?

You could add the -debug parameter just to see if there's any hidden messages, maybe it failed to initialize the database correctly. Your terminal command looks to be OK, so that is not the problem.

You can also retry the startup attempt, as a test, by specifying another userdir or by removing the current user dir (/home/kyrrin/userdir/database/). But only of course if this not an upgrade of older version of Data Crow.

Cheers,
Robert

[dakota]

Hi,

I am having the same problem. The first time I run the setup, it says invalid credentials; the second and any time after that it gives a database error saying I have version 0.0.0 and need to upgrade. This is a completely new install. I have tried deleting both the database folder and the entire user folder and the problem persists.

I ran it with the debug parameter as well, it didn't show anything about the database before it came up with the error. I'm on linux mint 21.1 Vera (base Ubuntu 22.04 jammy), java version 17.0.6. Output below, this is w/o debug as it was so long but I can post that if it is helpful.

Apologies for any breaches in etiquette, this is my first post on here as I couldn't figure out how to get past this problem. Thank you for any help you are able to provide!

Edit: I also tried it with a completely different user folder, with the same result. I did attach a file with the results from running it with debug on.

---

~/Programs/dc-server$ sudo java -Xmx1024m -jar datacrow-server.jar -userdir:/home/dakota/Programs/dc-user/ -port:9000 -imageserverport:9001 -webserverport:9002 -credentials:xxxx/xxxx -ip:10.0.0.11
2023-05-03 03:47:18,131 [main] INFO : Logger enabled
2023-05-03 03:47:18,138 [main] INFO : Using installation directory: /home/dakota/Programs/dc-server/
2023-05-03 03:47:18,139 [main] INFO : Using user directory: /home/dakota/Programs/dc-user/
2023-05-03 03:47:18,140 [main] INFO : Using images directory: /home/dakota/Programs/dc-user/images/
2023-05-03 03:47:18,141 [main] INFO : Using database directory: /home/dakota/Programs/dc-user/database/
2023-05-03 03:47:18,795 [main] INFO : Data Crow 4.8.1
2023-05-03 03:47:18,796 [main] INFO : Java version: 17.0.6
2023-05-03 03:47:18,796 [main] INFO : Java vendor: Private Build
2023-05-03 03:47:18,797 [main] INFO : Operating System: Linux
2023-05-03 03:47:18,798 [main] INFO : Wed May 03 03:47:18 CDT 2023 Starting Data Crow Server.
2023-05-03 03:47:18,890 [main] INFO : Upgraded module movie, altered field Frames
2023-05-03 03:47:18,891 [main] INFO : Upgraded module movie, altered field Audio Bitrate
2023-05-03 03:47:18,892 [main] INFO : Upgraded module movie, altered field Audio Sample Rate
2023-05-03 03:47:18,892 [main] INFO : Upgraded module movie, altered field Audio Channels
2023-05-03 03:47:18,892 [main] INFO : Upgraded module movie, altered field Video Bitrate
2023-05-03 03:47:18,893 [main] INFO : Upgraded module movie, altered field Width
2023-05-03 03:47:18,894 [main] INFO : Upgraded module movie, altered field Height
2023-05-03 03:47:18,900 [main] INFO : Upgraded module Record Label, altered field Description
2023-05-03 03:47:18,901 [main] INFO : Upgraded module Record Label, altered field Webpage
2023-05-03 03:47:18,902 [main] INFO : Upgraded module Record Label, altered field Name
2023-05-03 03:47:18,902 [main] INFO : Upgraded module Record Label, altered field Contact Information
2023-05-03 03:47:18,907 [main] INFO : Upgraded module Music Album, altered field Record Label
The version of the database [0.0.0] is not supported by this version of Data Crow. First upgrade to version 3.12.5. After upgrading to version 3.12.5 you can use the database with this version of Data Crow. NOTE: It is always important to make backups; before and after upgrading to version 3.12.5 make a backup of Data Crow (Tools > Backup & Restore).

Server has stopped

[Robert Jan van der Waals]

Hi,

Thanks for that! No breach of anything, no worries :-)

Can you start it with credentials SA, so (after clearing the user2 folder):

sudo java -jar datacrow-server.jar -userdir:/home/dakota/Programs/dc-user2/ -port:9000 -imageserverport:9001 -webserverport:9002 -credentials:SA -ip:10.0.0.11 -debug

Cheers,
Robert

[dakota]

Robert,

That worked. Thank you kindly sir. I guess something was off with the non-default credentials? Regardless looking forward to exploring the software!

[Robert Jan van der Waals]

Hi,

Well, yes - I think it is actually a bug to be honest. I'll update this for version 4.9 so that when you supply different credentials on startup for a completely new installation it will actually create a new user for this. I can see how one could go wrong here and I think the expectation is correct; if you supply credentials for a new installation they should always be valid.

But until there's a fix the initial installation will require the credentials to be "SA";

sudo java -jar datacrow-server.jar -userdir:/home/rwaals/datacrow/data -port:9000 -imageserverport:9001 -webserverport:9002 -credentials:SA -ip:xxx.xxx.xxx.xxx

Thanks for the help,
All the best,
Robert

[Robert Jan van der Waals]

Fixed in version 4.9; now if you give credentials when creating a new Data Crow instance, Data Crow will create a user with these credentials. Previously it would only work with username SA and a blank password.