Project

General

Profile

Version 4 scratch install HOWTO help!

Added by Demian Biscocho over 5 years ago

Post all your v4 scratch install related issues and problems, solutions and fixes and etc here.

RTPEngine:

You need to install the following:

ngcp-rtpengine-kernel-6.4.0.0-1.el7.x86_64
ngcp-rtpengine-dkms-6.4.0.0-1.el7.noarch
dkms-2.6.1-1.el7.noarch

This should do the trick:

yum install ngcp-rtpengine-kernel ngcp-rtpengine-dkms dkms kernel-devel

Recompile the kernel module:

cd /usr/src/ngcp-rtpengine-6.4.0.0-1.el7/
make
make install

Restart RTPEngine:

systemctl restart ngcp-rtpengine

Replies (43)

RE: Version 4 scratch install HOWTO help! - Added by Guilherme Bizzani over 5 years ago

Good Morning Demian,
As I said in other topics, my Telephony tab now have Inbound submenu, but only it, I think it's missing some menus, right?
Also I cannot create Ingroup, the form's submit return 'null' as stated in the following screenshot:
http://prntscr.com/komm1n

And for RTPEngine, I still cannot get arround the error "ERR: FAILED TO CREATE KERNEL TABLE 0 (No such file or directory), KERNEL FORWARDING DISABLED"
What I noticed is, by doing your steps in this topic, when I type "make install" it returns me an "make: Nothing to be done for `install'."
And my Makefile has it's install tag empty.

Any news about the ISO for the 4.0 version?

RE: Version 4 scratch install HOWTO help! - Added by Demian Biscocho over 5 years ago

Looks like your goadmin user doesn't have the rights or access to the missing menus. Can you post the output of the following:

MariaDB [goautodial]> select * from user_access_group\G;

It should be similar to below:

MariaDB [goautodial]> select * from user_access_group\G; 
*************************** 1. row ***************************
               id: 1
       user_group: ADMIN
      permissions: {"dashboard":{"dashboard_display":"Y"},"user":{"user_create":"C","user_read":"R","user_update":"U","user_delete":"D"},"campaign":{"campaign_create":"C","campaign_read":"R","campaign_update":"U","campaign_delete":"D"},"disposition":{"disposition_create":"C","disposition_update":"U","disposition_delete":"D"},"pausecodes":{"pausecodes_create":"C","pausecodes_read":"R","pausecodes_update":"U","pausecodes_delete":"D"},"hotkeys":{"hotkeys_create":"C","hotkeys_read":"R","hotkeys_delete":"D"},"list":{"list_create":"C","list_read":"R","list_update":"U","list_delete":"D","list_upload":"C"},"customfields":{"customfields_create":"C","customfields_read":"R","customfields_update":"U","customfields_delete":"D"},"loadleads":{"loadleads_read":"R"},"script":{"script_create":"C","script_read":"R","script_update":"U","script_delete":"D"},"inbound":{"inbound_create":"C","inbound_read":"R","inbound_update":"U","inbound_delete":"D"},"voicefiles":{"voicefiles_upload":"C","voicefiles_delete":"D"},"reportsanalytics":{"reportsanalytics_display":"Y"},"recordings":{"recordings_display":"Y"},"support":{"support_display":"Y"},"multi-tenant":{"tenant_create":"Y","tenant_display":"Y","tenant_update":"Y","tenant_delete":"Y","tenant_logs":"Y","tenant_calltimes":"Y","tenant_phones":"Y","tenant_voicemails":"Y"}}
      group_level: 9
      date_create: 2013-06-05 11:42:17
allowed_campaigns: NULL
    group_list_id: NULL
