[OpenSIPS-Users] Regarding opensipsctl error

[Bogdan-Andrei Iancu]

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 <bogdan at voice-system.ro> 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
>>> <bogdan at voice-system.ro <mailto:bogdan at voice-system.ro>> 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
>>>         Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>>>         http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>>>
>>>
>>>
>>>       
>>     
>
>