User demo does not exist

joejoe2010

Hello,

I'm trying to execute OpenPetra using

nant startPetraServer
nant StartPetraClient

Everything is working fine and the Client-window is opened.

But then - after trying to login as User demo and Pasßword demo I get the errormessage "User does not exist in DB".
I didn't get any warning or error messages during the compileprocess described in the wiki.
Did there go something wrong while the compileprocess?

What can I do?

Thank you

Joachim

pokorra

Which database are you using?

For development, I recommend Postgresql, this will also allow you to have a quick look at the tables with pgAdmin.

Can you give the lines in the Server.log that are dealing with that demo login?

joejoe2010

Hello Timotheus,

I'm now using postgreSQl (changed the value in OpenPetra.build.config which was set on SQLite before)

After doing again the compile-process I can see in pgAdminIII the database openpetra.
In which table should appear the user demo?

My Server.log can be found attached: [attachment=0]Server.log[/attachment] Please scroll down.

Thank you

Joachim

pokorra

ok, you have run nant recreateDatabase. It seems you have not run nant resetDatabase yet. I

You should find the user in pgAdmin in table s_user.

The other message about missing 'CurrentDatabaseVersion' in table s_system_defaults also is an indicator for the missing data in the database.

I just checked, the resetDatabase is included in the instructions at (http://sourceforge.net/apps/mediawiki/openpetraorg/index.php?title=Setup_of_Development_environment#initial_steps)

I hope it will work now!

When you get the latest version from git, make sure you run nant compilePetraTools patchDatabase compilePetra because we changed a couple of things. Then your server and client should display version 0.2.5, not anymore 0.0.9.

Edit: I just realised that at the bottom at your Server.log you have already version 0.2.5.

joejoe2010

Hello Timotheus,

after executing

nant resetDatabase

I can see the user demo in the database in table s_user.
As well the value of 'CurrentDatabaseVersion' in table s_system_defaults can be seen.
(See attachment[attachment=1]pgadmin.jpg[/attachment])

What can I do?

I also attach my current log-file. [attachment=0]Server.log[/attachment]

Greetings

Joachim

pokorra

Hello Joachim,

I think that message says that there is already a server running on that port.
This means the user connection still happens with the server running before, which perhaps does not try again to connect to the database.
Try stopping all servers, and start again.
I will come online to IRC as well in a minute.

Timotheus

pokorra

Just to finish this thread. On IRC we found that the etc/server.config file was still connecting to the SQLite database.

We have now added bug sourceforge.net/apps/mantisbt/o ... php?id=156 "it is not clear in the Server.log which database the server is connecting to" which has been fixed now.

We also linked the paragraph sourceforge.net/apps/mediawiki/ ... ase_system more prominently on the developer setup pages. I have also changed that the config files are now copied when running "nant startPetraServer", not during compilePetraServer, which now makes more sense.