sraj49 wrote on Friday, March 06, 2009:
Brady,
Do you need access to my cpanel and sql? My email id is : sraj1949@comcast.net or 9169903180 cell /916 458 6482 land line.
Raj
bradymiller wrote on Friday, March 06, 2009:
hey,
Time to try a new strategy.
drop database and delete we directory
turn debug on in gacl.ini.php
In openemr/gacl/admin/gacl_admin.inc.php file:
Above line 61 insert the following:
$gacl_options[‘smarty_dir’] = dirname(__FILE__).’/’.$gacl_options[‘smarty_dir’];
$gacl_options[‘smarty_template_dir’] = dirname(__FILE__).’/’.$gacl_options[‘smarty_template_dir’];
$gacl_options[‘smarty_compile_dir’] = dirname(__FILE__).’/’.$gacl_options[‘smarty_compile_dir’];
install
This is just a quick hack, gonna have to figure out a better way to deal with these path problems
-brady
sraj49 wrote on Friday, March 06, 2009:
Brady,
I am a little confused. Pardon me since I am not a software guy.
1 drop database and delete we directory
Deleted the data base completely. What is we directory?
2 When I run set up again shoud I choose Create a table option…There is an issue here since I wll not have access o the root of Sql although I can create an empty Data Base and have all privileges.
3 I have trund the debug on in Gacl.ini.php file.
4 I have modifed the file by including the three statements. looks as below…
<?php
/*
* phpGACL - Generic Access Control List
* Copyright (C) 2002 Mike Benoit
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*
* For questions, help, comments, discussion, etc., please join the
* phpGACL mailing list. http://sourceforge.net/mail/?group_id=57103
*
* You may contact the author of phpGACL by e-mail at:
* ipso@snappymail.ca
*
* The latest version of phpGACL can be obtained from:
* http://phpgacl.sourceforge.net/
*
*/
require_once(dirname(__FILE__).’/…/gacl.class.php’);
require_once(dirname(__FILE__).’/…/gacl_api.class.php’);
require_once(dirname(__FILE__).’/gacl_admin_api.class.php’);
// phpGACL Configuration file.
if ( !isset($config_file) ) {
# $config_file = ‘…/gacl.ini.php’;
$config_file = dirname(__FILE__).’/…/gacl.ini.php’;
}
//Values supplied in $gacl_options array overwrite those in the config file.
if ( file_exists($config_file) ) {
$config = parse_ini_file($config_file);
if ( is_array($config) ) {
if ( isset($gacl_options) ) {
$gacl_options = array_merge($config, $gacl_options);
} else {
$gacl_options = $config;
}
}
unset($config);
}
$gacl_api = new gacl_admin_api($gacl_options);
$gacl = &$gacl_api;
$db = &$gacl->db;
$gacl_options[‘smarty_dir’] = dirname(__FILE__).’/’.$gacl_options[‘smarty_dir’];
$gacl_options[‘smarty_template_dir’] = dirname(__FILE__).’/’.$gacl_options[‘smarty_template_dir’];
$gacl_options[‘smarty_compile_dir’] = dirname(__FILE__).’/’.$gacl_options[‘smarty_compile_dir’];
//Setup the Smarty Class.
require_once(dirname(__FILE__).’/’.$gacl_options[‘smarty_dir’].’/Smarty.class.php’);
$smarty = new Smarty;
$smarty->compile_check = TRUE;
$smarty->template_dir = $gacl_options[‘smarty_template_dir’];
$smarty->compile_dir = $gacl_options[‘smarty_compile_dir’];
/*
* Email address used in setup.php, please do not change.
*/
$author_email = ‘ipso@snappymail.ca’;
/*
* Don’t need to show notices, some of them are pretty lame and people get overly worried when they see them.
* Mean while I will try to fix most of these. 
Please submit patches if you find any I may have missed.
*/
error_reporting (E_ALL ^ E_NOTICE);
?>
Thanks for your understanding
Raj
bradymiller wrote on Friday, March 06, 2009:
hey,
Don’t worry about it. It won’t work. I just sent you an email (gonna compare your debug script with mine for discrepancies) so we don’t drive people following the forums mad.
-brady
sraj49 wrote on Friday, March 06, 2009:
Thanks Brady…I was afriad of that . Spare the world…lol
I am yet to get the email.
Raj
sraj49 wrote on Saturday, March 07, 2009:
Brady,
Did you send it to sraj1949@comcast.net? you can cpy to sraj49@gamil.com also.
Thanks
Raj
bradymiller wrote on Saturday, March 07, 2009:
hey,
Figure I’d post the problem and solution.
problem:
The database Raj was using was set by default to use the UTF-8 character set. Because of this, the php-gacl database could not be installed correctly secondary to indexes/keys being over size limits (this produced several ‘1071: Specified key was too long; max key length is 1000 bytes’ errors buried in php-gacl debug output). The default out of box mysql settings are the ‘latin1’ character set and ‘latin1-swedish-ci’ collation, which is why this problem is very infrequent (a developer, or in Raj’s case a service provider has to go out of their way to change the mysql defaults to UTF-8).
solution:
When creating the database on a mysql server that has globally changed its default to UTF-8, select the ‘latin1’ character set and the ‘latin1-swedish-ci’ collation when creating the database. (This does not get in the way of OpenEMR’s main database using UTF-8, because OpenEMR explicitly creates each table in UTF-8 during installation).
-Brady
jvorstermans wrote on Saturday, March 14, 2009:
Just installed Openemr 3.0 on Debian Etch - install went perfect.
Magic.
- John