RxNorm appears not working in Docker

Day-to-Day Users
#1

Hello All,

I’m testing 5.0.2 in Docker and hoping to get some answer about the aforementioned topic.

I downloaded the RxNorm_full_11022020.zip from the NIH website and copied it into the openemr container at contrib/rxnorm. Then I registered it through Admin->Other->External Data Loads. The operation appeared successful as it showed the correct version under Installed Release. I also went to Admin->Lists->Code Types to enable RXCUI. The check box under the Drug column is also checked. But when I tried to add a new medication using RXCUI Medication it shows “No matching records found”.

Did I miss anything? Thanks for your help!

–Cuong

#2

hi @chauct, we were just working on this :slight_smile:

#3

Hi Stephen,

I did look at that post before posting my question.

I bumped the post_max_size to 300M but still got “LOAD SUCCESSFUL. Codes inserted: 0, replaced: 0”. The standardized_tables_track table is empty. Any idea where I should look next?

Thanks,
Cuong

#4

just use the “Current Prescribable Content Monthly Release”

#5

I had tried this before and tried again as you suggested but still not working. I even tried the July version that @PeteBoyd had much luck with.

Just to be clear, I’m using the Docker production docker-compose.yml to bring openemr up.

Thanks,
–Cuong

#6

The solution I described used Administration > Other > Native Data Loads, not External Data Loads.

#7

I switched to using Native Load after reading your post but the problem still persists

#8

hi @chauct, did you restart the openemr docker after changing the php setting?

#9

Yes. otherwise it would have showed the error “POST-Content-Length… bytes exceeds the limit of…”.

What’s the easiest way to debug openemr? I’ve worked with other languages but this would be my first foray into PHP. :slight_smile:

#10

ok, nice, you can follow the contributing guide

1st command in step 7 will show php error logs

#11

I’m using the crudest form of debugging: error_log :wink:

It appears there’s something wrong with the POST uploads in Docker as it shows $_FILES[‘form_file’][‘size’] is ZERO and $_FILES[‘form_file’][‘tmp_name’] empty.

#12

ok, some folks are using phpstorm with xdebug, step 19

#13

did you check this setting in php?

    mysqli.allow_local_infile = On
#14

Yes, It is ON.

Any idea why the upload file does not show up?

#15

nope, should be fine, just tested on https://six.openemr.io/c/openemr/index.php with the weekly rxnorm

#16

I have tested this on 2 different computers both running Ubuntu 20.04 with identical problem.

I just tried to upload a medical record (image type) and it works. Strange!

1 Like
#17

Okay, I think the problem may appear to be a MIME related. I extracted the RXNCONSO.RRF and upload worked!

1 Like
#18

Is this a browser thing or something needs to be changed on the server side?