Upgrading to 1.10.007beta1... Table does not exist.. installation stops here

System: CentOs 5.2 Final
Asterisk: version 1.2.27
Vicidial and astgui installed
Apache / PHP / MySQL all latest versions and running
FreePBX system requirement ok, to my best knowledge.

FreePBXversion: 2.5.0rc2
MySQL db: asteriskcdrdb setup with no table
MySQL db: asterisk is setup and filled with vicidial related tables.

I want to install FreePBX on top of the above listed configuration.
The system has been set up fresh.

Here is were I stuck:


[[email protected] freepbx-2.5.0rc2]# ./install_amp
Checking for PEAR DB…OK
Checking for PEAR Console::Getopt…OK
Checking user…OK
Checking if Asterisk is running…running with PID: 6680…OK
Checking for /etc/amportal.conf…OK
Reading /etc/amportal.conf…OK
Checking for /etc/asterisk/asterisk.conf…OK
Reading /etc/asterisk/asterisk.conf…OK
Using asterisk as PBX Engine
Checking for Asterisk version…1.2.27
Checking for selinux…OK
Connecting to database…OK
Checking current version of AMP…no version information
Assuming new installation
Installing new FreePBX files…OK (476 files copied, 0 skipped)
Configuring install for your environment…amportal…freepbx_engine…done
apply username/password changes to conf files…done
creating missing #include files…OK
No such command ‘module’ (type ‘help’ for help)
– Remote UNIX connection
Verbosity is at least 6
== Parsing ‘/etc/asterisk/manager.conf’: Found
== Parsing ‘/etc/asterisk/manager_additional.conf’: Found
== Parsing ‘/etc/asterisk/manager_custom.conf’: Found
Verbosity is at least 6
OK
Setting permissions on files…OK
Checking for upgrades…29 found
Upgrading to 1.10.007beta1…
-> Running SQL script /usr/src/freePBX/freepbx-2.5.0rc2/upgrades/1.10.007beta1/t ables.sql
[FATAL] ALTER TABLE sip CHANGE id id BIGINT( 11 ) DEFAULT “-1” NOT NULL [n ativecode=1146 ** Table ‘asteriskcdrdb.sip’ doesn’t exist]" while running tables .sql

[[email protected] freepbx-2.5.0rc2]#


Thx a lot for taking your time to deal with my crappy prob.

http://www.freepbx.org/support/documentation/installation/install-process-for-centos-5-1

looks to me you have told it that you are using asteriskcdrdb as your asterisk database (probably in the amportal.conf file), however given what you have described with the vicidial integration and all, it is highly likely you will run into plenty of other issues. Unless you really understand the dialplan as well as how to customize, vicidial does not play well with FreePBX.

[[email protected] freepbx-2.5.1]# amportal start

**** ERROR IN CONFIGURATION ****
astrundir in /etc/asterisk/asterisk.conf is set to ‘/var/run’ - THIS IS WRONG.
Please change it to something sensible (eg, ‘/var/run/asterisk’) and re-run
install_amp
[[email protected] freepbx-2.5.1]# ./install_amp
Checking for PEAR DB…OK
Checking for PEAR Console::Getopt…OK
Checking user…OK
Checking if Asterisk is running…running with PID: 3700…OK
Checking for /etc/amportal.conf…OK
Reading /etc/amportal.conf…OK
Checking for /etc/asterisk/asterisk.conf…OK
Reading /etc/asterisk/asterisk.conf…OK
Using asterisk as PBX Engine
Checking for Asterisk version…1.4.23.2
Checking for selinux…OK
Connecting to database…OK
Checking current version of AMP…no version information
Assuming new installation
Installing new FreePBX files…OK (504 files copied, 0 skipped)
Configuring install for your environment…amportal…freepbx_engine…done
apply username/password changes to conf files…done
creating missing #include files…OK
Unable to connect to remote asterisk (does /var/run/asterisk/asterisk.ctl exist?)
Unable to connect to remote asterisk (does /var/run/asterisk/asterisk.ctl exist?)
OK
Setting permissions on files…OK
Checking for upgrades…32 found
Upgrading to 1.10.007beta1…
-> Running SQL script /usr/src/freepbx-2.5.1/upgrades/1.10.007beta1/tables.sql
[FATAL] ALTER TABLE sip CHANGE id id BIGINT( 11 ) DEFAULT “-1” NOT NULL [nativecode=1146 ** Table ‘asterisk.sip’ doesn’t exist]" while running tables.sql

mehdy,

Please don’t hijack somebody elses thread. While you might think it’s related it is not. Please post a new thread, also you’ve not provided enough info for us to help you. We can see that you are having a install problem with FreePBX 2.5.1 and are using asterisk 1.4.23.2 but past that we know nothing.

Please see http://freepbx.org/forum/freepbx/installation/so-you-have-a-problem-and-want-help