Followed the steps on from Scratch in Centos 7 - Steps are missing.
Added by Fidel Garcia almost 9 years ago
I have followed the steps listed here:
http://goautodial.org/projects/goautodialce/wiki/Centos7
The database does not get populated with Asterisk or Vicidial information, in fact, nothing gets changed in mysql. I am obviously missing something or the steps are missing something.
What have I done so far?
1. I have done 3 clean installs of Centos 7 and followed the steps, the results are the same.
2. I manually created the Asterisk Database and User, Vicidial was able to populate the database but obviously, Asterisk information is not in the database and therefore nothing works.
What to do next?
Replies (16)
RE: Followed the steps on from Scratch in Centos 7 - Steps are missing.
-
Added by clyde shaw almost 9 years ago
Before or After downloading Vicidial and GOautodial RPMS
Make sure you run following commands to get your MariaDB up and running.
systemctl start mariadb
systemctl enable mariadb
To check the status of MySQL/MariaDB:
systemctl status mariadb
Check the installation with the command client:
mysql
- *Skip these steps
Temporarily change your MySQL password to "vicidialnow":
mysqladmin password vicidialnow
If you already have a MySQL password:
mysqladmin password vicidialnow -p *
Directly jump to rpm installation but with sudo privileges
sudo rpm -ivh --nodeps vicidial-2.9.441a-140612.1628.2.go.noarch.rpm
sudo rpm -ivh --nodeps goautodial-ce-3.3-1406088000.noarch.rpm
sudo rpm -ivh --nodeps goautodial-ce-config-3.3-1.noarch.rpm
Then follow the rest of steps given in http://goautodial.org/projects/goautodialce/wiki/Centos7
following these steps I was able to successfully install GoAutoDial on CentOS 7
How ever I couldn't access GoAutodial UI but could Access ViciDial Interface using
Admin: http://$ip_address/vicidial/admin.php
Agent: http://$ip_address/agc/vicidial.php
While accessing GoAutodial it gives me HTTP 500 error. See if you can find a workaround for the same and update here, probably I'm missing something in httpd configurations.
RE: Followed the steps on from Scratch in Centos 7 - Steps are missing.
-
Added by Demian Biscocho almost 9 years ago
You might have missed a step or two. Particularly this one:
sed -i 's/AllowOverride None/AllowOverride All/' /etc/httpd/conf/httpd.conf
systemctl restart httpd
From: http://goautodial.org/projects/goautodialce/wiki/Centos7.
RE: Followed the steps on from Scratch in Centos 7 - Steps are missing.
-
Added by Tiago Canoas almost 9 years ago
I tried to install from scratch in centos 7 using the steps from the wiki, but its not working.
After install the rpm files, the databases are not created.
Will the rpm file create the database?
Or do I need to create by hand the databases first?
Best Regards,
Tiago Canoas
RE: Followed the steps on from Scratch in Centos 7 - Steps are missing.
-
Added by Demian Biscocho almost 9 years ago
The databases are automatically created by the RPM packages. You need to change the mysql admin password first to "vicidialnow".
Temporarily change your MySQL password to "vicidialnow":¶
mysqladmin password vicidialnow
If you already have a MySQL password:
mysqladmin password vicidialnow -p
Install the RPMS:¶
rpm -ivh --nodeps vicidial-2.9.441a-140612.1628.2.go.noarch.rpm rpm -ivh --nodeps goautodial-ce-3.3-1406088000.noarch.rpm rpm -ivh --nodeps goautodial-ce-config-3.3-1.noarch.rpm
RE: Followed the steps on from Scratch in Centos 7 - Steps are missing.
-
Added by Marius Sebastian almost 9 years ago
Got the same problem, i folow all the step. Try to reinstall RPMS but got error on installing some packages , because of dependency
RE: Followed the steps on from Scratch in Centos 7 - Steps are missing.
-
Added by srdjan sajin over 8 years ago
hello, can somebody help me install on centos 7 ? I have problem with mysql
RE: Followed the steps on from Scratch in Centos 7 - Steps are missing.
-
Added by srdjan sajin over 8 years ago
Now i have installed, but i cant activate SIP, cant register on netwotk
RE: Followed the steps on from Scratch in Centos 7 - Steps are missing.
-
Added by Tim Jung almost 8 years ago
Hi,
Can you please assist how did you install this.?
RE: Followed the steps on from Scratch in Centos 7 - Steps are missing.
-
Added by Tim Jung almost 8 years ago
I'm able to install this but facing issue in real time screen time. All agents ready time is displaying 120 minutes while is should be 00:00 sec. As well as AMD is not working as extension 8369 is already configured in campaign.
RE: Followed the steps on from Scratch in Centos 7 - Steps are missing.
-
Added by M. A Rody Candera over 6 years ago
Same with me, i wan never success Install Goautodial From Scratch CentOS 64bit (CentOS 7). I have follow how to "https://goautodial.org/projects/goautodialce/wiki/Centos7"
one of problem error i was found is:
===============================================================================
rpm -ivh --nodeps vicidial-2.9.441a-140612.1628.2.go.noarch.rpm
Preparing... ################################# [100%]
Updating / installing...
1:vicidial-2.9.441a-140612.1628.2.g################################# [100%]
Redirecting to /bin/systemctl start mysqld.service
Failed to start mysqld.service: Unit not found.
error reading information on service mysqld: No such file or directory
Redirecting to /bin/systemctl start httpd.service
Note: Forwarding request to 'systemctl enable httpd.service'.
Vicidial configuration not found. Installing data...
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Installing Vicidial...
Updating IP address...
CLI defined old server IP: 10.10.100.139
Previous astGUIclient configuration file found at: /etc/astguiclient.conf
Writing change to astguiclient.conf file: /etc/astguiclient.conf
STARTING DATABASE TABLES UPDATES PHASE...
DBI connect('asterisk:localhost:3306','cron',...) failed: Access denied for user 'cron''localhost' (using password: YES) at /usr/share/astguiclient/ADMIN_update_server_ip.pl line 389.
'localhost' (using password: YES) at /usr/share/astguiclient/ADMIN_update_server_ip.pl line 389.
Couldn't connect to database: Access denied for user 'cron'
----- USING LOCAL DATA FILES -----
DBI connect('asterisk:localhost:3306','cron',...) failed: Access denied for user 'cron''localhost' (using password: YES) at /usr/share/astguiclient/ADMIN_area_code_populate.pl line 158.
'localhost' (using password: YES) at /usr/share/astguiclient/ADMIN_area_code_populate.pl line 158.
Couldn't connect to database: Access denied for user 'cron'
warning: %post(vicidial-2.9.441a-140612.1628.2.go.noarch) scriptlet failed, exit status 255
===============================================================================
Note; I have set mysqladmin/root password to vicidialnow.
RE: Followed the steps on from Scratch in Centos 7 - Steps are missing.
-
Added by M. A Rody Candera over 6 years ago
i'm do not instal mariadb and try using mysql80, still fail installing.
[root@santos7 ~]# rpm -ivh --nodeps vicidial-2.9.441a-140612.1628.2.go.noarch.rpm
Preparing... ################################# [100%]
Updating / installing...
1:vicidial-2.9.441a-140612.1628.2.g################################# [100%]
Redirecting to /bin/systemctl start mysqld.service
Note: Forwarding request to 'systemctl enable mysqld.service'.
Redirecting to /bin/systemctl start httpd.service
Note: Forwarding request to 'systemctl enable httpd.service'.
Vicidial configuration not found. Installing data...
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Installing Vicidial...
Updating IP address...
CLI defined old server IP: 10.10.100.139
Previous astGUIclient configuration file found at: /etc/astguiclient.conf
Writing change to astguiclient.conf file: /etc/astguiclient.conf
STARTING DATABASE TABLES UPDATES PHASE...
DBI connect('asterisk:localhost:3306','cron',...) failed: Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory at /usr/share/astguiclient/ADMIN_update_server_ip.pl line 389.
Couldn't connect to database: Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory at /usr/share/astguiclient/ADMIN_update_server_ip.pl line 389.
----- USING LOCAL DATA FILES -----
DBI connect('asterisk:localhost:3306','cron',...) failed: Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory at /usr/share/astguiclient/ADMIN_area_code_populate.pl line 158.
Couldn't connect to database: Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory at /usr/share/astguiclient/ADMIN_area_code_populate.pl line 158.
warning: %post(vicidial-2.9.441a-140612.1628.2.go.noarch) scriptlet failed, exit status 255
RE: Followed the steps on from Scratch in Centos 7 - Steps are missing.
-
Added by M. A Rody Candera over 6 years ago
M. A Rody Candera wrote:
Same with me, i wan never success Install Goautodial From Scratch CentOS 64bit (CentOS 7). I have follow how to "https://goautodial.org/projects/goautodialce/wiki/Centos7"
one of problem error i was found is:
===============================================================================
[...]
Preparing... ################################# [100%]
Updating / installing...
1:vicidial-2.9.441a-140612.1628.2.g################################# [100%]
Redirecting to /bin/systemctl start mysqld.service
Failed to start mysqld.service: Unit not found.
error reading information on service mysqld: No such file or directory
Redirecting to /bin/systemctl start httpd.service
Note: Forwarding request to 'systemctl enable httpd.service'.
Vicidial configuration not found. Installing data...
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Installing Vicidial...
Updating IP address...
CLI defined old server IP: 10.10.100.139
Previous astGUIclient configuration file found at: /etc/astguiclient.conf
Writing change to astguiclient.conf file: /etc/astguiclient.confSTARTING DATABASE TABLES UPDATES PHASE...
DBI connect('asterisk:localhost:3306','cron',...) failed: Access denied for user 'cron''localhost' (using password: YES) at /usr/share/astguiclient/ADMIN_update_server_ip.pl line 389.
'localhost' (using password: YES) at /usr/share/astguiclient/ADMIN_update_server_ip.pl line 389.
Couldn't connect to database: Access denied for user 'cron'----- USING LOCAL DATA FILES -----
DBI connect('asterisk:localhost:3306','cron',...) failed: Access denied for user 'cron'
'localhost' (using password: YES) at /usr/share/astguiclient/ADMIN_area_code_populate.pl line 158.
'localhost' (using password: YES) at /usr/share/astguiclient/ADMIN_area_code_populate.pl line 158.
Couldn't connect to database: Access denied for user 'cron'
warning: %post(vicidial-2.9.441a-140612.1628.2.go.noarch) scriptlet failed, exit status 255 ===============================================================================Note; I have set mysqladmin/root password to vicidialnow.
I see, fail connect to mysql, db asterisk fail to created.
how do I modify vicidial-2.9.441a-140612.1628.2.go.noarch.rpm ?
RE: Followed the steps on from Scratch in Centos 7 - Steps are missing.
-
Added by Demian Biscocho over 6 years ago
You need to change the default MySQL root password to "vicidialnow" without the quotes.
Here's the command:
mysqladmin password vicidialnow -p
Enter your current password.
RE: Followed the steps on from Scratch in Centos 7 - Steps are missing.
-
Added by Rameez Amjad over 6 years ago
Is there any iso for installing goautodial 3.3 64 bit with centos 7 ????
RE: Followed the steps on from Scratch in Centos 7 - Steps are missing.
-
Added by Demian Biscocho over 6 years ago
Nope. It was based on CentOS 5.X. However, there is a HOWTO for installing version 3.3 on CentOS 7.X. It's pretty straightforward. Try it.
RE: Followed the steps on from Scratch in Centos 7 - Steps are missing.
-
Added by Demian Biscocho over 6 years ago
Download the GOautodial 4 ISO installer. It's available now (thought the "Getting Started Guide" to be posted soon). Details are here: https://goautodial.org/boards/20/topics/14072.