asterisk users - Dec 2004 - ASTCC configuration problem

hi 
Today I?ve installed, apache 2.0.52, mysql-4.1.7, asterisk-perl-0.08
and ASTCC prepaid card aplication  from CVS, so now I have access to
the astcc-admin.cgi  from web server
http://asterisk/cgi-bin/astcc-admin/astcc-admin.cgi and I?ve been able
to create the database from "Configure" menu but I have some doubts to
continue:

- Do I have to reinstall asterisk with mysql support?
- How asterisk or astcc knows what db should use, where the
configuration files are?
- when I go to "Cards" I ge this: ""Please define at least
one brand
before creating cards"" and when I go to "Brands", I have
this error:
"Something is wrong with the brands database" ...in
"Users_Configure"
menu I have this error: Not Configured!


please send me some advise to continue,  
thanks

Rafael 

Lima-Peru



-- 

rrgv

I have Aastra pt480e phones and would like to present the caller the CID
info about the extension being called.

I have tried the following with no avail:

exten => 311,1,Macro(stdexten,311,${TIM})

exten => s,1,SetCIDName(${ARG2})
exten => s,2,Dial(${ARG2},20,rt)
exten => s,3,Goto(s-${DIALSTATUS},1)               

etc.....

so when dialing extension 311 I would like to display TIM(the person you are
calling) to the Caller while still displaying the Caller's CID to the person
being called.

Hope that makes sense.

Tim.
 

VOIP*CLI> show version
Asterisk CVS-v1-0-11/07/04-13:39:19 built by root@VOIP on a i686 running
Linux

Hi

I need some advice in this issue, I installed astcc again and creates
database from configure menu but I am still getting errors messages:

in Brands menu: "Something is wrong with the brands database"
in Cards menu: "Please define at least one brand before creating
cards"
in Trunks menu: "Something is wrong with the trunks database" 
in Routes menu: "Please define at least one trunk before creating
routes"
in Users_Configure: "Not Configured!"

Also I have noted that created database exists but its tables are
empty the same as the file astcc-config.conf although the apache user
has rights on it...

any idea????

thanks 
Rafael


On Wed, 1 Dec 2004 16:23:25 -0500, Rafael J. Risco G.V.
<rafael.risco@gmail.com> wrote:
> hi
> Today I?ve installed, apache 2.0.52, mysql-4.1.7, asterisk-perl-0.08
> and ASTCC prepaid card aplication  from CVS, so now I have access to
> the astcc-admin.cgi  from web server
> http://asterisk/cgi-bin/astcc-admin/astcc-admin.cgi and I?ve been able
> to create the database from "Configure" menu but I have some
doubts to
> continue:
> 
> - Do I have to reinstall asterisk with mysql support?
> - How asterisk or astcc knows what db should use, where the
> configuration files are?
> - when I go to "Cards" I ge this: ""Please define at
least one brand
> before creating cards"" and when I go to "Brands", I
have this error:
> "Something is wrong with the brands database" ...in
"Users_Configure"
> menu I have this error: Not Configured!
> 
> please send me some advise to continue,
> thanks
> 
> Rafael
> 
> Lima-Peru
> 
> --
> 
> rrgv
> 

-- 

rrgv

Same thing here.  It used to work perfectly until I re-installed.



Hi

I need some advice in this issue, I installed astcc again and creates
database from configure menu but I am still getting errors messages:

in Brands menu: "Something is wrong with the brands database"
in Cards menu: "Please define at least one brand before creating
cards"
in Trunks menu: "Something is wrong with the trunks database"
in Routes menu: "Please define at least one trunk before creating
routes"
in Users_Configure: "Not Configured!"

Also I have noted that created database exists but its tables are
empty the same as the file astcc-config.conf although the apache user
has rights on it...

any idea????

thanks
Rafael


On Wed, 1 Dec 2004 16:23:25 -0500, Rafael J. Risco G.V.
<rafael.risco@gmail.com> wrote:
> hi
> Today I?ve installed, apache 2.0.52, mysql-4.1.7, asterisk-perl-0.08
> and ASTCC prepaid card aplication  from CVS, so now I have access to
> the astcc-admin.cgi  from web server
> http://asterisk/cgi-bin/astcc-admin/astcc-admin.cgi and I?ve been able
> to create the database from "Configure" menu but I have some
doubts to
> continue:
>
> - Do I have to reinstall asterisk with mysql support?
> - How asterisk or astcc knows what db should use, where the
> configuration files are?
> - when I go to "Cards" I ge this: ""Please define at
least one brand
> before creating cards"" and when I go to "Brands", I
have this error:
> "Something is wrong with the brands database" ...in
"Users_Configure"
> menu I have this error: Not Configured!
>
> please send me some advise to continue,
> thanks
>
> Rafael
>
> Lima-Peru
>
> --
>
> rrgv
>

-- 

rrgv
_______________________________________________
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

Hi 
Problem was that I forgot to grant more privileges to "apache" user
and group... now I can create the tables but I do not understand some
terms like brands, trunks, etc, do you have a document with
descriptions?

thanks
rafael



On Sat, 4 Dec 2004 10:06:34 -0500, Steve Totaro
<asterisk@totarotechnologies.com> wrote:
> Same thing here.  It used to work perfectly until I re-installed.
> 
> Hi
> 
> I need some advice in this issue, I installed astcc again and creates
> database from configure menu but I am still getting errors messages:
> 
> in Brands menu: "Something is wrong with the brands database"
> in Cards menu: "Please define at least one brand before creating
cards"
> in Trunks menu: "Something is wrong with the trunks database"
> in Routes menu: "Please define at least one trunk before creating
routes"
> in Users_Configure: "Not Configured!"
> 
> Also I have noted that created database exists but its tables are
> empty the same as the file astcc-config.conf although the apache user
> has rights on it...
> 
> any idea????
> 
> thanks
> Rafael
> 
> On Wed, 1 Dec 2004 16:23:25 -0500, Rafael J. Risco G.V.
> <rafael.risco@gmail.com> wrote:
> > hi
> > Today I?ve installed, apache 2.0.52, mysql-4.1.7, asterisk-perl-0.08
> > and ASTCC prepaid card aplication  from CVS, so now I have access to
> > the astcc-admin.cgi  from web server
> > http://asterisk/cgi-bin/astcc-admin/astcc-admin.cgi and I?ve been able
> > to create the database from "Configure" menu but I have some
doubts to
> > continue:
> >
> > - Do I have to reinstall asterisk with mysql support?
> > - How asterisk or astcc knows what db should use, where the
> > configuration files are?
> > - when I go to "Cards" I ge this: ""Please define
at least one brand
> > before creating cards"" and when I go to "Brands",
I have this error:
> > "Something is wrong with the brands database" ...in
"Users_Configure"
> > menu I have this error: Not Configured!
> >
> > please send me some advise to continue,
> > thanks
> >
> > Rafael
> >
> > Lima-Peru
> >
> > --
> >
> > rrgv
> >
> 
> --
> 
> rrgv
> _______________________________________________
> 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
> 
> 

-- 

rrgv

I am still stuck on this.  How did you add more privileges?  I have webmin
installed if its easier than command line.  I am still getting the hang of
linux.

----- Original Message ----- 
From: "Rafael J. Risco G.V." <rafael.risco@gmail.com>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users@lists.digium.com>
Sent: Monday, December 06, 2004 5:25 PM
Subject: Re: [Asterisk-Users] ASTCC configuration problem


Hi
Problem was that I forgot to grant more privileges to "apache" user
and group... now I can create the tables but I do not understand some
terms like brands, trunks, etc, do you have a document with
descriptions?

thanks
rafael



