Project

General

Profile

Cannot Login || Goautodial v4.0

Added by Amit Iyer over 5 years ago

Hello,

I have installed Goautodial via the wiki provided and followed all the instructions correctly, i even have a domain assigned. But after the installation i cannot login to the portal. i am receiving an error "Invalid login or password. Please try again"


Replies (38)

RE: Cannot Login || Goautodial v4.0 - Added by Demian Biscocho over 5 years ago

Are you trying to login as the "goadmin" account as specified in the HOWTO? Can you show the output of the following:

MariaDB [asterisk]> select user,pass,pass_hash from vicidial_users;
MariaDB [asterisk]> select pass_hash_enabled,pass_cost from system_settings;

RE: Cannot Login || Goautodial v4.0 - Added by Amit Iyer over 5 years ago

Hello Demian,

Please find the below outputs.

MariaDB [asterisk]> select user,pass,pass_hash from vicidial_users;
+----------+------------+---------------------------------+
| user     | pass       | pass_hash                       |
+----------+------------+---------------------------------+
| VDAD     | donotedit  |                                 |
| admin    | goautodial |                                 |
| agent001 | goautodial |                                 |
| agent002 | goautodial |                                 |
| agent003 | goautodial |                                 |
| agent004 | goautodial |                                 |
| agent005 | goautodial |                                 |
| agent006 | goautodial |                                 |
| agent007 | goautodial |                                 |
| agent008 | goautodial |                                 |
| agent009 | goautodial |                                 |
| agent010 | goautodial |                                 |
| agent011 | goautodial |                                 |
| agent012 | goautodial |                                 |
| agent013 | goautodial |                                 |
| agent014 | goautodial |                                 |
| agent015 | goautodial |                                 |
| agent016 | goautodial |                                 |
| agent017 | goautodial |                                 |
| agent018 | goautodial |                                 |
| agent019 | goautodial |                                 |
| agent020 | goautodial |                                 |
| VDCL     | donotedit  |                                 |
| goAPI    |            | EORxUHT6Ju2kLOOB4g3X3GxJcQ9RGGS |
| goadmin  |            | h0CAwQ/of1y0YFKgut1hVcqNl1SMSNu |
+----------+------------+---------------------------------+
25 rows in set (0.00 sec)

MariaDB [asterisk]> select pass_hash_enabled,pass_cost from system_settings;
+-------------------+-----------+
| pass_hash_enabled | pass_cost |
+-------------------+-----------+
| 0                 |        12 |
+-------------------+-----------+
1 row in set (0.00 sec)

RE: Cannot Login || Goautodial v4.0 - Added by Amit Iyer over 5 years ago

yes, i am using the credentials specified in the HOWTO.

RE: Cannot Login || Goautodial v4.0 - Added by Amit Iyer over 5 years ago

I also tried to change the pass_hash_enabled from 0 to 1 but it still did not work.

RE: Cannot Login || Goautodial v4.0 - Added by Brett05 VOIP over 5 years ago

with my case after i follow the scratch install
i have success the login with admin and goautodial as password

RE: Cannot Login || Goautodial v4.0 - Added by Amit Iyer over 5 years ago

Brett, did you use an v3 iso ? I am using centos minimal os and then I installed be first and then installed the v4. Am I doing it correctly?

RE: Cannot Login || Goautodial v4.0 - Added by Demian Biscocho over 5 years ago

Guys,

You need to have pass_hash_enabled and use the "goadmin" user to login. Setting this (pass_hash_enabled) to 1 means the system will be using the encrypted passwords (pass_hash) table first instead of the plaintext pass column. It won't read the pass_hash column if set to 0.

Can you post the contents of the following file:

1. /var/www/html/astguiclient.conf
2. /var/www/html/php/Config.php
3. /var/www/html/php/goCRMAPISettings.php

RE: Cannot Login || Goautodial v4.0 - Added by Amit Iyer over 5 years ago

Hi,

Please find the below requested contents.

[root@hwsrv-277267 /]# cat /var/www/html/astguiclient.conf
# /etc/astguiclient.conf - configuration elements for the astguiclient/vicidial package
# this is the astguiclient configuration file
# all comments will be lost if you run install.pl again

# Paths used by astGUIclient
PATHhome => /usr/share/astguiclient
PATHlogs => /var/log/astguiclient
PATHagi => /var/lib/asterisk/agi-bin
PATHweb => /var/www/html
PATHsounds => /var/lib/asterisk/sounds
PATHmonitor => /var/spool/asterisk/monitor
PATHDONEmonitor => /var/spool/asterisk/monitorDONE

