Cant do admin login after latest SVN upgrade

[urmi.l]

Hello,

I m having GOautodial CE 2.1 ISO and working fine.
VERSION: 2.4-309a | BUILD: 110430-1642 | Asterisk 1.4.39.1-vici | Single Server | No Extra Software After Installation | CentOS release 5.5

I want to do 3way calling and for that I did the upgrade using the following link :
viewtopic.php?t=16326&highlight=

I can do admin login through : https://192.168.1.10/goautodial-admin/ But I m not able to do admin login through : https://192.168.1.10/vicidial/admin.php. It gives below issue.

The username and password requested by https://192.168.1.10. The site says: "CONTACT-CENTER-ADMIN"

Login incorrect, please try again: |||BAD|

Below are my screen output :

[root@go extras]# screen -list
There are screens on:
2760.ASTlisten (Detached)
2495.asterisk (Detached)
2763.ASTVDauto (Detached)
2769.ASTVDadapt (Detached)
2754.ASTupdate (Detached)
2444.astshell20130930160213 (Detached)
2772.ASTfastlog (Detached)
2766.ASTVDremote (Detached)
2747.goautodial_d (Detached)
2757.ASTsend (Detached)
10 Sockets in /var/run/screen/S-root.

[root@go extras]# service iptables status
Firewall is stopped.

-Thanks

[tick]

Hi,
from mysql:
mysql> use asterisk;
mysql> select user,pass from vicidial_users;
or
mysql> select pass from vicidial_users where user = 6666;

[urmi.l]

Thank you for your reply.

mysql> select pass from vicidial_users where user = 6666;
MySQL returned an empty result set

There is no user named 6666. The admin user is having password 'goautodial' in DB. But if I use the same to login, its not working.

Wat can be the issue ?

-Thanks

[DomeDan]

The easy fix is to add the 6666 user:

Code: Select all

INSERT INTO vicidial_users (user,pass,full_name,user_level,user_group,load_leads,campaign_detail,ast_admin_access,modify_users) values('6666','1234','Admin','9','ADMIN','1','1','1','1');

but there might be more problems if your upgrade failed,
tell us the process when you upgraded, for example: did you run the sql upgrade script/scripts?

[urmi.l]

I have successfully added the user 6666 with ur sql query. And then tried to login to do admin login but still its not working.

Login incorrect, please try again: |6666|1234|BAD|

Please suggest me if I did anything wrong while upgrade. I did the following steps for upgrade. I refer this link : viewtopic.php?t=16326&highlight=

1. Backup existing system:

1.1 Run this for a 1-server system or server with database on it:
(this may take hours on large system)
/usr/share/astguiclient/ADMIN_backup.pl --debugX

1.2 Run this on dialer/Asterisk-only servers:
(do not run this if you only have one server):
/usr/share/astguiclient/ADMIN_backup.pl --debugX --without-db --without-web

2. Test backup:

Create a new (any name) database on any mysql server, apply the backup data to it, and verify a new lead from Today is actually in there.

3. On ALL servers: (Database, web, telephony)

cd /usr/src/astguiclient

Download Vicidial trunk on ALL servers

svn checkout svn://svn.eflo.net:3690/agc_2-X/trunk

4. On ONLY database server:

Going into mysql and executing the upgrade sql file:
mysql
use asterisk
\. /usr/src/astguiclient/trunk/extras/upgrade_2.4.sql
quit

5. On ALL servers: (Database, web, telephony)

cd /usr/src/astguiclient/trunk
perl ./install.pl
NOTES: If you have customized any scripts in the bin or agi folders,
then make sure you back them up before running the install.pl script.
This script will replace existing files in the astguiclient installation.


6. On one server only, update your phone codes data:

/usr/share/astguiclient/ADMIN_area_code_populate.pl --purge-table –debug

[DomeDan]

then you didnt run the upgrade_2.6.sql file, try that

[urmi.l]

Yes, I did it and I can login to admin. But again got another issue of "there is a time synchronization problem with your system please tell your system administrator".

My server_updater table is blank. And i think that is the reason i m getting time synchronization issue.

[root@go astguiclient]# ps -A | grep AST
18451 ? 00:00:00 AST_manager_kil

Below is my ADMIN_keepalive_ALL.pl --debugxxxxx

[root@go astguiclient]# /usr/share/astguiclient/ADMIN_keepalive_ALL.pl --debugxxxxx

----- SUPER-DUPER DEBUGGING -----


----- TRIPLE DEBUGGING -----