On Sat, 4 Dec 2004 10:06:34 -0500, Steve Totaro
<asterisk@totarotechnologies.com> wrote:
> Same thing here.  It used to work perfectly until I re-installed.
>
> Hi
>
> I need some advice in this issue, I installed astcc again and creates
> database from configure menu but I am still getting errors messages:
>
> in Brands menu: "Something is wrong with the brands database"
> in Cards menu: "Please define at least one brand before creating
cards"
> in Trunks menu: "Something is wrong with the trunks database"
> in Routes menu: "Please define at least one trunk before creating
routes"
> in Users_Configure: "Not Configured!"
>
> Also I have noted that created database exists but its tables are
> empty the same as the file astcc-config.conf although the apache user
> has rights on it...
>
> any idea????
>
> thanks
> Rafael
>
> On Wed, 1 Dec 2004 16:23:25 -0500, Rafael J. Risco G.V.
> <rafael.risco@gmail.com> wrote:
> > hi
> > Today I?ve installed, apache 2.0.52, mysql-4.1.7, asterisk-perl-0.08
> > and ASTCC prepaid card aplication  from CVS, so now I have access to
> > the astcc-admin.cgi  from web server
> > http://asterisk/cgi-bin/astcc-admin/astcc-admin.cgi and I?ve been able
> > to create the database from "Configure" menu but I have some
doubts to
> > continue:
> >
> > - Do I have to reinstall asterisk with mysql support?
> > - How asterisk or astcc knows what db should use, where the
> > configuration files are?
> > - when I go to "Cards" I ge this: ""Please define
at least one brand
> > before creating cards"" and when I go to "Brands",
I have this error:
> > "Something is wrong with the brands database" ...in
"Users_Configure"
> > menu I have this error: Not Configured!
> >
> > please send me some advise to continue,
> > thanks
> >
> > Rafael
> >
> > Lima-Peru
> >
> > --
> >
> > rrgv
> >
>
> --
>
> rrgv
> _______________________________________________
> 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
>
>

-- 

rrgv
_______________________________________________
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

/SNIP/
-----Original Message-----
I am still stuck on this.  How did you add more privileges?  I have webmin
installed if its easier than command line.  I am still getting the hang of
linux.


Solution: Follow these steps
---------
This may not be due to privileges but due to the way database is created.

1) Loginto MySQL
2) drop databse astcc;
3) go to your admin page http://yourip/cgi-bin/astcc-admin/astcc-admin.cgi
4) select configure
7) Don't give IP for the host name. just type 'localhost' for the
host
8) click on create databse

This will create the database and you will be able to add brands, cards etc.

Seshu Kanuri


----- Original Message -----
From: "Rafael J. Risco G.V." <rafael.risco@gmail.com>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users@lists.digium.com>
Sent: Monday, December 06, 2004 5:25 PM
Subject: Re: [Asterisk-Users] ASTCC configuration problem


Hi
Problem was that I forgot to grant more privileges to "apache" user
and group... now I can create the tables but I do not understand some
terms like brands, trunks, etc, do you have a document with
descriptions?

thanks
rafael