# The IP address of this machine
VARserver_ip => 127.0.0.1

# Database connection information
VARDB_server => localhost
VARDB_database => asterisk
VARDB_user => asterisku
VARDB_pass => asterisku1234
VARDB_custom_user => asterisku
VARDB_custom_pass => asterisku1234
VARDB_port => 3306

#connection to goautodial db
VARDBgo_server => localhost
VARDBgo_database => goautodial
VARDBgo_user => goautodialu
VARDBgo_pass => goautodialu1234
VARDBgo_port => 3306

#connection to kamailio db
VARDBgokam_server => localhost
VARDBgokam_database => kamailio
VARDBgokam_user => kamailiou
VARDBgokam_pass => kamailiou1234
VARDBgokam_port => 3306

#connection to osticket db
VARDBost_server => localhost
VARDBost_database => osticketdb
VARDBost_user => osticketu
VARDBost_pass => osticketu1234
VARDBost_port => 3306

# Alpha-Numeric list of the astGUIclient processes to be kept running
# (value should be listing of characters with no spaces: 1234568)
#  X - NO KEEPALIVE PROCESSES (use only if you want none to be keepalive)
#  1 - AST_update
#  2 - AST_send_listen
#  3 - AST_VDauto_dial
#  4 - AST_VDremote_agents
#  5 - AST_VDadapt (If multi-server system, this must only be on one server)
#  6 - FastAGI_log
#  7 - AST_VDauto_dial_FILL (only for multi-server, this must only be on one server)
#  8 - ip_relay (used for blind agent monitoring)
#  9 - Timeclock auto logout, (If multi-server system, this must only be on one server)
#  E - Email processor, (If multi-server system, this must only be on one server)
VARactive_keepalives => 1234568

# Asterisk version VICIDIAL is installed for
VARasterisk_version => 13.X

# FTP recording archive connection information
VARFTP_host => 127.0.0.1
VARFTP_user => ftpuser
VARFTP_pass => ftpuser1234
VARFTP_port => 21
VARFTP_dir => RECORDINGS
VARHTTP_path => http://127.0.0.1

# REPORT server connection information
VARREPORT_host => 127.0.0.1
VARREPORT_user => ftpuser
VARREPORT_pass => ftpuser1234
VARREPORT_port => 21
VARREPORT_dir => backup

# Settings for FastAGI logging server
VARfastagi_log_min_servers => 3
VARfastagi_log_max_servers => 16
VARfastagi_log_min_spare_servers => 2
VARfastagi_log_max_spare_servers => 8
VARfastagi_log_max_requests => 1000
VARfastagi_log_checkfordead => 30
VARfastagi_log_checkforwait => 60

# Expected DB Schema version for this install
ExpectedDBSchema => 1552

[root@hwsrv-277267 /]# cat /var/www/html/php/Config.php
<?php
// database configuration
define('DB_USERNAME', 'goautodialu');
define('DB_PASSWORD', 'goautodialu1234');
define('DB_HOST', 'localhost');
define('DB_NAME', 'goautodial');
define('DB_PORT', '3306');
define('DB_NAME_ASTERISK', 'asterisk');
// other configuration parameters
define('CRM_ADMIN_EMAIL', 'admin@localhost.com');
?>

[root@hwsrv-277267 /]# cat /var/www/html/php/goCRMAPISettings.php
<?php
define ('gourl', 'https://cc.ikconinfotech.com/goAPIv2'); //replace HOSTNAME with your FQDN
define ('goUser', 'goAPI');
define ('goPass', 'goAPIpass1234');
define ('responsetype', 'json');
?>

RE: Cannot Login || Goautodial v4.0 - Added by Brett05 VOIP over 5 years ago

Amit Iyer wrote:

Brett, did you use an v3 iso ? I am using centos minimal os and then I installed be first and then installed the v4. Am I doing it correctly?

yes i have start from v3 scratch install on centos 7 64bit on vps

RE: Cannot Login || Goautodial v4.0 - Added by Brett05 VOIP over 5 years ago

Brett05 VOIP wrote:

Amit Iyer wrote:

Brett, did you use an v3 iso ? I am using centos minimal os and then I installed be first and then installed the v4. Am I doing it correctly?

yes i have start from v3 scratch install on centos 7 64bit on vps

but after i have success login i have foud many error

exemple when i type screen -ls
i found only 4 process runing

then when i login as agent after that i click on the dialer button inside i see error login please contact your admin

