------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------
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 [email protected] database engine 'MYSQL' loaded Control engine 'FIFO' loaded is_user: user counter=0 check_db_alias: alias counter=0 MySql password for user 'open...@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 'open...@localhost': new user '1001' added ------------------------------------------------------------------------------------- Multumiri! Larry Kemp Network Engineer U.S. Metropolitan Telecom, LLC Bonita Springs, FL USA ------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------- -----Original Message----- From: [email protected] [mailto:[email protected]] 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 [email protected] (mydomain.com) > > /sbin/openserctl add 1001 password [email protected] (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 [email protected] 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 > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