*************************** 2. row ***************************
               id: 2
       user_group: AGENTS
      permissions: {"dashboard":{"dashboard_display":"N"},"user":{"user_create":"N","user_read":"N","user_update":"N","user_delete":"N"},"campaign":{"campaign_create":"N","campaign_read":"N","campaign_update":"N","campaign_delete":"N"},"disposition":{"disposition_create":"N","disposition_update":"N","disposition_delete":"N"},"pausecodes":{"pausecodes_create":"N","pausecodes_read":"N","pausecodes_update":"N","pausecodes_delete":"N"},"hotkeys":{"hotkeys_create":"N","hotkeys_read":"N","hotkeys_delete":"N"},"list":{"list_create":"N","list_read":"N","list_update":"N","list_delete":"N","list_upload":"N"},"customfields":{"customfields_create":"N","customfields_read":"N","customfields_update":"N","customfields_delete":"N"},"loadleads":{"loadleads_read":"N"},"script":{"script_create":"N","script_read":"N","script_update":"N","script_delete":"N"},"inbound":{"inbound_create":"N","inbound_read":"N","inbound_update":"N","inbound_delete":"N"},"voicefiles":{"voicefiles_upload":"N","voicefiles_delete":"N"},"reportsanalytics":{"reportsanalytics_display":"N"},"recordings":{"recordings_display":"N"},"support":{"support_display":"N"},"multi-tenant":{"tenant_create":"N","tenant_display":"N","tenant_update":"N","tenant_delete":"N","tenant_logs":"N","tenant_calltimes":"N","tenant_phones":"N","tenant_voicemails":"N"}}
      group_level: 1
      date_create: 2013-06-05 11:49:21
allowed_campaigns: NULL
    group_list_id: NULL
*************************** 3. row ***************************
               id: 3
       user_group: SUPERVISOR
      permissions: {"dashboard":{"dashboard_display":"Y"},"user":{"user_create":"C","user_read":"R","user_update":"N","user_delete":"N"},"campaign":{"campaign_create":"N","campaign_read":"R","campaign_update":"U","campaign_delete":"N"},"disposition":{"disposition_create":"C","disposition_update":"U","disposition_delete":"N"},"pausecodes":{"pausecodes_create":"C","pausecodes_read":"R","pausecodes_update":"U","pausecodes_delete":"N"},"hotkeys":{"hotkeys_create":"C","hotkeys_read":"R","hotkeys_delete":"N"},"list":{"list_create":"C","list_read":"R","list_update":"U","list_delete":"N","list_upload":"C"},"customfields":{"customfields_create":"C","customfields_read":"R","customfields_update":"U","customfields_delete":"N"},"script":{"script_create":"C","script_read":"R","script_update":"U","script_delete":"N"},"inbound":{"inbound_create":"C","inbound_read":"R","inbound_update":"U","inbound_delete":"N"},"ivr":{"ivr_create":"C","ivr_read":"R","ivr_update":"U","ivr_delete":"N"},"did":{"did_create":"C","did_read":"R","did_update":"U","did_delete":"N"},"voicefiles":{"voicefiles_upload":"C","voicefiles_play":"Y","voicefiles_download":"Y"},"moh":{"moh_create":"C","moh_read":"R","moh_update":"U","moh_delete":"N"},"reportsanalytics":{"reportsanalytics_statistical_display":"Y","reportsanalytics_agent_time_display":"Y","reportsanalytics_agent_performance_display":"Y","reportsanalytics_dial_status_display":"Y","reportsanalytics_agent_sales_display":"Y","reportsanalytics_sales_tracker_display":"Y","reportsanalytics_inbound_call_display":"Y","reportsanalytics_export_call_display":"Y"},"recordings":{"recordings_display":"Y"},"support":{"support_display":"Y"},"multi-tenant":{"tenant_create":"N","tenant_display":"N","tenant_update":"N","tenant_delete":"N","tenant_logs":"N","tenant_calltimes":"N","tenant_phones":"N","tenant_voicemails":"N"},"chat":{"chat_create":"C","chat_read":"R","chat_update":"U","chat_delete":"D"},"osticket":{"osticket_create":"C","osticket_read":"R","osticket_update":"U","osticket_delete":"D"}}
      group_level: 8
      date_create: 2018-08-12 05:24:38
allowed_campaigns: NULL
    group_list_id: NULL
