I’m trying to install version 2.3.1 onto a Suse 10.1 machine that’s running asterisk v 1.4.9, MySQL 5.0 and PHP5.
I had a bunch of problems along the way mostly with paths and so on but now I’m really stumped.
The install almost completes but fails when attampting to update the MySQL databases as shown below. I have created the databases and given permission as per the INSTALL doc.
Configuring install for your environment…amportal…freepbx_engine…done
apply username/password changes to conf files…done
== Parsing ‘/etc/asterisk/manager.conf’: Found
Verbosity is at least 3
Setting permissions on files…OK
Checking for upgrades…20 found
Upgrading to 1.10.007beta1…
-> Running SQL script /home/hwaterfall/freepbx/freepbx-2.3.1/upgrades/1.10.007beta1/tables.sql
[FATAL] ALTER TABLE
id BIGINT( 11 ) DEFAULT “-1” NOT NULL [nativecode=1146 ** Table ‘asterisk.sip’ doesn’t exist]" while running tables.sql