Problem setting up smoon

[Thomas Schmidt]

Hi, I am trying to setup a smoon server on openSUSE 10.3 from the 1.1.1.1 release.
I changed the dev.cfg to use a mysql backend.

When running: smoltSendProfile -as http://localhost:8080
I get: "An error has occured while contacting the server: [Errno 14] HTTP Error 500:
Internal error"
the server log is attached.

Checking the HTTP traffic shows that the /tokens/token_json?uuid=... call returns
successful.
Also the POST to /client/add_json returns with a HTML page containing a pub uuid,
but there is nothing stored to the database, I cannot see an UPDATE or INSERT statement in
the log.
The third call /tokens/admin_token_json?uuid=... then fails because it can not lookup the
uuid from db.

Has somebody an idea what could go wrong here?
Greetings

-- 
Thomas Schmidt (tschmidt [at] suse.de)
SUSE Linux Products GmbH :: Research & Development :: Internal Tools
"Don't Panic", Douglas Adams (1952 - 11.05.2001)

[Mike McGrath]

On Mon, 21 Apr 2008, Thomas Schmidt wrote:

>  Hi, I am trying to setup a smoon server on openSUSE 10.3 from the
> 1.1.1.1
>  release.
>  I changed the dev.cfg to use a mysql backend.
>
>  When running: smoltSendProfile -as http://localhost:8080
>  I get: "An error has occured while contacting the server: [Errno 14] HTTP
>  Error 500: Internal error"
>  the server log is attached.
>
>  Checking the HTTP traffic shows that the /tokens/token_json?uuid=... call
>  returns successful.
>  Also the POST to /client/add_json returns with a HTML page containing a pub
>  uuid,
>  but there is nothing stored to the database, I cannot see an UPDATE or INSERT
>  statement in the log.
>  The third call /tokens/admin_token_json?uuid=... then fails because it can not
>  lookup the uuid from db.
>
>  Has somebody an idea what could go wrong here?
>  Greetings
>  
A bug got introduced somewhere around 1.1.1 where if the database had no
entries in it already, it wouldn't allow new ones and I'd bet money thats
what you're seeing there.  Would you mind putting some fake stuff into the
db and see if that fixes your problem?  If it does we'll make sure to get
a patch in and available asap.

	-Mike

[Thomas Schmidt]

Mike McGrath schrieb:
>  On Mon, 21 Apr 2008, Thomas Schmidt wrote:
>  
> > Hi, I am trying to setup a smoon server on openSUSE 10.3 from the 1.1.1.1
> > release.
> > I changed the dev.cfg to use a mysql backend.
> >
> > When running: smoltSendProfile -as http://localhost:8080
> > I get: "An error has occured while contacting the server: [Errno 14] HTTP
> > Error 500: Internal error"
> > the server log is attached.
> >
> > Checking the HTTP traffic shows that the /tokens/token_json?uuid=... call
> > returns successful.
> > Also the POST to /client/add_json returns with a HTML page containing a pub
> > uuid,
> > but there is nothing stored to the database, I cannot see an UPDATE or INSERT
> > statement in the log.
> > The third call /tokens/admin_token_json?uuid=... then fails because it can not
> > lookup the uuid from db.
> >
> > Has somebody an idea what could go wrong here?
> > Greetings
> >
>  
>  A bug got introduced somewhere around 1.1.1 where if the database had no
>  entries in it already, it wouldn't allow new ones and I'd bet money thats
>  what you're seeing there.  Would you mind putting some fake stuff into the
>  db and see if that fixes your problem?  If it does we'll make sure to get
>  a patch in and available asap. 
I added a fake entry to each table with correct relations of the foreign keys.
But I still get the same error. Can you reproduce the problem with a fresh setup?
Greetings

-- 
Thomas Schmidt (tschmidt [at] suse.de)
SUSE Linux Products GmbH :: Research & Development :: Internal Tools
"Don't Panic", Douglas Adams (1952 - 11.05.2001)

[Mike McGrath]

On Mon, 21 Apr 2008, Thomas Schmidt wrote:

>  Mike McGrath schrieb:
>  > On Mon, 21 Apr 2008, Thomas Schmidt wrote:
>  >
>  >> Hi, I am trying to setup a smoon server on openSUSE 10.3 from the 1.1.1.1
>  >> release.
>  >> I changed the dev.cfg to use a mysql backend.
>  >>
>  >> When running: smoltSendProfile -as http://localhost:8080
>  >> I get: "An error has occured while contacting the server: [Errno 14] HTTP
>  >> Error 500: Internal error"
>  >> the server log is attached.
>  >>
>  >> Checking the HTTP traffic shows that the /tokens/token_json?uuid=... call
>  >> returns successful.
>  >> Also the POST to /client/add_json returns with a HTML page containing a pub
>  >> uuid,
>  >> but there is nothing stored to the database, I cannot see an UPDATE or INSERT
>  >> statement in the log.
>  >> The third call /tokens/admin_token_json?uuid=... then fails because it can not
>  >> lookup the uuid from db.
>  >>
>  >> Has somebody an idea what could go wrong here?
>  >> Greetings
>  >>
>  >
>  > A bug got introduced somewhere around 1.1.1 where if the database had no
>  > entries in it already, it wouldn't allow new ones and I'd bet money thats
>  > what you're seeing there.  Would you mind putting some fake stuff into the
>  > db and see if that fixes your problem?  If it does we'll make sure to get
>  > a patch in and available asap.
>
>  I added a fake entry to each table with correct relations of the foreign keys.
>  But I still get the same error. Can you reproduce the problem with a fresh setup?
>  Greetings
>  
Actually let me ask you this, are you stuck on using 1.1.1 or would you
mind using the next version when it comes out?  (currently in devel) It
should have a simpler db setup as well as no views.  Its a big change but
is in decent shape.  In the meantime though if you're just looking to get
something setup to look at let me know and I'll make sure to get either
devel in working shape for you or I'll come up with a patch for 1.1.1.
Your call.

	-Mike

[Thomas Schmidt]

