Re: [Asterisk-Users] Astcc Configuration Problem
Yes, mysql is confirmed running. I also placed a call through astcc and I used a card number I inserted into the database created by the configuration web-page part. The call record was written by astcc to the mysql file. Regards; Chawki Hammoud --- Darren Wiebe [EMAIL PROTECTED] wrote: The missing file is nothing to worry about. It still looks like either the config file is empty or apache can't read it. Have you confirmed that your mysql server is running? Darren Wiebe [EMAIL PROTECTED] chawki hammoud wrote: There is mysql connection problem and missing files in var/www/html/. This is the error I get when I configure database [Tue Aug 02 23:43:25 2005] [error] [client 127.0.0.1] DBI connect('database=;host=','',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) at /var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67, referer: http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure [Tue Aug 02 23:43:25 2005] [error] [client 127.0.0.1] File does not exist: /var/www/html/favicon.ico [Tue Aug 02 23:44:18 2005] [error] [client 127.0.0.1] DBI connect('database=;host=','',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) at /var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67, referer: http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure [Tue Aug 02 23:44:18 2005] [error] [client 127.0.0.1] File does not exist: /var/www/html/favicon.ico The following error is created when I try to save the configuration. [Tue Aug 02 23:43:25 2005] [error] [client 127.0.0.1] DBI connect('database=;host=','',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) at /var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67, referer: http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure [Tue Aug 02 23:43:25 2005] [error] [client 127.0.0.1] File does not exist: /var/www/html/favicon.ico [Tue Aug 02 23:44:18 2005] [error] [client 127.0.0.1] DBI connect('database=;host=','',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) at /var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67, referer: http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure [Tue Aug 02 23:44:18 2005] [error] [client 127.0.0.1] File does not exist: /var/www/html/favicon.ico The following error is reported when I attempt the route configuration. [Tue Aug 02 23:50:44 2005] [error] [client 127.0.0.1] DBI connect('database=;host=','',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) at /var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67, referer: http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure [Tue Aug 02 23:50:44 2005] [error] [client 127.0.0.1] File does not exist: /var/www/html/favicon.ico --- Darren Wiebe [EMAIL PROTECTED] wrote: astcc-admin.cgi will post output to /var/log/httpd/error_log That should help solve the problem. Darren Wiebe [EMAIL PROTECTED] chawki hammoud wrote: All suggested files were changed to be owned by root and apache and I logged in as root. After I unsuccessfully try the route and trunk pages and go back to the configure page, I get the message database is unavailable on the same page that created it. I manually inserted data to astcc-config.conf but it seems apache is not writing or reading these files. Database is created successfully when I name the hostname= localhost.localdomain and it fails for hostname = localhost. I don't know if apache is loosing communication due to localhost somewhere and localhost.localdomain in other places. I will uninstall apache and reinstall it. I appreciate any more suggestions. --- Darren Wiebe [EMAIL PROTECTED] wrote: Try this line in /var/lib/astcc and see if it helps. chown apache * and chown -R apache * from /var/www/cgi-bin. If it does not help, do an ls -l in /var/www and see who owns it. Then repeat the command above with the correct user. Darren Wiebe [EMAIL PROTECTED] chawki hammoud wrote: Hi: How do I check it? Thanks --- Darren Wiebe [EMAIL PROTECTED] wrote: === message truncated === Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs ___ 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] Astcc Configuration Problem
There is mysql connection problem and missing files in var/www/html/. This is the error I get when I configure database [Tue Aug 02 23:43:25 2005] [error] [client 127.0.0.1] DBI connect('database=;host=','',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) at /var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67, referer: http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure [Tue Aug 02 23:43:25 2005] [error] [client 127.0.0.1] File does not exist: /var/www/html/favicon.ico [Tue Aug 02 23:44:18 2005] [error] [client 127.0.0.1] DBI connect('database=;host=','',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) at /var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67, referer: http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure [Tue Aug 02 23:44:18 2005] [error] [client 127.0.0.1] File does not exist: /var/www/html/favicon.ico The following error is created when I try to save the configuration. [Tue Aug 02 23:43:25 2005] [error] [client 127.0.0.1] DBI connect('database=;host=','',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) at /var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67, referer: http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure [Tue Aug 02 23:43:25 2005] [error] [client 127.0.0.1] File does not exist: /var/www/html/favicon.ico [Tue Aug 02 23:44:18 2005] [error] [client 127.0.0.1] DBI connect('database=;host=','',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) at /var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67, referer: http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure [Tue Aug 02 23:44:18 2005] [error] [client 127.0.0.1] File does not exist: /var/www/html/favicon.ico The following error is reported when I attempt the route configuration. [Tue Aug 02 23:50:44 2005] [error] [client 127.0.0.1] DBI connect('database=;host=','',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) at /var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67, referer: http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure [Tue Aug 02 23:50:44 2005] [error] [client 127.0.0.1] File does not exist: /var/www/html/favicon.ico --- Darren Wiebe [EMAIL PROTECTED] wrote: astcc-admin.cgi will post output to /var/log/httpd/error_log That should help solve the problem. Darren Wiebe [EMAIL PROTECTED] chawki hammoud wrote: All suggested files were changed to be owned by root and apache and I logged in as root. After I unsuccessfully try the route and trunk pages and go back to the configure page, I get the message database is unavailable on the same page that created it. I manually inserted data to astcc-config.conf but it seems apache is not writing or reading these files. Database is created successfully when I name the hostname= localhost.localdomain and it fails for hostname = localhost. I don't know if apache is loosing communication due to localhost somewhere and localhost.localdomain in other places. I will uninstall apache and reinstall it. I appreciate any more suggestions. --- Darren Wiebe [EMAIL PROTECTED] wrote: Try this line in /var/lib/astcc and see if it helps. chown apache * and chown -R apache * from /var/www/cgi-bin. If it does not help, do an ls -l in /var/www and see who owns it. Then repeat the command above with the correct user. Darren Wiebe [EMAIL PROTECTED] chawki hammoud wrote: Hi: How do I check it? Thanks --- Darren Wiebe [EMAIL PROTECTED] wrote: Check and make sure that astcc-config.conf is owned by the same process that owns apache. Usually the problem is that astcc-admin cannot write to the file due to permission problems. Darren Wiebe [EMAIL PROTECTED] chawki hammoud wrote: 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
Re: [Asterisk-Users] Astcc Configuration Problem
There is mysql connection problem and missing files in var/www/html/. This is the error I get when I configure database [Tue Aug 02 23:43:25 2005] [error] [client 127.0.0.1] DBI connect('database=;host=','',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) at /var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67, referer: http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure [Tue Aug 02 23:43:25 2005] [error] [client 127.0.0.1] File does not exist: /var/www/html/favicon.ico [Tue Aug 02 23:44:18 2005] [error] [client 127.0.0.1] DBI connect('database=;host=','',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) at /var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67, referer: http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure [Tue Aug 02 23:44:18 2005] [error] [client 127.0.0.1] File does not exist: /var/www/html/favicon.ico The following error is created when I try to save the configuration. [Tue Aug 02 23:43:25 2005] [error] [client 127.0.0.1] DBI connect('database=;host=','',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) at /var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67, referer: http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure [Tue Aug 02 23:43:25 2005] [error] [client 127.0.0.1] File does not exist: /var/www/html/favicon.ico [Tue Aug 02 23:44:18 2005] [error] [client 127.0.0.1] DBI connect('database=;host=','',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) at /var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67, referer: http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure [Tue Aug 02 23:44:18 2005] [error] [client 127.0.0.1] File does not exist: /var/www/html/favicon.ico The following error is reported when I attempt the route configuration. [Tue Aug 02 23:50:44 2005] [error] [client 127.0.0.1] DBI connect('database=;host=','',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) at /var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67, referer: http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure [Tue Aug 02 23:50:44 2005] [error] [client 127.0.0.1] File does not exist: /var/www/html/favicon.ico --- Darren Wiebe [EMAIL PROTECTED] wrote: astcc-admin.cgi will post output to /var/log/httpd/error_log That should help solve the problem. Darren Wiebe [EMAIL PROTECTED] chawki hammoud wrote: All suggested files were changed to be owned by root and apache and I logged in as root. After I unsuccessfully try the route and trunk pages and go back to the configure page, I get the message database is unavailable on the same page that created it. I manually inserted data to astcc-config.conf but it seems apache is not writing or reading these files. Database is created successfully when I name the hostname= localhost.localdomain and it fails for hostname = localhost. I don't know if apache is loosing communication due to localhost somewhere and localhost.localdomain in other places. I will uninstall apache and reinstall it. I appreciate any more suggestions. --- Darren Wiebe [EMAIL PROTECTED] wrote: Try this line in /var/lib/astcc and see if it helps. chown apache * and chown -R apache * from /var/www/cgi-bin. If it does not help, do an ls -l in /var/www and see who owns it. Then repeat the command above with the correct user. Darren Wiebe [EMAIL PROTECTED] chawki hammoud wrote: Hi: How do I check it? Thanks --- Darren Wiebe [EMAIL PROTECTED] wrote: Check and make sure that astcc-config.conf is owned by the same process that owns apache. Usually the problem is that astcc-admin cannot write to the file due to permission problems. Darren Wiebe [EMAIL PROTECTED] chawki hammoud wrote: 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
Re: [Asterisk-Users] Astcc Configuration Problem
The missing file is nothing to worry about. It still looks like either the config file is empty or apache can't read it. Have you confirmed that your mysql server is running? Darren Wiebe [EMAIL PROTECTED] chawki hammoud wrote: There is mysql connection problem and missing files in var/www/html/. This is the error I get when I configure database [Tue Aug 02 23:43:25 2005] [error] [client 127.0.0.1] DBI connect('database=;host=','',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) at /var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67, referer: http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure [Tue Aug 02 23:43:25 2005] [error] [client 127.0.0.1] File does not exist: /var/www/html/favicon.ico [Tue Aug 02 23:44:18 2005] [error] [client 127.0.0.1] DBI connect('database=;host=','',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) at /var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67, referer: http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure [Tue Aug 02 23:44:18 2005] [error] [client 127.0.0.1] File does not exist: /var/www/html/favicon.ico The following error is created when I try to save the configuration. [Tue Aug 02 23:43:25 2005] [error] [client 127.0.0.1] DBI connect('database=;host=','',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) at /var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67, referer: http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure [Tue Aug 02 23:43:25 2005] [error] [client 127.0.0.1] File does not exist: /var/www/html/favicon.ico [Tue Aug 02 23:44:18 2005] [error] [client 127.0.0.1] DBI connect('database=;host=','',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) at /var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67, referer: http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure [Tue Aug 02 23:44:18 2005] [error] [client 127.0.0.1] File does not exist: /var/www/html/favicon.ico The following error is reported when I attempt the route configuration. [Tue Aug 02 23:50:44 2005] [error] [client 127.0.0.1] DBI connect('database=;host=','',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) at /var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67, referer: http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure [Tue Aug 02 23:50:44 2005] [error] [client 127.0.0.1] File does not exist: /var/www/html/favicon.ico --- Darren Wiebe [EMAIL PROTECTED] wrote: astcc-admin.cgi will post output to /var/log/httpd/error_log That should help solve the problem. Darren Wiebe [EMAIL PROTECTED] chawki hammoud wrote: All suggested files were changed to be owned by root and apache and I logged in as root. After I unsuccessfully try the route and trunk pages and go back to the configure page, I get the message database is unavailable on the same page that created it. I manually inserted data to astcc-config.conf but it seems apache is not writing or reading these files. Database is created successfully when I name the hostname= localhost.localdomain and it fails for hostname = localhost. I don't know if apache is loosing communication due to localhost somewhere and localhost.localdomain in other places. I will uninstall apache and reinstall it. I appreciate any more suggestions. --- Darren Wiebe [EMAIL PROTECTED] wrote: Try this line in /var/lib/astcc and see if it helps. chown apache * and chown -R apache * from /var/www/cgi-bin. If it does not help, do an ls -l in /var/www and see who owns it. Then repeat the command above with the correct user. Darren Wiebe [EMAIL PROTECTED] chawki hammoud wrote: Hi: How do I check it? Thanks --- Darren Wiebe [EMAIL PROTECTED] wrote: Check and make sure that astcc-config.conf is owned by the same process that owns apache. Usually the problem is that astcc-admin cannot write to the file due to permission problems. Darren Wiebe [EMAIL PROTECTED] chawki hammoud wrote: 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
Re: [Asterisk-Users] Astcc Configuration Problem
Hi: How do I check it? Thanks --- Darren Wiebe [EMAIL PROTECTED] wrote: Check and make sure that astcc-config.conf is owned by the same process that owns apache. Usually the problem is that astcc-admin cannot write to the file due to permission problems. Darren Wiebe [EMAIL PROTECTED] chawki hammoud wrote: 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 ___ 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 ___ 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 __ Yahoo! Mail for Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail ___ 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] Astcc Configuration Problem
Try this line in /var/lib/astcc and see if it helps. chown apache * and chown -R apache * from /var/www/cgi-bin. If it does not help, do an ls -l in /var/www and see who owns it. Then repeat the command above with the correct user. Darren Wiebe [EMAIL PROTECTED] chawki hammoud wrote: Hi: How do I check it? Thanks --- Darren Wiebe [EMAIL PROTECTED] wrote: Check and make sure that astcc-config.conf is owned by the same process that owns apache. Usually the problem is that astcc-admin cannot write to the file due to permission problems. Darren Wiebe [EMAIL PROTECTED] chawki hammoud wrote: 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 ___ 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 ___ 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 __ Yahoo! Mail for Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail ___ 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 ___ 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] Astcc Configuration Problem
All suggested files were changed to be owned by root and apache and I logged in as root. After I unsuccessfully try the route and trunk pages and go back to the configure page, I get the message database is unavailable on the same page that created it. I manually inserted data to astcc-config.conf but it seems apache is not writing or reading these files. Database is created successfully when I name the hostname= localhost.localdomain and it fails for hostname = localhost. I don't know if apache is loosing communication due to localhost somewhere and localhost.localdomain in other places. I will uninstall apache and reinstall it. I appreciate any more suggestions. --- Darren Wiebe [EMAIL PROTECTED] wrote: Try this line in /var/lib/astcc and see if it helps. chown apache * and chown -R apache * from /var/www/cgi-bin. If it does not help, do an ls -l in /var/www and see who owns it. Then repeat the command above with the correct user. Darren Wiebe [EMAIL PROTECTED] chawki hammoud wrote: Hi: How do I check it? Thanks --- Darren Wiebe [EMAIL PROTECTED] wrote: Check and make sure that astcc-config.conf is owned by the same process that owns apache. Usually the problem is that astcc-admin cannot write to the file due to permission problems. Darren Wiebe [EMAIL PROTECTED] chawki hammoud wrote: 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 ___ 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 ___ 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 __ Yahoo! Mail for Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail ___ 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 ___ 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 Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs ___ 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] Astcc Configuration Problem
astcc-admin.cgi will post output to /var/log/httpd/error_log That should help solve the problem. Darren Wiebe [EMAIL PROTECTED] chawki hammoud wrote: All suggested files were changed to be owned by root and apache and I logged in as root. After I unsuccessfully try the route and trunk pages and go back to the configure page, I get the message database is unavailable on the same page that created it. I manually inserted data to astcc-config.conf but it seems apache is not writing or reading these files. Database is created successfully when I name the hostname= localhost.localdomain and it fails for hostname = localhost. I don't know if apache is loosing communication due to localhost somewhere and localhost.localdomain in other places. I will uninstall apache and reinstall it. I appreciate any more suggestions. --- Darren Wiebe [EMAIL PROTECTED] wrote: Try this line in /var/lib/astcc and see if it helps. chown apache * and chown -R apache * from /var/www/cgi-bin. If it does not help, do an ls -l in /var/www and see who owns it. Then repeat the command above with the correct user. Darren Wiebe [EMAIL PROTECTED] chawki hammoud wrote: Hi: How do I check it? Thanks --- Darren Wiebe [EMAIL PROTECTED] wrote: Check and make sure that astcc-config.conf is owned by the same process that owns apache. Usually the problem is that astcc-admin cannot write to the file due to permission problems. Darren Wiebe [EMAIL PROTECTED] chawki hammoud wrote: 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 ___ 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 ___ 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 __ Yahoo! Mail for Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail ___ 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 ___ 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 Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs ___ 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 ___ 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
[Asterisk-Users] Astcc Configuration Problem
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 ___ 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] Astcc Configuration Problem
Check and make sure that astcc-config.conf is owned by the same process that owns apache. Usually the problem is that astcc-admin cannot write to the file due to permission problems. Darren Wiebe [EMAIL PROTECTED] chawki hammoud wrote: 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 ___ 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 ___ 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] ASTCC configuration problem
Steve, What version of MySQL are you running? I upgraded to 4.1.8 and ran into the problem below. I initially tested with the user root and the default blank password and was OK. But when I changed over to a new user with a password, I noticed an error message in the httpd logs: Client does not support authentication protocol requested by server; consider upgrading MySQL client Once I converted to OLD_PASSWORD for the user, I was OK. Remember to set the password for the [EMAIL PROTECTED] matching the host name you have used in the config file. http://dev.mysql.com/doc/mysql/en/Old_client.html Karl Putz Karl, Thanks for your reply. It actually was not the problem but lead me one step closer to getting everything working. I had to change permissions to /var/lib/astcc/* so that it was writeable. Now everything looks like it should work but when I call the script it just terminates like below. == Spawn extension (from-internal, h, 1) exited non-zero on 'SIP/201-2c52' -- Executing Answer(SIP/201-0bef, ) in new stack -- Executing DeadAGI(SIP/201-0bef, astcc.agi) in new stack -- Launched AGI Script /var/lib/asterisk/agi-bin/astcc.agi == Spawn extension (from-internal, 77, 2) exited non-zero on 'SIP/201-0bef' Nothing is heard on the phone. I have a feeling I am very close. Any help is appreciated. Steve ___ 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] ASTCC configuration problem
Steve, What version of MySQL are you running? I upgraded to 4.1.8 and ran into the problem below. I initially tested with the user root and the default blank password and was OK. But when I changed over to a new user with a password, I noticed an error message in the httpd logs: Client does not support authentication protocol requested by server; consider upgrading MySQL client Once I converted to OLD_PASSWORD for the user, I was OK. Remember to set the password for the [EMAIL PROTECTED] matching the host name you have used in the config file. http://dev.mysql.com/doc/mysql/en/Old_client.html Karl Putz Karl, Thanks for your reply. It actually was not the problem but lead me one step closer to getting everything working. I had to change permissions to /var/lib/astcc/* so that it was writeable. Now everything looks like it should work but when I call the script it just terminates like below. == Spawn extension (from-internal, h, 1) exited non-zero on 'SIP/201-2c52' -- Executing Answer(SIP/201-0bef, ) in new stack -- Executing DeadAGI(SIP/201-0bef, astcc.agi) in new stack -- Launched AGI Script /var/lib/asterisk/agi-bin/astcc.agi == Spawn extension (from-internal, 77, 2) exited non-zero on 'SIP/201-0bef' Nothing is heard on the phone. I have a feeling I am very close. Any help is appreciated. Steve 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? AGI Debugging Enabled -- Accepting AUTHENTICATED call from x.x.x.x, requested format = 1024, actual format = 2 -- Executing Answer(IAX2/[EMAIL PROTECTED]/5, ) in new stack -- Executing DeadAGI(IAX2/[EMAIL PROTECTED]/5, astcc.agi) in new stack -- Launched AGI Script /var/lib/asterisk/agi-bin/astcc.agi AGI Tx agi_request: astcc.agi AGI Tx agi_channel: IAX2/[EMAIL PROTECTED]/5 AGI Tx agi_language: en AGI Tx agi_type: IAX2 AGI Tx agi_uniqueid: 1105546846.5 AGI Tx agi_callerid: (Softphone) Steve\'s Dell 200 AGI Tx agi_dnid: 77 AGI Tx agi_rdnis: unknown AGI Tx agi_context: from-internal AGI Tx agi_extension: 77 AGI Tx agi_priority: 2 AGI Tx agi_enhanced: 0.0 AGI Tx agi_accountcode: AGI Tx AGI Rx ANSWER AGI Tx 200 result=0 AGI Rx STREAM FILE astcc-tone 0123456789 AGI Tx 200 result=0 endpos=0 ___ 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] ASTCC configuration problem
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Steve Totaro Sent: Wednesday, January 12, 2005 10:30 AM 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 AGI Debugging Enabled -- Accepting AUTHENTICATED call from x.x.x.x, requested format = 1024, actual format = 2 -- Executing Answer(IAX2/[EMAIL PROTECTED]/5, ) in new stack -- Executing DeadAGI(IAX2/[EMAIL PROTECTED]/5, astcc.agi) in new stack -- Launched AGI Script /var/lib/asterisk/agi-bin/astcc.agi AGI Tx agi_request: astcc.agi AGI Tx agi_channel: IAX2/[EMAIL PROTECTED]/5 AGI Tx agi_language: en AGI Tx agi_type: IAX2 AGI Tx agi_uniqueid: 1105546846.5 AGI Tx agi_callerid: (Softphone) Steve\'s Dell 200 AGI Tx agi_dnid: 77 AGI Tx agi_rdnis: unknown AGI Tx agi_context: from-internal AGI Tx agi_extension: 77 AGI Tx agi_priority: 2 AGI Tx agi_enhanced: 0.0 AGI Tx agi_accountcode: AGI Tx AGI Rx ANSWER AGI Tx 200 result=0 AGI Rx STREAM FILE astcc-tone 0123456789 AGI Tx 200 result=0 endpos=0 ___ 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 ___ 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] 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. ___ 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] 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. ___ 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] ASTCC configuration problem
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 ___ 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] 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 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 ___ 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] ASTCC configuration problem
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. [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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. [EMAIL PROTECTED] 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 ___ 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] ASTCC configuration problem
/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. [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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. [EMAIL PROTECTED] 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. ___ 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] ASTCC configuration problem
/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 Seshu, I tried that and it still doesnt work. Same problem and I even restarted mysql. - Original Message - From: Rafael J. Risco G.V. [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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. [EMAIL PROTECTED] 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 ___ 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] ASTCC configuration problem
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 '00', `expiration` timestamp(14) NOT NULL default '00', `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. ___ 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] ASTCC configuration problem
Same problem. I dropped all the tables and ran the above. I also checked the sockets and they are correct. Any other ideas? 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 '00', `expiration` timestamp(14) NOT NULL default '00', `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; ___ 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] ASTCC configuration problem
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 ___ 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] ASTCC configuration problem
Steve, What version of MySQL are you running? I upgraded to 4.1.8 and ran into the problem below. I initially tested with the user root and the default blank password and was OK. But when I changed over to a new user with a password, I noticed an error message in the httpd logs: Client does not support authentication protocol requested by server; consider upgrading MySQL client Once I converted to OLD_PASSWORD for the user, I was OK. Remember to set the password for the [EMAIL PROTECTED] matching the host name you have used in the config file. http://dev.mysql.com/doc/mysql/en/Old_client.html Karl Putz -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Steve Totaro Sent: Tuesday, January 11, 2005 6:39 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] ASTCC configuration problem Same problem. I dropped all the tables and ran the above. I also checked the sockets and they are correct. Any other ideas? ___ 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] 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 [EMAIL PROTECTED] 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. [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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] ASTCC configuration problem
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. [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[Asterisk-Users] ASTCC configuration problem
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. [EMAIL PROTECTED] 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 [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[Asterisk-Users] 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 ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users