gutiersa wrote on Tuesday, September 20, 2011:
actually you would get an error message on the screen.
the fact that users is blank means the populating of tables is stuck somewhere, cuz it should create the admin user. veryimportant to be able to log into openemr the first time
gutiersa wrote on Tuesday, September 20, 2011:
it is hanging somewhere in the tables before users table, this is why the sqlconf.php file is not getting done. the setup gets stuck at tables and cannot continue.
gutiersa wrote on Tuesday, September 20, 2011:
Kk now check the tables in between:
notes has 0 rows
onotes has 0 rows
openemr_modules has 1 rows
openemr_module_vars has 19 rows
openemr_postcalendar_categories has 9 rows
openemr_postcalendar_events has 3 rows
openemr_postcalendar_limits has 0 rows
openemr_postcalendar_topics has 0 rows
openemr_session_info has 3 rows
patient_data has 0 rows
payments has 0 rows
pharmacies has 0 rows
phone_numbers has 0 rows
pma_bookmark has 4 rows
pma_column_info has rows 0
pma_history has rows 0
pma_pdf_pages has rows 0
pma_relation has rows 0
pma_table_coords has rows 0
pma_table_info has rows 0
pnotes has rows 0
prescriptions has rows 0
prices has rows 0
porocedure_order has rows 0
porocedure_report has rows 0
porocedure_results has rows 0
porocedure_type has rows 0
registry has rows 9
sequences has rows 1
syndromic_surveillance has rows 0
hopefully this is accurate enough
sandra
enginama1 wrote on Tuesday, September 20, 2011:
so …I think I need to get all the sql’s and work backwards from user name insert, to see where it worked and where it stopped.
I think you had mentioned you have the sql’s or know where I get them?
enginama1 wrote on Tuesday, September 20, 2011:
Differences:
openemr_session_info has 3 rows - NO has 1 row
All other tables listed are the same apart from the one above and users.
gutiersa wrote on Tuesday, September 20, 2011:
session is ok, probably cuz i logged in a few times. your user table is not populated.
do it yourself via phpmyadmin, sql:
CREATE TABLE IF NOT EXISTS `users` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`username` varchar(255) DEFAULT NULL,
`password` longtext,
`authorized` tinyint(4) DEFAULT NULL,
`info` longtext,
`source` tinyint(4) DEFAULT NULL,
`fname` varchar(255) DEFAULT NULL,
`mname` varchar(255) DEFAULT NULL,
`lname` varchar(255) DEFAULT NULL,
`federaltaxid` varchar(255) DEFAULT NULL,
`federaldrugid` varchar(255) DEFAULT NULL,
`upin` varchar(255) DEFAULT NULL,
`facility` varchar(255) DEFAULT NULL,
`facility_id` int(11) NOT NULL DEFAULT ‘0’,
`see_auth` int(11) NOT NULL DEFAULT ‘1’,
`active` tinyint(1) NOT NULL DEFAULT ‘1’,
`npi` varchar(15) DEFAULT NULL,
`title` varchar(30) DEFAULT NULL,
`specialty` varchar(255) DEFAULT NULL,
`billname` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`assistant` varchar(255) DEFAULT NULL,
`organization` varchar(255) DEFAULT NULL,
`valedictory` varchar(255) DEFAULT NULL,
`street` varchar(60) DEFAULT NULL,
`streetb` varchar(60) DEFAULT NULL,
`city` varchar(30) DEFAULT NULL,
`state` varchar(30) DEFAULT NULL,
`zip` varchar(20) DEFAULT NULL,
`street2` varchar(60) DEFAULT NULL,
`streetb2` varchar(60) DEFAULT NULL,
`city2` varchar(30) DEFAULT NULL,
`state2` varchar(30) DEFAULT NULL,
`zip2` varchar(20) DEFAULT NULL,
`phone` varchar(30) DEFAULT NULL,
`fax` varchar(30) DEFAULT NULL,
`phonew1` varchar(30) DEFAULT NULL,
`phonew2` varchar(30) DEFAULT NULL,
`phonecell` varchar(30) DEFAULT NULL,
`notes` text,
`cal_ui` tinyint(4) NOT NULL DEFAULT ‘1’,
`taxonomy` varchar(30) NOT NULL DEFAULT ‘207Q00000X’,
`ssi_relayhealth` varchar(64) DEFAULT NULL,
`calendar` tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘1 = appears in calendar’,
`abook_type` varchar(31) NOT NULL DEFAULT ‘’,
`pwd_expiration_date` date DEFAULT NULL,
`pwd_history1` longtext,
`pwd_history2` longtext,
`default_warehouse` varchar(31) NOT NULL DEFAULT ‘’,
`irnpool` varchar(31) NOT NULL DEFAULT ‘’,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
INSERT INTO `users` (`id`, `username`, `password`, `authorized`, `info`, `source`, `fname`, `mname`, `lname`, `federaltaxid`, `federaldrugid`, `upin`, `facility`, `facility_id`, `see_auth`, `active`, `npi`, `title`, `specialty`, `billname`, `email`, `url`, `assistant`, `organization`, `valedictory`, `street`, `streetb`, `city`, `state`, `zip`, `street2`, `streetb2`, `city2`, `state2`, `zip2`, `phone`, `fax`, `phonew1`, `phonew2`, `phonecell`, `notes`, `cal_ui`, `taxonomy`, `ssi_relayhealth`, `calendar`, `abook_type`, `pwd_expiration_date`, `pwd_history1`, `pwd_history2`, `default_warehouse`, `irnpool`) VALUES
(1, ‘admin’, ‘d033e22ae348aeb5660fc2140aec35850c4da997’, 1, NULL, NULL, ‘’, NULL, ‘Administrator’, NULL, NULL, NULL, NULL, 3, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, ‘207Q00000X’, NULL, 1, ‘’, NULL, NULL, NULL, ‘’, ‘’);
since I exported this from my installation the password is ‘admin’, all lower case no quotes. the user is of course admin
enginama1 wrote on Tuesday, September 20, 2011:
ok did that … after the sql execution what else does the install do.
I’m assuming it updates some config files, will need to update.
e.g need to update sqlconf.php to have the correct DB connection settings?
Then assume theirs some delete files that it does to make it go to the login screen instead of the install screen?
enginama1 wrote on Tuesday, September 20, 2011:
or maybe is their a way to rerun install but edit the install procedure to bypass the DB build?
gutiersa wrote on Tuesday, September 20, 2011:
I think you may be right the initial user gets added at the end of step 3. your problem is writing SQL configuration.
step one checks that sqlconf.php is world writable. it replies ready, or not ready, dunno what yours said. if u made a copy of step 1 go back and check
make sure sqlconf.php in /openemr/sites/default is world writable.
gutiersa wrote on Tuesday, September 20, 2011:
this is the rest of step 3:
writing sql configuration…OK
setting version indicators…OK
writing Global configuration defaults…OK
adding initial user…OK
Next step will install and configure access controls (php-GACL)
“Continue”
when click continue goes to step 4. so better u keep trying with the setup.php file. U don’t wnat to mess with configuring access controls. It used to be done manually in past and it was long and kinda complicated
enginama1 wrote on Tuesday, September 20, 2011:
It went through the checks and confirmed all files needed were world writeable.See below:
‘/home/pctech/public_html/openemr/sites/default/documents’ directory is ready.
‘/home/pctech/public_html/openemr/sites/default/edi’ directory is ready.
‘/home/pctech/public_html/openemr/sites/default/era’ directory is ready.
‘/home/pctech/public_html/openemr/sites/default/letter_templates’ directory is ready.
‘/home/pctech/public_html/openemr/gacl/admin/templates_c’ directory is ready.
‘/home/pctech/public_html/openemr/interface/main/calendar/modules/PostCalendar/pntemplates/compiled’ directory is ready.
‘/home/pctech/public_html/openemr/interface/main/calendar/modules/PostCalendar/pntemplates/cache’ directory is ready.
The step 3 never shows a continue button … I guess cos it never gets past connecting to DB and creating the tables. So need to know how to rerun the install and get it to bypass the DB config.
enginama1 wrote on Tuesday, September 20, 2011:
Whoops missed one:
Ensuring following files are world-writable…
‘/home/pctech/public_html/openemr/sites/default/sqlconf.php’ file is ready.
gutiersa wrote on Tuesday, September 20, 2011:
check sqlconfig.php and see if it was modified:
at the bottom should be a 1 if modified
gutiersa wrote on Tuesday, September 20, 2011:
no
gutiersa wrote on Tuesday, September 20, 2011:
sorry, I mean yes that line. if it is still at zero, then setup.php is not editing that file
after setup that becomes 1
bradymiller wrote on Wednesday, September 21, 2011:
Hi,
Really need to find where your php error log is. Recommend placing a file called dummy.php on your website and then running it over the browser to see if it will show you where the php error log is (place below code into the dummy.php file).
<?php
phpinfo ();
?>
-brady
OpenEMR
enginama1 wrote on Wednesday, September 21, 2011:
had my server vendor move me to a new VPS and it worked. Apparently there was something wrong in the way they had set it up, as the new server works.
Thanks for spending all this time with me and sorry it took so much of your valuable time.
gutiersa wrote on Thursday, September 22, 2011:
Congratulations!