Hello,
after installing Openemr, I am getting this when I log in :
Warning: require_once(sites/default/sqlconf.php): failed to open stream: No such file or directory in /hermes/bosnaweb02a/b166/ipg.hakemclinicorg/index.php on line 19 Fatal error: require_once(): Failed opening required ‘sites/default/sqlconf.php’ (include_path=’.:/usr/local/lib/php-5.3.13/lib/php’) in /hermes/bosnaweb02a/b166/ipg.hakemclinicorg/index.php on line 19
…/index.php has 3 frames, each frame shows same error, the file …/sites/default/sqlconf.php is intact Line 19 is:… require_once “sites/$site_id/sqlconf.php”;
if function looks ok
if (empty($site_id) || preg_match(’/[^A-Za-z0-9\-.]/’, $site_id))
die(“Site ID ‘$site_id’ contains invalid characters.”);
require_once “sites/$site_id/sqlconf.php”;
if ($config == 1) {
header(“Location: interface/login/login.php?site=$site_id”);
} else {
header(“Location: setup.php?site=$site_id”);
}
I upload my files and folders using FileZilla , They appear in /root/openemr directory
There is a folder called ‘openemr/sites’ in my account. If I update the path as ‘openemr/sites/$site_id/sqlconf.php’ in index file, it will reflect a redirect error.
I do appreciate any help!
thank you
Which operating system?
Was a new database created during installation?
Was there an attempt to transfer data from another copy of OpenEMR?
Single site or multiple sites?
I use windows to install OpenEMR on localhost/openemr. The hosting server uses Linux, I uploaded all files and folders to the root of my server, and used PhpmyAdmin to import database from my local computer. all installation steps were successful. but when I click login link it gives that warning…
for the first question, MySQL uses phpmyadmin version v 2.8.0.1 to import *.sql or zipped files. and I checked the tables and all were fine.
For the second qustion, I’ll ask ipage.com support…
That was the response from support team:
The home directory path for your account is: /home/users/web/b166/ipg.hakemclinicorg/ or /hermes/bosnaweb02a/b166/ipg.hakemclinicorg/ . You can update any of the paths in the OpenEMR config files so that the installer will work fine.
The tables may look ok, but the problem as suggested by the error message in the original post is that the path to the sqlconf.php file may be incorrect.
Application is worthless if unable to login & write to database.
Additionally site id may be wrong as well.
var/www is in the root directory, not home directory, on a local machine.
Hosting adds another layer of complexity and reduces the user’s control over the installation process.
An alternative to iPage is WordPress. The Wiki article was written specifically about the Patient Portal but there are instructions about configuring WordPress.
Although more work is involved, more control will be regained with an open source system. Explore the feasibility of installing Brady’s Debian package with Wordpress.
so far, the problem is within /global.php web root tag
// $webserver_root = “/var/www/openemr”;
to be replaced with
$webserver_root = “/home/users/web/b166/ipg.hakemclinicorg/openemr/”;
I am not sure if there are other files with the same location tag??/