asterisk2billing.org
http://forum.asterisk2billing.org/

A2Billing 1.4 Install Instructions
http://forum.asterisk2billing.org/viewtopic.php?f=21&t=5010
Page 3 of 5

Author:  graher01 [ Sat Sep 26, 2009 6:15 pm ]
Post subject:  Re: A2Billing 1.4 Install Instructions

alben wrote:
Hi everybody
I have piaf (vmware, centos5.2 fpbx 2.5 astreisk 1.4) installed and working properly.
Im following these instructions to install A2billing , but when I go to ./install-db.sh i get

Enter Database Name :
a2billing_dbname
Enter Hostname :
localhost
Enter UserName :
a2billing_dbuser
Enter Password :
passw0rd
mysql --user=a2billing_dbuser --password=passw0rd --host=localhost a2billing_dbname
ERROR 1045 (28000): Access denied for user 'a2billing_dbuser'@'localhost' (using password: YES)
the user name should be root and the password should be what ever the root password is.

i tried password = a2billing_dbpassword too

I will appreciate your help

Author:  flatpack [ Sun Sep 27, 2009 5:26 pm ]
Post subject:  Re: A2Billing 1.4 Install Instructions

what username and password you have used in this command?
mysqladmin create mya2billing -u a2billinguser -pa2billing

Code:
it is always better to use steps as they are once successfull then change what u want



alben wrote:
Hi everybody
I have piaf (vmware, centos5.2 fpbx 2.5 astreisk 1.4) installed and working properly.
Im following these instructions to install A2billing , but when I go to ./install-db.sh i get

Enter Database Name :
a2billing_dbname
Enter Hostname :
localhost
Enter UserName :
a2billing_dbuser
Enter Password :
passw0rd
mysql --user=a2billing_dbuser --password=passw0rd --host=localhost a2billing_dbname
ERROR 1045 (28000): Access denied for user 'a2billing_dbuser'@'localhost' (using password: YES)


i tried password = a2billing_dbpassword too

I will appreciate your help

Author:  graher01 [ Sun Sep 27, 2009 11:42 pm ]
Post subject:  Re: A2Billing 1.4 Install Instructions

for some reason my suggestion did not take.
you need to use username "root" and password "passw0rd"

Author:  alben [ Mon Sep 28, 2009 6:15 pm ]
Post subject:  Re: A2Billing 1.4 Install Instructions

hi, now i did this as your instructions

Enter Database Name :
a2billing_dbname
Enter Hostname :
localhost
Enter UserName :
root
Enter Password :
passw0rd
mysql --user=root --password=passw0rd --host=localhost a2billing_dbname
ERROR 1049 (42000): Unknown database 'a2billing_dbname'

thanks again

Author:  flatpack [ Mon Sep 28, 2009 7:45 pm ]
Post subject:  Re: A2Billing 1.4 Install Instructions

alben run this command first.

mysqladmin create a2billing_dbname -u root -ppassw0rd

Author:  alben [ Tue Sep 29, 2009 3:23 pm ]
Post subject:  Re: A2Billing 1.4 Install Instructions

Now I do

$ echo "GRANT ALL PRIVILEGES ON *.* TO 'a2billinguser'@'localhost' IDENTIFIED BY 'a2billing' WITH GRANT OPTION;" | mysql -ppassw0rd
$ mysqladmin create mya2billing -u a2billinguser -pa2billing

then i get

mysqladmin create mya2billing -u a2billinguser -pa2billing
mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'mya2billing'; database exists'


thanks

Author:  alben [ Tue Sep 29, 2009 3:36 pm ]
Post subject:  Re: A2Billing 1.4 Install Instructions

my mistake
i folloowed last advice and didnt get eny error this time
thanks

Author:  alben [ Tue Sep 29, 2009 4:16 pm ]
Post subject:  Re: A2Billing 1.4 Install Instructions

