[asterisk-users] SIP accounts from MYSQL.

2007-05-27 Thread Jonson Player

Hello,
I just want to put all my sip accounts in mysql and asterisk use it from
mysql. How can I do that, could you be more specific because I readed alot
on wiki and i'm lost... I don't know what to modify in Makefile from channel
directory. I use asterisk 1.4.4, that is already compiled and i also have
CDR in mysql. I must create manny accounts and I want to realize that from
mysql. Thank you for your support guys.
___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] SIP accounts from MYSQL.

2007-05-27 Thread Yossi Ben Hagai

Asterisk realtime is what you are looking for. the subject is explained very
clearly including configuration examples and DB schema on the following
links:
http://www.voip-info.org/wiki-Asterisk+RealTime
http://www.asteriskdocs.org/modules/news/article.php?storyid=28

I won't go over the process as it is detailed in the links above, but
basically you should compile the asterisk-addons, configure the res_mysql
with the proper DB details, create a table to hold sip.conf and optionally
extensions.conf then configure extconfig to map the newly created tables.

Joss.


On 5/27/07, Jonson Player [EMAIL PROTECTED] wrote:


Hello,
I just want to put all my sip accounts in mysql and asterisk use it from
mysql. How can I do that, could you be more specific because I readed alot
on wiki and i'm lost... I don't know what to modify in Makefile from channel
directory. I use asterisk 1.4.4, that is already compiled and i also have
CDR in mysql. I must create manny accounts and I want to realize that from
mysql. Thank you for your support guys.


___
--Bandwidth and Colocation provided by Easynews.com http://easynews.com/--

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] SIP accounts from MYSQL.

2007-05-27 Thread Jonson Player

Than you Joss, the links was very usefull.


On 5/27/07, Yossi Ben Hagai [EMAIL PROTECTED] wrote:


Asterisk realtime is what you are looking for. the subject is explained
very clearly including configuration examples and DB schema on the following
links:
http://www.voip-info.org/wiki-Asterisk+RealTime
http://www.asteriskdocs.org/modules/news/article.php?storyid=28

I won't go over the process as it is detailed in the links above, but
basically you should compile the asterisk-addons, configure the res_mysql
with the proper DB details, create a table to hold sip.conf and optionally
extensions.conf then configure extconfig to map the newly created tables.

Joss.


On 5/27/07, Jonson Player [EMAIL PROTECTED] wrote:

 Hello,
 I just want to put all my sip accounts in mysql and asterisk use it from
 mysql. How can I do that, could you be more specific because I readed alot
 on wiki and i'm lost... I don't know what to modify in Makefile from channel
 directory. I use asterisk 1.4.4, that is already compiled and i also
 have CDR in mysql. I must create manny accounts and I want to realize that
 from mysql. Thank you for your support guys.


 ___
 --Bandwidth and Colocation provided by Easynews.comhttp://easynews.com/--

 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users



___
--Bandwidth and Colocation provided by Easynews.com http://easynews.com/--

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] SIP accounts from MYSQL.

2007-05-27 Thread Jonathan Creasy
I don't think you need to modify th Makefile at all. That might be why 
you are having trouble finding details on that.


-Jonathan

Jonson Player wrote:

Hello,
I just want to put all my sip accounts in mysql and asterisk use it 
from mysql. How can I do that, could you be more specific because I 
readed alot on wiki and i'm lost... I don't know what to modify in 
Makefile from channel directory. I use asterisk 1.4.4, that is already 
compiled and i also have CDR in mysql. I must create manny accounts 
and I want to realize that from mysql. Thank you for your support guys.




___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users
  


___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] sip accounts

2005-10-14 Thread Kong

hi, i facing a problem here. in my sip.conf, i specify a account like this,
[1234]
type=friend
context=from-sip
username=1234
secret=1234
nat=no
canreinvite=yes
dtmfmode=info
[EMAIL PROTECTED]
disallow=all
allow=ulaw

so i am able to login with username 1234 and password 1234

but ther weird part is, i can also register as any number (account) 
without having to specify in sip.conf. thus anybody can just use my 
system to call others.. lets say i do have set that some certain 
account can make some certain calls only.


how can i solve this problem?

thank you.

___
--Bandwidth and Colocation sponsored by Easynews.com --

Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [Asterisk-Users] sip accounts

2005-10-14 Thread Dinesh Nair



On 10/14/05 15:42 Kong said the following:
but ther weird part is, i can also register as any number (account) 
without having to specify in sip.conf. thus anybody can just use my 


