Installation on CentOS7
Added by kaz okam over 6 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 6 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 6 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 6 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:
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 6 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 6 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 6 years ago
Let's consolidate everything version 4 scratch install HOWTO here: https://goautodial.org/boards/3/topics/13811.