RE: Cannot Login || Goautodial v4.0 - Added by Brett05 VOIP over 5 years ago

the version is not stable i think they need do us a full script or iso image
because thet use kamilio with webrtc and dns server too

RE: Cannot Login || Goautodial v4.0 - Added by Demian Biscocho over 5 years ago

Brett05 VOIP wrote:

Brett05 VOIP wrote:

Amit Iyer wrote:

Brett, did you use an v3 iso ? I am using centos minimal os and then I installed be first and then installed the v4. Am I doing it correctly?

yes i have start from v3 scratch install on centos 7 64bit on vps

but after i have success login i have foud many error

exemple when i type screen -ls
i found only 4 process runing

then when i login as agent after that i click on the dialer button inside i see error login please contact your admin

It's good to see that you can login to the v4 portal. If you only have 4 process running under "screen -ls", you might have missed installing some of the Perl dependencies. Try running manually one of the Vicidial Perl scripts:

/usr/share/astguiclient/ADMIN_keepalive_ALL.pl --debugX

The output will show any missing dependencies.

RE: Cannot Login || Goautodial v4.0 - Added by Demian Biscocho over 5 years ago

Also updated the HOWTO for the missing RTPengine package required by webRTC for clients behind firewalls (which most of us are).

Install RTPengine

yum install ngcp-rtpengine

Configure RTPengine

nano /etc/rtpengine/rtpengine.conf
[rtpengine]

table = 0
# no-fallback = false
### for userspace forwarding only:
# table = -1

### a single interface:
#interface = 123.234.345.456
### separate multiple interfaces with semicolons:
# interface = internal/12.23.34.45;external/23.34.45.54
### for different advertised address:
# interface = 12.23.34.45!23.34.45.56

listen-ng = 127.0.0.1:2223

Uncomment and change to your public IP address:

#interface = 123.234.345.456

Change the listening port from 2223 to 5066:

listen-ng = 127.0.0.1:5066

Start RTPengine:

systemctl enable ngcp-rtpengine
systemctl start ngcp-rtpengine
systemctl status ngcp-rtpengine

RE: Cannot Login || Goautodial v4.0 - Added by Amit Iyer over 5 years ago

i tried to reinstall and again i and receiving login issues, Am i missing something from the installation script ?

RE: Cannot Login || Goautodial v4.0 - Added by Demian Biscocho over 5 years ago

What's the php version you're running? It should be 7.0.X or below.

RE: Cannot Login || Goautodial v4.0 - Added by Amit Iyer over 5 years ago

i am using PHP version 7.


[root@hwsrv-277267 ~]# php -v
PHP 7.0.30 (cli) (built: Apr 28 2018 08:14:08) ( NTS )
Copyright (c) 1997-2017 The PHP Group
Zend Engine v3.0.0, Copyright (c) 1998-2017 Zend Technologies
    with Zend OPcache v7.0.30, Copyright (c) 1999-2017, by Zend Technologies

RE: Cannot Login || Goautodial v4.0 - Added by Brett05 VOIP over 5 years ago

Demian Biscocho wrote:

Brett05 VOIP wrote:

Brett05 VOIP wrote:

Amit Iyer wrote:

Brett, did you use an v3 iso ? I am using centos minimal os and then I installed be first and then installed the v4. Am I doing it correctly?

yes i have start from v3 scratch install on centos 7 64bit on vps

but after i have success login i have foud many error

exemple when i type screen -ls
i found only 4 process runing

then when i login as agent after that i click on the dialer button inside i see error login please contact your admin

It's good to see that you can login to the v4 portal. If you only have 4 process running under "screen -ls", you might have missed installing some of the Perl dependencies. Try running manually one of the Vicidial Perl scripts:

[...]

The output will show any missing dependencies.

ok i will do and i will back to you

RE: Cannot Login || Goautodial v4.0 - Added by Demian Biscocho over 5 years ago

Amit Iyer wrote:

i am using PHP version 7.

[...]

Please paste the output of the following when you login:

tail /var/log/php-fpm/www-error.log

RE: Cannot Login || Goautodial v4.0 - Added by Demian Biscocho over 5 years ago

Brett05 VOIP wrote:

Demian Biscocho wrote:

Brett05 VOIP wrote:

Brett05 VOIP wrote:

Amit Iyer wrote:

Brett, did you use an v3 iso ? I am using centos minimal os and then I installed be first and then installed the v4. Am I doing it correctly?

yes i have start from v3 scratch install on centos 7 64bit on vps

but after i have success login i have foud many error

