Open Health IT Open Source Solutions for Healthcare

3Oct/100

OpenEMR – Force Secure Socket Login

If you want to force a SSL connection to OpenEMR, insert the code below into the index.php in /var/www/openemr/index.php

Place the lines below after the line "include_once("library/sqlconf.php");"

/**
* Check for SSL connection to webserver
*/
if ( !isset($_SERVER['HTTPS']) || ($_SERVER['HTTPS'] != 'on') ) {
echo "Do not use OpenEMR over an unsecured connection.\n\n" ; echo "\nUse this link: <a href='https://" . $_SERVER['HTTP_HOST'] . $_SERVER['PHP_SELF'] ."'>https://" . $_SERVER['HTTP_HOST'] . $_SERVER['PHP_SELF'] ."</a><br>";
die();
}

Tagged as: No Comments
16Sep/100

OpenEMR – Check Database

This addition to the crontab is used to verify the database integrity and then to optimize the indexes and tables.

Add the following to the /etc/crontab

30 22 * * *     root    mysqlcheck -A -e --user={YOUR OPENEMR DB USER} --password={YOUR OPENEMR DB PASSWORD}  openemr
35 22 * * *     root    mysqlcheck -A -a --user={YOUR OPENEMR DB USER} --password={YOUR OPENEMR DB PASSWORD}  openemr
40 22 * * *     root    mysqlcheck -A -o --user={YOUR OPENEMR DB USER} --password={YOUR OPENEMR DB PASSWORD} openemr

16Jun/105

OpenEMR – Dump Database

Updated: On some systems (debian squeeze) the statement (let OLDFILES=${FILENAMEDATE}-${KEEPDAYS}) will no longer execute properly so it should be updated to (OLDFILES=`expr ${FILENAMEDATE} - ${KEEPDAYS}`).   The correction has been applied to the script below.

As part of our backup process on the OpenEMR system we create hourly dumps of the database. The script below handles the database export, compression, and daily cleanup. This script can be run manually but we choose to place it in /etc/cron.hourly.

The script is currently running on a Debian (lenny) system but should work on ubuntu and Centos.

#!/bin/sh
#
# dump openemr db
#
# This script will create a backup of the openemr database
# and store it in LOCATION with the file format of
# FILENAMEPREFIX.FILENAMEDATE.FILENAMEHOUR.FILENAMESUFFIX
# for example at 2am on June 16 2010 the file would appear as
# /var/log/mysql/backup/mysql_openemr.167.02.dump.gz
#
# LOCATION=directory to store the backups
LOCATION=/var/lib/mysql/backup
#
FILENAMEPREFIX="mysql_openemr"
FILENAMESUFFIX="dump"
#
FILENAMEDATE=`date +%j`
FILENAMEHOUR=`date +%H`
#
FILENAME=${FILENAMEPREFIX}.${FILENAMEDATE}.${FILENAMEHOUR}.${FILENAMESUFFIX}
#echo $FILENAME
#
# KEEPDAYS=number of days to hold dump file before deletion
KEEPDAYS=7
OLDFILES=`expr ${FILENAMEDATE} - ${KEEPDAYS}`
#
# mysqldump options
OPTIONS="--opt"
#
# GZIP=0 do not zip files
# GZIP=1 zip files
GZIP=0
#
# Username and Password for mysql
# change this for your installation
USERNAME="myopenemrusername"
PASSWORD="openemrdbpassword"
#
# dump the database
# zip the file if GZIP set
#
if [ ${GZIP} -ne 0 ]
then
mysqldump ${OPTIONS} --user=${USERNAME} --password=${PASSWORD} openemr | gzip >${LOCATION}/${FILENAME}.gz
else
mysqldump ${OPTIONS} --user=${USERNAME} --password=${PASSWORD} openemr >${LOCATION}/${FILENAME}
fi
if [ ${FILENAMEHOUR} -eq 0 ]
then
FILENAMES=`ls ${LOCATION}`
for fname in ${FILENAMES}
do
FDATE=`echo ${fname} | cut --delimiter=. -f 2`
if [ ${FDATE} -lt ${OLDFILES} ]
then
echo Deleting ${fname}
rm ${LOCATION}/${fname}
fi
done
fi

27May/100

Centos – Logitech Bluetooth

When setting up a Logitech bluetooth keyboard and/or mouse with the Centos linux distribution you need to force Centos to ignore the bluetooth capability.  This can be done by editing the sysconfig file below.

sudo vi /etc/sysconfig/bluetooth

/etc/sysconfig/bluetooth

HID2HCI_ENABLE=false