manager.py - user_service_current...

[Timuckl]

Hi everyone...

I was able to compile freezer and burner 64bit for windows... and
everything is running so far.
I needed to add/change some export flags to get all the libs compiled:

\lib\stonegui\include\recordfilterwidget.h -> STONE_EXPORT to
STONEGUI_EXPORT
\lib\freezer\include\hostviewerfactory.h -> added ASSFREEZER_EXPORT
\lib\freezer\include\jobviewerfactory.h -> added ASSFREEZER_EXPORT
\lib\classesui\include\classesui\threadview.h -> added
CLASSESUI_EXPORT

( ... also needed to add the includes where the macros are defined. )


Currently I am trying to get the manager.py to run and have problems
with the sql queries.

When I start the latest manager from the repository I get these
messages:
Sql Error: SELECT * from user_service_current
There is no table called user_service_current!

The same happens to user_service_limits, user_slots_current,
user_slots_limits, project_slots_current, ....


I am not sure if I set up the database correctly!
I used the blur_starter_db.sql to generate the database and then I run
the classmaker with the schema.xml.
Freezer and Burner were able to connect to the database and I can stop/
start the burner with the freezer...

Could it be that user_service_limits, user_slots_current,... are slq
functions which are missing in the sql dump???

When i use an older manager (144) without the userservice stuff, it
works (.... well I think! )
I don't get an error, just these messages repeating...

QPSQLResult::data: column 3 out of range
QPSQLResult::data: column 4 out of range
Fr 3. Dez 15:55:43 2010:1596 :Finished assigning high priority jobs,
took 0
Fr 3. Dez 15:55:44 2010:1596 :Using key_even_by_priority job sort
method
Fr 3. Dez 15:55:44 2010:1596 :Manager: Beginning Loop. Assign Rate:
15000 Assign Period: 10 Assign Left: 1501


Thank you in advance,
Timo

[Barry Robison]

Timo,

Apologies, there have been code updates in the repo without corresponding database updates.

There are some views I created to get complex queries used in a couple place out of the client side code.

We really need a better way to manage updates to the database schema, as obviously reinstalling a clean db is not viable.

Let me pull something together for your db!

regards,
-barry

[Timuckl]

HI Barry,

were you able to collect some stuff for the db? I know everyone is
busy ;) But I am really looking forward to get everthing to run!

One other question...
To edit the users and project I have to do this directly in the
database with pgadmin or similar. Or is there any other way?
If not, I would create a little tool for that and would check that
back into the project.

regards,
Timo

On Dec 5, 12:01 am, Barry Robison <barry.robi...@gmail.com> wrote:
> Timo,
>
> Apologies, there have been code updates in the repo without corresponding
> database updates.
>
> There are some views I created to get complex queries used in a couple place
> out of the client side code.
>
> We really need a better way to manage updates to the database schema, as
> obviously reinstalling a clean db is not viable.
>
> Let me pull something together for your db!
>
> regards,
> -barry
>

[Todd Daugherty]

There is a import_user.py somewhere that I have used in the tree
somewhere. Not the best info but I know there is some little tool
somewhere in there.

Todd

[Timuckl]

I am already using the import_users script. But it would be nice to
have a ui for this stuff and I think a can put something together
really quickly...

Timo

On 9 Dez., 11:00, Todd Daugherty <t...@fotokem.hu> wrote:
> There is a import_user.py somewhere that I have used in the tree
> somewhere. Not the best info but I know there is some little tool
> somewhere in there.
>
> Todd
>