*************************** 4. row ***************************
               id: 4
       user_group: TENANT
      permissions: {"dashboard":{"dashboard_display":"Y"},"user":{"user_create":"C","user_read":"R","user_update":"N","user_delete":"N"},"campaign":{"campaign_create":"N","campaign_read":"R","campaign_update":"U","campaign_delete":"N"},"disposition":{"disposition_create":"C","disposition_update":"U","disposition_delete":"N"},"pausecodes":{"pausecodes_create":"C","pausecodes_read":"R","pausecodes_update":"U","pausecodes_delete":"N"},"hotkeys":{"hotkeys_create":"C","hotkeys_read":"R","hotkeys_delete":"N"},"list":{"list_create":"C","list_read":"R","list_update":"U","list_delete":"N","list_upload":"C"},"customfields":{"customfields_create":"C","customfields_read":"R","customfields_update":"U","customfields_delete":"N"},"script":{"script_create":"C","script_read":"R","script_update":"U","script_delete":"N"},"inbound":{"inbound_create":"C","inbound_read":"R","inbound_update":"U","inbound_delete":"N"},"ivr":{"ivr_create":"C","ivr_read":"R","ivr_update":"U","ivr_delete":"N"},"did":{"did_create":"C","did_read":"R","did_update":"U","did_delete":"N"},"voicefiles":{"voicefiles_upload":"C","voicefiles_play":"Y","voicefiles_download":"Y"},"moh":{"moh_create":"C","moh_read":"R","moh_update":"U","moh_delete":"N"},"reportsanalytics":{"reportsanalytics_statistical_display":"Y","reportsanalytics_agent_time_display":"Y","reportsanalytics_agent_performance_display":"Y","reportsanalytics_dial_status_display":"Y","reportsanalytics_agent_sales_display":"Y","reportsanalytics_sales_tracker_display":"Y","reportsanalytics_inbound_call_display":"Y","reportsanalytics_export_call_display":"Y"},"recordings":{"recordings_display":"Y"},"support":{"support_display":"Y"},"multi-tenant":{"tenant_create":"N","tenant_display":"N","tenant_update":"N","tenant_delete":"N","tenant_logs":"N","tenant_calltimes":"N","tenant_phones":"N","tenant_voicemails":"N"},"chat":{"chat_create":"C","chat_read":"R","chat_update":"U","chat_delete":"D"},"osticket":{"osticket_create":"C","osticket_read":"R","osticket_update":"U","osticket_delete":"D"}}
      group_level: 8
      date_create: 2018-08-12 05:25:07
allowed_campaigns: NULL
    group_list_id: NULL

For the RTPEngine, can you post the output of:

rpm -qa | grep ngcp-rtpengine

Should be:

ngcp-rtpengine-6.4.0.0-1.el7.x86_64
ngcp-rtpengine-dkms-6.4.0.0-1.el7.noarch
ngcp-rtpengine-kernel-6.4.0.0-1.el7.x86_64

Also make sure you have installed the kernel-devel RPM package (yum install kernel-devel).

No news yet on the ISO for v4.0.

RE: Version 4 scratch install HOWTO help! - Added by C L over 5 years ago

Hi,
When following the v4 scratch install I happen to have errors for these lines:

INSERT INTO vicidial_users(user,pass_hash,full_name,user_level,user_group,active) values('goAPI','EORxUHT6Ju2kLOOB4g3X3GxJcQ9RGGS','GOautodial API User','9','ADMIN','N');
The error message: Field 'pass' doesn't have a default value
AND:

INSERT INTO users(userid,name,fullname,avatar,role,status,user_group,phone) VALUES;
The error message : Field 'password_hash' doesn't have a default value

Please help

RE: Version 4 scratch install HOWTO help! - Added by Demian Biscocho over 5 years ago

Try this instead:

use asterisk;
INSERT INTO vicidial_users(user,pass,pass_hash,full_name,user_level,user_group,active) values('goAPI',' ','EORxUHT6Ju2kLOOB4g3X3GxJcQ9RGGS','GOautodial API User','9','ADMIN','N');
user goautodial;
INSERT INTO users(userid,name,fullname,password_hash,avatar,role,status,user_group,phone) VALUES('1416','goadmin','Admin User',' ',' ','9','1','ADMIN','7798306534');

RE: Version 4 scratch install HOWTO help! - Added by Leigh Johnston over 5 years ago

Demian Biscocho wrote:

Looks like your goadmin user doesn't have the rights or access to the missing menus. Can you post the output of the following:

[...]

It should be similar to below:

[...]

For the RTPEngine, can you post the output of:

[...]

Should be:

[...]

Also make sure you have installed the kernel-devel RPM package (yum install kernel-devel).

No news yet on the ISO for v4.0.

I am having the same rtcengine issue.
[root@ausEfuture ngcp-rtpengine-6.4.0.0-1.el7]# cd /usr/src/ngcp-rtpengine-6.4.0.0-1.el7/
[root@ausEfuture ngcp-rtpengine-6.4.0.0-1.el7]# make
Makefile:3: lib/lib.Makefile: No such file or directory
make -C daemon lib/lib.Makefile
make: * daemon: No such file or directory. Stop.
make: *
[lib/lib.Makefile] Error 2
[root@ausEfuture ngcp-rtpengine-6.4.0.0-1.el7]# rpm -qa | grep ngcp-rtpengine
ngcp-rtpengine-dkms-6.4.0.0-1.el7.noarch
ngcp-rtpengine-6.4.0.0-1.el7.x86_64
ngcp-rtpengine-kernel-6.4.0.0-1.el7.x86_64
[root@ausEfuture ngcp-rtpengine-6.4.0.0-1.el7]# yum install kernel-devel
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile * base: centos.mirror.serversaustralia.com.au * epel: fedora.melbourneitmirror.net * extras: centos.melbourneitmirror.net * updates: centos.mirror.serversaustralia.com.au
Package kernel-devel-3.10.0-957.1.3.el7.x86_64 already installed and latest version
Nothing to do
[root@ausEfuture ngcp-rtpengine-6.4.0.0-1.el7]#

RE: Version 4 scratch install HOWTO help! - Added by Steve Turner about 5 years ago

As per the new instructions, there is a typo and says no package available for kamailio-tls-5.0.7-3.el7.centos.x86_64.

Also, says no package available for perl-Sys-RunAlone. Was able to download rpm from another source and install.

During install shows Kernel Headers error during ngcp (see attached photo)

RE: Version 4 scratch install HOWTO help! - Added by Steve Turner about 5 years ago

Steve Turner wrote:

As per the new instructions, there is a typo and says no package available for kamailio-tls-5.0.7-3.el7.centos.x86_64.

Also, says no package available for perl-Sys-RunAlone. Was able to download rpm from another source and install.

During install shows Kernel Headers error during ngcp (see attached photo)

After complete install, root mails shows
"install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at (eval 3) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Proxy, Sponge."

"Can't locate Net/Telnet.pm in @INC"
"Can't find lame binary! Exiting..."

FIXED
yum install perl-DBD-mysql
yum install perl-Net-Telnet
yum install lame

No access to webpage and asterisk does not start on reboot, needs to be manually started.

RE: Version 4 scratch install HOWTO help! - Added by Steve Turner about 5 years ago

Ok, had some free time to sit and troubleshoot my installation more.

Needed to yum install screen and cpan, then run the cpan commands from Goautodial V3 to install the perl scripts. Not sure if cpan was installed from the beginning if this would solve the issue or not, i will test it. After installing screen and the perl commands, asterisk starts normal with only a few folder permission errors to be fixed.

Also, in the steps for scratch install, need to be sure to start mysql cause if not running the install will not copy over the sql files.

perl-Sys-Alone rpm install:
wget https://rpm.mag-sol.com/Centos/7/x86_64/perl-Sys-RunAlone-0.12-1.el7.centos.noarch.rpm
rpm -i perl-Sys-RunAlone-0.12-1.el7.centos.noarch.rpm

Still have these issues in systemctl status asterisk:

Jan 23 13:18:19 dialer.ngtechnologies.net asterisk8034: [Jan 23 13:18:19] WARNING8034: chan_dahdi.c:19034 process_dahdi: Ignoring any changes to 'hasmanager' (on reload) at line 47.
Jan 23 13:18:19 dialer.ngtechnologies.net asterisk8034: [Jan 23 13:18:19] WARNING8034: db.c:465 ast_db_deltree: Couldn't execute stmt: SQL logic error or missing database
Jan 23 13:18:19 dialer.ngtechnologies.net asterisk8034: [Jan 23 13:18:19] WARNING8034: channel.c:570 ast_channel_register: Already have a handler for type 'MulticastRTP'
Jan 23 13:18:19 dialer.ngtechnologies.net asterisk8034: [Jan 23 13:18:19] ERROR8034: chan_rtp.c:396 load_module: Unable to register channel class 'MulticastRTP'
Jan 23 13:18:19 dialer.ngtechnologies.net asterisk8034: [Jan 23 13:18:19] NOTICE8034: confbridge/conf_config_parser.c:2095 verify_default_profiles: Adding default_menu men..._confbridge
Jan 23 13:18:19 dialer.ngtechnologies.net asterisk8034: [Jan 23 13:18:19] NOTICE8034: cel_custom.c:97 load_config: No mappings found in cel_custom.conf. Not logging CEL to custom CSVs.
Jan 23 13:18:19 dialer.ngtechnologies.net asterisk8034: [Jan 23 13:18:19] ERROR8034: pbx_dundi.c:5035 load_module: Unable to bind to 0.0.0.0 port 4520: Address already in use
Jan 23 13:18:19 dialer.ngtechnologies.net asterisk8034: [Jan 23 13:18:19] ERROR8034: codec_dahdi.c:820 find_transcoders: Failed to open /dev/dahdi/transcode: No such file or directory

And these errors on asterisk CLI reload:
[Jan 23 13:19:10] WARNING8286: res_phoneprov.c:1231 get_defaults: Unable to find a valid server address or name.
[Jan 23 13:19:10] ERROR8286: ari/config.c:312 process_config: No configured users for ARI

Will make a fresh install with the added requirements to find out if any more of the errors disappear

RE: Version 4 scratch install HOWTO help! - Added by Dan Cavallo about 5 years ago

Hello - I followed the guide exactly on a CentOS7 machine and I received the following errors during install:

chmod: cannot access ‘/etc/pki/tls/private/localhost.key’: No such file or directory
chmod: cannot access ‘/etc/pki/tls/certs/localhost.crt’: No such file or directory

The rest worked just fine. At the end when I tried to access the GoAutodial login page by typing https://serverIP I am getting a connection refused. I noticed that there were two other recent posts with this issue. Are there any suggestions on how to troubleshoot?

Any guidance would be much appreciated.

RE: Version 4 scratch install HOWTO help! - Added by Demian Biscocho about 5 years ago

We just updated the scratch install HOWTO. Can you run the following commands:

yum install screen mod_ssl
chmod 644 /etc/pki/tls/private/localhost.key
chmod 644 /etc/pki/tls/certs/localhost.crt

This will install the required local TLS/SSL certificates.

RE: Version 4 scratch install HOWTO help! - Added by Dan Cavallo about 5 years ago

Hi Demian - thanks very much for your help. I ran the above commands and restarted first Apache and then the server itself just in case.

I am getting a different error now when trying to get into the main login page: "currently unable to handle this request. HTTP ERROR 500"

I ran all the install commands from the updated directions just in case, and looks like I was just missing a mail service which installed. Still no luck getting to the log-in page. What would you suggest now to troubleshoot further?

Thanks again for helping me sort through this.

RE: Version 4 scratch install HOWTO help! - Added by Demian Biscocho about 5 years ago

Have you restarted your server? I just tested the install from scratch HOWTO and can get to the login page without issues.

Can you post the output of the following:

systemctl status httpd
rpm -qa | grep ssl

RE: Version 4 scratch install HOWTO help! - Added by Dan Cavallo about 5 years ago

Here's the output of the first command:
sudo systemctl status httpd
? httpd.service - The Apache HTTP Server
Loaded: loaded (/usr/lib/systemd/system/httpd.service; enabled; vendor preset : disabled)
Active: active (running) since Mon 2019-02-25 21:08:20 UTC; 16h ago
Docs: man:httpd(8)
man:apachectl(8)
Process: 4773 ExecStop=/bin/kill -WINCH ${MAINPID} (code=exited, status=0/SUCC ESS)
Main PID: 4776 (httpd)
Status: "Total requests: 10; Current requests/sec: 0; Current traffic: 0 B/ sec"
CGroup: /system.slice/httpd.service
+-4776 /usr/sbin/httpd -DFOREGROUND
+-4777 /usr/sbin/httpd -DFOREGROUND
+-4778 /usr/sbin/httpd -DFOREGROUND
+-4779 /usr/sbin/httpd -DFOREGROUND
+-4780 /usr/sbin/httpd -DFOREGROUND
+-4781 /usr/sbin/httpd -DFOREGROUND
+-4782 /usr/sbin/httpd -DFOREGROUND

Here's the second one:

sudo rpm -qa | grep ssl
openssl-libs-1.0.2k-16.el7.x86_64
python-backports-ssl_match_hostname-3.5.0.1-1.el7.noarch
openssl-1.0.2k-16.el7.x86_64
mod_ssl-2.4.6-88.el7.centos.x86_64