exemple when i type screen -ls
i found only 4 process runing

then when i login as agent after that i click on the dialer button inside i see error login please contact your admin

It's good to see that you can login to the v4 portal. If you only have 4 process running under "screen -ls", you might have missed installing some of the Perl dependencies. Try running manually one of the Vicidial Perl scripts:

[...]

The output will show any missing dependencies.

ok i will do and i will back to you

Please create a new thread for this.

RE: Cannot Login || Goautodial v4.0 - Added by Amit Iyer over 5 years ago

Hi,

Please find the below outputs.

[root@hwsrv-277267 php]# tail /var/log/php-fpm/www-error.log
#2 /var/www/html/index.php(33): require_once('/var/www/html/p...')
#3 {main}
  thrown in /var/www/html/php/DatabaseConnectorFactory.php on line 110
[20-Aug-2018 01:16:41 America/New_York] PHP Fatal error:  Uncaught Exception: Incorrect credentials. Access denied or incorrect parameters. in /var/www/html/php/DatabaseConnectorFactory.php:110
Stack trace:
#0 /var/www/html/php/SessionHandler.php(60): creamy\DatabaseConnectorFactory->getDatabaseConnectorOfType('MySQL')
#1 /var/www/html/php/APIHandler.php(31): creamy\SessionHandler->__construct()
#2 /var/www/html/index.php(33): require_once('/var/www/html/p...')
#3 {main}
  thrown in /var/www/html/php/DatabaseConnectorFactory.php on line 110

[root@hwsrv-277267 php]# cat Config.php
<?php
// database configuration
define('DB_USERNAME', 'goautodialu');
define('DB_PASSWORD', 'goautodialu1234');
define('DB_HOST', 'localhost');
define('DB_NAME', 'goautodial');
define('DB_PORT', '3306');
define('DB_NAME_ASTERISK', 'asterisk');
// other configuration parameters
define('CRM_ADMIN_EMAIL', 'admin@localhost.com');
?>

[root@hwsrv-277267 php]# tail /var/log/php-fpm/www-error.log
#3 {main}
  thrown in /var/www/html/php/DatabaseConnectorFactory.php on line 110
[20-Aug-2018 13:23:42 Asia/Manila] PHP Notice:  Undefined variable: session_id in /var/www/html/php/SessionHandler.php on line 116
[20-Aug-2018 13:24:01 Asia/Manila] PHP Notice:  Undefined variable: session_id in /var/www/html/php/SessionHandler.php on line 116
[20-Aug-2018 01:24:16 America/New_York] PHP Fatal error:  Uncaught Exception: Unable to connect to the database. Access denied or incorrect parameters. in /var/www/html/goAPIv2/includes/MySQLiDB.php:176
Stack trace:
#0 /var/www/html/goAPIv2/goDBgoautodial.php(56): MySQLiDB->__construct('localhost', 'goautodialu', 'goautodialu1234', 'goautodial')
#1 /var/www/html/goAPIv2/goAPI.php(24): include_once('/var/www/html/g...')
#2 {main}
  thrown in /var/www/html/goAPIv2/includes/MySQLiDB.php on line 176

Then i have changed the username and password to root / vicidialnow and then again i received the below error.

[root@hwsrv-277267 php]# tail /var/log/php-fpm/www-error.log
  thrown in /var/www/html/php/DatabaseConnectorFactory.php on line 110
[20-Aug-2018 13:34:07 Asia/Manila] PHP Notice:  Undefined variable: session_id in /var/www/html/php/SessionHandler.php on line 116
[20-Aug-2018 13:34:17 Asia/Manila] PHP Notice:  Undefined variable: session_id in /var/www/html/php/SessionHandler.php on line 116
[20-Aug-2018 05:34:45 UTC] PHP Warning:  password_hash(): Provided salt is too short: 0 expecting 22 in /var/www/html/goAPIv2/goFunctions.php on                                               line 1823
[20-Aug-2018 05:34:45 UTC] PHP Warning:  password_hash(): Provided salt is too short: 0 expecting 22 in /var/www/html/goAPIv2/goFunctions.php on                                               line 1823
[20-Aug-2018 13:34:51 Asia/Manila] PHP Notice:  Undefined variable: session_id in /var/www/html/php/SessionHandler.php on line 116
[20-Aug-2018 05:35:22 UTC] PHP Warning:  password_hash(): Provided salt is too short: 0 expecting 22 in /var/www/html/goAPIv2/goFunctions.php on                                               line 1823
[20-Aug-2018 05:35:22 UTC] PHP Warning:  password_hash(): Provided salt is too short: 0 expecting 22 in /var/www/html/goAPIv2/goFunctions.php on                                               line 1823
[20-Aug-2018 05:35:22 UTC] PHP Notice:  Undefined index: user_group in /var/www/html/goAPIv2/goUsers/goUserLogin.php on line 156
[20-Aug-2018 13:35:29 Asia/Manila] PHP Notice:  Undefined variable: session_id in /var/www/html/php/SessionHandler.php on line 116

