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/