Koozali.org: home of the SME Server

Obsolete Releases => SME VoIP (Asterisk, SAIL etc) => Topic started by: compsos on July 14, 2011, 09:39:06 AM

Title: CDR Database with 3.1.0-120
Post by: compsos on July 14, 2011, 09:39:06 AM
Hi Jeff
Asterisk 18-1.8.5.0-1
Seems like the new Sail version is not opening the database for entries
Code: [Select]
[Jul 14 17:29:56] WARNING[13487] res_config_mysql.c: MySQL RealTime: No database user found, using 'asterisk' as default.
[Jul 14 17:29:56] WARNING[13487] res_config_mysql.c: MySQL RealTime: No database password found, using 'asterisk' as default.
[Jul 14 17:29:56] WARNING[13487] res_config_mysql.c: MySQL RealTime: No database host found, using localhost via socket.
[Jul 14 17:29:56] WARNING[13487] res_config_mysql.c: MySQL RealTime: No database name found, using 'asterisk' as default.
[Jul 14 17:29:56] WARNING[13487] res_config_mysql.c: MySQL RealTime: No database port found, using 3306 as default.
[Jul 14 17:29:56] WARNING[13487] res_config_mysql.c: MySQL RealTime: No database socket found, using '/var/lib/mysql/mysql.sock' as default.
[Jul 14 17:29:56] WARNING[13487] res_config_mysql.c: MySQL RealTime: No database socket found (and unable to detect a suitable path).
The database does exist and the entries is sark_cdr_mysql.conf do match MYSQL asterisk database. We are getting the same error on 2 independant systems. it look as though asterisk is not using the sark settings but it's on configuration.

Any clues on where to look as we are trying to reset up a CDR reading system.
Title: Re: CDR Database wit 3.1.0-120
Post by: SARK devs on July 16, 2011, 02:21:47 AM
Hi Gordon

Let's see if I can help.  First of all, the messages you show are generated by Asterisk realtime, they aren't as fas as I know anything to do with Asterisk cdr generation.   SARK V3 doesn't use MySQL at all and as a result, the sark_cdr_mysql.conf file should have everything commented out (unless you have an old version carried over from V2). 

If you want Asterisk to generate CDRs into MySQL the you can to create the database and tell Asterisk to use it.  It's pretty easy to set up; there is a good article here

http://www.voip-info.org/wiki/view/Asterisk+cdr+mysql

Once you've done that then Asterisk will generate both normal and MySQL cdrs.

Hope this helps.

Jeff
Title: Re: CDR Database wit 3.1.0-120
Post by: compsos on July 16, 2011, 07:11:20 AM
Thanks Jeff
Yes I did find it all commented out and un-commenting but it did not help.
Setup the new database as per the article added the connection details to sark_cdr_mysql.conf (not much difference to what was there)
Reloaded Asterisk
Tested and works
Now back to getting the info back out as a report/s.
Title: Re: CDR Database with 3.1.0-120
Post by: compsos on July 16, 2011, 09:11:03 AM
Looking at astCDR as it does not look like it is over the top with features.

I know you have moved to sqlite db system so this may be the easiest to use. I am getting an error when the checkconfig.php file runs but do not want to do anything that will distrub the running of sail.

Code: [Select]
CONFIGURATION CHECK     CHECKED REQUIRED RESOURCE   RESULT    Sqlite_open PHP function  missing   Sqlite_query PHP function  missing   Sqlite_close PHP function  missing   Asterisk cdr.db SQLite database readable
Jeff do you know anything about the sqlite PHP functions? Are the in use by Sail?

Also on the mysql side, found the "Grant " statement giving the user asterisk only insert rights cause asterisk to fail to load. Raising those rights solved the problem.
Title: Re: CDR Database with 3.1.0-120
Post by: SARK devs on July 16, 2011, 09:02:58 PM
Quote
do you know anything about the sqlite PHP functions? Are the in use by Sail?

The SAIL PHP code (which currently is only used in the generator) uses PDO to talk to sqlite so no, I don't think it needs the php sqlite functions you refer to.  I have seen reference to Asterisk building SQLite CDRs but I've not done any work on it.

Kind Regards

Jeff



Title: Re: CDR Database with 3.1.0-120
Post by: compsos on July 17, 2011, 10:28:25 AM
Trying astCDRview from http://astcdrview.berlios.de/documentation.php (http://astcdrview.berlios.de/documentation.php)

I think this might be the stumbling block
Code: [Select]
Asterisk and astCDRview databases are version 2
On my system we have
Code: [Select]
sqlite-3.3.6-5
python-sqlite-1.1.7-1.2.1.0
python-sqlite2-2.3.3-1.el5.rf
sqlite-devel-3.3.6-5

Asterisk is writing to the cdr.db but sqlite3 complains that it is encrypted.

Jeff I assume the sqlite for sail is ver3? If so then it is back to mysql db.

just found this answer but it seems strange when using sqlite3 to open the file
Quote
If you get an error message:
 
      Warning: sqlite_open() [function.sqlite-open]: file is encrypted or is not a database
 
 then most probably your code is accessing a SQLite3 database.
 
 sqlite_open() only supports SQLite2.  Use PDO to access SQLite3.
