I had followed every step as per the manual and in step 4 I get a message 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.
Configuration:
driver = mysql,
host = localhost,
user = mytwirle_sraj49,
database = mytwirle_mbs3,
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_mbs3" exists…
Success! Good, database "mytwirle_mbs3" already exists!
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). Click ‘continue’ to see further instructions.
Couple questions.:
Is your OS linux or windows?
What’s the file name of the OpenEMR that your downloaded (there have been several pre-releases) and what day did you download it? Or are you using most recent CVS version?
What’s your php and mysql version?
In step 1, did you “Have setup create the database”?
Judging from the last line of output, your likely not using the most current CVS version:
should end with:
Done installing and configuring access controls (php-GACL).
Next step will configure PHP.
and not:
Done installing and configuring access controls (php-GACL). Click ‘continue’ to see further instructions.
1) Are you logging your php errors.; this is extremely useful. This is configured in the php.ini file on your server. Don’t use ‘display_errors’, it sucks and causes some errors in openemr. You should turn on ‘log_errors’ and can then select a file at ‘error_log’ (default usually goes to your syslog)
2) I’m assuming you just created a empty database mytwirle_mbs3. Do you have mysqladmin on the server. If so, it would be interesting to see if you have any tables in your mytwirle_mbs3 database after your attempted installation. If so, are there any with the gacl_ prefix?(I’m guessing there aren’t).
3)Have you edited the openemr/gacl/gacl.ini.php or openemr/gacl/gacl.class.php files directly (you shouldn’t have)
Without any of the above info, I’m blindly guessing this is a mysql permission problem (error log should help us out here). It would be very strange if step 3 (openemr mysql stuff) worked fine, but step 4 (phpgacl mysql stuff) didn’t since they are both using same mysql login information.
Another thing I forgot to mention is that your not using the most current development version. If you know how to use CVS, that’s the best way to get most recent development version. I’ll see if we can get a more recent linux development version posted on oemr.org .
1 I enabled the debug and I got to knowthe issues - all with table creation.
2 Yes, I created an empty data base. 100 tables were created in the data base. From the error log lots of coorrection had to be made and I had to crate three more tables making the totla 1003 tables. One of the issue was related to the variable characters if there are more than one with length 240 I was not able to create an index unless I reduce one field length to 90.
3 I have not deited openemr/gacl.ini.php or gacl/gacl.class.php.
4 I do not know how to use CVS but I am sure I can do that if you can gide me.
5 Now I am able to log in. On the left side i have two rows of radio buttons for navigation. Unfortunately it is hideen starting from patient until charges- bot the text and the butoons are not clickable and hidden. Starting from Calendar to Auth/notes i can click. But I am not able to make any entry in the calendar.
I hope these details spark off some solutions that can help me.
I was looking at the demo of cvs version. What I find missing on my screen is the new patient button. Is some file missing in the download or is it not uploaded properly by me… Whihc file creates this New Ptient link?
I compared the 3.0r1 demo on ine and my program. I mentioned to thhat the new patient radio button is no there. I notice the following are not there.
1 Admin
2 New Pt
3 Issues
The above three buttons are missing. For adding calener entry the pop up comes but I am not able to fill in since no patient is availbale in the data base…
I am sure may be missing some files…The patient_data tabel is there in the data base…
I have checked the Php settings through siteground and I also took a printout. Seems OK to me.
> 2 Yes, I created an empty data base. 100 tables were created in
> the data base. From the error log lots of coorrection had to be
> made and I had to crate three more tables making the totla 1003
> tables. One of the issue was related to the variable characters if
> there are more than one with length 240 I was not able to create
> an index unless I reduce one field length to 90.
That is concerning. You should get thru mysql stuff with no errors, and you definitely should not be having to create and correct tables. Sounds like your mysql openemr database is screwed up, which will cause bunch of issues I’m guessing. I’d completely re-install (to remove openemr, just drop your table(mytwirle_mbs3) and delete the openemr directory). Then try it again, and paste the error log file here. Also, try to get the exact mysql version your using.
Current Release 03-05-2009 (Unix/Linux): openemr-3.0-rc1.tar.bz2
I downloaded this throeugh oemr.org site. COmparing with Demo I see all radi buttons except Admin, Billing & Issues. Buttons from auth/notes downwards are not clickable. YOu can log on to this temporary site and use admin and pass to ente and you will see.
I did what you suggested. I deleted the data base, created a new one…openemr to keep it simple…downloaded the files again 3.01rc. It went celan unitl step 4 and then this is what I get. The server is on PHP 5.2 and supports both MySql 4 and 5.
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.
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…
Success! Good, database "mytwirle_openemr" already exists!
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.
I went in to the file gacl/admin/gacl_admin.inc.php. But I am not able to find whee I have to enable the dubug mode. I dont see any statement for Debig there.
Is it some other file? I see the file gacl/gacl.ini.php has a Debug statement as False and should I change that to TRUE. I am not able to find a debug statement in the file indicated in step 4.
Should be fine turning on debug in gacl/gacl.ini.php, but the real money is probably going to be in your PHP log file is; once you get that paste it here. The php log file is set in the php.ini file. In the php.ini file ensure ‘display_errors’ is OFF and ensure ‘log_errors’ is turned ON. You can also specify a log file in php.ini at ‘error_log’ (default usually goes to your syslog).
Are your PHP and mysql on separate servers? It would be helpful to know you exact mysql version you’ve got.
[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
Details of MySql:
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.0.45
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient
php Version 5.x
DOes this help?
I really appreciate your taking time and trying to help out.
Subsequent to the Php error log I sent you, I was checking the code at /home/mytwirle/public_html/openemr/gacl/admin/gacl_admin.inc.php and checking the code it is showing error at the following place:
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;