0| 1 init [3] |
1| 2 [migration/0]|
2| 3 [ksoftirqd/0]|
3| 4 [watchdog/0]|
4| 5 [migration/1]|
5| 6 [ksoftirqd/1]|
6| 7 [watchdog/1]|
7| 8 [events/0]|
8| 9 [events/1]|
9| 10 [khelper]|
10| 11 [kthread]|
11| 15 [kblockd/0]|
12| 16 [kblockd/1]|
13| 17 [kacpid]|
14| 109 [cqueue/0]|
15| 110 [cqueue/1]|
16| 113 [khubd]|
17| 115 [kseriod]|
18| 181 [khungtaskd]|
19| 182 [pdflush]|
20| 183 [pdflush]|
21| 184 [kswapd0]|
22| 185 [aio/0]|
23| 186 [aio/1]|
24| 344 [kpsmoused]|
25| 375 [ata/0]|
26| 376 [ata/1]|
27| 377 [ata_aux]|
28| 381 [scsi_eh_0]|
29| 382 [scsi_eh_1]|
30| 392 [kstriped]|
31| 405 [kjournald]|
32| 430 [kauditd]|
33| 463 /sbin/udevd -d|
34| 896 [kedac]|
35| 1270 [kmpathd/0]|
36| 1271 [kmpathd/1]|
37| 1272 [kmpath_handlerd]|
38| 1298 [kjournald]|
39| 1480 [iscsi_eh]|
40| 1534 [ib_addr]|
41| 1544 [ib_mcast]|
42| 1545 [ib_inform]|
43| 1546 [local_sa]|
44| 1549 [iw_cm_wq]|
45| 1554 [ib_cm/0]|
46| 1555 [ib_cm/1]|
47| 1559 [rdma_cm]|
48| 1575 brcm_iscsiuio|
49| 1581 iscsid|
50| 1582 iscsid|
51| 1793 syslogd -m 0|
52| 1796 klogd -x|
53| 1835 dbus-daemon --system|
54| 1849 /usr/sbin/acpid|
55| 2061 hald|
56| 2062 hald-runner|
57| 2069 hald-addon-acpi: listening on acpid socket /var/run/acpid.socket|
58| 2109 /usr/sbin/sshd|
59| 2148 /usr/sbin/vsftpd /etc/vsftpd/vsftpd.conf|
60| 2185 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --user=mysql|
61| 2232 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --socket=/var/lib/mysql/mysql.sock|
62| 2273 sendmail: accepting connections|
63| 2283 sendmail: Queue runner@01:00:00 for /var/spool/clientmqueue|
64| 2298 /usr/sbin/httpd|
65| 2311 crond|
66| 2326 /usr/sbin/httpd|
67| 2327 /usr/sbin/httpd|
68| 2328 /usr/sbin/httpd|
69| 2329 /usr/sbin/httpd|
70| 2330 /usr/sbin/httpd|
71| 2331 /usr/sbin/httpd|
72| 2332 /usr/sbin/httpd|
73| 2333 /usr/sbin/httpd|
74| 2334 /usr/sbin/munin-node|
75| 2374 /usr/sbin/atd|
76| 2557 /usr/bin/SCREEN -d -m -S goautodial_d /usr/share/goautodial/goautodiald.pl|
77| 2558 /usr/bin/perl /usr/share/goautodial/goautodiald.pl|
78| 2609 /usr/bin/SCREEN -S astshell20131001163704|
79| 2610 /bin/sh|
80| 2704 SCREEN -L -S asterisk|
81| 2705 /bin/sh|
82| 2942 /usr/sbin/smartd -q never|
83| 2947 /sbin/mingetty tty1|
84| 2948 /sbin/mingetty tty2|
85| 2949 /sbin/mingetty tty3|
86| 2954 /sbin/mingetty tty4|
87| 2957 /sbin/mingetty tty5|
88| 2962 /sbin/mingetty tty6|
89| 3078 sshd: root@pts/1 |
90| 3082 -bash|
91|12683 ntpd -u ntp:ntp -p /var/run/ntpd.pid -g|
92|18340 /bin/sh /usr/sbin/safe_asterisk|
93|18344 /usr/sbin/asterisk -f -vvvg -c|
94|19276 crond|
95|19293 /usr/bin/perl /usr/share/astguiclient/AST_manager_kill_hung_congested.pl|
96|19678 /usr/bin/perl /usr/share/astguiclient/ADMIN_keepalive_ALL.pl --debugxxxxx|
97|19679 /bin/ps -o %p %a --no-headers -A|
|SELECT count(*) from system_settings where timeclock_end_of_day LIKE "%1716%";|
SYSTEM SETTINGS: 0||exten => _87.,1,Goto(defaultlog,985${EXTEN:2},1)|
DONE
[root@go astguiclient]#

[urmi.l]

