[OpenSIPS-Users] An Old OpenSER Error For A New OpenSIPS User

Kemp, Larry Larry.Kemp at usmetrotel.com
Wed Oct 14 16:15:26 CEST 2009


------------------------------------------------------------------------------------
------------------------------------------------------------------------------------

Bogdan,

Thank you very much for your help with OpenSER. I have seen many people report this issue in forums but was never really able to see where folks found a resolve for this. I see too in Flavio's book on page 100 where he states what the user openser's password must be entered as when adding VoIP extensions. In the book it states to change HAS_SERWEB="yes". I guess later on it will cover the PHP & SerMyAdmin possibilities. Now that I know that this is controlled in this location if I need the SERWEB enabled again, I can as needed and then restart OpenSER. Now I can move on to getting the VoIP X-Lite soft-phones to register to OpenSER and make hopefully make interdomain test calls. 

Here is my output now:
-------------------------------------------------------------------------------------

MY-SERVERS-NAME:/etc/openser# /sbin/openserctl add 1000 password 1000 at mydomain.com
database engine 'MYSQL' loaded
Control engine 'FIFO' loaded
is_user: user counter=0
check_db_alias: alias counter=0
MySql password for user 'openser at localhost': 
new user '1000' added

MY-SERVERS-NAME:/etc/openser# /sbin/openserctl add 1001 password 1001@ mydomain.com
database engine 'MYSQL' loaded
Control engine 'FIFO' loaded
is_user: user counter=0
check_db_alias: alias counter=0
MySql password for user 'openser at localhost': 
new user '1001' added
-------------------------------------------------------------------------------------

Multumiri!

Larry Kemp
Network Engineer
U.S. Metropolitan Telecom, LLC
Bonita Springs, FL USA
-------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------

-----Original Message-----
From: users-bounces at lists.opensips.org [mailto:users-bounces at lists.opensips.org] On Behalf Of Bogdan-Andrei Iancu
Sent: Tuesday, October 13, 2009 5:06 PM
To: OpenSIPS users mailling list
Subject: Re: [OpenSIPS-Users] An Old OpenSER Error For A New OpenSIPS User

Hi Larry,

in openserctlrc check for the SERWEB compatibility field and disable it. 
When this is enabled, openserctl tries to populate the phplib_id field 
in the subscriber table (which by default does not exists).

Regards,
Bogdan

Kemp, Larry wrote:
>
> I am certain for anyone experienced this is an easy fix, so help me 
> out OpenSIPS community.
>
> I am using OpenSER Source 1.2.2 on Linux version 2.6.26-2-686 (Debian 
> 2.6.26-19) (gcc version 4.1.3 20080704 (prerelease) (Debian 4.1.2-25)).
>
> I am using Flavio's book. On page 100 (Adding Authentication with 
> MySQL) at step 4 it states:
>
> Configure two user accounts using the openserctl utility.
>
> /sbin/openserctl add 1000 password 1000 at voffice.com.br (mydomain.com)
>
> /sbin/openserctl add 1001 password 1001 at voffice.com.br (mydomain.com)
>
> In either instance the system returns:
>
> Database 'MYSQL' loaded
>
> Control engine 'FIFO' loaded
>
> is_user: user counter=0
>
> check_db_alias: alias counter=0
>
> *ERROR 1045 (28000): Access denied for user 'openser'@'localhost' 
> (using password: YES)*
>
> or
>
> *ERROR 1054 (42S22) at line 1: Unknown column 'phplib_id' in 'field list'*
>
> *ERROR: introducing the new user'1000' to the database failed*
>
> I have verified that the users openser, openserro and root have the 
> correct passwords to access the MySQL database named openser (as one 
> forum stated it was a password issue). I have tried several changes to 
> the file /etc/openser/openserctlrc as several online forums indicated 
> this was the issue. I have found this listed in many online forums but 
> I have not been able to fix this trying several of the things that are 
> mentioned.
>
> Can anyone on this users at lists.opensips.org please advise me? I am 
> using OpensSER 1.2.2 as that is what the book I have procured 
> indicates to use and I want to strictly follow what Flavio's book 
> states to use. Thanks in advance.
>
> Respectfully,
>
> Larry Kemp
> Network Engineer
> U.S. Metropolitan Telecom, LLC
> Bonita Springs, FL USA
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>   


_______________________________________________
Users mailing list
Users at lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



More information about the Users mailing list