[Users] Fresh OpenSER 1.2.0 Openserctl can only add 1 user?!

[Geir O. Jensen]

Hi, now this is a bit disappointing... I swear I search through the mailing
list archive... But as soon as I got subscribed these messages started
popping up about error 1062. :D 

So yes, I did have SerWEB, and no I didn't read the upgrade notes carefully
- as I thought I wouldn't have to with a fresh install... Reinstalling the
db without serweb ofcourse fixed my problem.

However I do strongly believe that this should've "fixed" itself, by
openserctl being aware of the fact that the user installed SerWEB tables.
(Or having the openser_mysql script do the appropriate changes to
openserctl...)

New users won't go through the Wiki looking for upgrade guides :D

Anyways, thanks! 

- Geir

> -----Original Message-----
> From: Ovidiu Sas [mailto:sip.nslu at gmail.com] 
> Sent: Wednesday, March 21, 2007 6:08 PM
> To: Geir O. Jensen
> Cc: users at openser.org
> Subject: Re: [Users] Fresh OpenSER 1.2.0 Openserctl can only 
> add 1 user?!
> 
> Have you installed the serweb tables?
> 
> -ovi
> 
> On 3/21/07, Geir O. Jensen <geir.o.jensen at uninett.no> wrote:
> > I have two server, one in production and one for testing. Trying to 
> > debug something else entirely I upgraded the production server from 
> > 1.1.0 to 1.2.0 yesterday. Everything seems to work fine on it.
> >
> > So I wiped my testbed and compiled OpenSER 1.2.0 on the testing 
> > system, installed the mysql db and started it up. Worked fine.
> >
> > I then began adding testaccounts on the testsystem,
> > - first user ok...
> > - second user, not so ok...
> >
> > # openserctl add test test gojensen at uninett.no MySql 
> password for user 
> > 'xxx at localhost':
> > ERROR 1062 (23000) at line 1: Duplicate entry '' for key 3
> > ERROR: introducing the new user 'test' to the database failed
> >
> > Of course, I couldn't add a third or fourth either, so I'm 
> basically 
> > stuck with one user and the admin account. Any idea where to start 
> > debugging this?!
> >
> > (As a note, I added 3 test accounts on the production 
> server with no 
> > problems... Their config files are basically identical - 
> the testing 
> > server only adds the presence module...)
> >
> > // sip:gojensen at uninett.no | h323: 004710012
> >    pstn: +47 73 55 79 23   | fax: +47 73 55 79 01
> >
> >
> > _______________________________________________
> > Users mailing list
> > Users at openser.org
> > http://openser.org/cgi-bin/mailman/listinfo/users
> >
>