[root@go ~]# /usr/share/astguiclient/AST_vm_update.pl --debugx
|SELECT telnet_host,telnet_port,ASTmgrUSERNAME,ASTmgrSECRET,ASTmgrUSERNAMEupdate,ASTmgrUSERNAMElisten,ASTmgrUSERNAMEsend,max_vicidial_trunks,answer_transfer_agent,local_gmt,ext_context,asterisk_version FROM servers where server_ip = '192.168.1.208';|
|SELECT extension,voicemail_id,messages,old_messages from phones where server_ip='192.168.1.208'|
MailboxCount- 8001 NEW:|0| OLD:|0| MESSAGE COUNT UNCHANGED, DOING NOTHING FOR THIS MAILBOX
MailboxCount- 7001 NEW:|0| OLD:|0| MESSAGE COUNT UNCHANGED, DOING NOTHING FOR THIS MAILBOX
MailboxCount- 8002 NEW:|0| OLD:|0| MESSAGE COUNT UNCHANGED, DOING NOTHING FOR THIS MAILBOX
MailboxCount- 8003 NEW:|0| OLD:|0| MESSAGE COUNT UNCHANGED, DOING NOTHING FOR THIS MAILBOX
MailboxCount- 8004 NEW:|0| OLD:|0| MESSAGE COUNT UNCHANGED, DOING NOTHING FOR THIS MAILBOX
MailboxCount- 8005 NEW:|0| OLD:|0| MESSAGE COUNT UNCHANGED, DOING NOTHING FOR THIS MAILBOX
MailboxCount- 8006 NEW:|0| OLD:|0| MESSAGE COUNT UNCHANGED, DOING NOTHING FOR THIS MAILBOX
MailboxCount- 8007 NEW:|0| OLD:|0| MESSAGE COUNT UNCHANGED, DOING NOTHING FOR THIS MAILBOX
MailboxCount- 8008 NEW:|0| OLD:|0| MESSAGE COUNT UNCHANGED, DOING NOTHING FOR THIS MAILBOX
MailboxCount- 8009 NEW:|0| OLD:|0| MESSAGE COUNT UNCHANGED, DOING NOTHING FOR THIS MAILBOX
MailboxCount- 8010 NEW:|0| OLD:|0| MESSAGE COUNT UNCHANGED, DOING NOTHING FOR THIS MAILBOX
MailboxCount- 424 NEW:|0| OLD:|0| MESSAGE COUNT UNCHANGED, DOING NOTHING FOR THIS MAILBOX
|SELECT count(*) from system_settings where active_voicemail_server='192.168.1.208';|
DONE... Exiting... Goodbye... See you later..

[root@go ~]# ps -A | grep AST
3575 ? 00:00:00 AST_VDhopper.pl
3577 ? 00:00:00 AST_conf_update
3579 ? 00:00:00 AST_CRON_audio_
3581 ? 00:00:00 AST_vm_update.p
3583 ? 00:00:00 AST_manager_kil

After few seconds :

[root@go ~]# ps -A | grep AST
3583 ? 00:00:00 AST_manager_kil
[root@go ~]#

[root@go ~]# ps -A | grep AST
[root@go ~]#

[DomeDan]

do a screen -ls to check if your screens is running

if not then try to restart the vicidial service and check for errors:

/etc/init.d/vicidial restart

[urmi.l]

I reisntall the goautodial-2.1 and then once again did the upgrade of using /usr/src/astguiclient/trunk/extras/upgrade_2.6.sql. Still the same issue of admin login from vicidial and time synchronization problem.

[root@go asterisk]# ps -AH | grep AST
5373 ? 00:00:00 AST_manager_kil
[root@go asterisk]#
[root@go asterisk]# ps -AH | grep AST
[root@go asterisk]#
[root@go asterisk]# screen -ls
There are screens on:
2782.goautodial_d (Detached)
2543.astshell20131002165354 (Detached)
2551.asterisk (Detached)
3 Sockets in /var/run/screen/S-root.

[root@go asterisk]# /etc/init.d/vicidial restart
-bash: /etc/init.d/vicidial: No such file or directory

[DomeDan]

Oh yeah you're using goautodial.. then dont upgrade using svn I guess... ?
you should do a "yum update" to upgrade goautodial http://vicidial.org/VICIDIALforum/viewt ... =7&t=28230

Or use vicibox and do a svn upgrade

[urmi.l]

I did the upgrade with your said link. But still the same issue.

[root@go ~]# screen -ls
There are screens on:
2991.astshell20131002085150 (Detached)
2996.asterisk (Detached)
3142.goautodial_d (Detached)
3 Sockets in /var/run/screen/S-root.

[root@go ~]#
[root@go ~]#
[root@go ~]# ps -AH | grep AST
[root@go ~]# ps -AH | grep AST

[DomeDan]

you probably need to do a reinstall again and then a yum update
dont do a svn update on goautodial

[urmi.l]

Thank you for your quick response. Now again I started with reinstalation and then will do yum update.
After that I will update the status here also.