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
