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@gmail.com] Sent: Wednesday, March 21, 2007 6:08 PM To: Geir O. Jensen Cc: users@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@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@uninett.no MySql
password for user
'xxx@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@uninett.no | h323: 004710012 pstn: +47 73 55 79 23 | fax: +47 73 55 79 01
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users