[Users] Re: Database in openser and SIP registration

Daniel-Constantin Mierla daniel at voice-system.ro
Thu Jun 15 15:00:35 CEST 2006


Hello,

On 06/15/06 15:44, Shenen Shenen wrote:
> Hi!I've run the command to create the database in this way;
>  
> openser_mysql.sh create
>  
> I've entered a blank password for root, I entered ser as the domain: I
> got a creating database ... message, then got another "Enter password:"
> request, entered blank and then returned to the command line
>  
> Domain (realm) for the default user 'admin' : ser       I've put;
>  
> If I run in mysql with mysql -p and entered in it,I run connect,I've this;
>  
> mysql> connect
> Connection id:    115
> Current database: *** NONE ***
>  
> If I use
>  
> mysql>connect ser
> ERROR 1049 (42000): Unknown database 'ser'

the name for database used by openser is 'openser', not 'ser'. After you 
login as root in mysql, do 'show databases' to see available databases 
in the server.

>  
>  
> Where is the problem?
>  
> I use the following command to register my openser;
>  
> openserctl add 650 1234 650 at 192.168.251.12 <mailto:650 at 192.168.251.12> 
> [ mailto:650 at 192.168.251.12]
>  

Have you set the SIP_DOMAIN environment variable?

Cheers,
Daniel

> /usr/local/sbin/openserctl 1.1 - $Revision: 1.6.2.2 <http://1.6.2.2/> $
> parameter usage:
>            * subscribers *
>  add <username> <password> <email> .. add a new subscriber (*)
>  passwd <username> <passwd> ......... change user's password (*)
>  rm <username> ...................... delete a user (*)
>  mail <username> .................... send an email to a user
>
>  alias show [<alias>] ............... show aliases
>  alias rm <alias> ................... remove an alias
>  alias add <alias> <uri> ............ add an aliases
>
>  rpid add <username> <rpid> ......... add rpid for a user (*)
>  rpid rm <username> ................. set rpid to NULL for a user (*)
>  rpid show <username> ............... show rpid of a user
>
>  alias_db show <alias> .............. show alias details
>
> .............
> etc etc....
>  
>  
> Where is the problem?
>  
>   




More information about the sr-users mailing list