When setting the "DBENGINE=MYSQL ", what is the output on opensipsctl ?
Regards, Bogdan Ranganath B wrote: > Hi Bogdan, > > I have already configured the DBENGINE=MYSQL in the opensipsctlrc > file. Not sure why these parameters are not being read from that file? > Any pointers? > > Regards, > Ranga > > On 2/18/09, Bogdan-Andrei Iancu <[email protected]> wrote: > >> Hi Ranga, >> >> You must not force manually the DBENGINELOADED !! you have to set >> DBENGINE=MYSQL in the opensipsctlrc file. >> >> >> Regards, >> Bogdan >> >> Ranganath B wrote: >> >>> Hi Bogdan, >>> >>> I am using MySQL as the backend DB and I am trying to run the >>> following commands: >>> >>> 1) /usr/local/sbin/opensipsctl domain add "opensips.net >>> <http://opensips.net>" - To add domain. Also I found that adding >>> domain command does not exist anymore. >>> 2) /usr/local/sbin/opensipsctl add alice alice - To add subscriber >>> "alice" with password "alice" >>> >>> But previous to the below mentioned errors I was getting another error >>> saying that the DBENGINELOADED cannot be read so I did a hardcode in >>> the opensipsctl file with "DBENGINELOADED=1". >>> >>> Please correct me if I am doing something wrong. >>> >>> Regards, >>> Ranga >>> >>> >>> On Tue, Feb 17, 2009 at 10:26 PM, Bogdan-Andrei Iancu >>> <[email protected] <mailto:[email protected]>> wrote: >>> >>> Hi Ranga, >>> >>> What DB backend are you using ? MySQL.? Postgres? >>> >>> Also, what is the exact command you are running? >>> >>> Regard, >>> Bogdan >>> >>> Ranganath B wrote: >>> >>> >>> Hi, >>> >>> I installed the opensips version 1.4.4 and when I try to add >>> subscribers or domain in the database I get the following error >>> messages respectively: >>> >>> /usr/local/sbin/opensipsctl: line 197: select count(*) from >>> subscriber where username='alice' and domain='opensips.net >>> <http://opensips.net> >>> <http://opensips.net>';: command not found >>> >>> INFO: user 'alice' already exists >>> >>> /usr/local/sbin/opensipsctl: line 215: select count(*) from >>> domain >>> where domain='opensips.net <http://opensips.net> >>> <http://opensips.net>';: command not found >>> INFO: opensips.net <http://opensips.net> >>> <http://opensips.net> already in domain table >>> >>> >>> I am not able to proceed with the testing, kindly help me in >>> resolving the issue with opensips. >>> >>> For your kind reference I have attached the opensipsctl >>> file too. >>> >>> Thanks in advance, >>> Ranga >>> >>> >>> >>> ------------------------------------------------------------------------ >>> >>> _______________________________________________ >>> Users mailing list >>> [email protected] <mailto:[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