Title: Re: CDR Database with 3.1.0-120
Post by: SARK devs on July 18, 2011, 04:12:00 PM
SARK uses sqlite3, as does SME Server 8.0

Best

Jeff
Title: Re: CDR Database with 3.1.0-120
Post by: compsos on July 23, 2011, 04:41:49 AM
We are close to having a working solution,  it is an independent webpage outside the the "sail" screens.
For a client who needs a report on calls and costs over a selected period, is it worthwhile to add a new table to the asterisk mysql DB to record ITSP call charges or just store in a stand alone file?
Title: Re: CDR Database with 3.1.0-120
Post by: SARK devs on July 24, 2011, 02:21:46 AM
I'm not sure it matters too much at this point. Better just to get something up and running to evaluate the functionality and usability.

Best

Jeff
Title: Re: CDR Database with 3.1.0-120
Post by: compsos on August 03, 2011, 09:01:51 AM
We installed Asterisk-CDR-Viewer and made it working. You can check it out here http://code.google.com/p/asterisk-cdr-viewer/ (http://code.google.com/p/asterisk-cdr-viewer/)
Title: Re: CDR Database with 3.1.0-120
Post by: SARK devs on August 05, 2011, 10:27:40 AM
Can you tell us what you did to make it work?

Best

S
Title: Re: CDR Database with 3.1.0-120
Post by: compsos on August 06, 2011, 05:19:57 AM
Sorry Jeff my colleague was little short on words.

We did look at about 5 different packages but this one worked without a large array of supporting modules.

This needs to be scripted but basically....
download the package
Add the mysql_addons module to asterisk
Load the module in asterisk
Check that the asterisk DB exists and data is being added
Create an Ibay as a local webenabled.
Expand the the downloaded file to the html directory
Edit the include/config.inc.php to link to the asterisk DB
Open the connection http://yourdomain/youribay (http://yourdomain/youribay)

Ideally would be better to add into Sail like the version 2 and install under /opt/sail