under the [general] section, use a context which limits what 
unauthenticated users can do/call. it can even be a catchall IVR which says 
bugger off !. :)


--
Regards,   /\_/\   All dogs go to heaven.
[EMAIL PROTECTED](0 0)http://www.alphaque.com/
+==oOO--(_)--OOo==+
| for a in past present future; do|
|   for b in clients employers associates relatives neighbours pets; do   |
|   echo The opinions here in no way reflect the opinions of my $a $b.  |
| done; done  |
+=+
___
--Bandwidth and Colocation sponsored by Easynews.com --

Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [Asterisk-Users] sip accounts

2005-10-14 Thread Kong

how to chech if the user is an unauthenticated one? thank you

At 03:58 PM 10/14/2005, you wrote:



On 10/14/05 15:42 Kong said the following:
but ther weird part is, i can also register as any number (account) 
without having to specify in sip.conf. thus anybody can just use my


under the [general] section, use a context which limits what 
unauthenticated users can do/call. it can even be a catchall IVR 
which says bugger off !. :)


--
Regards,   /\_/\   All dogs go to heaven.
[EMAIL PROTECTED](0 0)http://www.alphaque.com/
+==oOO--(_)--OOo==+
| for a in past present future; do|
|   for b in clients employers associates relatives neighbours pets; do   |
|   echo The opinions here in no way reflect the opinions of my $a $b.  |
| done; done  |
+=+
___
--Bandwidth and Colocation sponsored by Easynews.com --

Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


___
--Bandwidth and Colocation sponsored by Easynews.com --

Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [Asterisk-Users] sip accounts

2005-10-14 Thread Dinesh Nair



On 10/14/05 16:40 Kong said the following:

how to chech if the user is an unauthenticated one? thank you


read www.voip-info.org on SIP.

--
Regards,   /\_/\   All dogs go to heaven.
[EMAIL PROTECTED](0 0)http://www.alphaque.com/
+==oOO--(_)--OOo==+
| for a in past present future; do|
|   for b in clients employers associates relatives neighbours pets; do   |
|   echo The opinions here in no way reflect the opinions of my $a $b.  |
| done; done  |
+=+
___
--Bandwidth and Colocation sponsored by Easynews.com --

Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [Asterisk-Users] sip accounts

2005-10-14 Thread Kong

can i know where to start? SIP is such a big topic.

At 05:58 PM 10/14/2005, you wrote:



On 10/14/05 16:40 Kong said the following:

how to chech if the user is an unauthenticated one? thank you


read www.voip-info.org on SIP.

--
Regards,   /\_/\   All dogs go to heaven.
[EMAIL PROTECTED](0 0)http://www.alphaque.com/
+==oOO--(_)--OOo==+
| for a in past present future; do|
|   for b in clients employers associates relatives neighbours pets; do   |
|   echo The opinions here in no way reflect the opinions of my $a $b.  |
| done; done  |
+=+
___
--Bandwidth and Colocation sponsored by Easynews.com --

Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


___
--Bandwidth and Colocation sponsored by Easynews.com --

Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [Asterisk-Users] sip accounts

2005-10-14 Thread El Flynn

Kong wrote:

can i know where to start? SIP is such a big topic.


Try looking for SIP configuration (sip.conf) in the Wiki, it's got lots of 
examples. Or you can also try looking it up on google.


Flynn

___
--Bandwidth and Colocation sponsored by Easynews.com --

Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [Asterisk-Users] sip accounts

2005-10-14 Thread Andy Kuo
Hi,

Try add 

[1234]
...
host=dynamic or host=xxx.xxx.xxx.xxx (the client's IP)
...
...


AK
On 10/14/05, Kong [EMAIL PROTECTED] wrote:
hi, i facing a problem here. in my sip.conf, i specify a account like this,[1234]type=friendcontext=from-sip
username=1234secret=1234nat=nocanreinvite=yesdtmfmode=info[EMAIL PROTECTED]disallow=allallow=ulawso i am able to login with username 1234 and password 1234but ther weird part is, i can also register as any number (account)
without having to specify in sip.conf. thus anybody can just use mysystem to call others.. lets say i do have set that some certainaccount can make some certain calls only.how can i solve this problem?
thank you.___--Bandwidth and Colocation sponsored by Easynews.com --Asterisk-Users mailing list
Asterisk-Users@lists.digium.comhttp://lists.digium.com/mailman/listinfo/asterisk-usersTo UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
___
--Bandwidth and Colocation sponsored by Easynews.com --

Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users