Hello,
I followed all the steps now up until
switch/a2billing
but
get the unix screen index /of a2billing

go to admin and get the login screen
but
root/changepassword seems not working

thanks a lot again

Author:  flatpack [ Wed Sep 30, 2009 7:31 am ]
Post subject:  Re: A2Billing 1.4 Install Instructions

alben wrote:
root/changepassword seems not working


user name root and changepassword works for me r u sure you r going in admin???

Author:  alben [ Wed Sep 30, 2009 4:04 pm ]
Post subject:  Re: A2Billing 1.4 Install Instructions

Hi,
I do this
ipaddress/a2billing
then i get a unix like screen with the list admin, agent, common, customer
i click in admin and i get the authentication screen asking for user/password

I followed all the steps as per the begining of this thread, exept the code listed the cronjobs section.

As can you see I am a computer literate but not linux expert, so please help.

Author:  seer_tenedos [ Thu Oct 01, 2009 2:49 am ]
Post subject:  Re: A2Billing 1.4 Install Instructions

alben wrote:
Hi everybody
Enter UserName :
a2billing_dbuser

if i remember correctly it is a2billing_user but it also depends on what you set wen you created the database and user a few lines before.

Author:  alben [ Thu Oct 01, 2009 3:37 pm ]
Post subject:  Re: A2Billing 1.4 Install Instructions

This is what i did following the steps:

echo "GRANT ALL PRIVILEGES ON *.* TO 'a2billinguser'@'localhost' IDENTIFIED BY 'a2billing' WITH GRANT OPTION;" | mysql -ppassw0rd

mysqladmin create a2billing_dbname -u root -ppassw0rd
./install-db.sh

Enter Database Name :
a2billing_dbname
Enter Hostname :
localhost
Enter UserName :
root
Enter Password :
passw0rd

here i didnt get any error message
then i finished the steps to the end

but
root/changepassword dont work

what did i miss?

thanks

Author:  alben [ Thu Oct 01, 2009 4:14 pm ]
Post subject:  Re: A2Billing 1.4 Install Instructions

By the way my a2billing.conf says

[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

Author:  seer_tenedos [ Fri Oct 02, 2009 12:22 am ]
Post subject:  Re: A2Billing 1.4 Install Instructions

alben wrote:
By the way my a2billing.conf says

[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


the config is wrong.
you set
echo "GRANT ALL PRIVILEGES ON *.* TO 'a2billinguser'@'localhost' IDENTIFIED BY 'a2billing' WITH GRANT OPTION;" | mysql -ppassw0rd
so should be
user=a2billinguser
password=passw0rd
dbname=a2billing

now you mentioned somewhere else as the dbname been a2billing_dbname so that may be the one you configured instead.

lastly the root password is case sensitive. that got me.
i think the password is Changepassword not changepassword

Chris

Author:  trimode [ Sat Oct 03, 2009 3:32 pm ]
Post subject:  Re: A2Billing 1.4 Install Instructions

i tried whatever you said but i still getting error

root@11015-10047:/usr/local/src/a2billing/DataBase/mysql-5.x $ ./install-db.sh
Install A2Billing DataBase
-----------------------------

Enter Database Name :
a2billing
Enter Hostname :
localhost
Enter UserName :
a2billinguser
Enter Password :
passw0rd
mysql --user=a2billinguser --password=passw0rd --host=localhost a2billing
ERROR 1045 (28000): Access denied for user 'a2billinguser'@'localhost' (using password: YES)
root@11015-10047:/usr/local/src/a2billing/DataBase/mysql-5.x $


Please help, it's driving me crazy... this is my info in a2billing.conf

[database]
hostname = localhost
; port for postgres is 5432 by default
port =
;user = a2billing_dbuser
;password = a2billing_dbpassword
;dbname = a2billing_dbname
user = a2billinguser
password = passw0rd
dbname = a2billing
; dbtype setting can either be mysql or postgres
dbtype = mysql

Page 3 of 5 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/