On Sat, 4 Dec 2004 10:06:34 -0500, Steve Totaro
<asterisk@totarotechnologies.com> wrote:
> Same thing here.  It used to work perfectly until I re-installed.
>
> Hi
>
> I need some advice in this issue, I installed astcc again and creates
> database from configure menu but I am still getting errors messages:
>
> in Brands menu: "Something is wrong with the brands database"
> in Cards menu: "Please define at least one brand before creating
cards"
> in Trunks menu: "Something is wrong with the trunks database"
> in Routes menu: "Please define at least one trunk before creating
routes"
> in Users_Configure: "Not Configured!"
>
> Also I have noted that created database exists but its tables are
> empty the same as the file astcc-config.conf although the apache user
> has rights on it...
>
> any idea????
>
> thanks
> Rafael
>
> On Wed, 1 Dec 2004 16:23:25 -0500, Rafael J. Risco G.V.
> <rafael.risco@gmail.com> wrote:
> > hi
> > Today I?ve installed, apache 2.0.52, mysql-4.1.7, asterisk-perl-0.08
> > and ASTCC prepaid card aplication  from CVS, so now I have access to
> > the astcc-admin.cgi  from web server
> > http://asterisk/cgi-bin/astcc-admin/astcc-admin.cgi and I?ve been able
> > to create the database from "Configure" menu but I have some
doubts to
> > continue:
> >
> > - Do I have to reinstall asterisk with mysql support?
> > - How asterisk or astcc knows what db should use, where the
> > configuration files are?
> > - when I go to "Cards" I ge this: ""Please define
at least one brand
> > before creating cards"" and when I go to "Brands",
I have this error:
> > "Something is wrong with the brands database" ...in
"Users_Configure"
> > menu I have this error: Not Configured!
> >
> > please send me some advise to continue,
> > thanks
> >
> > Rafael
> >
> > Lima-Peru 
--------------------------------------------------------
 
NOTICE: If received in error, please destroy and notify sender.  Sender does not
waive confidentiality or privilege, and use is prohibited.

<SNIP>
I am still stuck on this.
</SNIP>

Allright, let us do it the easy way. Just copy and run the script below
on your 
Mysql Command line. Lets see how this goes.

If you want to use webmin to find what the problem is go to webmin ->
servers ->Mysql and check the configuration there. My guess is that
there may be some problem with your Mysql Socket which may have been
configured for running at /tmp/mysql.sock rather than what ASTCC expects
at /var/lib/mysql/mysql.sock

If the problem is with the Mysql Socket, them you have to use webmin to
redefine the mysql sock file  location as /tmp/mysql.sock (first of all
find if this is the case). If this is looking for a Mysql Socket at
/var/lib/mysql/mysql.sock and infact your socket is /tmp/mysql.sock ,
then you have to add a symbolic link using the command below:

ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock



Seshu Kanuri
------------
##Create table manually ##

use astcc;

CREATE TABLE `brands` (

`name` char(40) NOT NULL default '',

`language` char(10) default NULL,

`publishednum` char(40) default NULL,

`did` char(40) default NULL,

`markup` int(11) default NULL,

`inc` int(11) default NULL,

PRIMARY KEY (`name`)

) TYPE=MyISAM; 

CREATE TABLE `cards` (

`number` char(20) NOT NULL default '',

`language` char(10) default NULL,

`facevalue` int(11) default NULL,

`used` int(11) NOT NULL default '0',

`inc` int(11) NOT NULL default '0',

`markup` int(11) NOT NULL default '0',

`creation` timestamp(14) NOT NULL,

`firstuse` timestamp(14) NOT NULL default '00000000000000',

`expiration` timestamp(14) NOT NULL default '00000000000000',

`inuse` int(11) default NULL,

`pin` char(20) NOT NULL default '123456789',

PRIMARY KEY (`number`)

) TYPE=MyISAM; 

CREATE TABLE `cdrs` (

`cardnum` char(40) default NULL,

`callerid` char(80) default NULL,

`callednum` char(80) default NULL,

`trunk` char(40) default NULL,

`disposition` char(20) default NULL,

`billseconds` int(11) default NULL,

`billcost` int(11) default NULL
) TYPE=MyISAM; 

CREATE TABLE `iaxfriends` (

`name` char(40) NOT NULL default '',

`secret` char(40) default NULL,

`context` char(40) default NULL,

`ipaddr` char(20) default NULL,

`port` int(6) default NULL,

`regseconds` int(11) NOT NULL default '0',

PRIMARY KEY (`name`)

) TYPE=MyISAM; 

