asterisk2billing.org http://forum.asterisk2billing.org/ |
|
A2Billing 1.4 Install Instructions http://forum.asterisk2billing.org/viewtopic.php?f=21&t=5010 |
Page 4 of 5 |
Author: | seer_tenedos [ Sat Oct 03, 2009 9:49 pm ] |
Post subject: | Re: A2Billing 1.4 Install Instructions |
Sorry password should have been a2billing not passw0rd. Also you can just try to login to mysql with the details directly to quickly check |
Author: | alben [ Sat Oct 10, 2009 6:42 pm ] |
Post subject: | Re: A2Billing 1.4 Install Instructions |
hi I was messing around with these instructions, but i cant get to login to a2billing page even i get the login screen. I get conection failed when i enter login/password please help can i redo the database setup? thanks |
Author: | jroper [ Sun Oct 11, 2009 7:43 am ] |
Post subject: | Re: A2Billing 1.4 Install Instructions |
Check the connection to the database. Look in /etc/a2billing.conf and check the database credentials in there, and see if you can connect to mysql via the command line with mysql -ua2b-user -pa2b-password replacing a2b-user and a2b-password with the values in a2billing.conf. Once in mysql, type use a2b-database, and then show tables, to confirm that the database exists. Replace a2b-database with the value in a2billing.conf Joe |
Author: | alben [ Mon Oct 12, 2009 6:36 pm ] |
Post subject: | Re: A2Billing 1.4 Install Instructions |
Hello this is my a2billing.conf [database] hostname = localhost ; port for postgres is 5432 by default port = user = a2billing_dbuser password = a2billing_dbpassword dbname = a2billing_dbname ; dbtype setting can either be mysql or postgres dbtype = mysql then i do mysql -ua2billing_dbuser -pa2billing_dbpassword following you but i get root@pbx:~ $ mysql -ua2billing_dbuser -pa2billing_dbpassword ERROR 1045 (28000): Access denied for user 'a2billing_dbuser'@'localhost' (using password: YES) root@pbx:~ $ thanks again |
Author: | ylan [ Mon Oct 12, 2009 7:45 pm ] |
Post subject: | Re: A2Billing 1.4 Install Instructions |
Hi everybody, Does someone know how to execute cronjob on the a2billing install, which command to execute. FYI: I have asterisk compiled from scratch and it's working for inbound and outbound call Thank you for your response |
Author: | jroper [ Mon Oct 12, 2009 8:09 pm ] |
Post subject: | Re: A2Billing 1.4 Install Instructions |
In respect of Cronjobs, for the Linux conversational, they are best set up using webmin. The suggested timings are as comments in the cronjobs themselves, and the files in the Cronjobs directory in the installation Tarball. In respect of the MySQL problem, you need to add a matching user for A2Billing, again for the Linux conversational, this is easiest accomplished with either phpMyAdmin, or Webmin. Joe |
Author: | ylan [ Mon Oct 12, 2009 9:44 pm ] |
Post subject: | Re: A2Billing 1.4 Install Instructions |
Thank you for your anwer I succeeded in running crontab, now when I make crontab -l I have my list |
Author: | seer_tenedos [ Mon Oct 12, 2009 10:18 pm ] |
Post subject: | Re: A2Billing 1.4 Install Instructions |
alben wrote: Hello this is my a2billing.conf [database] hostname = localhost ; port for postgres is 5432 by default port = user = a2billing_dbuser password = a2billing_dbpassword dbname = a2billing_dbname ; dbtype setting can either be mysql or postgres dbtype = mysql then i do mysql -ua2billing_dbuser -pa2billing_dbpassword following you but i get root@pbx:~ $ mysql -ua2billing_dbuser -pa2billing_dbpassword ERROR 1045 (28000): Access denied for user 'a2billing_dbuser'@'localhost' (using password: YES) root@pbx:~ $ thanks again ok just to be clear as i may not have been before try the lien below. it logs you in correct? mysqladmin -ua2billinguser -pa2billing if the line above works your username = a2billinguser password=a2billing database=mya2billing your config should be [database] hostname = localhost ; port for postgres is 5432 by default port = user = a2billinguser password = a2billing dbname = mya2billing ; dbtype setting can either be mysql or postgres dbtype = mysql does that make sense? now i am basing the dbname off what is standard and what you mentioned in a post before. someone else may have a simple way to confirm it is the right db and that it is not an empty db but for now use those setting and try to login to the admin site with the following details username = root password= Changeme (case sensitive and someone correct me if this is wrong this is from memory and my memory is quite bad) |
Author: | ylan [ Mon Oct 12, 2009 10:41 pm ] |
Post subject: | Re: A2Billing 1.4 Install Instructions |
Hi, Could you connect to mysql as a root as follow mysql -u root -h localhost -p show databases; use mysql (if it is in the database list you've just shown) select user, password from user; Could you post us the result Thanks |
Author: | alben [ Wed Oct 14, 2009 4:27 pm ] |
Post subject: | Re: A2Billing 1.4 Install Instructions |
Hi, still having problems. this is what i have now. root@pbx:~ $ vi /etc/a2billing.conf ; A2Billing config file ; ; Global Database Setup - select the database type and authentication as required. [database] hostname = localhost ; port for postgres is 5432 by default port = user = a2billing_dbuser password = a2billing_dbpassword dbname = a2billing_dbname ; dbtype setting can either be mysql or postgres dbtype = mysql ...etc if I do root@pbx:~ $ mysqladmin -ua2billinguser -pa2billing I get the command help screen i think mysqladmin Ver 8.41 Distrib 5.0.45, for redhat-linux-gnu on i686 Copyright (C) 2000-2006 MySQL AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license ...etc as if I type just mysqladmin If I do root@pbx:~ $ mysql -u root -h localhost -p it ask for password which password? it matters which prompt i located in to run the commands? thanks again friends |
Author: | alben [ Wed Oct 14, 2009 5:21 pm ] |
Post subject: | Re: A2Billing 1.4 Install Instructions |
Hi Now i followed the steps for "reset mysql root password" : # /etc/init.d/mysql stop # mysqld_safe --skip-grant-tables & # mysql -u root mysql> mysql> use mysql; mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root'; mysql> flush privileges; mysql> quit # /etc/init.d/mysql stop # /etc/init.d/mysql start # mysql -u root -p ... but the new password I entered don't work either: root@pbx:~ $ mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) root@pbx:~ $ thanks |
Author: | alben [ Wed Oct 14, 2009 7:10 pm ] |
Post subject: | Re: A2Billing 1.4 Install Instructions |
My mistake, following the steps for "reset root password" did work so I did : root@pbx:~ $ mysql -u root -p and get : mysql> show databases; Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 5.0.45 Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | a2billing_dbname | | asterisk | | asteriskcdrdb | | mya2billing | | mysql | | test | +--------------------+ 7 rows in set (0.00 sec) mysql> so this is where I am now appreciate your help |
Author: | seer_tenedos [ Wed Oct 14, 2009 8:41 pm ] |
Post subject: | Re: A2Billing 1.4 Install Instructions |
alben, Looks like you have missed my post so i am not going to repeat it but just give you a link to it. Your config /etc/a2billing.conf is WRONG. It should be as i explained in reply http://forum.asterisk2billing.org/viewtopic.php?f=21&t=5010&p=25179#p25147. If the config i told you in the link above does not work then change the database name to a2billing_dbname but only if the database name mya2billing does not work first. If both of these configs don't work then post again. |
Author: | alben [ Thu Oct 15, 2009 6:47 pm ] |
Post subject: | Re: A2Billing 1.4 Install Instructions |
Hi, I followed exactly the install steps in another PC and now and it is working, I can login to switch\a2billing with root-changepassword I think my error was not changing my a2billing.conf when I copied from /var as instructed. thanks a lot |
Author: | alben [ Fri Oct 16, 2009 5:09 pm ] |
Post subject: | Re: A2Billing 1.4 Install Instructions |
Hi everyone again I found this problem i have vmware piaf a2billing i noticed that my clock time is very delayed just recently, when i just installed piaf clock was fine, now a real minute last 20 sec when i run >date. I found this in the web: http://rextang.net/blogs/work/archive/2 ... /4516.aspx ----------------------------------- A search to Google finally found the answer. From VMWare KB. It's exactly the answer of this problem if you are running kernel 2.6 inside VMWare. the reason that caused the slowing time inside guest system is because of that the guest clock frequency is setting too high than the host OS can offer. in 2.4 kernel the clock rate is set to 100HZ and after 2.6 kernel the clock is set to 1000HZ on compiling time, thus cause the timer in guest OS slower than host OS. refer to this KB for more detail explaination. Just follow what the KB said to tune bootup kernel options for both slow time and quick time problem, like the following (GRUB case): image=/boot/vmlinuz label="linux" root=/dev/hda1 initrd=/boot/initrd.img append="resume=/dev/hda6 splash=silent clock=pit nosmp noapic nolapic" read-only "clock=pit" is to fix quick clock problem, "nosmp noapic nolapic" is to fix slow clock problem. after a reboot of guest linux (both my Fedora one and CentOS one) , the clock is back to normal and strangely that the ntpd also back to normal work and can query outside time server without problems. cool! --------------------------------- Should I do this procedure? thanks for your knowledge and help |
Page 4 of 5 | All times are UTC |
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |