Project

General

Profile

Installation on CentOS7

Added by kaz okam over 5 years ago

I have followed all the instruction from https://goautodial.org/projects/goautodialce/wiki/Version_4_How_To_Install_Goautodial_From_Scratch_using_CentOS_7X.

In the step of ' Create "goadmin" Admin user account '

use goautodial;
INSERT INTO users(userid,name,fullname,avatar,role,status,user_group,phone) VALUES('1416','goadmin','Admin User','','9','1','ADMIN','7798306534');

running that code gave me an Error which says no table found.

And I found my database structures is different than Instruction does.
Did I miss some steps? or Database has updated?
---------------------- | Tables_in_goautodial |
---------------------- | attachments | | clients_1 | | clients_2 | | customer_types | | events | | go_action_logs | | go_agent_sessions | | go_firewall_blocklist | | go_firewall_interfaces | | go_firewall_rules | | go_firewall_whitelist | | go_last_login | | go_login_type | | go_notifications | | go_recording_access | | go_remember | | go_server_settings | | go_sessions | | go_sysbackup_access | | go_users | | go_widget_position | | justgovoip_sippy_info | | user_access_group |
----------------------
------------------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra |
------------------------------+------+-----+---------+----------------+ | user_id | int(20) unsigned | NO | PRI | NULL | auto_increment | | user_name | varchar(20) | NO | | NULL | | | user_pass | varchar(100) | NO | | NULL | | | user_fname | varchar(50) | YES | | NULL | | | user_lname | varchar(50) | YES | | NULL | | | user_mname | varchar(50) | YES | | NULL | | | user_email | varchar(50) | YES | | NULL | | | user_level | int(1) | YES | | 1 | | | user_group | varchar(50) | YES | | Users | | | user_enabled | enum('N','Y') | YES | | Y | |
------------------------------+------+-----+---------+----------------+

Also, When I run "systemctl enable ngcp-rtpengine",
it gave me an Error "No such file or directory".

I appreciate your help, and sorry for my bad English.


Replies (6)

RE: Installation on CentOS7 - Added by Demian Biscocho over 5 years ago

Have you installed version 3.3 first? You need to have an existing GOautodial v3.X system in order to upgrade to v4.

RE: Installation on CentOS7 - Added by kaz okam over 5 years ago

Hi, Demian.

If the following link is the one to install version 3.x, my answer would be yes.
https://goautodial.org/projects/goautodialce/wiki/Centos7

RE: Installation on CentOS7 - Added by Guilherme Bizzani over 5 years ago

I think the problem happens before this line of the tutorial.
When you download this file,

wget https://downloads2.goautodial.org/files/version4/goautodial.sql

and try to create the database "create database goautodial" it says that the database already exists, and finally when you try to type the following:

mysql -p goautodial < /root/goautodial.sql

It'll find an error in line 141~ saying that a table already exists, then it will stop it's execution.
I modified this file (goautodial.sql), by placing a "DROP TABLE IF EXISTS `table`;" before each "CREATE TABLE".
if you want you can get mine from this link:

https://pastebin.com/L4Rd0kgG

Also, before trying to "recompile" the RTP Engine you will have to install the kernel-devel, otherwise you will get an error when trying to "make" in the rtp folder:

yum install kernel-devel

RE: Installation on CentOS7 - Added by Guilherme Bizzani over 5 years ago

but even with kernel, making a "make" inside the rtp folder, I'm still getting a

ERR: FAILED TO CREATE KERNEL TABLE 0 (No such file or directory), KERNEL FORWARDING DISABLED

when trying to "systemctl start ngcp-rtpengine".

:/

RE: Installation on CentOS7 - Added by kaz okam over 5 years ago

Thank you, Guilherme.

Your SQL file really helped me:)

I just installed kernel-devel and tried to recompile, but I still get an error like below.

[root@localhost ~]# cd /usr/src/ngcp-rtpengine-6.4.0.0-1.el7/
bash: cd: /usr/src/ngcp-rtpengine-6.4.0.0-1.el7/: No such file or directory

RE: Installation on CentOS7 - Added by Demian Biscocho over 5 years ago

Let's consolidate everything version 4 scratch install HOWTO here: https://goautodial.org/boards/3/topics/13811.

    (1-6/6)
    Go to top