CREATE TABLE `routes` (

`pattern` char(40) NOT NULL default '',

`comment` char(80) default NULL,

`trunks` char(80) default NULL,

`connectcost` int(11) NOT NULL default '0',

`includedseconds` int(11) NOT NULL default '0',

`cost` int(11) NOT NULL default '0',

PRIMARY KEY (`pattern`)

) TYPE=MyISAM; 

CREATE TABLE `sipfriends` (

`name` char(40) NOT NULL default '',

`username` char(40) default NULL,

`secret` char(40) NOT NULL default '',

`context` char(40) NOT NULL default '',

`ipaddr` char(20) NOT NULL default '',

`port` int(6) NOT NULL default '0',

`regseconds` int(11) default NULL,

PRIMARY KEY (`name`)

) TYPE=MyISAM; 

CREATE TABLE `trunks` (

`name` char(40) NOT NULL default '',

`tech` char(10) default NULL,

`path` char(40) NOT NULL default '',

PRIMARY KEY (`name`)

) TYPE=MyISAM; 
--------------------------------------------------------
 
NOTICE: If received in error, please destroy and notify sender.  Sender does not
waive confidentiality or privilege, and use is prohibited.

> CREATE TABLE `cdrs` (
>
> `cardnum` char(40) default NULL,
>
> `callerid` char(80) default NULL,
>
> `callednum` char(80) default NULL,
>
> `trunk` char(40) default NULL,
>
> `disposition` char(20) default NULL,
>
> `billseconds` int(11) default NULL,
>
> `billcost` int(11) default NULL
> ) TYPE=MyISAM;
The cdrs table creation script is missing the callstart field.  I use the
sql below:

CREATE TABLE `cdrs` (
`cardnum` varchar(40) default NULL,
`callerid` varchar(80) default NULL,
`callednum` varchar(80) default NULL,
`trunk` varchar(40) default NULL,
`disposition` varchar(20) default NULL,
`billseconds` int(11) default NULL,
`billcost` int(11) default NULL,
`callstart` varchar(24)
 ) TYPE=MyISAM;


Karl Putz

> > > If nothing else, my efforts are documented for anyone else in the
> > > same boat.
> > > It seems that you can debug agi by typing agi debug at the *
command
> line.
> > > Amazing!  Here is the output.  I am assuming that since
astcc-tone
didnt
> > > play, the problem lies there.  Thoughts?
> >
> > Steve,
> >
> > I just remembered...
> >
> > The Makefile puts all its sounds into /usr/share/asterisk/sounds but *
> needs
> > the sounds in /var/lib/asterisk/sounds.
> >
> >
> > Karl
>
> Karl,
>
> Thanks alot!  Everything is working now but I dont get any audio in either
> direction.  If I dial the same external number from the same extension,
> everything is fine but going through the AGI breaks the audio.
To clarify, I get audio just fine while entering the pin and phone number
but when the call connects over my IAX provider there is no audio in either
direction.

> -----Original Message-----
> From: asterisk-users-bounces@lists.digium.com
> [mailto:asterisk-users-bounces@lists.digium.com]On Behalf Of Steve
> Totaro
> Sent: Wednesday, January 12, 2005 12:13 PM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: Re: [Asterisk-Users] ASTCC configuration problem
>
>
>
>
> > > > If nothing else, my efforts are documented for anyone else
in the
> > > > same boat.
> > > > It seems that you can debug agi by typing agi debug at the *
command
> > line.
> > > > Amazing!  Here is the output.  I am assuming that since
astcc-tone
> didnt
> > > > play, the problem lies there.  Thoughts?
> > >
> > > Steve,
> > >
> > > I just remembered...
> > >
> > > The Makefile puts all its sounds into /usr/share/asterisk/sounds
but *
> > needs
> > > the sounds in /var/lib/asterisk/sounds.
> > >
> > >
> > > Karl
> >
> > Karl,
> >
> > Thanks alot!  Everything is working now but I dont get any
> audio in either
> > direction.  If I dial the same external number from the same
extension,
> > everything is fine but going through the AGI breaks the audio.
>
> To clarify, I get audio just fine while entering the pin and phone number
> but when the call connects over my IAX provider there is no audio
> in either
> direction.
Steve,

