Jump to content


Photo
- - - - -

Asterisk Realtime MySQL/Postgres


  • Please log in to reply
11 replies to this topic

#1 natas

natas

    De La Natas

  • Agents of the Revolution
  • 4,273 posts
  • Gender:Male
  • Location:The Old Skool

Posted 02 December 2005 - 04:07 AM

Is anyone using MySQL or Postgres to store their extensions/iax users/sip users yet? I'm thinking about trying to set up Asterisk CVS Head + Postgres today.

http://www.asteriskg...time_pgsql.html

Is Telephreak using Realtime Asterisk?

#2 john8675309

john8675309

    Gibson Hacker

  • Members
  • 78 posts

Posted 02 December 2005 - 09:37 AM

Some of greatcalling's machines run realtime asterisk for testing. It works pretty good, but it's not as easy as just hammering out a few lines in extenstions.conf. We use MySQL

#3 unity

unity

    Ten Ten Three Two Three

  • Agents of the Revolution
  • 1,236 posts

Posted 02 December 2005 - 11:26 AM

I use the MySQL stuff a bit. I use it to store Call-forwarding flags. Like, if call-forwarding is set on a phone, that sort of thing.

#4 marks

marks

    SUPR3M3 31337 Mack Daddy P1MP

  • Members
  • 496 posts
  • Location:npa-nxx == 512-826

Posted 02 December 2005 - 08:20 PM

Telephreak only uses mysql for voicemail.

Beave, gid, I, and all the other Telephreak mod/admins have been thinking about playing with it.

I plan on doing more with mysql & asterisk for personal/business use soon, will report any problems/success/tips and tricks

#5 natas

natas

    De La Natas

  • Agents of the Revolution
  • 4,273 posts
  • Gender:Male
  • Location:The Old Skool

Posted 02 December 2005 - 08:21 PM

fuck i cant get it to work on my gentoo box! i followed the instructions that the article gives, but i ran into errors. i posted a comment at the bottom of the tutorial about my problems. argh.

http://www.asteriskg...time_pgsql.html

#6 natas

natas

    De La Natas

  • Agents of the Revolution
  • 4,273 posts
  • Gender:Male
  • Location:The Old Skool

Posted 02 December 2005 - 10:22 PM

holy shit this is stressful! the documentation sucks. i think i have everything from that guide working now, but i dont know how to set up my config files properly now.

#7 natas

natas

    De La Natas

  • Agents of the Revolution
  • 4,273 posts
  • Gender:Male
  • Location:The Old Skool

Posted 02 December 2005 - 10:58 PM

wow. after screwing around with it all day today i finally got my extensions working with postgres.

#8 Dr^ZigMan

Dr^ZigMan

    Publish or Perish!

  • Agents of the Revolution
  • 1,207 posts
  • Location:561

Posted 02 December 2005 - 11:22 PM

wow. after screwing around with it all day today i finally got my extensions working with postgres.

View Post


Yeah!

I don't mess around with getting asterisk and mysql talking, I just wrote perl scripts to link the two and use AGI.
-Dr^ZigMan

#9 natas

natas

    De La Natas

  • Agents of the Revolution
  • 4,273 posts
  • Gender:Male
  • Location:The Old Skool

Posted 02 December 2005 - 11:29 PM

mysql looks easier to setup compared to postgres since they built a driver for it. i dont really know what im doing with ODBC. also, the new terms that they use when talking about Asterisk Realtime, such as "family name" are kind of confusing and stupid.

now i want to start playing around with iax and sip user accounts in the database! right after i celebrate with a 40. :D

#10 natas

natas

    De La Natas

  • Agents of the Revolution
  • 4,273 posts
  • Gender:Male
  • Location:The Old Skool

Posted 03 December 2005 - 05:01 AM

the documentation on this stuff sucks!!!!!!!!!!!!!!!!!!!!!!!! :cuss:

#11 natas

natas

    De La Natas

  • Agents of the Revolution
  • 4,273 posts
  • Gender:Male
  • Location:The Old Skool

Posted 03 December 2005 - 05:09 PM

woot! i got iax users and cdr's in postgres now too!

#12 unity

unity

    Ten Ten Three Two Three

  • Agents of the Revolution
  • 1,236 posts

Posted 03 December 2005 - 08:09 PM

Yeah, I'm with ZigMan for the most part. I love the Perl deally with the AGI, so I use that and Berkely DB's whenever I can.




BinRev is hosted by the great people at Lunarpages!