Date: Thu, 17 Jun 2010 22:28:57 +0100 From: "Jasvinder S. Bahra" <jazzsb@blueyonder.co.uk> To: <freebsd-questions@freebsd.org> Subject: Problem Creating GroupOffice Database (FreeBSD Group Office port) Message-ID: <D8E21250CF3F4353A650AB2ADE6035FF@atlantis>
next in thread | raw e-mail | index | archive | help
Hi, Has anyone had any luck getting the www/groupoffice-2.18.s.21 port working on FreeBSD? I'm running FreeBSD 7.3, the Apache Webserver 2.2.15_9 with PHP 5.2.13_2 and MySQL 5.5.4. I'm attempting to get group office up and running, but without success. Basically, i've opened http://<<IPADDRESS>>/groupoffice/install/install.php in a web browser - which works correctly. I'm go through the installation screens until I hit a form (asking for username/password to connect to mysql, as well as the details of a MySQL user account it can create for group office's use). I enter the details and hit the next button. I receive a message saying that a connection was successfully established to the database. I hit next again - at this point, it should (presumeably) run a series of SQL statements to create the database and populate it with the initial dataset. Unfortunately, instead I get pages and page of error messages, intersperced with HTML ("Welcome to the Group-Office CMS")... ------------------------------------------------ Database error: Invalid SQL: CREATE TABLE IF NOT EXISTS `ab_addressbooks` (`id` int(11) NOT NULL default '0',`user_id` int(11) NOT NULL default '0',`name` varchar(50) NOT NULL default '',`acl_read` int(11) NOT NULL default '0',`acl_write` int(11) NOT NULL default '0',PRIMARY KEY (`id`),KEY `user_id` (`user_id`)) TYPE=MyISAM MySQL Error: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1) Database error: Invalid SQL: INSERT INTO `ab_addressbooks` (`id`, `user_id`, `name`, `acl_read`, `acl_write`) VALUES(1, 1, 'Admin, Group-Office', 36, 37),(4, 1, 'test', 52, 53) MySQL Error: 1146 (Table 'groupoffice.ab_addressbooks' doesn't exist) . . . Database error: Invalid SQL: CREATE TABLE IF NOT EXISTS `cms_files` (`id` int(11) NOT NULL default '0',`folder_id` int(11) NOT NULL default '0',`extension` varchar(10) NOT NULL default '',`size` int(11) NOT NULL default '0',`ctime` int(11) NOT NULL,`mtime` int(11) NOT NULL default '0',`name` varchar(255) NOT NULL default '',`content` longtext NOT NULL,`auto_meta` enum('0','1') NOT NULL default '1',`title` varchar(100) NOT NULL default '',`description` text NOT NULL,`keywords` text NOT NULL,`priority` int(11) NOT NULL default '0',`hot_item` enum('0','1') default NULL,`hot_item_text` text NOT NULL,`template_item_id` int(11) NOT NULL default '0',`acl` int(11) NOT NULL,PRIMARY KEY (`id`),KEY `folder_id` (`folder_id`),FULLTEXT KEY `name` (`name`),FULLTEXT KEY `content` (`content`)) TYPE=MyISAM MySQL Error: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1) Database error: Invalid SQL: INSERT INTO `cms_files` (`id`, `folder_id`, `extension`, `size`, `ctime`, `mtime`, `name`, `content`, `auto_meta`, `title`, `description`, `keywords`, `priority`, `hot_item`, `hot_item_text`, `template_item_id`, `acl`) VALUES(1, 1, 'html', 230, 1159522480, 1159522489, 'Welcome.html', ' . . . Database error: Invalid SQL: INSERT INTO `users_groups` (`group_id`, `user_id`) VALUES(1, 1),(2, 1) MySQL Error: 1146 (Table 'groupoffice.users_groups' doesn't exist) Database error: Invalid SQL: SELECT * FROM settings WHERE name='version' AND user_id=0 MySQL Error: 1146 (Table 'groupoffice.settings' doesn't exist) Session halted. ------------------------------------------------ I connected to MySQL and found that the database had been created, as well as a user for group office to connect to it. The database however has no tables. Annoyingly, the documentation on the Group Office website does not seem to be version specific, so i'm not sure if its a configuration problem specific to the version available in the ports. Does anyone have any ideas? Note that I have set the following settings in my php.ini (originally php.ini-recommended) file... ------------------------------------------------ safe_mode=off memory_limit=128MB max_execution_time=300 error_reporting = E_ALL & ~E_NOTICE display_errors=On log_errors=On file_uploads=On upload_max_filesize=64MB ------------------------------------------------ I have the php MYSQL and MYSQLI extensions both installed. I've created an alias and a directory entry in my hhtpd.conf file... ------------------------------------------------ Alias /groupoffice "/usr/local/www/groupoffice2" ------------------------------------------------ ------------------------------------------------ <Directory "/usr/local/www/groupoffice2"> Options Indexes FollowSymLinks AllowOverride None Order allow,deny Allow from all </Directory> ------------------------------------------------ Regards, Jazz
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?D8E21250CF3F4353A650AB2ADE6035FF>