Page 1 of 1

Web interface not updating Asterisk

PostPosted: Wed Jul 22, 2009 7:33 pm
by ykhan
I managed to install Vicibox (1.0.0rc2). Then restored a database from a VicidialNOW install to start the dialing from the same lead etc. Then I tried to Rebuild conf files. But no action on the admin interface is making a difference in the CLI output.

PostPosted: Wed Jul 22, 2009 7:55 pm
by mflorell
There are a lot of things that can go wrong when you restore a database from another system.

What was the system_settings.db_schema_version of the old database?

PostPosted: Wed Jul 22, 2009 8:10 pm
by ykhan
Sorry, but I don't know about the schema version of the original database. It was a standard VicidialNOW 1.2 CE install. The MySQLDUMP file contained this:

Code: Select all
-- MySQL dump 10.10
--
-- Host: localhost    Database: asterisk
-- ------------------------------------------------------
-- Server version   5.0.22

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


Is there a way to revert back to the installed version?

PostPosted: Wed Jul 22, 2009 10:45 pm
by ykhan
The db_schema_version of the old database was 1135. Based on another thread, I looked in the upgrade_2.0.5.sql file for this schema number, but there are no lines after this.

PostPosted: Wed Jul 22, 2009 10:47 pm
by ykhan
The values in the Asterisk DB are updating from the interface. It seems like some scripts that communicate with Asterisk are not running.

PostPosted: Thu Jul 23, 2009 5:34 am
by mflorell
What is the output of 'screen -ls'

PostPosted: Thu Jul 23, 2009 8:16 am
by ykhan
Code: Select all
There are screens on:
        14171.ASTVDauto (Detached)
        5069.asterisk   (Detached)
        5013.ASTfastlog (Detached)
        5011.ASTVDadapt (Detached)
4 Sockets in /var/run/screen/S-root.


Should I reinstall the Vicidial code?

PostPosted: Thu Jul 23, 2009 2:23 pm
by mflorell
What happens when you run this command:

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

PostPosted: Thu Jul 23, 2009 3:24 pm
by ykhan
Thanks Matt for guiding me in the right direction. When I ran usr/share/astguiclient/AST_update.pl --debugX, I realized that I had not actually run the /usr/share/astguiclient/ADMIN_update_server_ip.pl script to update the server IP in the conf files. As soon as I rean the scritp, all 8 screens started and Asterisk was updated with the rebuilt conf files as well.

RESOLVED