RE: Cannot Login || Goautodial v4.0 - Added by Demian Biscocho over 5 years ago

Here's the problem:

[20-Aug-2018 01:24:16 America/New_York] PHP Fatal error:  Uncaught Exception: Unable to connect to the database. Access denied or incorrect parameters. in /var/www/html/goAPIv2/includes/MySQLiDB.php:176
Stack trace:
#0 /var/www/html/goAPIv2/goDBgoautodial.php(56): MySQLiDB->__construct('localhost', 'goautodialu', 'goautodialu1234', 'goautodial')

Your database user "goautodialu" doesn't have enough rights to access the "goautodial" database.

Please check the HOWTO on how to grant access to the "goautodialu" user.

RE: Cannot Login || Goautodial v4.0 - Added by Amit Iyer over 5 years ago

I have again granted the rights to goautodial and still cannot login. Now i am receiving the below error.

[root@hwsrv-277267 php]# tail /var/log/php-fpm/www-error.log
#1 /var/www/html/php/APIHandler.php(31): creamy\SessionHandler->__construct()
#2 /var/www/html/index.php(33): require_once('/var/www/html/p...')
#3 {main}
  thrown in /var/www/html/php/DatabaseConnectorFactory.php on line 110
[20-Aug-2018 18:39:38 Asia/Manila] PHP Notice:  Undefined variable: session_id in /var/www/html/php/SessionHandler.php on line 116
[20-Aug-2018 18:39:57 Asia/Manila] PHP Notice:  Undefined variable: session_id in /var/www/html/php/SessionHandler.php on line 116
[20-Aug-2018 10:39:57 UTC] PHP Warning:  password_hash(): Provided salt is too short: 0 expecting 22 in /var/www/html/goAPIv2/goFunctions.php on line 1823
[20-Aug-2018 10:39:57 UTC] PHP Warning:  password_hash(): Provided salt is too short: 0 expecting 22 in /var/www/html/goAPIv2/goFunctions.php on line 1823
[20-Aug-2018 10:39:57 UTC] PHP Notice:  Undefined index: user_group in /var/www/html/goAPIv2/goUsers/goUserLogin.php on line 156
[20-Aug-2018 18:40:17 Asia/Manila] PHP Notice:  Undefined variable: session_id in /var/www/html/php/SessionHandler.php on line 116

RE: Cannot Login || Goautodial v4.0 - Added by Brett05 VOIP over 5 years ago

Amit Iyer wrote:

I have again granted the rights to goautodial and still cannot login. Now i am receiving the below error.

[...]

did you use login : admin and password : goautodial for login if you have the default access for goautodial v3 after you have do the upgrade from my side i can not login with the login of goautodialv4 but witk admin and goautodial i can access try it please.

aftr that from my side i have find that kamilio have a probleme to start i will post my log soon here

RE: Cannot Login || Goautodial v4.0 - Added by Brett05 VOIP over 5 years ago

replace this :

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
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

use kamailio;
INSERT INTO subscriber(`username`, `domain`, `password`, `ha1`, `ha1b`) VALUES

with this :

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;

INSERT INTO vicidial_users (user,pass_hash,full_name,user_level,user_group,active)
values('goAPI','EORxUHT6Ju2kLOOB4g3X3GxJcQ9RGGS','GOautodial API User','9','ADMIN','N');

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;

INSERT INTO users(userid,name,fullname,avatar,role,status,user_group,phone)
VALUES;

RE: Cannot Login || Goautodial v4.0 - Added by Brett05 VOIP over 5 years ago

update those database insert :

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 vicidial_users (user,pass_hash,full_name,user_level,user_group,active) 
values('goAPI','EORxUHT6Ju2kLOOB4g3X3GxJcQ9RGGS','GOautodial API User','9','ADMIN','N');

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');

INSERT INTO users(userid,name,fullname,avatar,role,status,user_group,phone)
VALUES('1416','goadmin','Admin User','','9','1','ADMIN','7798306534');
(1-25/38) Go to top