[Asterisk-Users] ANNOUNCEMENT :
NEW CallingCard Application forAsterisk
Sergey Kuznetsov
asterisk_biz at deeptown.org
Wed Jan 26 13:45:41 MST 2005
Vahan,
Probably I will go there. But I already ported all my infrastructure
from MySQL to PostgreSQL. :)
Vahan Yerkanian wrote:
> Sergey,
>
> You should really revisit MySQL.com :) 4.0.x is way outdated...
>
> Regarding the high load etc... how about this copy-pasted excerpt from
> phpmyadmin?
>
> ---8<----
> This MySQL server has been running for 19 days, 6 hours, 8 minutes and
> 28 seconds. It started up on Jan 07, 2005 at 02:21 PM.
> Server traffic: These tables show the network traffic statistics of
> this MySQL server since its startup.
> Traffic ø per hour
> Received 2,579 MB 5,714 KB
> Sent 1,050 MB 2,327 KB
> Total 3,629 MB 8,040 KB
> Connections ø per hour %
> Failed attempts 83 0.18 0.00 %
> Aborted 1,416,484 3,065.05 6.42 %
> Total 22,064,865 47,744.87 100.00 %
>
> Query statistics: Since its startup, 68,530,509 queries have been sent
> to the server.
> ---8<----
>
> regards,
> Vahan
>
> Sergey Kuznetsov wrote:
>
>> Robert,
>>
>> It is better to stay with Postgres. If you don't want to loose your
>> business stay away from MySQL.
>> If you are from Toronto ( I suppose you are ), you can check my posts
>> to TLUG (Toronto Linux User Group)
>> regarding MySQL and Postgres. I would say Postgres is a Open Source
>> Oracle. It's very stable, very scalable
>> and it's perfectly works under serious workload. MySQL is dying at
>> the same configuration.
>> I have client of mine who having issue with MySQL. Under some
>> workload ( 10 users inserting at the same time )
>> it corrupts the index. Even MySQL 4.0.X is still corrupts the indexes
>> under heavy load.
>> I never saw it with Postgres. At the same time Postgres provides you
>> a very flexible SQL language and features,
>> as well as you can make stored procedures on Perl and many-many more.
>>
>>
>> All the Best!
>> Sergey.
>>
>>
>> Robert Augustyn wrote:
>>
>>> NICE!
>>> I understand that it works against Postgress, any idea what it would
>>> take to
>>> port it to mysql if anything?
>>> robert
>>> -----Original Message-----
>>> From: asterisk-users-bounces at lists.digium.com
>>> [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Areski
>>> Sent: Wednesday, January 26, 2005 12:05 PM
>>> To: Asterisk-Users Mailing-list
>>> Subject: [Asterisk-Users] ANNOUNCEMENT : NEW CallingCard Application
>>> forAsterisk
>>>
>>> Hello everyone,
>>>
>>>
>>> If you want to know why I am so tired today :D Check this CallingCard
>>> Solution : http://areski.net/areskicc-doc/ Just finish it yesterday
>>> night!
>>>
>>>
>>> Briefly, AreskiCC is an AGI script and PHP-Web application which
>>> greatly
>>> handle the complete CallingCard System.
>>>
>>>
>>> FEATURES - AGI :
>>> * Authenticate with the use of a Cardnumber the
>>> Cardnumber can also be defined as accountcode into sip.conf,
>>> iax.conf, etc.. * take care of multiple calls using the
>>> same Cardnumber * Caller gets informed about his credit
>>> Announce the remaining credit
>>> * Caller is requested to enter a destination number *
>>> Announce the maximal call time for the given destination
>>> number It calculates the remaining duration of the actual
>>> call (based
>>> on tariffrate tables), informs the caller about this and sets a
>>> timeout
>>> * Interupt the call if the card balance gets zero Warn
>>> the caller about the call interupt 60 & 30 seconds before
>>> the call gets interupted
>>> * It connects the Caller to the destination through the configured
>>> trunk note : different trunks can be configured and
>>> associated by
>>> prefix
>>> * After disconnecting the call AGI updates the credit and stores
>>> the concerning Call-Detail-Records with CallingPartyNumber,
>>> CalledPartyNumber, CallSetupTime, Duration, Charge and the
>>> remaining credit
>>>
>>>
>>> FEATURES - WEB INTERFACE:
>>> * CARD/CUSTOMERS
>>> * List customers
>>> * Refill customer
>>> * CARD/CUSTOMERS
>>> * List customers/cards
>>> * Refill customer/card
>>> * Create customer/card
>>> * Generate customers/cards
>>> * BILLING
>>> * View money situation
>>> * View Payment
>>> * Add new Payment
>>> * RATECARD
>>> * List Tariffplan
>>> * Create new Tariffplan
>>> * Define Tariffplan
>>> * TRUNK
>>> * List Trunk
>>> * Add Trunk
>>> * CALL REPORT - BALANCE
>>> Last note : It's distributed under GNU GPL Licence.
>>>
>>>
>>>
>>> I hope there will have a big interest for the soft,
>>> I am waiting your feedbacks...
>>> Regards, /Areski
>>>
>>>
>>>
>>>
>>>
>>> -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_
>>>
>>> Belaïd Arezqui
>>> www.areski.net
>>> E-mail : areski [alt at alt] gmail (.dot.) com
>>> _______________________________________________
>>> Asterisk-Users mailing list
>>> Asterisk-Users at 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
>>>
>>>
>>> _______________________________________________
>>> Asterisk-Users mailing list
>>> Asterisk-Users at 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
>>>
>>>
>>
>>
>_______________________________________________
>Asterisk-Users mailing list
>Asterisk-Users at 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
>
--
All the Best!
Sergey.
=========================
Sergey Kuznetsov
President/CEO
High Intellectual Technologies, Inc.
Web: http://www.hitcalls.com
E-mail: sergey.kuznetsov at highintellect.com
Business phone: (416) 548-9700
Mobile phone: (647) 287-8448
More information about the asterisk-users
mailing list