GOautodial Open Source Omni-channel Contact Center Suite

Have you upgrade the Asterisk database schema first by running the following as specified in the HOWTO:

cd /usr/src/astguiclient/trunk/extras
mysql -f -p asterisk < upgrade_2.10.sql
mysql -f -p asterisk < upgrade_2.12.sql
mysql -f -p asterisk < upgrade_2.14.sql

Hello Demian, Thanks for quick response yes I already did the upgrade as part of the given steps.

What's the MariaDB version you're using?

Hi Robert,

I am using the below commands to execute the user in the database.

INSERT INTO vicidial_users (user,pass,user_group,full_name,user_level,phone_login,phone_pass,agentonly_callbacks,agentcall_manual,active,vdc_agent_api_access,pass_hash,agent_choose_ingroups,vicidial_recording,vicidial_transfers,closer_default_blended,scheduled_callbacks) values('goadmin','','ADMIN','Admin User','9','7798306534','','1','1','Y','1','h0CAwQ/of1y0YFKgut1hVcqNl1SMSNu','1','1','1','1','1');

INSERT INTO phones (extension,dialplan_number,voicemail_id,phone_ip,computer_ip,server_ip,login,pass,status,active,phone_type,fullname,company,picture,protocol,local_gmt,outbound_cid,template_id,user_group,conf_secret,messages,old_messages) values('7798306534','99997798306534','7798306534','','','127.0.0.1','7798306534','','ACTIVE','Y','','Admin User','ADMIN','','EXTERNAL','-5','0000000000','--NONE--','ADMIN','','0','0');

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

use kamailio;
INSERT INTO subscriber(username,domain,password,ha1,ha1b) values('7798306534','vaglxc01.goautodial.com','','0f4c00d613252a5d0991608b77bc1541','053e5769a9ea23d954b4c821582984f3');

Hello Demian ,
Here is the details of my server

Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.0.30
Database client version: libmysql - 10.1.34-MariaDB

Hey Amit i tried to update as per the above details but its when i access the server i see nothing under Telephony drop down as well what ever changes i try to do on User groups or server settings or anything i get following error as given in attachment. Kindly let me know what am i missing

Can you post the output of the following:

MariaDB [asterisk]> select user,user_group,pass,pass_hash from vicidial_users;

MariaDB [asterisk]> select user_group, group_name from vicidial_user_groups;

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

Hello Demian Biscocho Biscocho.

Sorry for intruding, but since I'm having this same issue here are my queries about your last comment:

https://pastebin.com/d9agMkGN

Thanks in advance.

Can you try the SQL queries again? The HOWTO has been updated with the correct SQL queries.

Let me say that we had some progress!

http://prntscr.com/koeegt

The Telephony menu now has "Inbounds" submenu inside. I'm also copying my queries again as you asked:

https://pastebin.com/9kjJ8L4U

But as I said in the other topic, I'm still having problems with RTP engine. Tomorrow I'll try to follow the tutorial on "https://www.voztovoice.org/?q=node/1621" and update here how's it going.

Thanks for the updates Demian Biscocho Biscocho, let me know if I can help providing more info.

I suggest you to create a fixed topic about the install of the version 4.0, since many topics are being opened for the same thing.

Guilherme Bizzani wrote:

Let me say that we had some progress!

http://prntscr.com/koeegt

The Telephony menu now has "Inbounds" submenu inside. I'm also copying my queries again as you asked:

https://pastebin.com/9kjJ8L4U

But as I said in the other topic, I'm still having problems with RTP engine. Tomorrow I'll try to follow the tutorial on "https://www.voztovoice.org/?q=node/1621" and update here how's it going.

Thanks for the updates Demian Biscocho Biscocho, let me know if I can help providing more info.

I suggest you to create a fixed topic about the install of the version 4.0, since many topics are being opened for the same thing.

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