RE: Version 4 scratch install HOWTO help! - Added by Dan Cavallo about 5 years ago

I also tried a fresh install using your updated directions and still resulted in the same HTTP 500 error. I followed your new directions exactly with minimal errors.

However, i started checking the status of a few of the services and noticed mariadb and kamailio were not running. Neither is asterisk. When I try to start the mariadb and kamailio services manually I receive the errors at the bottom of this email.

Thanks again for your help - I followed the instructions exactly so hopefully this will be helpful for others who are having similar issues.

RE: Version 4 scratch install HOWTO help! - Added by Dan Cavallo about 5 years ago

kamailio.service - Kamailio (OpenSER) - the Open Source SIP Server
Loaded: loaded (/usr/lib/systemd/system/kamailio.service; enabled; vendor preset: disabled)
Active: failed (Result: start-limit) since Tue 2019-02-26 15:28:55 UTC; 3s ago
Process: 29561 ExecStart=/usr/sbin/kamailio -DD -P /var/run/kamailio/kamailio.pid -f $CFGFILE -m $SHM_MEMORY -M $PKG_MEMORY (code=exited, status=255)
Main PID: 29561 (code=exited, status=255)

Feb 26 15:28:55 ip-172-31-59-120.ec2.internal systemd1: kamailio.service: main process exited, code=exited, status=255/n/a
Feb 26 15:28:55 ip-172-31-59-120.ec2.internal systemd1: Unit kamailio.service entered failed state.
Feb 26 15:28:55 ip-172-31-59-120.ec2.internal systemd1: kamailio.service failed.
Feb 26 15:28:55 ip-172-31-59-120.ec2.internal systemd1: kamailio.service holdoff time over, scheduling restart.
Feb 26 15:28:55 ip-172-31-59-120.ec2.internal systemd1: Stopped Kamailio (OpenSER) - the Open Source SIP Server.
Feb 26 15:28:55 ip-172-31-59-120.ec2.internal systemd1: start request repeated too quickly for kamailio.service
Feb 26 15:28:55 ip-172-31-59-120.ec2.internal systemd1: Failed to start Kamailio (OpenSER) - the Open Source SIP Server.
Feb 26 15:28:55 ip-172-31-59-120.ec2.internal systemd1: Unit kamailio.service entered failed state.
Feb 26 15:28:55 ip-172-31-59-120.ec2.internal systemd1: kamailio.service failed.

RE: Version 4 scratch install HOWTO help! - Added by Dan Cavallo about 5 years ago

Feb 26 15:28:28 ip-172-31-59-120.ec2.internal systemd1: Starting MariaDB 10.1.36 database server...
Feb 26 15:28:30 ip-172-31-59-120.ec2.internal mysqld29532: 2019-02-26 15:28:30 140514046814464 [Note] Using unique option prefix 'max_heap_table' is error-prone and can break...' instead.
Feb 26 15:28:30 ip-172-31-59-120.ec2.internal mysqld29532: 2019-02-26 15:28:30 140514046814464 [Note] /usr/sbin/mysqld (mysqld 10.1.36-MariaDB) starting as process 29532 ...
Feb 26 15:28:30 ip-172-31-59-120.ec2.internal systemd1: mariadb.service: main process exited, code=exited, status=1/FAILURE
Feb 26 15:28:30 ip-172-31-59-120.ec2.internal systemd1: Failed to start MariaDB 10.1.36 database server.
Feb 26 15:28:30 ip-172-31-59-120.ec2.internal systemd1: Unit mariadb.service entered failed state.
Feb 26 15:28:30 ip-172-31-59-120.ec2.internal systemd1: mariadb.service failed.

RE: Version 4 scratch install HOWTO help! - Added by Jorge Cornejo about 5 years ago

Installing dkms-2.6.1-1.el7.noarch.rpm with CentOS 7 gives an error:

warning: /var/cache/yum/x86_64/7/epel/packages/dkms-2.6.1-1.el7.noarch.rpm: Header V3 RSA/SHA256 Signature, key ID 352c64e5: NOKEY
Public key for dkms-2.6.1-1.el7.noarch.rpm is not installed

Any idea how to solve?

RE: Version 4 scratch install HOWTO help! - Added by Demian Biscocho about 5 years ago

Dan Cavallo wrote:

Here's the output of the first command:
sudo systemctl status httpd
? httpd.service - The Apache HTTP Server
Loaded: loaded (/usr/lib/systemd/system/httpd.service; enabled; vendor preset : disabled)
Active: active (running) since Mon 2019-02-25 21:08:20 UTC; 16h ago
Docs: man:httpd(8)
man:apachectl(8)
Process: 4773 ExecStop=/bin/kill -WINCH ${MAINPID} (code=exited, status=0/SUCC ESS)
Main PID: 4776 (httpd)
Status: "Total requests: 10; Current requests/sec: 0; Current traffic: 0 B/ sec"
CGroup: /system.slice/httpd.service
-4776 /usr/sbin/httpd -DFOREGROUND
-4777 /usr/sbin/httpd -DFOREGROUND
-4778 /usr/sbin/httpd -DFOREGROUND
-4779 /usr/sbin/httpd -DFOREGROUND
-4780 /usr/sbin/httpd -DFOREGROUND
-4781 /usr/sbin/httpd -DFOREGROUND
+-4782 /usr/sbin/httpd -DFOREGROUND

Here's the second one:

sudo rpm -qa | grep ssl
openssl-libs-1.0.2k-16.el7.x86_64
python-backports-ssl_match_hostname-3.5.0.1-1.el7.noarch
openssl-1.0.2k-16.el7.x86_64
mod_ssl-2.4.6-88.el7.centos.x86_64

Do you have a firewall blocking your web server? I can't really recreate the issues you're having. I followed the install from scratch HOWTO down to the letter and my installation was good.

RE: Version 4 scratch install HOWTO help! - Added by Dan Cavallo about 5 years ago

Hi Demian - I tried the updated install instructions as of 3/2 and I am still getting the same errors. We don't have a firewall, but the install breaks a lot of the services. For example, Maria DB is showing as not running, and I cannot get it to start.

Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.

Kamailio also does not start when the server restarted.

I've been using the CentOS 7 install from AWS:
https://aws.amazon.com/marketplace/pp/B00O7WM7QW/ref=mke_ste_catgtm_freetlp

Would that make a difference? Thoughts?

RE: Version 4 scratch install HOWTO help! - Added by Jorge Cornejo about 5 years ago

I think you are facing the same error I had, missing DBs. By some reason the install script doesn't create them, even after setting root password to "vicidialnow".
I created them manually at the MariaBD and began to work.

RE: Version 4 scratch install HOWTO help! - Added by Dan Cavallo about 5 years ago

Hi Jorge - thanks for your reply. But even if the DBs are missing wouldn't the service start?

Would you be able to post the commands you ran so I can test them on our server?

Thanks very much for your help.

RE: Version 4 scratch install HOWTO help! - Added by Demian Biscocho about 5 years ago

I would recommend installing this on a local virtual machine first like VirtualBox or VMWare before proceeding to AWS. By default, the MariaDB root password is empty on CentOS. If you have changed this, you need to modify the installer script to include your password.

RE: Version 4 scratch install HOWTO help! - Added by Dan Cavallo about 5 years ago

Demian Biscocho wrote:

I would recommend installing this on a local virtual machine first like VirtualBox or VMWare before proceeding to AWS. By default, the MariaDB root password is empty on CentOS. If you have changed this, you need to modify the installer script to include your password.

Hi Demian,

Got it - are there IP related configurations that would be done once imported to AWS? I'm assuming the private IP of the machine would change, and thought the installer used that as an input.

Thanks again for your expertise!

RE: Version 4 scratch install HOWTO help! - Added by Jorge Cornejo about 5 years ago

I installed again from scratch following last Wiki Update on the Howto, but before that I did a hostname modification to be sure no problems will appear with that, yet some missing parameters were missing at the kamailio cfg file.
After the new install, DBs were populated and services began to start correctly, and no, without a DB won't start as you are not installing the services from scratch, they are already pre-configured at some point and need some information to start.
So, DB is a must.

If these steps are not done, agent WebRTC register won't work

nano /etc/kamailio/kamctlrc
SIP_DOMAIN=subdomain.domain.com

nano /etc/kamailio/kamailio.cfg
/* add local domain aliases */
#alias="172.31.14.56" 
alias="subdomain.domain.com" 

# kamctl restart

Now I am stuck at RTP part...due a fail at FastAGI
Still working on that part

(1-25/43) Go to top