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/ |