Errors after install

Installation, configuration instruction and issues for ictfax 0.3.2 can be found here.

Errors after install

Postby fax » Mon Oct 01, 2012 11:56 am

HI I've followed through the install guide.

When doing the ictfax_proc.sql file i get this error
ERROR 1146 (42S02) at line 781: Table 'ictfax.pbx_sessions' doesn't exist

When trying to browse to the URl i get this in the http logs.

PHP Fatal error: Table 'ictfax.pbx_users' doesn't exist\nquery: SELECT u.*, s.* FROM pbx_users u INNER JOIN pbx_sessions s ON u.uid = s.uid WHERE s.sid = '50v90grgadrg7kgg7cfv3513e3' AND u.status < 3 LIMIT 0, 1 in /usr/ictfax/wwwroot/includes/database.mysql.inc on line 66

I believe this is related to the top sql problem.
any ideas
Thanks
fax
 
Posts: 1
Joined: Mon Oct 01, 2012 11:17 am

Database installation

Postby falak » Mon Oct 01, 2012 11:56 am

Yes you are right , it does seem that database is not created properly

please delete existing database "ictfax" and do following steps again and not the step where it does not succeed

1. create "ictfax" database in mysql

echo 'CREATE DATABASE ictfax;' | mysql --user=root --password=ROOT_PASSWD

2. create tables in "ictfax" while using /usr/ictfax/database/ictfax.sql

mysql --user=root --password=ROOT_PASSWD ictfax

3. create mysql procedures with /usr/ictfax/database/ictfax_proc.sql

mysql --user=root --password=ROOT_PASSWD ictfax

4. above command will also create a user "ictfaxuser" with "ictfax786" as default. it is strongly recommended to change default password.
falak
Site Admin
 
Posts: 168
Joined: Tue Jan 17, 2012 7:33 am


Return to Installation and Configuration

Who is online

Users browsing this forum: No registered users and 1 guest