Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Thu Mar 28, 2024 5:06 pm
VoIP Billing solution


All times are UTC




Post new topic Reply to topic  [ 63 posts ]  Go to page Previous  1, 2, 3, 4, 5  Next
Author Message
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Sat Sep 26, 2009 6:15 pm 
Offline

Joined: Thu Sep 13, 2007 12:46 pm
Posts: 254
Location: Naples, Fl ( USA )
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


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Sun Sep 27, 2009 5:26 pm 
Offline
User avatar

Joined: Fri Sep 18, 2009 5:46 pm
Posts: 132
Location: hhhhmmmmm
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


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Sun Sep 27, 2009 11:42 pm 
Offline

Joined: Thu Sep 13, 2007 12:46 pm
Posts: 254
Location: Naples, Fl ( USA )
for some reason my suggestion did not take.
you need to use username "root" and password "passw0rd"


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Mon Sep 28, 2009 6:15 pm 
Offline

Joined: Wed Oct 24, 2007 7:02 pm
Posts: 39
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


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Mon Sep 28, 2009 7:45 pm 
Offline
User avatar

Joined: Fri Sep 18, 2009 5:46 pm
Posts: 132
Location: hhhhmmmmm
alben run this command first.

mysqladmin create a2billing_dbname -u root -ppassw0rd


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Tue Sep 29, 2009 3:23 pm 
Offline

Joined: Wed Oct 24, 2007 7:02 pm
Posts: 39
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


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Tue Sep 29, 2009 3:36 pm 
Offline

Joined: Wed Oct 24, 2007 7:02 pm
Posts: 39
my mistake
i folloowed last advice and didnt get eny error this time
thanks


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Tue Sep 29, 2009 4:16 pm 
Offline

Joined: Wed Oct 24, 2007 7:02 pm
Posts: 39
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


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Wed Sep 30, 2009 7:31 am 
Offline
User avatar

Joined: Fri Sep 18, 2009 5:46 pm
Posts: 132
Location: hhhhmmmmm
alben wrote:
root/changepassword seems not working


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


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Wed Sep 30, 2009 4:04 pm 
Offline

Joined: Wed Oct 24, 2007 7:02 pm
Posts: 39
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.


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Thu Oct 01, 2009 2:49 am 
Offline

Joined: Mon Sep 28, 2009 9:49 pm
Posts: 58
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.


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Thu Oct 01, 2009 3:37 pm 
Offline

Joined: Wed Oct 24, 2007 7:02 pm
Posts: 39
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


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Thu Oct 01, 2009 4:14 pm 
Offline

Joined: Wed Oct 24, 2007 7:02 pm
Posts: 39
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


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Fri Oct 02, 2009 12:22 am 
Offline

Joined: Mon Sep 28, 2009 9:49 pm
Posts: 58
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


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Sat Oct 03, 2009 3:32 pm 
Offline

Joined: Wed Feb 27, 2008 6:44 am
Posts: 7
Location: Mississauga, ON
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


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 63 posts ]  Go to page Previous  1, 2, 3, 4, 5  Next
Hosted Voice Broadcast


All times are UTC


Who is online

Users browsing this forum: No registered users and 6 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group