We have also done a small cost calculator modification to the package
(http://forums.contribs.org/data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAdAAAAFeCAIAAAC6hdn/AAAgAElEQVR4nO2dO5LcOLOFaz+zAS1g7LE0pnoBv1kd8sedkDXmREVoC/LbmBVcs1ZRm+hr8IVHJpgkASQSOF/AkFhoEgmQp1Agmef2CQAAoAo37QYAAMAoQHABAKASoeD+HwAADE89wS10JAAAMAEEFwAAKqEguKrTeRFW2gmAFXBNaQru23+fzRYr7URBsVJwTUFwRV2j3hgUlA4KrikIrqhr1BuDgtJBwTUFwRV1jXpjUFA6KLimILiirlFvTB/l23/PLzePLz/jjx5/bPVfv3+93W633368/P3Q26fyx7t/jNv991/E30bMx40aubUH5WLBNQXBFXWNemM6KN9+PgL9+uPdEdz500CFjwnuqpW+jnuCG1X25dhvJFkH5XTBNQXBFXWNemOsl1gKgzJNS7+8P2632+39ufzVQcGNNF3QpE1M1926jZz3+fXjT+0+7KDgmoLgirpGvTHWy7dfH7/xUrho3+OP7R/T9oOCOx8lnCnTTYoFd/5zf85LbUQ5V3BNQXBFXaPeGOslPfd0Z5HzVPfn59upNdw/f9zDtVlmcsoLrtdIrCpkLLimILiirlFvjPWSnuFOIjup56yY78+3szfN3AoTZDXMcOsXXFMQXFHXqDfGekms4caPLqxz4dOCuxZXypnjYg23XsE1BcEVdY16Yzoo3FMK0YMBm+qduWnmKOM3f0U4bA/5lII/E8f0Nm/BNQXBFXWNemP6KMFNrdvt9uXn8tt/eTLhbX2Q9uvHn+Qzs+9P+lna96f7bNkMPzPlFmfxHG65gmsKgivqGvXGoKB0UHBNQXBFXaPeGBSUDgquKQiuqGvUG4OC0kHBNQXBFXWNemNQUDoouKYguKKuUW8MCkoHBdcUBFfUNeqNQUHpoOCaguCKuka9MSgoHRRcUxBcUdeoNwYFpYOCawqCK+oa9cagoHRQcE1BcEVdo94YFJQOCq4pCK6oa9Qbg4LSQcE1BcEVdY16Y1BQOii4ptoVXCpBiWsvGOf0u//+i7YIdPNORbCpSXByoKDkLdevqdMeoEf+cN/GNEsPNCq4S/J/L6Eql1816KA4vZ48gT8EFwUlb8l4TZ32AGWzxB2xMc3SA00L7pufq1QquFF/QXBRULRKUcEV5o/nFOCQjWmWHmhecB2RPSq40U4guCgotUtZwZU5JCWnvVIb0yw90L7gul4A8RouYcoSW2kNJbh/vMMbBqWhUkVwdzxAU2sRYhvTLD1gUnC5GW4gxIkBKH1yzOeB42jgnBwr8QkxEy2G+L+PqJ279dNW4SgoNUuzM9yjNqZZeqB5wT2+hisZp9InR6yJ38KfLdt/w49+PjbBJRf1ecH988cd9jAoTZU213BP2Jhm6YGmBffcUwqScSp9chCC+/MRtHD6Uv3yc/5H3PitN969E4gT3Lk+JcQoKFql+FMKAg9QQnCP25hm6YFGBTf4zvF7zcV7DrdlwY1Vdd2yKi+9k68ff/rtZwX318dv8JpFaayUFtw3QhnCH3nBH246c8TGNEsPtCW46qWpGe58BkSjzgkubpehNFisXPt1egCCy3bNlf1cX8MNv5PdtWzyjtx/zy/5fgShjFymyUGuW69Wrv1yBYIr6por+wkfSPj68efBpxQSSxD0zn8+FG+XrU2aV9v9dTQu8HiNyP/zCfo7hvvbesGuz8n70e3c8KQ2Fh2RsA+X4/7543673X//Rdw7+vJjXptK3J6VFyvXfrkCwRV1jXpj5EX9dtl2eTtPNS4r7HtT++kLw/n3W/xfTnDrLqF49xhcwfUeJwql6o/31MaSraX6cOn8RXDduNwvSAhutgLBFXWNemPkZbowFB+/Xe7v3X+73X//+fHb7f7bKj384jUhuNvrlS0K7nzon96boE6TJtl6/OEv2W/xUhsLtpPsw6/337afULTghsMKwb1WILiirlFvjKGyXpnz3Hb+x/33X6nHMxLLAlLB3aj3eAYpuMukfp7Iu1GvOktuLNhOpg+nofnyDsGtVCC4oq5Rb4yhsl6Z6/2W7Xe0bIb75k/6LM5w3/Yms03McN+fzncVBLdGgeCKuka9MXHJe/s4Z8OiK3MTXNka7ptZwXXfDFxfyW93Dff9uXY1BLdOgeCKuibvnpl7xMunUc4E8tXDvLeP80dHCa4be/DzP47RTz+0/UinHsxQeEohejFnm8IHIbw1+5TCfH+PfBGAEVyv2w+3xMq1X65AcEVdk3fPiXvEb/x1WPT2MQpKhWLl2q/TAxBctmvy7llwjzjMmfBW+LceCkqFYuXar9MDEFy2a/LuOXWPmMmZ8AbBRbFfrFz7dXoAgst2Td49J+4RczkT3iC4KPaLlWu/Tg9AcNmuybtn7h5xImfCGwQXxX6xcu3X6QEILts1effM3SNOvBfwVvj2MQpKhWLl2q/TAxBctmvUG4OC0kHBNQXBFXWNemNQUDoouKYguKKuUW8MCkoHBdcUBFfUNeqNQUHpoOCaguCKuka9MSgoHRRcUxBcUdeoNwYFpYOCawqCK+oa9cagoHRQcE1BcEVdo94YFJQOCq4pCK6oa9Qbg4LSQcE1BcEVdY16Y1BQOii4piC4oq5RbwwKSgcF1xQEV9Q16o1BQemg4JqC4Iq6Rr0xKCgdFFxTEFxR16g3BgWlg4JrCoIr6hr1xqCgdFBwTUFwRV2j3hgUlA4KrillwW0cK+0EwAq4ptQEFwAAxgSCCwAAlYDgAgAqob6WqlgmILgAgEqoqx4EFwAwCuqqB8EFAIyCuupBcA3yfNw/XtqNyERPsUjoKV6DsXBi9O2/59+3x3dtTRxGcF8f95vL4xl/4J1c3PYqZD7RhbE8H1HvZOgHtYv2+dhvcVyntXgl7Sl2DhuMpVnB/fbz8e/t9i/Thm//Pf++3f6Nyt8/yU/vf/1qX3CpcXo+NnWR/Ls8/jdDjuOKYnl93KlPrvVD/lhkrN8ciUuTrtNavJL2lDmHrcZCadnrr6++kL0/q0rtr49/tqOLRP9/P+5u5e/vjvhOwv31438GBdef4Lw+7vNIctuLMx94nllkmWCIYnk+uPP/fD8UiOUIr4/77rwurNNavJL2FDmH7cbCqe3fP19/fX18nwSrruBKZrjkbPefHy/nv/OsNvhvw4Ibf18H19v6X257cZavhYzqJIrl+bjd71sHLRUu9UOBWA5xQnBbi1fSniLnsOFYGPG6//VrFtz6UntUcIPp7TJBXv67yPE04W1VcB2ej0VSwq/K5YuU216B5Zdu1hN9Lxb/DN5WFy72Q/ZYDnFScFuKVzp2Bc5hs7FwM9ytUD/G2xHcdf1h1VPzgruNX3Mz3AXJIqQQ6cyCO9Ev90PGWA5Re4a7oDB2xc5hg7GkVezQQqqK4E7Lte63QkeC294a7sz8U46503d0X0fXzrb/5uiHnLEcofoa7roPzbHLew4bjIXVu/kpBXYBtAXBXep4YmpxDff1cfefAztyJ7TiUwpLO6cTPZPQp+JaTmP3364KXeiHIrEcIBJcN8ZUnZbilY5d5nPYcCyUzt7/+rUIrj9b1BXcZeq6Kumy+hHd07P3lML2iGn4jEuxZxhP4bUzm0LRsQQCtB06Uz+UieX4kakvFa5Oe/FKxi7/OWw3FkpwlddwowWNuQ2B4C73yoipq8HncG1h8A0flp5ikdBTvAZjYVVP+8WHCmUCgnscgyc6S0+xSOgpXoOxQHAhuACASqirHgQXADAK6qo3ouCqRy7sGvVmIJbB40UsPZVABrODGS4AAHhAcAEAoBIQXABAJdR/12NJAQAwCuqqB8EFAIyCuupBcAEAo6CuehBcgxh8w4elp1gk9BSvwVg4McKbZtcpaiI5UTH1uH/YAkcVxfL6uPsdcTmJj8JFu99m/3TYkrNw2w9g0HiRxWAszQrusXy4jsVOsDHhyTbRjOBS48SnfdPMm507T5M4ltfH/X6/Bzm1WjIilCBos5uu083RyG0Xkj9emEjK/3aCklobJpKJRLff37cMubP4UiFMtCy4e4mNq3s9FDRe3I/l+bg9nl611owIDxx2RtJmro5+vDCRHMhEclLSdVa7s5/G8+H6X9h7JpKf/JayvAoaL+7FMhv3utUu2bSUjCV92KNt5tZajq0nFYhXzWLHcCz8tLFpE8m1nf983Ul6O6fNbV1wHfZNJFeqz3DXX/+VBXf7ARAKbktGhBKOttkzABFsT2DWeJHAbCzcDLdxE8nAqYyrvK5OkBPhieYEdxu/5ma4CyUWkBOxuOst2Wa4C5UXww+1OaParhg0XmQxGAstds2bSDLGZaS5GbuTiYYFt7013JkSxotpwb2FzJ5WF9YBZ2qbSIrbTHicJbeLj58vXphIjmIi6aw1E/orUdumBPd11ETSqVt5DbeY8WIUCy0sfrXWjAglSMwKRbfJj1EkXphIHo2F0lkbJpLz4uz78y26M7apbXI9ZKIFwd1+G0XPuHDP93Emg2UpY94nMVVcCHX5/LOceiaSdJudeP2mbfW47SLsGi/G2I2FElwbJpKb5vrtJEKIVhuaE1xjGHzDh6WnWCT0FK/BWFjV037xoUKZgOAex+CJztJTLBJ6itdgLBBcCC4AoBLqqgfBBQCMgrrqjSi46pELu0a9GYhl8HgRS08lkMHsYIYLAAAeEFwAAKgEBBcAUAn13/VYUgAAjIK66kFwAQCjoK56EFwAwCioqx4E1yAG3/Bh6SkWCT3FazAWTozwptl1sphITsQpjc8n/shAdm+d/UQkbi23zuV+0DWRlMTrVJH1VZLqxot8m1sbO0l7MievqSy4REowcfacqOaW1KYfE0kux/I1A74rZLjkox36uZiIfvA2u/9pzYhQeFAyFqaOm67zZdBEkh3f1saubxNJzilyzQ/pSSfVgOkjz/FhkeZuTCSdT71rK0fy5lMUN16kY/G3btG3ZkQogYuFrcLGpR/vFUPM1sZuCBPJXadIzgKScXwgEqVbNpH0PuU9POqlIX+VNl7k3Azcad52dl/qh+KxJA5MxBLWEHhkmTCR9PH9+loaOyWLncomkqeteb/5mdFJi52pWDaRXCFG9IIB3xVKGS+uXzjc1MBNOe26GrdkRHj0wGy8cc5r8uK3YCLpVG167CTt4eociYWb4dZJQM6aPzrrs7GGygXXuImkt6WFGe5COeNFegHMP4PXOln6obKJJBdLQPom6gm1dY+fK94T/d/s2CnNcAOdKm0iKV1SYO14U4LbgYmku6WJNdz1+MuJVkJxxTOLLP1Q2UTyxMzu+Qj/wpKJJPcnrY3dECaS+4Ib2er4Ysqu4XZiIulsa+EphVcB8z5vHS5Y33Q9vrw7+26dlowIBSRjoW+gCWbE+xSJV2C8mBzflsZuBBNJ2inSWcRwV2AD8U08pdCTiSRnFnn5GcZTlDDv4/bpCxC37nm+H/RMJOlYvHi3KuHk1udAzFrGi/xxWxu7/ViyP4dbzURyzymSeCgtEFzuOVyYSJbH4Bs+LD3FIqGneA3Gwgoi3jS7DATXAj3FIqGneA3GAsGF4AIAKqGuehBcAMAoqKveiIKrHrmwa9SbgVgGjxex9FQCGcwOZrgAAOABwQUAgEpAcAEAlVD/XY8lBQDAKKirHgQXADAK6qoHwQUAjIK66kFwDWLwDR+WnmKR0FO8BmPhxAhvml2nqIlkenthYCKZgeTY0edDnLzmdErDXAj7n0zG09rYSdqTOXlNU4I7pwpjcpC/BWaRa44bk8lr2JSeXI7l2nmzF7Kb90mMEb3NLRsRyhCMnSTFa5Andx8d40UuXXprY9e3ieRucdOGxVrpeK85yku1c1Ft4stjonHBXT5lrb6qCi5MJLORHrt9wT2cdVvLRJL5Xmht7IYwkWTVdpqlvj84p7LQ8YHJ27vOdpu32DlkIrm7vRTljReZ39k9mUhux5cuKTB6dXhKmDteUf8/H7f7fQtmqdDa2I1hIsmV7++TerLWkEHmcs61NzG9bUxwHfZNJHe3l6Oo8WLKqqsnE8nPz88DY0c5QZxau1czXgzSd6+eZi2N3RgmkmSZVPLvnykv3uAjUnDXRQluCXiiOcEVeJrtbS9NiQXkHbWlbGZaMyI8hLy10flwyVNGwXiRE6mWxm4ME0nu0NMKQEJwqUaG7ZwXdvkvjAkI7nGyGy+mjRF7MpFcOS+41x5N0TVebHfshjCR5Ka3cSEXYbfWTisMzlrzsubATm+bEtzDJpI720tRxniRua3bqYmkc/zYGHRbnGbPh7MtVTVepFZuWxu7EUwkd2a7wboB5+Abbd8WRpK3+yZaEFz/AUuRiSS3vSwFzPtYY8QxTCRpYWLPhwviome86BzaG6PWxk4SS+bncKuZSF4XXG8u7Ddy+WhnYj7RhOAaw+AbPiw9xSKhp3gNxpIUO7xpdgkIrgV6ikVCT/EajAWCC8EFAFRCXfUguACAUVBXvREFVz1yYdeoNwOxDB4vYumpBDKYHcxwAQDAA4ILAACVgOACACqh/rseSwoAgFFQVz0ILgBgFNRVD4ILABgFddWD4BrE4Bs+LD3FIqGneA3GwokR3jS7TkETSS03rrU5WU/0GuZ9LAoX7cF4advFs+OOsWOpEUuDghsl0GFz0JAmkuF2PmfYRDOCS48TmWP5JTBeLIRV8z4Kna8tQZvdIXXTM14cd4xdimFNJCe5nDOETWlto4xlaRPJ7+9bGtyEv+RE44K7fHogP3dB7Jr3sQeubSIpaHOwkYtLP96exm5QE8nALIczKxOaSCYkuz3BTXxfpwX3mgPAEQyb91EHrqu062FP29IEHBt3jN3eLjUsdtRNJEMlZVx2hCaSb2tu3NYF1+GAieRn2gqsAGbN+whUTCRFbY5zXpN9cnDcMXYJasXCzXC1EpBLBVdgIunsrX2bdJdjnmb1b5kxC8vnUJslLVQ2kRS2OX0T9cq4Y+xIlGa4gU5pmUjuCi7VyLCdzs03UzbpUsFNGy8WxaB5X+L4+WKRHe9om5+PcP50Zdwxdty+NNZwfbVSMJEUruGGfxWbSO6pbVOC+zpsInn8tm4OXnbN++rEIkESr9fM0GDrXDsxdk3EQumdsokk95TCERPJRW2T6yETLQju9tso+vlIGg6yxoulsWveF6NnIimId2tcOLk9Pe4Yuz1qxMJMMDVNJLnncIUmkkQIzKLERBOCawyDb/iw9BSLhJ7iNRhLUvXwptklILgW6CkWCT3FazAWCC4EFwBQCXXVg+ACAEZBXfVGFFz1yIVdo94MxDJ4vIilpxLIYHYwwwUAAA8ILgAAVAKCCwCohPrveiwpAABGQV31ILgAgFFQVz0ILgBgFNRVD4JrEINv+LD0FIuEnuI1GAsnRnjT7DowkRTiRpOIhUzocj4ByrrXQhctP0bOJztDF4x7nLzmdErDXEj6P3/ymhmDsagL7pqDxk8lvpN6JlHNZvIaNqUnZyK5YwhQjOxS7zWfjYVJud2aEaG/c3KM3BATicQFubWDPLmiJmWOFyaS8r+doKS2nomkm0Q8FkRHjnekP1Et8dFE44K7fJq48Ormcr1/5DXv81vP23cx5//5JNZVTSTXtgWNTLc5Ne6Hs27bNV5kD2wwFk5tK5hIzlPR9wfr6bDMVUmDHEm19B4mmhHcxPd1UnArOj8UMO/zp3kJu8T71kHuBPG0TUuRWDi2MTrk5ZWI6Mz0Nne8ahY7hmNhFKqGieT392niyZroFJ3eNia4DmITyVWkK67hFjFedJcmOT/wIAU0NVtMixd/2JKCG4+RwCDS+2vy01NGzWaNFwnMxsLNcEsnIJ+k0F1yDVdpl9UGcqlBUm13DxPNCa7U02ylvt1OTuNF/+wkY0md6KdnSe4Ri+uuF9fODVIHJqJLa0gGjRdZDMaSVrFCJpLT/qef+ZzgTkY7u3KfqLa7hwn7gntuvnOFjOZ9otlBfLN++m9rRoTJwxxZnJ6hx/3acBs0Xkwc31wsrCaWNJH03HGcsq60zlZmu9NbvppkDxMtCO7roImkt3aVuNWdm1cB8z7vJ3awnuuZ91Ert60ZEToIxsgfVuFS0tmWFokXJpJHY6F0tqqJZDzD3ZY1/Jt1gacZVy39UZuC6z9guW8iGWytt55Q5rj0Gm4gQFslT4LOP8tZug/Z/dMGkUG89LhfERe7xosxdmPh5K+aiWQsuMv8d8edl6uW/qhRwTWGwTd8WHqKRUJP8RqMJamDeNPsEhBcC/QUi4Se4jUYCwQXggsAqIS66kFwAQCjoK56IwqueuTCrlFvBmIZPF7E0lMJZDA7mOECAIAHBBcAACoBwQUAVEL9dz2WFAAAo6CuehBcAMAoqKseBBcAMArqqgfBNYjBN3xYeopFQk/xGoyFEyO8aXadgiaS/t9VP+uqm/fxDlbnE6DMKFy0kjbnT/gyY9B4kcVgLA0KbpRAh85BM6e7pYzXhHuYaEZw6XFK5lh+fdzv95oWkkrmfW76ylzpGT9LxCIBxovyv+WxGguld/VMJMkyKels4jultWXyi68JxmbxXdop3MNE44K7fEonon48z6XKP4uSeZ9PpiTWVU0ko8POVEzabdd4kT2wwVg4ta1gIpmc3q5Jb0UZ0F1Vle9hohnBTXxfU6o6ewVUFVwl876A9fRuzYhQeFgdWxqlsUMsPrzeFTeRpKXTT3nOGfAEZU6AOwmueA8TbQiugyTz/zYhrjvDXVc4sp7oR8wEXe+Eo38bUMNEMkLSZq5Oa/EiluOxcDPcagnIrwvu6sA2m6RZF9x9TzN3/aGy4E5UNu/zKjtdc2mWtFDHRHJFbVa4YNB4kcVgLGkJK2QimVFwnftjy58MIbi3kKq2vbXN+5aK4XncmhGh7HhK657rvuuOHWLxYIWvpIlkSnCPrOHGantoDxMtCO7roImk7KP8vLTM+7hbv60ZEUqA8eLIsVASVtVEMi7cMwaRieSittGih72nFI6aSG5Uf0qhwKyafobROdH9w3r1pM8/1opFwm68bJ324kUs6e0h/JxRZw2XasOisI7gEu101g0MPodrC4Nv+LD0FIuEnuI1GEtS9fCm2SUguBboKRYJPcVrMBYILgQXAFAJddWD4AIARkFd9UYUXPXIhV2j3gzEMni8iKWnEshgdjDDBQAADwguAABUAoILAKiE+u96LCkAAEZBXfUguACAUVBXPQguAGAU1FUPgmsQg2/4sPQUi4Se4jUYCydGeNPsOiVNJHfqF6bIiZ5OQe0GbNtE0h86euD26hxM1+3/adZ49/ufj6W1sZO0J3PymqYEd/ZxoFLZSpLszHnC+CgmmhFcepyYHMvV0reGSOTiKLt5pL2UaO5/WjMilB2UTaEuqHMl53b+eGUGoH6urVbHblgTybkZThJ0RnC3HGCBiaSfQN224C6ftiG4BY0XU3km/Yyn2/SuNSPC40javJuQXgYMQCW7TLanQxNJbwL7/pAYmr0xSW+tzXAT39ek4Fafm20yX0KdkiLiZmXfzu5LNi0lY5EjWRuI65wR3ALxHu//Lbdsa2OnZLGjbiLpzFhXv4l9wZ1muJOnmU3BdZCYSO7UL0c548WdS85NOb18wYRTCW0jwqNQ5h6iOtccwLKKlLD/1wlCq2MnaQ9X50gs3AxXMQH5tHT7989DhmbUsoNRwT38E7KiPcxMCePFVIz+Gbwukl2aJbl709Dd02r7ec3mQ8sAdDt6k2OnNMOdpUrbRHL23xXPcEltheAWo4Tx4o5vGzmDaM2I8MBB90UiUeea4OaL90T/Nzt2g5pIrk8mBCVYLmC+Ibx2GhLc10ETyb36pXgVNF6MRCTwNPOeUnDWc5syIhSRMMRcg0wHc3INV8V40VtnbXnshjWR9BvjOJW5nma/Pv5x1jpmmbZ70+yoiSRfvyxlzPv4GInHoYLjnn+WU8lEkjXElJlm7pmKSg9cz3iRP25rY7cfS/bncFswkZQKbtBO51EK4tPGXXuNYfANH5aeYpHQU7wGY0mKHd40uwQE1wI9xSKhp3gNxgLBheACACqhrnoQXADAKKir3oiCqx65sGvUm4FYBo8XsfRUAhnMDma4AADgAcEFAIBKQHABAJVQ/12PJQUAwCioqx4EFwAwCuqqB8EFAIyCuupBcA1i8A0flp5ikdBTvAZj4cQIb5pdp6SJ5LyxduaV9cglTvTXx303i0lUpzUjwgMI4g3GPU5qczqlYV5SKbd597HWxk7SnszJaxoR3NmjjHdUI5LsLGluEh+1Lbj0OPEmkvV1dj1w9jxN047v952sg1Gd1owIjx08Fa8gt/bz0UC8EgNQ2hCztbEb00TSMVVzlHevAUsWXeIbIvHRROOCu3wa5YrVUNsS5n3rjh/PfZedoE5rRoRyJPHuGmsea7GSAWhcEyaSpN7pmEh+8zPwfhMk5F2ntHGS8sRH7Qlu4vs6PKGfj9v9vv1BNakoZbw4f3/sWbeFdVozIhQjiffzM1nhzPS2WLzynl+lqbWxG9VEMsga/k1gOXFuetuY4Drsm0j6/626ulDAeHGbqvFnKl2nNSNCGZJ4t6p0hYORrn9UKF6hXLpnamtjJ2kPV+dILNwMVysBeZh0fE9w11zjhIkk/1HTgrvvaXbxZL1OXvO+dSfcdcvVac2IUIIkXrcyVeGSp0xtA1C3zo1ezRXuIQYmklk0N/Zr4BswL/JS3wqJj4wLLnHzurbgLifa5eOGj2dQSypsndaMCAVI4vUqk0+nXGhqZQPQ5aCRKLY2doOaSIbNmFYYmEXkZf0h4ZGecvydaEFwXwdNJL0T+Nzk4BRFzPu83QdPIMRxxXVaMiI8xm681NCebWnJeJPnJzcwrY0dTCQDL97wv+vqRyTHiY/aFFz/AUuBiaT3QcXZbVnjxeOCe+VZTiUTSYdUvMy4XxAXJQPQhCFma2NHt6d7E0nPKd05eiC4SzVi9p34qFHBNYbBN3xYeopFQk/xGoyFnV3iTbPLQHAt0FMsEnqK12AsEFwILgCgEuqqB1LWrwEAAArCSURBVMEFAIyCuuqNKLjqkQu7Rr0ZiGXweBFLTyWQwexghgsAAB4QXAAAqAQEFwBQCfXf9VhSAACMgrrqQXABAKOgrnoQXADAKKirHgTXIAbf8GHpKRYJPcVrMBZOjPCm2XXKmUjmMBO8gq55X9NGhPscceOKMzFy/SDGoPEii8FYWhPcQ9lzOK/JKI16+44PbErPEmaCVzgiFzIEqe28tFruf1ozIpQd1M89dWDc2X4QH7r+2GVIaUhhNRZK8nRNJOf8kJ6k8gkYY6/J9aPJxyzw7DEnuMun+cwEr6Bk3udv3f6iNSPC46TbTOWipPpBhF3jRfbABmPhhUzHRDJszySX0SQ34TUZuPIkTHommhHcxPd1QnBrT29zq5PMnsTNyr6d3ZdsWgrEchw65+9KFBHdDyKUxi6HLQ11YKuxUBNMTRPJoExTV8KON+k16f7VVLN5114HYeb/pW5duVAx73MP7H4hSf+WQclE8vPz0/mCTX5bEuNO9YMQs8aLBGZj4Wa4ignI3/yVXNIjZ9dr0lveZXYy0ZzgCjzN2IqVqGzeF5zB6yLZpVmSuzc13d1Z8Et72R1f+Fz+quLYFZnhLhiMhdY7VRPJxEw22UhmScH3iehJcKtPb50jLyfa9QYI1r/YGURrRoQnSA4icSVfdms2aLyYOL65WJJzzAZMJHm5JHR5umnmL/sGt9faFNzXURPJT53prZZ5n7fKEqxjNmVEKMBbdwxj2VlKYvtBgNbYlXhKwXAslM5qmkh++/Xxj7OIMbuTff34Hy++jNfkstrAhzDRguD6D9ZKTCSVVhP0zPu4tcvzz3JqmUhyxxWZSF5Yw7VrvBhjNxZKcDXXcImFguUZCcZEkmhkFEX7z+HawuAbPiw9xSKhp3gNxsIKH940uwwE1wI9xSKhp3gNxgLBheACACqhrnoQXADAKKir3oiCqx65sGvUm4FYBo8XsfRUAhnMDma4AADgAcEFAIBKQHABAJVQ/12PJQUAwCioqx4EFwAwCuqqB8EFAIyCuupBcA1i8A0flp5ikdBTvAZj4cQIb5pdp5yJZPAH1bPYZD3Rxe5UW8YSp9L5BCjrXgtftGwSxdfHfbfRQZ0MTl5F4t1NMkme262NnaQ9mZPXVBZcLt0t5w7J1iHy4e7n35loRnDpcSphJniFDJd8tENfUMhYmFyErRkRxq1jL8HXx/1+3xm5sI6sr1K7yx6vIAc4c263NnZ9m0j6WcE2wU24Q5KCS7jvyGworQju8mk+M8ErFDdeZNJOMs5trRkRUrDJ4x/PHcncq9NOvOlA6HO7tbEbwkQynuEm3CGFgksfgprkTjQjuInv6+iEDhJX19LbAuZ9Poyp4vNxu9+3DlpqtGZEyB0natX8/ZFs8G6dHQNKoh3F4t0V3Pjcbm3slCx2KptIEoKbdIeMBXc36W1ClyfaEFwHmYnkBTPBK5QyXlwvSioWP/zty+ai5UwdE0nqy3L+P39lJusk+ypBuXjFcrmd262NnaQ9XJ0jsXAz3DoJyAnB3XOHJMsivsR+OAfJdgVX4GmWw0zwCuWMF8lYUif66VmSe8SSuhs3cnf1XVLn8+y4l4hX3vPrULY2dkoz3FmtaplIkjfNOHfI1H5467OEDeWEQcG9ODu4TkHjRTKWYKMpE0li7ELCRkvqTE1XNpFcOCG4zY3dECaSCTX0KuwtIqcE14Jr7+ugieQVM8ErvAqY94lMFd1/u53RmhEhfZzUXa/tI3pN1qvD9pWsHcXijWJ0YmHP7dbGbgQTybTgMu6Qa/PoRxESNpTNCq5viicxkVRawy1h3iczVXSqxbcPT/2uLG8iyY3dwmHBvdTmMvHSMYYiRR+2tbGj29OHiSSxbrAciHOHjATX+/P1tljChrJdwTWGwTd8WHqKRUJP8RqMhRVEvGl2GQiuBXqKRUJP8RqMBYILwQUAVEJd9SC4AIBRUFe9EQVXPXJh16g3A7EMHi9i6akEMpgdzHABAMADggsAAJWA4AIAKqH+ux5LCgCAUVBXPQguAGAU1FUPggsAGAV11YPgGsTgGz4sPcUioad4DcbCiRHeNLtOBhPJPeem6okZl8NmTqa6n4jEreXWOZ8AZab+RcuMNdEyuga3XYZB40UWg7E0KLhREvSdZqzJboJE464lRPOOD3RKTze1HZc3qrJcyOTx2A65GD/JzZnSM34WiEV82N1B43IvXsrFmT/eOsaLFFZjEehdERPJXbWdJHI/Ya6TG2wVXKFPxETLghvV2XGCKI6SiaS/dZvWt2ZEKEMw1oxpJrtdgl3jRfbABmPh9K6OiSQluJ5WpqVz/vT98bcvuEJ/yYlmBHf3+zpeP6gtuK/ixovMGkmQmHzLbd2UEaH8yDtjzZhmstuFR80dby1bGurAVmPh9a6GiSRZXLmcZricdH5/nya/tA3aP9s8ndbriTYE14FPRE16sdSVi6LGi6nfy1TC9YtWQ3VMJHebsJd0fOsVbvuBg2WNV9L/XJ3Wxq5WLNwMt46JZFpz/43WCtwyLd3+/ZPznVz+24unGbeip3PTLP8C8o7aBin4mzQiPAH587OQSK1/lCtetRnugsFYSL2rZiJJHDpYUmAcyabt8yw4afQbfGpQcOlZ0FpT8SkFycKzdIepi4YVmtaMCI8jWSvk4j0ruPniVVvDXfdtLpak8BU3kSSOO01Il2m1s6ZMTG/j8s+PV/AniVXgiRYElzXa27nlqbCGW8CIkInREWHWNLM1I8IDx53/zZsVLv8On8qgth84rkHjxZ5ioXS2nokkIbjL5HqWS6cB7Gw3msPOcjx5SvoK3qbgeiuUgY+ij3v/hNpcmALmfWyM/qyXM808/yxneRNJwXH5XzKMaSa7/dhxTRkvxtiNhflFr7mGG7Vhlnu54IZTYCaEiSYE1xgG3/Bh6SkWCT3FazCWpOrhTbNLQHAt0FMsEnqK12AsEFwILgCgEuqqB8EFAIyCuuqNKLjqkQu7Rr0ZiGXweBFLTyWQwexghgsAAB4QXAAAqAQEFwBQCfXf9VhSAACMgrrqQXABAKOgrnoQXADAKKirHgTXIAbf8GHpKRYJPcVrMBZOjPCm2XUymEh6H3g5OrjtVTBo3seicNH2FC9ikf/t52eTghslr0n661DVhHuYaEZwiXFyM/C5qfy47RXwvxnsmPdR5I9FQk/xIhb5305QQqZpIvm22D14fg1Uuq9ENeEeJhoW3CDR5/pfbnt57Jr3sQeubSLZU7yIZRQTyUQ1uQ3lRDOCG39fF7VaOYNh8z7qwHWVdj1sN/EilssWO+omkt/8lOecQU6imnAPjQmuA+d04Awkt708Zs37CFRMJHuKF7Ecj4Wb4WolIIfg+uPH3Uxjb7JVwaB5H0tlE8me4kUsl2e4vpxpmEhCcNk1oOeD1lVuezkMmvcljp8vFtnx+okXsdg3kRxyDffFmki6VcivzZrrCWs7DZr31YlFQk/xIpajsVB6p2ki+cY/YxB4mnX1lAJnLOh84I8ht70wds37YrRMJPuKF7Gkt4cwE8ymTCSXuaovuH09h2sLg2/4sPQUi4Se4jUYS1L18KbZJSC4FugpFgk9xWswFgguBBcAUAl11YPgAgBGQV31RhRc9ciFXaPeDMQyeLyIpacSyGB2MMMFAAAPCC4AAFSiquACAMDgVBJcAAAAhfh/KhnUlxiTN8wAAAAASUVORK5CYII=)http://compsos.com.au/callcosts.jpg (http://compsos.com.au/callcosts.jpg)

This is some what basic in that it reads call costs from a file and at this stage using logic in the webpage for the calculation of a particular ITSP.
There rules are
If anyone is interested in the costing we can pass on the modifications.

Any questions please ask.