sraj49 wrote on Friday, March 06, 2009:
Brady,
I keptthe corrected Gacl/admin/gacl_admin.inc.php file as suggested by you , enabled the debug in gacl.ini.php and step 4 is as below.
OpenEMR Setup
Step 4
Installing and Configuring Access Controls (php-GACL)…
Writing php-GACL configuration settings to config files…
Finished writing php-GACL configuration settings to config files.
Option: db_type
Valid Config options: db_type
Option: db_host
Valid Config options: db_host
Option: db_user
Valid Config options: db_user
Option: db_password
Valid Config options: db_password
Option: db_name
Valid Config options: db_name
Option: db_table_prefix
Valid Config options: db_table_prefix
Option: caching
Valid Config options: caching
Option: force_cache_expire
Valid Config options: force_cache_expire
Option: cache_dir
Valid Config options: cache_dir
Option: cache_expire_time
Valid Config options: cache_expire_time
Option: items_per_page
Valid Config options: items_per_page
Option: max_select_box_items
Valid Config options: max_select_box_items
Option: max_search_return_items
Valid Config options: max_search_return_items
Option: smarty_dir
ERROR: Config option: smarty_dir is not a valid option
Option: smarty_template_dir
ERROR: Config option: smarty_template_dir is not a valid option
Option: smarty_compile_dir
ERROR: Config option: smarty_compile_dir is not a valid option
Configuration:
driver = mysql,
host = localhost,
user = mytwirle_sraj49,
database = mytwirle_openemr,
table prefix = gacl_Testing database connection…
Success! Connected to “mysql” database on “localhost”.
Testing database type…
Success! Compatible database type “mysql” detected!
Making sure database “mytwirle_openemr” exists…
(mysql): show databases
Success! Good, database “mytwirle_openemr” already exists!
(mysql): select version()
(mysql): SHOW INDEX FROM gacl_phpgacl
1146: Table ‘mytwirle_openemr.gacl_phpgacl’ doesn’t exist
(mysql): SHOW COLUMNS FROM `gacl_phpgacl`
1146: Table ‘mytwirle_openemr.gacl_phpgacl’ doesn’t exist
(mysql): SHOW INDEX FROM gacl_acl
1146: Table ‘mytwirle_openemr.gacl_acl’ doesn’t exist
(mysql): SHOW COLUMNS FROM `gacl_acl`
1146: Table ‘mytwirle_openemr.gacl_acl’ doesn’t exist
(mysql): SHOW INDEX FROM gacl_acl_sections
1146: Table ‘mytwirle_openemr.gacl_acl_sections’ doesn’t exist
(mysql): SHOW COLUMNS FROM `gacl_acl_sections`
1146: Table ‘mytwirle_openemr.gacl_acl_sections’ doesn’t exist
(mysql): SHOW INDEX FROM gacl_aco
1146: Table ‘mytwirle_openemr.gacl_aco’ doesn’t exist
(mysql): SHOW COLUMNS FROM `gacl_aco`
1146: Table ‘mytwirle_openemr.gacl_aco’ doesn’t exist
(mysql): SHOW INDEX FROM gacl_aco_map
1146: Table ‘mytwirle_openemr.gacl_aco_map’ doesn’t exist
(mysql): SHOW COLUMNS FROM `gacl_aco_map`
1146: Table ‘mytwirle_openemr.gacl_aco_map’ doesn’t exist
(mysql): SHOW INDEX FROM gacl_aco_sections
1146: Table ‘mytwirle_openemr.gacl_aco_sections’ doesn’t exist
(mysql): SHOW COLUMNS FROM `gacl_aco_sections`
1146: Table ‘mytwirle_openemr.gacl_aco_sections’ doesn’t exist
(mysql): SHOW INDEX FROM gacl_aro
1146: Table ‘mytwirle_openemr.gacl_aro’ doesn’t exist
(mysql): SHOW COLUMNS FROM `gacl_aro`
1146: Table ‘mytwirle_openemr.gacl_aro’ doesn’t exist
(mysql): SHOW INDEX FROM gacl_aro_map
1146: Table ‘mytwirle_openemr.gacl_aro_map’ doesn’t exist
(mysql): SHOW COLUMNS FROM `gacl_aro_map`
1146: Table ‘mytwirle_openemr.gacl_aro_map’ doesn’t exist
(mysql): SHOW INDEX FROM gacl_aro_sections
1146: Table ‘mytwirle_openemr.gacl_aro_sections’ doesn’t exist
(mysql): SHOW COLUMNS FROM `gacl_aro_sections`
1146: Table ‘mytwirle_openemr.gacl_aro_sections’ doesn’t exist
(mysql): SHOW INDEX FROM gacl_axo
1146: Table ‘mytwirle_openemr.gacl_axo’ doesn’t exist
(mysql): SHOW COLUMNS FROM `gacl_axo`
1146: Table ‘mytwirle_openemr.gacl_axo’ doesn’t exist
(mysql): SHOW INDEX FROM gacl_axo_map
1146: Table ‘mytwirle_openemr.gacl_axo_map’ doesn’t exist
(mysql): SHOW COLUMNS FROM `gacl_axo_map`
1146: Table ‘mytwirle_openemr.gacl_axo_map’ doesn’t exist
(mysql): SHOW INDEX FROM gacl_axo_sections
1146: Table ‘mytwirle_openemr.gacl_axo_sections’ doesn’t exist
(mysql): SHOW COLUMNS FROM `gacl_axo_sections`
1146: Table ‘mytwirle_openemr.gacl_axo_sections’ doesn’t exist
(mysql): SHOW INDEX FROM gacl_aro_groups
1146: Table ‘mytwirle_openemr.gacl_aro_groups’ doesn’t exist
(mysql): SHOW COLUMNS FROM `gacl_aro_groups`
1146: Table ‘mytwirle_openemr.gacl_aro_groups’ doesn’t exist
(mysql): SHOW INDEX FROM gacl_groups_aro_map
1146: Table ‘mytwirle_openemr.gacl_groups_aro_map’ doesn’t exist
(mysql): SHOW COLUMNS FROM `gacl_groups_aro_map`
1146: Table ‘mytwirle_openemr.gacl_groups_aro_map’ doesn’t exist
(mysql): SHOW INDEX FROM gacl_aro_groups_map
1146: Table ‘mytwirle_openemr.gacl_aro_groups_map’ doesn’t exist
(mysql): SHOW COLUMNS FROM `gacl_aro_groups_map`
1146: Table ‘mytwirle_openemr.gacl_aro_groups_map’ doesn’t exist
(mysql): SHOW INDEX FROM gacl_axo_groups
1146: Table ‘mytwirle_openemr.gacl_axo_groups’ doesn’t exist
(mysql): SHOW COLUMNS FROM `gacl_axo_groups`
1146: Table ‘mytwirle_openemr.gacl_axo_groups’ doesn’t exist
(mysql): SHOW INDEX FROM gacl_groups_axo_map
1146: Table ‘mytwirle_openemr.gacl_groups_axo_map’ doesn’t exist
(mysql): SHOW COLUMNS FROM `gacl_groups_axo_map`
1146: Table ‘mytwirle_openemr.gacl_groups_axo_map’ doesn’t exist
(mysql): SHOW INDEX FROM gacl_axo_groups_map
1146: Table ‘mytwirle_openemr.gacl_axo_groups_map’ doesn’t exist
(mysql): SHOW COLUMNS FROM `gacl_axo_groups_map`
1146: Table ‘mytwirle_openemr.gacl_axo_groups_map’ doesn’t exist
Here’s the SQL to do the build:
CREATE TABLE gacl_phpgacl (
name VARCHAR(230) NOT NULL,
value VARCHAR(230) NOT NULL,
PRIMARY KEY (name)
);
DELETE FROM gacl_phpgacl WHERE name=‘version’;
INSERT INTO gacl_phpgacl (name,value) VALUES (‘version’,‘3.3.7’);
DELETE FROM gacl_phpgacl WHERE name=‘schema_version’;
INSERT INTO gacl_phpgacl (name,value) VALUES (‘schema_version’,‘2.1’);
CREATE TABLE gacl_acl (
id INTEGER NOT NULL DEFAULT 0,
section_value VARCHAR(230) NOT NULL DEFAULT ‘system’,
allow INTEGER NOT NULL DEFAULT 0,
enabled INTEGER NOT NULL DEFAULT 0,
return_value TEXT,
note TEXT,
updated_date INTEGER NOT NULL DEFAULT 0,
PRIMARY KEY (id)
);
ALTER TABLE gacl_acl ADD INDEX gacl_enabled_acl (enabled);
ALTER TABLE gacl_acl ADD INDEX gacl_section_value_acl (section_value);
ALTER TABLE gacl_acl ADD INDEX gacl_updated_date_acl (updated_date);
CREATE TABLE gacl_acl_sections (
id INTEGER NOT NULL DEFAULT 0,
value VARCHAR(230) NOT NULL,
order_value INTEGER NOT NULL DEFAULT 0,
name VARCHAR(230) NOT NULL,
hidden INTEGER NOT NULL DEFAULT 0,
PRIMARY KEY (id)
);
ALTER TABLE gacl_acl_sections ADD UNIQUE INDEX gacl_value_acl_sections (value);
ALTER TABLE gacl_acl_sections ADD INDEX gacl_hidden_acl_sections (hidden);
DELETE FROM gacl_acl_sections WHERE id=1 AND value=‘system’;
INSERT INTO gacl_acl_sections (id,value,order_value,name) VALUES (1,‘system’,1,‘System’);
DELETE FROM gacl_acl_sections WHERE id=2 AND value=‘user’;
INSERT INTO gacl_acl_sections (id,value,order_value,name) VALUES (2,‘user’,2,‘User’);
CREATE TABLE gacl_aco (
id INTEGER NOT NULL DEFAULT 0,
section_value VARCHAR(240) NOT NULL DEFAULT ‘0’,
value VARCHAR(240) NOT NULL,
order_value INTEGER NOT NULL DEFAULT 0,
name VARCHAR(255) NOT NULL,
hidden INTEGER NOT NULL DEFAULT 0,
PRIMARY KEY (id)
);
ALTER TABLE gacl_aco ADD UNIQUE INDEX gacl_section_value_value_aco (section_value, value);
ALTER TABLE gacl_aco ADD INDEX gacl_hidden_aco (hidden);
CREATE TABLE gacl_aco_map (
acl_id INTEGER NOT NULL DEFAULT 0,
section_value VARCHAR(230) NOT NULL DEFAULT ‘0’,
value VARCHAR(230) NOT NULL,
PRIMARY KEY (acl_id, section_value, value)
);
CREATE TABLE gacl_aco_sections (
id INTEGER NOT NULL DEFAULT 0,
value VARCHAR(230) NOT NULL,
order_value INTEGER NOT NULL DEFAULT 0,
name VARCHAR(230) NOT NULL,
hidden INTEGER NOT NULL DEFAULT 0,
PRIMARY KEY (id)
);
ALTER TABLE gacl_aco_sections ADD UNIQUE INDEX gacl_value_aco_sections (value);
ALTER TABLE gacl_aco_sections ADD INDEX gacl_hidden_aco_sections (hidden);
CREATE TABLE gacl_aro (
id INTEGER NOT NULL DEFAULT 0,
section_value VARCHAR(240) NOT NULL DEFAULT ‘0’,
value VARCHAR(240) NOT NULL,
order_value INTEGER NOT NULL DEFAULT 0,
name VARCHAR(255) NOT NULL,
hidden INTEGER NOT NULL DEFAULT 0,
PRIMARY KEY (id)
);
ALTER TABLE gacl_aro ADD UNIQUE INDEX gacl_section_value_value_aro (section_value, value);
ALTER TABLE gacl_aro ADD INDEX gacl_hidden_aro (hidden);
CREATE TABLE gacl_aro_map (
acl_id INTEGER NOT NULL DEFAULT 0,
section_value VARCHAR(230) NOT NULL DEFAULT ‘0’,
value VARCHAR(230) NOT NULL,
PRIMARY KEY (acl_id, section_value, value)
);
CREATE TABLE gacl_aro_sections (
id INTEGER NOT NULL DEFAULT 0,
value VARCHAR(230) NOT NULL,
order_value INTEGER NOT NULL DEFAULT 0,
name VARCHAR(230) NOT NULL,
hidden INTEGER NOT NULL DEFAULT 0,
PRIMARY KEY (id)
);
ALTER TABLE gacl_aro_sections ADD UNIQUE INDEX gacl_value_aro_sections (value);
ALTER TABLE gacl_aro_sections ADD INDEX gacl_hidden_aro_sections (hidden);
CREATE TABLE gacl_axo (
id INTEGER NOT NULL DEFAULT 0,
section_value VARCHAR(240) NOT NULL DEFAULT ‘0’,
value VARCHAR(240) NOT NULL,
order_value INTEGER NOT NULL DEFAULT 0,
name VARCHAR(255) NOT NULL,
hidden INTEGER NOT NULL DEFAULT 0,
PRIMARY KEY (id)
);
ALTER TABLE gacl_axo ADD UNIQUE INDEX gacl_section_value_value_axo (section_value, value);
ALTER TABLE gacl_axo ADD INDEX gacl_hidden_axo (hidden);
CREATE TABLE gacl_axo_map (
acl_id INTEGER NOT NULL DEFAULT 0,
section_value VARCHAR(230) NOT NULL DEFAULT ‘0’,
value VARCHAR(230) NOT NULL,
PRIMARY KEY (acl_id, section_value, value)
);
CREATE TABLE gacl_axo_sections (
id INTEGER NOT NULL DEFAULT 0,
value VARCHAR(230) NOT NULL,
order_value INTEGER NOT NULL DEFAULT 0,
name VARCHAR(230) NOT NULL,
hidden INTEGER NOT NULL DEFAULT 0,
PRIMARY KEY (id)
);
ALTER TABLE gacl_axo_sections ADD UNIQUE INDEX gacl_value_axo_sections (value);
ALTER TABLE gacl_axo_sections ADD INDEX gacl_hidden_axo_sections (hidden);
CREATE TABLE gacl_aro_groups (
id INTEGER NOT NULL DEFAULT 0,
parent_id INTEGER NOT NULL DEFAULT 0,
lft INTEGER NOT NULL DEFAULT 0,
rgt INTEGER NOT NULL DEFAULT 0,
name VARCHAR(255) NOT NULL,
value VARCHAR(255) NOT NULL,
PRIMARY KEY (id, value)
);
ALTER TABLE gacl_aro_groups ADD INDEX gacl_parent_id_aro_groups (parent_id);
ALTER TABLE gacl_aro_groups ADD UNIQUE INDEX gacl_value_aro_groups (value);
ALTER TABLE gacl_aro_groups ADD INDEX gacl_lft_rgt_aro_groups (lft, rgt);
CREATE TABLE gacl_groups_aro_map (
group_id INTEGER NOT NULL DEFAULT 0,
aro_id INTEGER NOT NULL DEFAULT 0,
PRIMARY KEY (group_id, aro_id)
);
ALTER TABLE gacl_groups_aro_map ADD INDEX gacl_aro_id (aro_id);
CREATE TABLE gacl_aro_groups_map (
acl_id INTEGER NOT NULL DEFAULT 0,
group_id INTEGER NOT NULL DEFAULT 0,
PRIMARY KEY (acl_id, group_id)
);
CREATE TABLE gacl_axo_groups (
id INTEGER NOT NULL DEFAULT 0,
parent_id INTEGER NOT NULL DEFAULT 0,
lft INTEGER NOT NULL DEFAULT 0,
rgt INTEGER NOT NULL DEFAULT 0,
name VARCHAR(255) NOT NULL,
value VARCHAR(255) NOT NULL,
PRIMARY KEY (id, value)
);
ALTER TABLE gacl_axo_groups ADD INDEX gacl_parent_id_axo_groups (parent_id);
ALTER TABLE gacl_axo_groups ADD UNIQUE INDEX gacl_value_axo_groups (value);
ALTER TABLE gacl_axo_groups ADD INDEX gacl_lft_rgt_axo_groups (lft, rgt);
CREATE TABLE gacl_groups_axo_map (
group_id INTEGER NOT NULL DEFAULT 0,
axo_id INTEGER NOT NULL DEFAULT 0,
PRIMARY KEY (group_id, axo_id)
);
ALTER TABLE gacl_groups_axo_map ADD INDEX gacl_axo_id (axo_id);
CREATE TABLE gacl_axo_groups_map (
acl_id INTEGER NOT NULL DEFAULT 0,
group_id INTEGER NOT NULL DEFAULT 0,
PRIMARY KEY (acl_id, group_id)
);
(mysql): CREATE TABLE gacl_phpgacl ( name VARCHAR(230) NOT NULL, value VARCHAR(230) NOT NULL, PRIMARY KEY (name) )
(mysql): DELETE FROM gacl_phpgacl WHERE name=‘version’
(mysql): INSERT INTO gacl_phpgacl (name,value) VALUES (‘version’,‘3.3.7’)
(mysql): DELETE FROM gacl_phpgacl WHERE name=‘schema_version’
(mysql): INSERT INTO gacl_phpgacl (name,value) VALUES (‘schema_version’,‘2.1’)
(mysql): CREATE TABLE gacl_acl ( id INTEGER NOT NULL DEFAULT 0, section_value VARCHAR(230) NOT NULL DEFAULT ‘system’, allow INTEGER NOT NULL DEFAULT 0, enabled INTEGER NOT NULL DEFAULT 0, return_value TEXT, note TEXT, updated_date INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (id) )
(mysql): ALTER TABLE gacl_acl ADD INDEX gacl_enabled_acl (enabled)
(mysql): ALTER TABLE gacl_acl ADD INDEX gacl_section_value_acl (section_value)
(mysql): ALTER TABLE gacl_acl ADD INDEX gacl_updated_date_acl (updated_date)
(mysql): CREATE TABLE gacl_acl_sections ( id INTEGER NOT NULL DEFAULT 0, value VARCHAR(230) NOT NULL, order_value INTEGER NOT NULL DEFAULT 0, name VARCHAR(230) NOT NULL, hidden INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (id) )
(mysql): ALTER TABLE gacl_acl_sections ADD UNIQUE INDEX gacl_value_acl_sections (value)
(mysql): ALTER TABLE gacl_acl_sections ADD INDEX gacl_hidden_acl_sections (hidden)
(mysql): DELETE FROM gacl_acl_sections WHERE id=1 AND value=‘system’
(mysql): INSERT INTO gacl_acl_sections (id,value,order_value,name) VALUES (1,‘system’,1,‘System’)
(mysql): DELETE FROM gacl_acl_sections WHERE id=2 AND value=‘user’
(mysql): INSERT INTO gacl_acl_sections (id,value,order_value,name) VALUES (2,‘user’,2,‘User’)
(mysql): CREATE TABLE gacl_aco ( id INTEGER NOT NULL DEFAULT 0, section_value VARCHAR(240) NOT NULL DEFAULT ‘0’, value VARCHAR(240) NOT NULL, order_value INTEGER NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL, hidden INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (id) )
(mysql): ALTER TABLE gacl_aco ADD UNIQUE INDEX gacl_section_value_value_aco (section_value, value)
1071: Specified key was too long; max key length is 1000 bytes
(mysql): ALTER TABLE gacl_aco ADD INDEX gacl_hidden_aco (hidden)
(mysql): CREATE TABLE gacl_aco_map ( acl_id INTEGER NOT NULL DEFAULT 0, section_value VARCHAR(230) NOT NULL DEFAULT ‘0’, value VARCHAR(230) NOT NULL, PRIMARY KEY (acl_id, section_value, value) )
1071: Specified key was too long; max key length is 1000 bytes
(mysql): CREATE TABLE gacl_aco_sections ( id INTEGER NOT NULL DEFAULT 0, value VARCHAR(230) NOT NULL, order_value INTEGER NOT NULL DEFAULT 0, name VARCHAR(230) NOT NULL, hidden INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (id) )
(mysql): ALTER TABLE gacl_aco_sections ADD UNIQUE INDEX gacl_value_aco_sections (value)
(mysql): ALTER TABLE gacl_aco_sections ADD INDEX gacl_hidden_aco_sections (hidden)
(mysql): CREATE TABLE gacl_aro ( id INTEGER NOT NULL DEFAULT 0, section_value VARCHAR(240) NOT NULL DEFAULT ‘0’, value VARCHAR(240) NOT NULL, order_value INTEGER NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL, hidden INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (id) )
(mysql): ALTER TABLE gacl_aro ADD UNIQUE INDEX gacl_section_value_value_aro (section_value, value)
1071: Specified key was too long; max key length is 1000 bytes
(mysql): ALTER TABLE gacl_aro ADD INDEX gacl_hidden_aro (hidden)
(mysql): CREATE TABLE gacl_aro_map ( acl_id INTEGER NOT NULL DEFAULT 0, section_value VARCHAR(230) NOT NULL DEFAULT ‘0’, value VARCHAR(230) NOT NULL, PRIMARY KEY (acl_id, section_value, value) )
1071: Specified key was too long; max key length is 1000 bytes
(mysql): CREATE TABLE gacl_aro_sections ( id INTEGER NOT NULL DEFAULT 0, value VARCHAR(230) NOT NULL, order_value INTEGER NOT NULL DEFAULT 0, name VARCHAR(230) NOT NULL, hidden INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (id) )
(mysql): ALTER TABLE gacl_aro_sections ADD UNIQUE INDEX gacl_value_aro_sections (value)
(mysql): ALTER TABLE gacl_aro_sections ADD INDEX gacl_hidden_aro_sections (hidden)
(mysql): CREATE TABLE gacl_axo ( id INTEGER NOT NULL DEFAULT 0, section_value VARCHAR(240) NOT NULL DEFAULT ‘0’, value VARCHAR(240) NOT NULL, order_value INTEGER NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL, hidden INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (id) )
(mysql): ALTER TABLE gacl_axo ADD UNIQUE INDEX gacl_section_value_value_axo (section_value, value)
1071: Specified key was too long; max key length is 1000 bytes
(mysql): ALTER TABLE gacl_axo ADD INDEX gacl_hidden_axo (hidden)
(mysql): CREATE TABLE gacl_axo_map ( acl_id INTEGER NOT NULL DEFAULT 0, section_value VARCHAR(230) NOT NULL DEFAULT ‘0’, value VARCHAR(230) NOT NULL, PRIMARY KEY (acl_id, section_value, value) )
1071: Specified key was too long; max key length is 1000 bytes
(mysql): CREATE TABLE gacl_axo_sections ( id INTEGER NOT NULL DEFAULT 0, value VARCHAR(230) NOT NULL, order_value INTEGER NOT NULL DEFAULT 0, name VARCHAR(230) NOT NULL, hidden INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (id) )
(mysql): ALTER TABLE gacl_axo_sections ADD UNIQUE INDEX gacl_value_axo_sections (value)
(mysql): ALTER TABLE gacl_axo_sections ADD INDEX gacl_hidden_axo_sections (hidden)
(mysql): CREATE TABLE gacl_aro_groups ( id INTEGER NOT NULL DEFAULT 0, parent_id INTEGER NOT NULL DEFAULT 0, lft INTEGER NOT NULL DEFAULT 0, rgt INTEGER NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL, value VARCHAR(255) NOT NULL, PRIMARY KEY (id, value) )
(mysql): ALTER TABLE gacl_aro_groups ADD INDEX gacl_parent_id_aro_groups (parent_id)
(mysql): ALTER TABLE gacl_aro_groups ADD UNIQUE INDEX gacl_value_aro_groups (value)
(mysql): ALTER TABLE gacl_aro_groups ADD INDEX gacl_lft_rgt_aro_groups (lft, rgt)
(mysql): CREATE TABLE gacl_groups_aro_map ( group_id INTEGER NOT NULL DEFAULT 0, aro_id INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (group_id, aro_id) )
(mysql): ALTER TABLE gacl_groups_aro_map ADD INDEX gacl_aro_id (aro_id)
(mysql): CREATE TABLE gacl_aro_groups_map ( acl_id INTEGER NOT NULL DEFAULT 0, group_id INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (acl_id, group_id) )
(mysql): CREATE TABLE gacl_axo_groups ( id INTEGER NOT NULL DEFAULT 0, parent_id INTEGER NOT NULL DEFAULT 0, lft INTEGER NOT NULL DEFAULT 0, rgt INTEGER NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL, value VARCHAR(255) NOT NULL, PRIMARY KEY (id, value) )
(mysql): ALTER TABLE gacl_axo_groups ADD INDEX gacl_parent_id_axo_groups (parent_id)
(mysql): ALTER TABLE gacl_axo_groups ADD UNIQUE INDEX gacl_value_axo_groups (value)
(mysql): ALTER TABLE gacl_axo_groups ADD INDEX gacl_lft_rgt_axo_groups (lft, rgt)
(mysql): CREATE TABLE gacl_groups_axo_map ( group_id INTEGER NOT NULL DEFAULT 0, axo_id INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (group_id, axo_id) )
(mysql): ALTER TABLE gacl_groups_axo_map ADD INDEX gacl_axo_id (axo_id)
(mysql): CREATE TABLE gacl_axo_groups_map ( acl_id INTEGER NOT NULL DEFAULT 0, group_id INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (acl_id, group_id) )
Failed! Failed creating tables. Please enable DEBUG mode (set it to TRUE in $gacl_options near top of admin/gacl_admin.inc.php) to see the error and try again. You will most likely need to delete any tables already created.
Failed! Please fix the above errors and try again.
OpenEMR ACL Setup
All done configuring and installing access controls (php-GACL)!
Gave the ‘admin’ user (password is ‘pass’) administrator access.
Done installing and configuring access controls (php-GACL).
Next step will configure PHP.
THE PHP ERROR LOG is as below.
[05-Mar-2009 23:06:47] PHP Fatal error: require_once() [<a href=‘function.require’>function.require</a>]: Failed opening required ‘/Smarty.class.php’ (include_path=’.:/usr/local/php52/pear’) in /home/mytwirle/public_html/openemr/gacl/admin/gacl_admin.inc.php on line 62
[05-Mar-2009 23:13:11] PHP Fatal error: require_once() [<a href=‘function.require’>function.require</a>]: Failed opening required ‘/Smarty.class.php’ (include_path=’.:/usr/local/php52/pear’) in /home/mytwirle/public_html/openemr/gacl/admin/gacl_admin.inc.php on line 65
[05-Mar-2009 23:28:32] PHP Parse error: syntax error, unexpected T_ELSE in /home/mytwirle/public_html/openemr/gacl/admin/gacl_admin.inc.php on line 51
[05-Mar-2009 23:41:17] PHP Fatal error: require_once() [<a href=‘function.require’>function.require</a>]: Failed opening required ‘/Smarty.class.php’ (include_path=’.:/usr/local/php52/pear’) in /home/mytwirle/public_html/openemr/gacl/admin/gacl_admin.inc.php on line 79
[05-Mar-2009 23:46:38] PHP Fatal error: require_once() [<a href=‘function.require’>function.require</a>]: Failed opening required ‘/Smarty.class.php’ (include_path=’.:/usr/local/php52/pear’) in /home/mytwirle/public_html/openemr/gacl/admin/gacl_admin.inc.php on line 81
[06-Mar-2009 11:28:36] PHP Fatal error: require_once() [<a href=‘function.require’>function.require</a>]: Failed opening required ‘smarty/libssmarty/lib/Smarty.class.php’ (include_path=’.:/usr/local/php52/pear’) in /home/mytwirle/public_html/openemr/gacl/admin/gacl_admin.inc.php on line 65
[06-Mar-2009 13:02:38] PHP Warning: include_once(gacl/gacl.class.php) [<a href=‘function.include-once’>function.include-once</a>]: failed to open stream: No such file or directory in /home/mytwirle/public_html/openemr/library/acl.inc on line 82
[06-Mar-2009 13:02:38] PHP Warning: include_once() [<a href=‘function.include’>function.include</a>]: Failed opening ‘gacl/gacl.class.php’ for inclusion (include_path=‘get_include_path:/home/mytwirle/public_html/openemr/gacl/admin//smarty/libs/’) in /home/mytwirle/public_html/openemr/library/acl.inc on line 82
[06-Mar-2009 13:02:38] PHP Warning: include_once(gacl/gacl_api.class.php) [<a href=‘function.include-once’>function.include-once</a>]: failed to open stream: No such file or directory in /home/mytwirle/public_html/openemr/library/acl.inc on line 296
[06-Mar-2009 13:02:38] PHP Warning: include_once() [<a href=‘function.include’>function.include</a>]: Failed opening ‘gacl/gacl_api.class.php’ for inclusion (include_path=‘get_include_path:/home/mytwirle/public_html/openemr/gacl/admin//smarty/libs/’) in /home/mytwirle/public_html/openemr/library/acl.inc on line 296
[06-Mar-2009 14:25:59] PHP Fatal error: require_once() [<a href=‘function.require’>function.require</a>]: Failed opening required ‘/home/mytwirle/public_html/openemr/gacl/adminsmarty/libs/Smarty.class.php’ (include_path=’.:/usr/local/php52/pear’) in /home/mytwirle/public_html/openemr/gacl/admin/gacl_admin.inc.php on line 62
[06-Mar-2009 14:28:26] PHP Fatal error: require_once() [<a href=‘function.require’>function.require</a>]: Failed opening required ‘/home/mytwirle/public_html/openemr/gacl/adminsmarty/libs/Smarty.class.php’ (include_path=’.:/usr/local/php52/pear’) in /home/mytwirle/public_html/openemr/gacl/admin/gacl_admin.inc.php on line 62
[06-Mar-2009 15:04:37] PHP Fatal error: require_once() [<a href=‘function.require’>function.require</a>]: Failed opening required ‘/smarty/libs/Smarty.class.php’ (include_path=’.:/usr/local/php52/pear’) in /home/mytwirle/public_html/openemr/gacl/admin/gacl_admin.inc.php on line 62
[06-Mar-2009 15:13:45] PHP Fatal error: require_once() [<a href=‘function.require’>function.require</a>]: Failed opening required ‘/smarty/libs/Smarty.class.php’ (include_path=’.:/usr/local/php52/pear’) in /home/mytwirle/public_html/openemr/gacl/admin/gacl_admin.inc.php on line 62
[06-Mar-2009 15:30:22] PHP Fatal error: require_once() [<a href=‘function.require’>function.require</a>]: Failed opening required ‘/smarty/libs/Smarty.class.php’ (include_path=’.:/usr/local/php52/pear’) in /home/mytwirle/public_html/openemr/gacl/admin/gacl_admin.inc.php on line 62
[06-Mar-2009 15:33:49] PHP Fatal error: require_once() [<a href=‘function.require’>function.require</a>]: Failed opening required ‘/smarty/libs/Smarty.class.php’ (include_path=’.:/usr/local/php52/pear’) in /home/mytwirle/public_html/openemr/gacl/admin/gacl_admin.inc.php on line 62
[06-Mar-2009 15:35:17] PHP Fatal error: require_once() [<a href=‘function.require’>function.require</a>]: Failed opening required ‘/smarty/libs/Smarty.class.php’ (include_path=’.:/usr/local/php52/pear’) in /home/mytwirle/public_html/openemr/gacl/admin/gacl_admin.inc.php on line 62
Raj
Please submit patches if you find any I may have missed.