I sounds like the problem may be in your "trunks" table definition of
the
IAX2 connection.

Unfortunately, I am only using TDM interfaces so I do not know what the path
field should contain for IAX.
For Zap interfaces, I simply put the group I want to use.  I.e. "g2".


Karl
>
> _______________________________________________
> 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
>
>

> > > > > If nothing else, my efforts are documented for anyone
else in the
> > > > > same boat.
> > > > > It seems that you can debug agi by typing agi debug at
the *
command
> > > line.
> > > > > Amazing!  Here is the output.  I am assuming that since
astcc-tone
> > didnt
> > > > > play, the problem lies there.  Thoughts?
> > > >
> > > > Steve,
> > > >
> > > > I just remembered...
> > > >
> > > > The Makefile puts all its sounds into
/usr/share/asterisk/sounds but
*
> > > needs
> > > > the sounds in /var/lib/asterisk/sounds.
> > > >
> > > >
> > > > Karl
> > >
> > > Karl,
> > >
> > > Thanks alot!  Everything is working now but I dont get any
> > audio in either
> > > direction.  If I dial the same external number from the same
extension,
> > > everything is fine but going through the AGI breaks the audio.
> >
> > To clarify, I get audio just fine while entering the pin and phone
number
> > but when the call connects over my IAX provider there is no audio
> > in either
> > direction.
>
> Steve,
>
> I sounds like the problem may be in your "trunks" table
definition of the
> IAX2 connection.
>
> Unfortunately, I am only using TDM interfaces so I do not know what the
path
> field should contain for IAX.
> For Zap interfaces, I simply put the group I want to use.  I.e.
"g2".
>
>
> Karl
My final solution after seeing some other posts about CVS update fixing
different issues was to update.  It all works perfectly now.  Thanks again.

Steve

Hi:

I used astcc to create database. After I get the
message database created, I save the configuration and
I move to the next step to assign trunk and route. But
I get the message:
Database unavailable -- please check configuration
Cannot edit routes until database is configured

I checked the databse and it's in mysql, the file
/var/lib/astcc/astcc-config.conf is empty.
astcc-admin.cgi is supposed to write a file based on
the configuration, but for some reason doesn't
I inserted data manually into the databse tables and
astcc works fine on asterisk and write data into the
database.
Why the web browser can't see the database it created?
could apache be the problem although it's running?

Regards;
Chawki


		
____________________________________________________
Start your day with Yahoo! - make it your home page 
http://www.yahoo.com/r/hs

You should have your pattern set to ^4207.  Then the pattern has to 
start with 4207.  The way my setup would be is ^0114207.

Darren Wiebe
darren@aleph-com.net


Ade Agbero wrote:
> Astcc applies a charge for Czech Republic - Mobile Code - 4207 to a 
> call destined for UK Landline 44207.
>
> It appears Astcc uses the first matching pattern of 4207 it finds in 
> the routes table instead of continuing to search through the routes 
> table until it comes to 44207 for UK.
>
> Any ideas on how to resolve this problem.
>
> Thanks,
>
> Ade.
>
> ------------------------------------------------------------------------
> How much free photo storage do you get? Store your holiday snaps for 
> FREE with Yahoo! Photos. *Get Yahoo! Photos* 
>
<http://us.rd.yahoo.com/mail/uk/taglines/default/photos/*http://uk.photos.yahoo.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
>

Hello..

I am new to the asterisk/astcc domain and have to do some maintenance work
on an existing system. As far as I know astcc has been installed and has
worked previously. All of a sudden it has stopped working. Since I am not
aware of how the interfacing between astcc and asterisk, I need some quick
pointers as to where I need to look at to see what is broken.

Thanks
Marios

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.9/62 - Release Date: 2/8/2005