Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Thu Mar 28, 2024 6:09 pm
Auto Dialer Software


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 Oct 03, 2009 9:49 pm 
Offline

Joined: Mon Sep 28, 2009 9:49 pm
Posts: 58
Sorry password should have been a2billing not passw0rd.

Also you can just try to login to mysql with the details directly to quickly check


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Sat Oct 10, 2009 6:42 pm 
Offline

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


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Sun Oct 11, 2009 7:43 am 
Offline

Joined: Fri Jun 23, 2006 3:56 pm
Posts: 4065
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


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Mon Oct 12, 2009 6:36 pm 
Offline

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


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Mon Oct 12, 2009 7:45 pm 
Offline

Joined: Mon Oct 12, 2009 6:53 pm
Posts: 12
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


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Mon Oct 12, 2009 8:09 pm 
Offline

Joined: Fri Jun 23, 2006 3:56 pm
Posts: 4065
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


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Mon Oct 12, 2009 9:44 pm 
Offline

Joined: Mon Oct 12, 2009 6:53 pm
Posts: 12
Thank you for your anwer I succeeded in running crontab, now when I make crontab -l I have my list


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Mon Oct 12, 2009 10:18 pm 
Offline

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


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Mon Oct 12, 2009 10:41 pm 
Offline

Joined: Mon Oct 12, 2009 6:53 pm
Posts: 12
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


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

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


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Wed Oct 14, 2009 5:21 pm 
Offline

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


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Wed Oct 14, 2009 7:10 pm 
Offline

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


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Wed Oct 14, 2009 8:41 pm 
Offline

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


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Thu Oct 15, 2009 6:47 pm 
Offline

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


Top
 Profile  
 
 Post subject: Re: A2Billing 1.4 Install Instructions
PostPosted: Fri Oct 16, 2009 5:09 pm 
Offline

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


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