Mike McGrath schrieb:
>  On Mon, 21 Apr 2008, Thomas Schmidt wrote:
>  
> > Mike McGrath schrieb:
> >> On Mon, 21 Apr 2008, Thomas Schmidt wrote:
> >>
> >>> Hi, I am trying to setup a smoon server on openSUSE 10.3 from the 1.1.1.1
> >>> release.
> >>> I changed the dev.cfg to use a mysql backend.
> >>>
> >>> When running: smoltSendProfile -as http://localhost:8080
> >>> I get: "An error has occured while contacting the server: [Errno 14]
> HTTP
> >>> Error 500: Internal error"
> >>> the server log is attached.
> >>>
> >>> Checking the HTTP traffic shows that the /tokens/token_json?uuid=... call
> >>> returns successful.
> >>> Also the POST to /client/add_json returns with a HTML page containing a pub
> >>> uuid,
> >>> but there is nothing stored to the database, I cannot see an UPDATE or
> INSERT
> >>> statement in the log.
> >>> The third call /tokens/admin_token_json?uuid=... then fails because it can
> not
> >>> lookup the uuid from db.
> >>>
> >>> Has somebody an idea what could go wrong here?
> >>> Greetings
> >>>
> >> A bug got introduced somewhere around 1.1.1 where if the database had no
> >> entries in it already, it wouldn't allow new ones and I'd bet money
> thats
> >> what you're seeing there.  Would you mind putting some fake stuff into the
> >> db and see if that fixes your problem?  If it does we'll make sure to get
> >> a patch in and available asap.
> > I added a fake entry to each table with correct relations of the foreign keys.
> > But I still get the same error. Can you reproduce the problem with a fresh setup?
> > Greetings
> >
>  
>  Actually let me ask you this, are you stuck on using 1.1.1 or would you
>  mind using the next version when it comes out?  (currently in devel) It
>  should have a simpler db setup as well as no views.  Its a big change but
>  is in decent shape.  In the meantime though if you're just looking to get
>  something setup to look at let me know and I'll make sure to get either
>  devel in working shape for you or I'll come up with a patch for 1.1.1.
>  Your call. 
Hi, I have no objections in using the latest devel release of smoon when the
1.1.1.1 clients can work with it.
But I just tested with the latest development version and still have the same issue...
This is what I did:
- git clone git://git.fedorahosted.org/smolt.git smolt.git
(also tried with the branch from http://fedorapeople.org/~ynemoy/git/smolt.git)
- set up mysql connection in dev.cfg
- imported all files from database/ with sql_create.sql at first and sql_remove_views.sql
at last
- start the server: ./start-hardware.py
- run the client: python ./sendProfile.py -s http://localhost:8080

-> Same problem as described in the first mail.
Am I doing something wrong?

Greetings

-- 
Thomas Schmidt (tschmidt [at] suse.de)
SUSE Linux Products GmbH :: Research & Development :: Internal Tools
"Don't Panic", Douglas Adams (1952 - 11.05.2001)

[Mike McGrath]

On Tue, 22 Apr 2008, Thomas Schmidt wrote:
>  Hi, I have no objections in using the latest devel release of smoon when the
>  1.1.1.1 clients can work with it.
>  But I just tested with the latest development version and still have the same issue...
>  This is what I did:
>  - git clone git://git.fedorahosted.org/smolt.git smolt.git
>  (also tried with the branch from http://fedorapeople.org/~ynemoy/git/smolt.git)
>  - set up mysql connection in dev.cfg
>  - imported all files from database/ with sql_create.sql at first and sql_remove_views.sql
> at last
>  - start the server: ./start-hardware.py
>  - run the client: python ./sendProfile.py -s http://localhost:8080
>
>  -> Same problem as described in the first mail.
>  Am I doing something wrong?
>  
No no, this was certainly in the code.  I've submitted a quick fix that
will allow this to work but I need to see if I've introduced any other
bugs.

Side note, I see you're with SuSE so if you like what you see or want to
submit any patches or need any help please just ask.  We're very
interested in working with you.  Stop by #smolt on irc.freenode.net if you
ever want to chat.  Also should you ever want commit access just let me
know and I'll help you (and whoever else you're working with) get setup.
We're quite excited about the possibility of expanding our developer base.
It always feels like there's so much to do but so little help to do it.

We've also got a summer of code project to pretty up the web interface
quite a bit.  So we'll probably want to get another good working version
out the door before he starts on all of that (just to give him a good
working point)

anyway, let us know if you need anything.

	-Mike

[Thomas Schmidt]

Mike McGrath schrieb:
>  On Tue, 22 Apr 2008, Thomas Schmidt wrote:
> > Hi, I have no objections in using the latest devel release of smoon when the
> > 1.1.1.1 clients can work with it.
> > But I just tested with the latest development version and still have the same
> issue...
> > This is what I did:
> > - git clone git://git.fedorahosted.org/smolt.git smolt.git
> > (also tried with the branch from http://fedorapeople.org/~ynemoy/git/smolt.git)
> > - set up mysql connection in dev.cfg
> > - imported all files from database/ with sql_create.sql at first and
> sql_remove_views.sql at last
> > - start the server: ./start-hardware.py
> > - run the client: python ./sendProfile.py -s http://localhost:8080
> >
> > -> Same problem as described in the first mail.
> > Am I doing something wrong?
> >
>  
>  No no, this was certainly in the code.  I've submitted a quick fix that
>  will allow this to work but I need to see if I've introduced any other
>  bugs. 
I pulled the latest git version, which skips the error, but there is still nothing written
to the database
and the subsequent client call to
GET /w/api.php?action=query...
fails with cherrypy.NotFound(objectpath).

>  Side note, I see you're with SuSE so if you like what you see or
> want to
>  submit any patches or need any help please just ask.  We're very
>  interested in working with you.  Stop by #smolt on irc.freenode.net if you
>  ever want to chat.  Also should you ever want commit access just let me
>  know and I'll help you (and whoever else you're working with) get setup.
>  We're quite excited about the possibility of expanding our developer base.
>  It always feels like there's so much to do but so little help to do it. 
I'm already on #smolt as digitltom. I don't speak python, but once we have a
running server
in use I would like to improve the documentation on how to set it up (especially on
opensuse).
And include the server in our smolt package.

>  We've also got a summer of code project to pretty up the web
> interface
>  quite a bit.  So we'll probably want to get another good working version
>  out the door before he starts on all of that (just to give him a good
>  working point)
>  
>  anyway, let us know if you need anything. 
I need a working instance of smoon to convince our managers that it's worth
to integrate the smolt client in the yast registration process for opensuse 11.0 :-)

Greetings

-- 
Thomas Schmidt (tschmidt [at] suse.de)
SUSE Linux Products GmbH :: Research & Development :: Internal Tools
"Don't Panic", Douglas Adams (1952 - 11.05.2001)

[Mike McGrath]

On Thu, 24 Apr 2008, Thomas Schmidt wrote:
>  Mike McGrath schrieb:
>  >
>  > anyway, let us know if you need anything.
>
>  I need a working instance of smoon to convince our managers that it's worth
>  to integrate the smolt client in the yast registration process for opensuse 11.0 :-)
>  
We chatted a bit on IRC but for anyone else watching I think we've got
this bug fixed and the current upstream repo has the correct code.

	-Mike