[OpenSIPS-Users] Regarding opensipsctl error

[Ranganath B]

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
>>
>>
>>
>>
>
>