Warning: require_once(sites/default/sqlconf.php): failed to open stream:

hakemz100220 wrote on Tuesday, August 19, 2014:

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

fsgl wrote on Tuesday, August 19, 2014:

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?

fsgl wrote on Tuesday, August 19, 2014:

Found thread with similar error message.

Possible explanations.

hakemz100220 wrote on Tuesday, August 19, 2014:

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…

fsgl wrote on Tuesday, August 19, 2014:

Try the following:

  1. Uninstall OpenEMR.
  2. Reinstall OpenEMR, but have the setup create a new database.
  3. Import openemr web directory & MySqldump via command line to 2.

hakemz100220 wrote on Wednesday, August 20, 2014:

HERE is the first step
http://hakemclinic.org/openemr

hakemz100220 wrote on Wednesday, August 20, 2014:

$host = ‘hakemclinicorg.ipagemysql.com’;
$port = ‘3306’;
$login = ‘openemr’;
$pass = ‘12345678a’;
$dbase = ‘openemr’;

fsgl wrote on Wednesday, August 20, 2014:

Two assumptions:

  1. Database created in vDeck will be used. OpenEMR setup will not create database.
  2. Credentials in sqlconf.php, as a result of the vDeck created database, are identical to those entered in your Step 2.

Two questions:

  1. Does vDeck have a command line? If no Terminal, not too many alternatives to phpMyAdmin import of .sql file.
  2. Is the openemr web directory in var/www/html or var/www? It needs to be in the latter for the application to work.

hakemz100220 wrote on Wednesday, August 20, 2014:

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…

hakemz100220 wrote on Wednesday, August 20, 2014:

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.

fsgl wrote on Wednesday, August 20, 2014:

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.

hakemz100220 wrote on Thursday, August 21, 2014:

Why it is so frustrating to get this application to work…on a hosting server… while it is easy on localhost …

fsgl wrote on Thursday, August 21, 2014:

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.

hakemz100220 wrote on Thursday, August 21, 2014:

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??/

fsgl wrote on Friday, August 22, 2014:

This works well on localhost.

If login is now possible & all modules function correctly, further exploration is unnecessary.

If not, a description of conflicts found here,

hakemz100220 wrote on Saturday, August 23, 2014:

Hello friends,
No, log in function is not possible so far, I am looking for any thing that related to $RootDir :<?php echo $rootdir;?> $webserver_root,…and see if modifying the default locations will be of any good results…
from main screen 2 frames are found, the most important frame is lost (somewhere in the ocean,…) ):
hakemclinic.org/openemr/interface/login_title.php (Found)
hakemclinic.org/openemr/interface/login_frame.php (Not found)
hakemclinic.org/openemr/interface/login/filler.php (Found)

fsgl wrote on Saturday, August 23, 2014:

Found this post.

fsgl wrote on Tuesday, August 26, 2014:

It appears that now login is possible with the link provided above for the website.

Left Navigational side bar has been re-arranged with different menu titles.

PhpMyAdmin is available as well.

It’s unclear what precisely the OP did to fix the problem, but it’s resolved.

hakemz100220 wrote on Friday, August 29, 2014:

yes, every thing is working… for now.

fsgl wrote on Saturday, August 30, 2014:

It would be helpful to other users to know if the sessions_save_path entry resolved the problem or the answer lies elsewhere.