Gacl.ini.php?

OpenEMR Development
1

dlee5400 wrote on Tuesday, November 17, 2009:

I truned the “debug” option to “True” because I am getting a blank screen each time i press the Advance link next to Access Control List Administration  (Advanced)"  in Administrator ->  ACL. Now it returns the following message, any advice on how to fix this? I tried changing the paths in the gacl.ini.php with no results…. Here is a copy of the message: `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
NOT EDITING ACL
=— (mysql): SELECT value, name FROM gacl_acl_sections WHERE hidden=0 ORDER BY order_value, name — =— (mysql): SELECT value, name FROM gacl_aco_sections WHERE hidden=0 ORDER BY order_value, name — =— (mysql): SELECT value, name FROM gacl_aro_sections WHERE hidden=0 ORDER BY order_value, name — =— (mysql): SELECT value, name FROM gacl_axo_sections WHERE hidden=0 ORDER BY order_value, name — =— (mysql): SELECT section_value, value, name FROM gacl_aco WHERE hidden=0 ORDER BY section_value, order_value, name LIMIT 100 — =— (mysql): SELECT section_value, value, name FROM gacl_aro WHERE hidden=0 ORDER BY section_value, order_value, name LIMIT 100 — =— (mysql): SELECT section_value, value, name FROM gacl_axo WHERE hidden=0 ORDER BY section_value, order_value, name LIMIT 100 — =— (mysql): SELECT id, parent_id, name FROM gacl_aro_groups ORDER BY parent_id, name — =— (mysql): SELECT id, parent_id, name FROM gacl_axo_groups ORDER BY parent_id, name — =— (mysql): select value from gacl_phpgacl where name = ‘version’ LIMIT 1 — =— (mysql): select value from gacl_phpgacl where name = ‘schema_version’ LIMIT 1 — `

2

bradymiller wrote on Tuesday, November 17, 2009:

hey,

What’s your operating system?

What’s your OpenEMR version (and is it an upgrade or a new install)?

I’m guessing it’s related to your openemr/gacl/admin/templates_c folder permissions, but need to know answer to above questions to be sure.

-brady

3

dlee5400 wrote on Tuesday, November 17, 2009:

Sorry about that : WIN 2003 Server, IIS 6, New Installed OpenEMR 3.1.0 patch 3 applied… I will check templates_c folder permissions

4

dlee5400 wrote on Tuesday, November 17, 2009:

In IIS the templates_c has RW - Script/Excutable - Looking from server level directory Admin - All Rights, Creator Owner - No Rights, System - All Rights, Users (Server) - Read&Execu - List Folders - Read - Write

5

bradymiller wrote on Tuesday, November 17, 2009:

hey,

IIS, so all bets are off here.

Is the acl->adminstration stuff working?; compare it to the online demos in wiki at oemr.org. Can you create a dummy user and do the following:

1) don’t give access to admin stuff (then when login with dummy user should be no administration option in menu)

2) remove dummy user from all groups (then should not be able to login with dummy user)

I remember you were having issues even with php-gacl install screen (during openemr install); if that’s still an issue then would be interesting to see the what output you get with the “debug” option set to on during install.

Some other random things:

1)Can you create a new patient ok?

2)Ensure your php settings are correct:

[What are you mysql and php version?

-brady

  : http://www.openmedsoftware.org/wiki/FAQ#What_are_the_correct_PHP_settings_.28can_be_found_in_the_php.ini_file.29_.3F](http://to%20Correct%20php%20settings%20here)

6

dlee5400 wrote on Tuesday, November 17, 2009:

PHP 5.1.40 and MySQL 5.1.40-community; I did change some settings and i think i got a clean install with every step completed. But I can run it again and check.

I will run your scenarios above and check back with you. Thanks!

7

dlee5400 wrote on Tuesday, November 17, 2009:

Yes, I put in a test user and gave them front-office rights and it worked fine!

8

dlee5400 wrote on Tuesday, November 17, 2009:

and yes removing them from all groups locked the user out… strange the only thing i can’t seem to get working is the advanced module. I have had to go and remove and/or change all demoted functions from the code. In this case i havn’t touched any gacl mods … is there a way to allow php to run even with warnings etc.? My experance is that it will hide the warnings etc but will not exec the script?

9

dlee5400 wrote on Tuesday, November 17, 2009:

When i go to put in a patient and only select “Who” and not other face sheet info i get :

    ERROR: insert failed: INSERT INTO patient_data SET pid = ‘1’, date = NOW(), title = ‘Mr.’, fname = ‘David’, mname = ‘’, lname = ‘Lee’, pubpid = ‘1’, DOB = ‘2009-11-02’, sex = ‘Female’, ss = ‘444-44-4444’, drivers_license = ‘’, status = ‘married’, genericname1 = ‘’, genericval1 = ‘’, genericname2 = ‘’, genericval2 = ‘’, street = ‘’, city = ‘’, state = ‘’, postal_code = ‘’, country_code = ‘’, contact_relationship = ‘’, phone_contact = ‘’, phone_home = ‘’, phone_biz = ‘’, phone_cell = ‘’, email = ‘’, providerID = ‘2’, pharmacy_id = ‘0’, hipaa_notice = ‘’, hipaa_voice = ‘’, hipaa_mail = ‘’, hipaa_allowsms = ‘’, hipaa_allowemail = ‘’, hipaa_message = ‘’, occupation = ‘’, language = ‘English’, ethnoracial = ‘Caucasian’, financial_review = ‘’, family_size = ‘’, monthly_income = ‘’, homeless = ‘’, interpretter = ‘’, migrantseasonal = ‘’

Error: Incorrect datetime value: ‘’ for column ‘financial_review’ at row 1

I can only assume that this ugly error means i still have some code issues or i need to read through the “add patient” portions of the manual. Any insight?

10

dlee5400 wrote on Tuesday, November 17, 2009:

Lastly, the PHP.INI was sync to the link you sent on FAQ PHP.INI settings…

11

bradymiller wrote on Tuesday, November 17, 2009:

hey,

Check your mysql configuration file (my.cnf). If your sql-mode parameter is not set to ‘’, then do the following:

1) Configure the sql-mode parameter in your mysql configuration file (my.cnf) to be blank: sql-mode=’’
(it will likely have settings which shouldn’t be there- for some reason some mysql windows releases set this)

2) Completely uninstall openemr (drop database and delete web directory)

3) Re-install OpenEMR

-brady

12

dlee5400 wrote on Wednesday, November 18, 2009:

Thanks Brady,

That created a complete install procedure but during the install/setup screens it gives the same message as my orginal post on step 4 (Setup gacl) BUT the script continues to install things that it didn’t initial intall, so i am that much closer.

I did notice that it throws off warnings such as

    PHP Deprecated: Function set_magic_quotes_runtime() is deprecated …

I had to look those up and fix them in the actual script before it would complete the setup function. I feel like one of two things are possible at this point. Fist is there is an ERROR message that is not throwing to the screen and thus exiting the script OR I still need to know what directories need what permission by what user…. thanks for you input on the last go around it made a huge differance in the setup scripts.

Thanks

13

bradymiller wrote on Wednesday, November 18, 2009:

hey,

This could end up being interesting. Are you sure your not using php5.3? You could try a php 5.2 instead and see what happens. Here’s a report discussing this in another software package:

Has anybody else had issues with php 5.3???

Also, regarding permissions, the first screen checks this so you should be ok. Here’s a configuration of php on IIs page that does discuss generic permission in php for IIS:

To get an idea of what files/folders neew write/executr permissions check out the linux install instructions here:

-brady

  : http://forum.epesibim.com/viewtopic.php?f=6&t=223
  : http://www.plus2net.com/php_tutorial/php_iis_installation.php
  : http://www.openmedsoftware.org/wiki/OpenEMR_3.1_Linux_Installation

14

dlee5400 wrote on Wednesday, November 18, 2009:

You are right again!! I ran the test.php script and sure enough it was 5.3.0 with a build date of Jun 29 2009 21:42:21. I’m sorry I stated the other, I must have read that in a INI file or something….

I will down shift and try your suggestion….

15

dlee5400 wrote on Thursday, November 19, 2009:

Ok, I did all that was suggested with the same results. But I did find this and it allowd me to get past the configuration error and now I am focused on a new issue, but first here is a potiential bug?

    on DEBUG output of phpgacl v3.3.6’s setup.php, i note ERRORs of:

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

checking in “gacl.class.php”, this ERROR is fired off if:

…
if (in_array($key, $available_options) ) {
$this->debug_text(“Valid Config options: $key”);
$property = ‘_’.$key;
$this->$property = $value;
} else {
$this->debug_text(“ERROR: Config option: $key is not a valid option”);
}
…

where,

$available_options =
array(‘db’,‘debug’,‘items_per_page’,‘max_select_box_items’,‘max_search_return_items’,‘db_table_prefix’,‘db_type’,‘db_host’,‘db_user’,‘db_password’,‘db_name’,‘caching’,‘force_cache_expire’,‘cache_dir’,‘cache_expire_time’);

iiuc, and those are, in fact, ‘valid options’, then i’d guess that array(…) should
*additionally* include:

‘smarty_dir’,‘smarty_template_dir’,‘smarty_compile_dir’

cheers,

richard

> MY NEW FOCUS is :

    NOT EDITING ACL
=— (mysql): SELECT value, name FROM gacl_acl_sections WHERE hidden=0 ORDER BY order_value, name — =— (mysql): SELECT value, name FROM gacl_aco_sections WHERE hidden=0 ORDER BY order_value, name — =— (mysql): SELECT value, name FROM gacl_aro_sections WHERE hidden=0 ORDER BY order_value, name — =— (mysql): SELECT value, name FROM gacl_axo_sections WHERE hidden=0 ORDER BY order_value, name — =— (mysql): SELECT section_value, value, name FROM gacl_aco WHERE hidden=0 ORDER BY section_value, order_value, name LIMIT 100 — =— (mysql): SELECT section_value, value, name FROM gacl_aro WHERE hidden=0 ORDER BY section_value, order_value, name LIMIT 100 — =— (mysql): SELECT section_value, value, name FROM gacl_axo WHERE hidden=0 ORDER BY section_value, order_value, name LIMIT 100 — =— (mysql): SELECT id, parent_id, name FROM gacl_aro_groups ORDER BY parent_id, name — =— (mysql): SELECT id, parent_id, name FROM gacl_axo_groups ORDER BY parent_id, name — =— (mysql): select value from gacl_phpgacl where name = ‘version’ LIMIT 1 — =— (mysql): select value from gacl_phpgacl where name = ‘schema_version’ LIMIT 1 —

Can this happen because there are no users other than the default Admin?

16

dlee5400 wrote on Thursday, November 19, 2009:

I want to break this out to its own issue under this heading.  It is still happening in the “Advance” tab under GACL

>NOT EDITING ACL
=— (mysql): SELECT value, name FROM gaclaclsections WHERE hidden=0 ORDER BY ordervalue, name — =— (mysql): SELECT value, name FROM gaclacosections WHERE hidden=0 ORDER BY ordervalue, name — =— (mysql): SELECT value, name FROM gaclarosections WHERE hidden=0 ORDER BY ordervalue, name — =— (mysql): SELECT value, name FROM gaclaxosections WHERE hidden=0 ORDER BY ordervalue, name — =— (mysql): SELECT sectionvalue, value, name FROM gaclaco WHERE hidden=0 ORDER BY sectionvalue, ordervalue, name LIMIT 100 — =— (mysql): SELECT sectionvalue, value, name FROM gaclaro WHERE hidden=0 ORDER BY sectionvalue, ordervalue, name LIMIT 100 — =— (mysql): SELECT sectionvalue, value, name FROM gaclaxo WHERE hidden=0 ORDER BY sectionvalue, ordervalue, name LIMIT 100 — =— (mysql): SELECT id, parentid, name FROM gaclarogroups ORDER BY parentid, name — =— (mysql): SELECT id, parentid, name FROM gaclaxogroups ORDER BY parentid, name — =— (mysql): select value from gaclphpgacl where name = ‘version’ LIMIT 1 — =— (mysql): select value from gaclphpgacl where name = ‘schema_version’ LIMIT 1 —

My question is: “Can this happen because there are no users other than the default Admin?”

17

bradymiller wrote on Thursday, November 19, 2009:

hey,

Regarding your first bug :

Option: smartydir ERROR: Config option: smartydir is not a valid option Option: smartytemplatedir ERROR: Config option: smartytemplatedir is not a valid option Option: smartycompiledir ERROR: Config option: smartycompiledir is not a valid option

This is normal and hasn’t caused any problems in the past. What are you seeing after it: should be something like this:

Did your changes fix an error or simply remove these ERROR printouts. If it indeed fixed something then likely related to IIS. Let me know.

For the second issue, if you turn off php-gacl debugging are you still not able to see the advanced screen?

Also, check out your php log to see if get any errors if still having problem even after tunring off php-gacl debugging.

Also, make sure you haven’t modified the gacl configuration files, since these take setting from OpenEMR now.

-brady

  : http://sourceforge.net/projects/openemr/forums/forum/202504/topic/3068329/index/page/2

18

dlee5400 wrote on Friday, November 20, 2009:

UPDATE & QUESTION

Does this error message give any more insight on my issues? This is found when I press (Advance) link in the ACL menu item…

    Warning: include(templates_c%%C7^C7B^C7BBD6D2%%acl_admin.tpl.php): failed to open stream: No such file or directory in C:\Inetpub\wwwroot\openemr\gacl\admin\smarty\libs\Smarty.class.php on line 1258 Warning: include(): Failed opening ‘templates_c%%C7^C7B^C7BBD6D2%%acl_admin.tpl.php’ for inclusion (include_path=’.;C:\php5\pear’) in C:\Inetpub\wwwroot\openemr\gacl\admin\smarty\libs\Smarty.class.php on line 1258

Thanks!

19

dlee5400 wrote on Saturday, November 21, 2009:

Ok, I have uninstalled the entire project down to PHP. I reinstalled PHP 5.2.11, MySQL 5.1.40 on IIS 6 Windows 2003.

The install went with zero issues (yeah!!) and I applied (post install) the patches (3-1-0-patch-3)

System started up and worked but two areas i see that doesn’t work the first is the same as my previous message on the (Advance) feature under ACL:

    Warning: include(templates_c%%C7^C7B^C7BBD6D2%%acl_admin.tpl.php): failed to open stream: No such file or directory in C:\Inetpub\wwwroot\openemr\gacl\admin\smarty\libs\Smarty.class.php on line 1258 Warning: include(): Failed opening ‘templates_c%%C7^C7B^C7BBD6D2%%acl_admin.tpl.php’ for inclusion (include_path=’.;C:\php5\pear’) in C:\Inetpub\wwwroot\openemr\gacl\admin\smarty\libs\Smarty.class.php on line 1258

**and** the second is the under the Practice feature there is only a blank screen.

I hope this installtion will be a bit easier to debug.

Thanks!!

20

bradymiller wrote on Sunday, November 22, 2009:

hey,

Problem 1:
I’m guessing that has to do with a permission problem in directory openemr/gacl/admin/templates_c

Problem 2:
Anything getting logged to your php error log during white screen of death in the Adminstration->Practice screen?

You are now debugging to get IIS to work. While it would be great to get IIS to work with OpenEMR, in case you start to lose your sanity just know that you could always switch to Apache server instead.

-brady