Installation 4.0.0 on Ubuntu 16.04 hangs at Connecting to MySQL server

I needed to install version 4.0.0 on a server running Ubuntu 16.04 LTS.
I have done the following

  1. Installed all the Openemr dependencies and changed the php settings as in the wiki
  2. Extracted the Openemr-4.0.0.tar.gz and moved the openemr folder to var/www/html
  3. Started to configure Openemr with the setup.php script on browser
  4. It gets to Step 3 and hangs at Connecting to MySQL server…

Can I manually configure Openemr or change the setup.php script to finish the installation?

@123dssj,

When it hangs at Connecting to MySQL server…step. Kindly make sure to check if your MySQL service is running.
If it is not running, start the service and check.
If it still has the same issue inspite of the service running, try to restart the service and try again.

If none of these help, then we might need more details.

Thanks,
ViSolve

Which version of MySQL are you using?

when I type mysql command it returns 10.1.26-MariaDB

@123dssj,
Could you please share your apache , mysql error logs …

Thanks,
ViSolve

Sure what folder or file are the apache and mysql error logs located.

try /var/log/mysql/error.log and /var/log/apache2/error.log

Hi,
4.0.0 won’t work on Ubuntu 16.04 since that uses PHP7(unless you forced an install of PHP5). You need OpenEMR 4.2.2 or higher.
-brady

Thank you for that. I have downgraded from PHP7.0 to PHP5.6 yet it still hangs at connecting to MySQL server. Anyway to modify the setup.php?

@123dssj,

Change the default database name “openemr” to some thing else in step 3 and try again . Still you have an issue in setup share the screen shot of the error message.

Thanks,
ViSolve

Here is screenshot after step 3. I have tried default database and changed name. All this with PHP5.6

Here is log from /var/log/mysql

2018-01-24 19:14:03 140291888665152 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-01-24 19:14:03 140291888665152 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-01-24 19:14:03 140291888665152 [Note] InnoDB: The InnoDB memory heap is disabled
2018-01-24 19:14:03 140291888665152 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-01-24 19:14:03 140291888665152 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-01-24 19:14:03 140291888665152 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-01-24 19:14:03 140291888665152 [Note] InnoDB: Using Linux native AIO
2018-01-24 19:14:03 140291888665152 [Note] InnoDB: Using generic crc32 instructions
2018-01-24 19:14:03 140291888665152 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-01-24 19:14:03 140291888665152 [Note] InnoDB: Completed initialization of buffer pool
2018-01-24 19:14:03 140291888665152 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2018-01-24 19:14:03 140291888665152 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2018-01-24 19:14:03 140291888665152 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2018-01-24 19:14:03 140291888665152 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2018-01-24 19:14:04 140291888665152 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2018-01-24 19:14:04 140291888665152 [Warning] InnoDB: New log files created, LSN=45883
2018-01-24 19:14:04 140291888665152 [Note] InnoDB: Doublewrite buffer not found: creating new
2018-01-24 19:14:04 140291888665152 [Note] InnoDB: Doublewrite buffer created
2018-01-24 19:14:04 140291888665152 [Note] InnoDB: 128 rollback segment(s) are active.
2018-01-24 19:14:04 140291888665152 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-01-24 19:14:04 140291888665152 [Note] InnoDB: Foreign key constraint system tables created
2018-01-24 19:14:04 140291888665152 [Note] InnoDB: Creating tablespace and datafile system tables.
2018-01-24 19:14:04 140291888665152 [Note] InnoDB: Tablespace and datafile system tables created.
2018-01-24 19:14:04 140291888665152 [Note] InnoDB: Waiting for purge to start
2018-01-24 19:14:04 140291888665152 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 0
2018-01-24 19:14:04 140291226990336 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-01-24 19:14:07 140690381214272 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-01-24 19:14:07 140690381214272 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-01-24 19:14:07 140690381214272 [Note] InnoDB: The InnoDB memory heap is disabled
2018-01-24 19:14:07 140690381214272 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-01-24 19:14:07 140690381214272 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-01-24 19:14:07 140690381214272 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-01-24 19:14:07 140690381214272 [Note] InnoDB: Using Linux native AIO
2018-01-24 19:14:07 140690381214272 [Note] InnoDB: Using generic crc32 instructions
2018-01-24 19:14:07 140690381214272 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-01-24 19:14:07 140690381214272 [Note] InnoDB: Completed initialization of buffer pool
2018-01-24 19:14:07 140690381214272 [Note] InnoDB: Highest supported file format is Barracuda.
2018-01-24 19:14:07 140690381214272 [Note] InnoDB: 128 rollback segment(s) are active.
2018-01-24 19:14:07 140690381214272 [Note] InnoDB: Waiting for purge to start
2018-01-24 19:14:07 140690381214272 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 1616799
2018-01-24 19:14:07 140689715230464 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-01-24 19:14:10 140444063707712 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-01-24 19:14:10 140444063707712 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-01-24 19:14:10 140444063707712 [Note] InnoDB: The InnoDB memory heap is disabled
2018-01-24 19:14:10 140444063707712 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-01-24 19:14:10 140444063707712 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-01-24 19:14:10 140444063707712 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-01-24 19:14:10 140444063707712 [Note] InnoDB: Using Linux native AIO
2018-01-24 19:14:10 140444063707712 [Note] InnoDB: Using generic crc32 instructions
2018-01-24 19:14:10 140444063707712 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-01-24 19:14:10 140444063707712 [Note] InnoDB: Completed initialization of buffer pool
2018-01-24 19:14:10 140444063707712 [Note] InnoDB: Highest supported file format is Barracuda.
2018-01-24 19:14:10 140444063707712 [Note] InnoDB: 128 rollback segment(s) are active.
2018-01-24 19:14:10 140444063707712 [Note] InnoDB: Waiting for purge to start
2018-01-24 19:14:10 140444063707712 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 1616809
2018-01-24 19:14:10 140443400533760 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-01-24 19:14:13 140276211040832 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-01-24 19:14:13 140276211040832 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-01-24 19:14:13 140276211040832 [Note] InnoDB: The InnoDB memory heap is disabled
2018-01-24 19:14:13 140276211040832 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-01-24 19:14:13 140276211040832 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-01-24 19:14:13 140276211040832 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-01-24 19:14:13 140276211040832 [Note] InnoDB: Using Linux native AIO
2018-01-24 19:14:13 140276211040832 [Note] InnoDB: Using generic crc32 instructions
2018-01-24 19:14:13 140276211040832 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-01-24 19:14:13 140276211040832 [Note] InnoDB: Completed initialization of buffer pool
2018-01-24 19:14:13 140276211040832 [Note] InnoDB: Highest supported file format is Barracuda.
2018-01-24 19:14:13 140276211040832 [Note] InnoDB: 128 rollback segment(s) are active.
2018-01-24 19:14:13 140276211040832 [Note] InnoDB: Waiting for purge to start
2018-01-24 19:14:13 140276211040832 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 1616819
2018-01-24 19:14:13 140276211040832 [Note] Plugin ‘FEEDBACK’ is disabled.
2018-01-24 19:14:13 140275540293376 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-01-24 19:14:18 139718301151808 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-01-24 19:14:18 139718301151808 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-01-24 19:14:18 139718301151808 [Note] InnoDB: The InnoDB memory heap is disabled
2018-01-24 19:14:18 139718301151808 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-01-24 19:14:18 139718301151808 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-01-24 19:14:18 139718301151808 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-01-24 19:14:18 139718301151808 [Note] InnoDB: Using Linux native AIO
2018-01-24 19:14:18 139718301151808 [Note] InnoDB: Using generic crc32 instructions
2018-01-24 19:14:18 139718301151808 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-01-24 19:14:18 139718301151808 [Note] InnoDB: Completed initialization of buffer pool
2018-01-24 19:14:18 139718301151808 [Note] InnoDB: Highest supported file format is Barracuda.
2018-01-24 19:14:18 139718301151808 [Note] InnoDB: 128 rollback segment(s) are active.
2018-01-24 19:14:18 139718301151808 [Note] InnoDB: Waiting for purge to start
2018-01-24 19:14:18 139718301151808 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 1616829
2018-01-24 19:14:18 139717634946816 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-01-24 19:14:18 139718301151808 [Note] Plugin ‘FEEDBACK’ is disabled.
2018-01-24 19:14:18 139718301151808 [Note] Server socket created on IP: ‘127.0.0.1’.
2018-01-24 19:14:18 139718301151808 [Note] /usr/sbin/mysqld: ready for connections.
Version: ‘10.1.26-MariaDB-0+deb9u1’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 Debian 9.1
2018-01-24 19:20:34 139718300366592 [Note] /usr/sbin/mysqld: Normal shutdown

2018-01-24 19:20:34 139718300366592 [Note] Event Scheduler: Purging the queue. 0 events
2018-01-24 19:20:34 139717693642496 [Note] InnoDB: FTS optimize thread exiting.
2018-01-24 19:20:34 139718300366592 [Note] InnoDB: Starting shutdown…
2018-01-24 19:20:34 139718300366592 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2018-01-24 19:20:36 139718300366592 [Note] InnoDB: Shutdown completed; log sequence number 1616839
2018-01-24 19:20:36 139718300366592 [Note] /usr/sbin/mysqld: Shutdown complete

2018-01-24 19:20:37 140653765976640 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-01-24 19:20:37 140653765976640 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-01-24 19:20:37 140653765976640 [Note] InnoDB: The InnoDB memory heap is disabled
2018-01-24 19:20:37 140653765976640 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-01-24 19:20:37 140653765976640 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-01-24 19:20:37 140653765976640 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-01-24 19:20:37 140653765976640 [Note] InnoDB: Using Linux native AIO
2018-01-24 19:20:37 140653765976640 [Note] InnoDB: Using generic crc32 instructions
2018-01-24 19:20:37 140653765976640 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-01-24 19:20:37 140653765976640 [Note] InnoDB: Completed initialization of buffer pool
2018-01-24 19:20:37 140653765976640 [Note] InnoDB: Highest supported file format is Barracuda.
2018-01-24 19:20:37 140653765976640 [Note] InnoDB: 128 rollback segment(s) are active.
2018-01-24 19:20:37 140653765976640 [Note] InnoDB: Waiting for purge to start
2018-01-24 19:20:37 140653765976640 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 1616839
2018-01-24 19:20:37 140653765976640 [Note] Plugin ‘FEEDBACK’ is disabled.
2018-01-24 19:20:37 140653103150848 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-01-24 19:20:37 140653765976640 [Note] Server socket created on IP: ‘127.0.0.1’.
2018-01-24 19:20:37 140653765976640 [Note] /usr/sbin/mysqld: ready for connections.
Version: ‘10.1.26-MariaDB-0+deb9u1’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 Debian 9.1
2018-01-24 19:22:59 140653765392128 [Note] /usr/sbin/mysqld: Normal shutdown

2018-01-24 19:22:59 140653765392128 [Note] Event Scheduler: Purging the queue. 0 events
2018-01-24 19:22:59 140653157652224 [Note] InnoDB: FTS optimize thread exiting.
2018-01-24 19:22:59 140653765392128 [Note] InnoDB: Starting shutdown…
2018-01-24 19:23:00 140653765392128 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2018-01-24 19:23:01 140653765392128 [Note] InnoDB: Shutdown completed; log sequence number 1616849
2018-01-24 19:23:01 140653765392128 [Note] /usr/sbin/mysqld: Shutdown complete

2018-01-24 19:23:02 139877873435200 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-01-24 19:23:02 139877873435200 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-01-24 19:23:02 139877873435200 [Note] InnoDB: The InnoDB memory heap is disabled
2018-01-24 19:23:02 139877873435200 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-01-24 19:23:02 139877873435200 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-01-24 19:23:02 139877873435200 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-01-24 19:23:02 139877873435200 [Note] InnoDB: Using Linux native AIO
2018-01-24 19:23:02 139877873435200 [Note] InnoDB: Using generic crc32 instructions
2018-01-24 19:23:02 139877873435200 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-01-24 19:23:02 139877873435200 [Note] InnoDB: Completed initialization of buffer pool
2018-01-24 19:23:02 139877873435200 [Note] InnoDB: Highest supported file format is Barracuda.
2018-01-24 19:23:02 139877873435200 [Note] InnoDB: 128 rollback segment(s) are active.
2018-01-24 19:23:02 139877873435200 [Note] InnoDB: Waiting for purge to start
2018-01-24 19:23:02 139877873435200 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 1616849
2018-01-24 19:23:02 139877873435200 [Note] Plugin ‘FEEDBACK’ is disabled.
2018-01-24 19:23:02 139877211436800 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-01-24 19:23:02 139877873435200 [Note] Server socket created on IP: ‘127.0.0.1’.
2018-01-24 19:23:02 139877873435200 [Note] /usr/sbin/mysqld: ready for connections.
Version: ‘10.1.26-MariaDB-0+deb9u1’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 Debian 9.1
2018-01-24 19:30:10 139877872649984 [Note] /usr/sbin/mysqld: Normal shutdown

2018-01-24 19:30:10 139877872649984 [Note] Event Scheduler: Purging the queue. 0 events
2018-01-24 19:30:10 139877265938176 [Note] InnoDB: FTS optimize thread exiting.
2018-01-24 19:30:10 139877872649984 [Note] InnoDB: Starting shutdown…
2018-01-24 19:30:10 139877872649984 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2018-01-24 19:30:11 139877872649984 [Note] InnoDB: Shutdown completed; log sequence number 1616859
2018-01-24 19:30:11 139877872649984 [Note] /usr/sbin/mysqld: Shutdown complete

2018-01-24 19:30:12 139672702059072 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-01-24 19:30:13 139672702059072 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-01-24 19:30:13 139672702059072 [Note] InnoDB: The InnoDB memory heap is disabled
2018-01-24 19:30:13 139672702059072 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-01-24 19:30:13 139672702059072 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-01-24 19:30:13 139672702059072 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-01-24 19:30:13 139672702059072 [Note] InnoDB: Using Linux native AIO
2018-01-24 19:30:13 139672702059072 [Note] InnoDB: Using generic crc32 instructions
2018-01-24 19:30:13 139672702059072 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-01-24 19:30:13 139672702059072 [Note] InnoDB: Completed initialization of buffer pool
2018-01-24 19:30:13 139672702059072 [Note] InnoDB: Highest supported file format is Barracuda.
2018-01-24 19:30:13 139672702059072 [Note] InnoDB: 128 rollback segment(s) are active.
2018-01-24 19:30:13 139672702059072 [Note] InnoDB: Waiting for purge to start
2018-01-24 19:30:13 139672702059072 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 1616859
2018-01-24 19:30:13 139672042862336 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-01-24 19:30:13 139672702059072 [Note] Plugin ‘FEEDBACK’ is disabled.
2018-01-24 19:30:13 139672702059072 [Note] Server socket created on IP: ‘127.0.0.1’.
2018-01-24 19:30:13 139672702059072 [Note] /usr/sbin/mysqld: ready for connections.
Version: ‘10.1.26-MariaDB-0+deb9u1’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 Debian 9.1

here is error log from /var/log/apache2

[Wed Jan 24 19:13:14.386599 2018] [mpm_event:notice] [pid 2074:tid 140338268320960] AH00489: Apache/2.4.25 (Debian) configured – resuming normal operations
[Wed Jan 24 19:13:14.386945 2018] [core:notice] [pid 2074:tid 140338268320960] AH00094: Command line: ‘/usr/sbin/apache2’
[Wed Jan 24 19:18:04.282219 2018] [mpm_event:notice] [pid 2074:tid 140338268320960] AH00491: caught SIGTERM, shutting down
[Wed Jan 24 19:18:04.356339 2018] [mpm_prefork:notice] [pid 10696] AH00163: Apache/2.4.25 (Debian) configured – resuming normal operations
[Wed Jan 24 19:18:04.356576 2018] [core:notice] [pid 10696] AH00094: Command line: ‘/usr/sbin/apache2’
[Wed Jan 24 19:18:04.702253 2018] [mpm_prefork:notice] [pid 10696] AH00169: caught SIGTERM, shutting down
[Wed Jan 24 19:18:04.819427 2018] [mpm_prefork:notice] [pid 10751] AH00163: Apache/2.4.25 (Debian) configured – resuming normal operations
[Wed Jan 24 19:18:04.819535 2018] [core:notice] [pid 10751] AH00094: Command line: ‘/usr/sbin/apache2’
[Wed Jan 24 19:18:43.346646 2018] [mpm_prefork:notice] [pid 10751] AH00169: caught SIGTERM, shutting down
[Wed Jan 24 19:18:43.465701 2018] [mpm_prefork:notice] [pid 10800] AH00163: Apache/2.4.25 (Debian) configured – resuming normal operations
[Wed Jan 24 19:18:43.465805 2018] [core:notice] [pid 10800] AH00094: Command line: ‘/usr/sbin/apache2’
[Wed Jan 24 19:20:22.685785 2018] [mpm_prefork:notice] [pid 10800] AH00169: caught SIGTERM, shutting down
[Wed Jan 24 19:20:22.807930 2018] [mpm_prefork:notice] [pid 10908] AH00163: Apache/2.4.25 (Debian) configured – resuming normal operations
[Wed Jan 24 19:20:22.808034 2018] [core:notice] [pid 10908] AH00094: Command line: ‘/usr/sbin/apache2’
[Wed Jan 24 19:22:49.300895 2018] [mpm_prefork:notice] [pid 10908] AH00169: caught SIGTERM, shutting down
[Wed Jan 24 19:22:49.432141 2018] [mpm_prefork:notice] [pid 11345] AH00163: Apache/2.4.25 (Debian) configured – resuming normal operations
[Wed Jan 24 19:22:49.432232 2018] [core:notice] [pid 11345] AH00094: Command line: ‘/usr/sbin/apache2’
[Wed Jan 24 19:28:19.347490 2018] [:error] [pid 11348] [client ::1:52808] PHP Notice: Undefined index: state in /var/www/html/openemr/setup.php on line 13, referer: http://www.open-emr.org/wiki/index.php/OpenEMR_4.0_Linux_Installation
[Wed Jan 24 19:28:21.991848 2018] [:error] [pid 11348] [client ::1:52808] PHP Notice: Undefined index: iuser in /var/www/html/openemr/library/classes/Installer.class.php on line 13, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:21.991902 2018] [:error] [pid 11348] [client ::1:52808] PHP Notice: Undefined index: iuserpass in /var/www/html/openemr/library/classes/Installer.class.php on line 14, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:21.991914 2018] [:error] [pid 11348] [client ::1:52808] PHP Notice: Undefined index: iuname in /var/www/html/openemr/library/classes/Installer.class.php on line 15, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:21.991925 2018] [:error] [pid 11348] [client ::1:52808] PHP Notice: Undefined index: igroup in /var/www/html/openemr/library/classes/Installer.class.php on line 16, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:21.991935 2018] [:error] [pid 11348] [client ::1:52808] PHP Notice: Undefined index: server in /var/www/html/openemr/library/classes/Installer.class.php on line 17, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:21.991946 2018] [:error] [pid 11348] [client ::1:52808] PHP Notice: Undefined index: loginhost in /var/www/html/openemr/library/classes/Installer.class.php on line 18, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:21.991956 2018] [:error] [pid 11348] [client ::1:52808] PHP Notice: Undefined index: port in /var/www/html/openemr/library/classes/Installer.class.php on line 19, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:21.991966 2018] [:error] [pid 11348] [client ::1:52808] PHP Notice: Undefined index: root in /var/www/html/openemr/library/classes/Installer.class.php on line 20, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:21.991995 2018] [:error] [pid 11348] [client ::1:52808] PHP Notice: Undefined index: rootpass in /var/www/html/openemr/library/classes/Installer.class.php on line 21, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:21.992006 2018] [:error] [pid 11348] [client ::1:52808] PHP Notice: Undefined index: login in /var/www/html/openemr/library/classes/Installer.class.php on line 22, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:21.992015 2018] [:error] [pid 11348] [client ::1:52808] PHP Notice: Undefined index: pass in /var/www/html/openemr/library/classes/Installer.class.php on line 23, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:21.992023 2018] [:error] [pid 11348] [client ::1:52808] PHP Notice: Undefined index: dbname in /var/www/html/openemr/library/classes/Installer.class.php on line 24, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:21.992032 2018] [:error] [pid 11348] [client ::1:52808] PHP Notice: Undefined index: collate in /var/www/html/openemr/library/classes/Installer.class.php on line 25, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:21.992043 2018] [:error] [pid 11348] [client ::1:52808] PHP Notice: Undefined index: source_site_id in /var/www/html/openemr/library/classes/Installer.class.php on line 27, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:21.992052 2018] [:error] [pid 11348] [client ::1:52808] PHP Notice: Undefined index: clone_database in /var/www/html/openemr/library/classes/Installer.class.php on line 28, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:21.992061 2018] [:error] [pid 11348] [client ::1:52808] PHP Notice: Undefined index: development_translations in /var/www/html/openemr/library/classes/Installer.class.php on line 29, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:21.992600 2018] [:error] [pid 11348] [client ::1:52808] PHP Notice: Undefined index: inst in /var/www/html/openemr/setup.php on line 169, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:49.673762 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: iuser in /var/www/html/openemr/library/classes/Installer.class.php on line 13, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:49.673854 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: iuserpass in /var/www/html/openemr/library/classes/Installer.class.php on line 14, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:49.673868 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: iuname in /var/www/html/openemr/library/classes/Installer.class.php on line 15, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:49.673875 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: igroup in /var/www/html/openemr/library/classes/Installer.class.php on line 16, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:49.673881 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: server in /var/www/html/openemr/library/classes/Installer.class.php on line 17, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:49.673887 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: loginhost in /var/www/html/openemr/library/classes/Installer.class.php on line 18, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:49.673896 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: port in /var/www/html/openemr/library/classes/Installer.class.php on line 19, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:49.673902 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: root in /var/www/html/openemr/library/classes/Installer.class.php on line 20, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:49.673908 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: rootpass in /var/www/html/openemr/library/classes/Installer.class.php on line 21, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:49.673926 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: login in /var/www/html/openemr/library/classes/Installer.class.php on line 22, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:49.673932 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: pass in /var/www/html/openemr/library/classes/Installer.class.php on line 23, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:49.673938 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: dbname in /var/www/html/openemr/library/classes/Installer.class.php on line 24, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:49.673944 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: collate in /var/www/html/openemr/library/classes/Installer.class.php on line 25, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:49.673950 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: source_site_id in /var/www/html/openemr/library/classes/Installer.class.php on line 27, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:49.673956 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: clone_database in /var/www/html/openemr/library/classes/Installer.class.php on line 28, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:49.673962 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: development_translations in /var/www/html/openemr/library/classes/Installer.class.php on line 29, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:49.674084 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: inst in /var/www/html/openemr/setup.php on line 169, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:52.912562 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: iuser in /var/www/html/openemr/library/classes/Installer.class.php on line 13, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:52.912619 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: iuserpass in /var/www/html/openemr/library/classes/Installer.class.php on line 14, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:52.912631 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: iuname in /var/www/html/openemr/library/classes/Installer.class.php on line 15, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:52.912642 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: igroup in /var/www/html/openemr/library/classes/Installer.class.php on line 16, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:52.912652 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: server in /var/www/html/openemr/library/classes/Installer.class.php on line 17, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:52.912662 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: loginhost in /var/www/html/openemr/library/classes/Installer.class.php on line 18, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:52.912673 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: port in /var/www/html/openemr/library/classes/Installer.class.php on line 19, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:52.912682 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: root in /var/www/html/openemr/library/classes/Installer.class.php on line 20, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:52.912692 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: rootpass in /var/www/html/openemr/library/classes/Installer.class.php on line 21, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:52.912703 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: login in /var/www/html/openemr/library/classes/Installer.class.php on line 22, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:52.912732 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: pass in /var/www/html/openemr/library/classes/Installer.class.php on line 23, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:52.912742 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: dbname in /var/www/html/openemr/library/classes/Installer.class.php on line 24, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:52.912751 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: collate in /var/www/html/openemr/library/classes/Installer.class.php on line 25, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:52.912760 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: source_site_id in /var/www/html/openemr/library/classes/Installer.class.php on line 27, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:52.912769 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: clone_database in /var/www/html/openemr/library/classes/Installer.class.php on line 28, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:52.912778 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: development_translations in /var/www/html/openemr/library/classes/Installer.class.php on line 29, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:52.912883 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: inst in /var/www/html/openemr/setup.php on line 169, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:54.959043 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: iuser in /var/www/html/openemr/library/classes/Installer.class.php on line 13, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:54.959087 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: iuserpass in /var/www/html/openemr/library/classes/Installer.class.php on line 14, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:54.959094 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: iuname in /var/www/html/openemr/library/classes/Installer.class.php on line 15, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:54.959101 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: igroup in /var/www/html/openemr/library/classes/Installer.class.php on line 16, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:54.959106 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: server in /var/www/html/openemr/library/classes/Installer.class.php on line 17, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:54.959113 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: loginhost in /var/www/html/openemr/library/classes/Installer.class.php on line 18, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:54.959119 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: port in /var/www/html/openemr/library/classes/Installer.class.php on line 19, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:54.959124 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: root in /var/www/html/openemr/library/classes/Installer.class.php on line 20, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:54.959130 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: rootpass in /var/www/html/openemr/library/classes/Installer.class.php on line 21, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:54.959136 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: login in /var/www/html/openemr/library/classes/Installer.class.php on line 22, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:54.959142 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: pass in /var/www/html/openemr/library/classes/Installer.class.php on line 23, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:54.959168 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: dbname in /var/www/html/openemr/library/classes/Installer.class.php on line 24, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:54.959175 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: collate in /var/www/html/openemr/library/classes/Installer.class.php on line 25, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:54.959181 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: source_site_id in /var/www/html/openemr/library/classes/Installer.class.php on line 27, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:54.959187 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: clone_database in /var/www/html/openemr/library/classes/Installer.class.php on line 28, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:28:54.959193 2018] [:error] [pid 11346] [client ::1:52814] PHP Notice: Undefined index: development_translations in /var/www/html/openemr/library/classes/Installer.class.php on line 29, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:29:51.134455 2018] [mpm_prefork:notice] [pid 11345] AH00169: caught SIGTERM, shutting down
[Wed Jan 24 19:29:51.252938 2018] [mpm_prefork:notice] [pid 12048] AH00163: Apache/2.4.25 (Debian) configured – resuming normal operations
[Wed Jan 24 19:29:51.253053 2018] [core:notice] [pid 12048] AH00094: Command line: ‘/usr/sbin/apache2’
[Wed Jan 24 19:30:45.454971 2018] [:error] [pid 12049] [client ::1:52816] PHP Notice: Undefined index: source_site_id in /var/www/html/openemr/library/classes/Installer.class.php on line 27, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:30:45.455034 2018] [:error] [pid 12049] [client ::1:52816] PHP Notice: Undefined index: clone_database in /var/www/html/openemr/library/classes/Installer.class.php on line 28, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:30:45.455042 2018] [:error] [pid 12049] [client ::1:52816] PHP Notice: Undefined index: development_translations in /var/www/html/openemr/library/classes/Installer.class.php on line 29, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:30:45.455688 2018] [:error] [pid 12049] [client ::1:52816] PHP Fatal error: Call to undefined function mysql_connect() in /var/www/html/openemr/library/classes/Installer.class.php on line 422, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:31:28.976249 2018] [:error] [pid 12050] [client ::1:52818] PHP Notice: Undefined index: iuser in /var/www/html/openemr/library/classes/Installer.class.php on line 13, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:31:28.976414 2018] [:error] [pid 12050] [client ::1:52818] PHP Notice: Undefined index: iuserpass in /var/www/html/openemr/library/classes/Installer.class.php on line 14, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:31:28.976451 2018] [:error] [pid 12050] [client ::1:52818] PHP Notice: Undefined index: iuname in /var/www/html/openemr/library/classes/Installer.class.php on line 15, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:31:28.976474 2018] [:error] [pid 12050] [client ::1:52818] PHP Notice: Undefined index: igroup in /var/www/html/openemr/library/classes/Installer.class.php on line 16, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:31:28.976502 2018] [:error] [pid 12050] [client ::1:52818] PHP Notice: Undefined index: server in /var/www/html/openemr/library/classes/Installer.class.php on line 17, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:31:28.976523 2018] [:error] [pid 12050] [client ::1:52818] PHP Notice: Undefined index: loginhost in /var/www/html/openemr/library/classes/Installer.class.php on line 18, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:31:28.976544 2018] [:error] [pid 12050] [client ::1:52818] PHP Notice: Undefined index: port in /var/www/html/openemr/library/classes/Installer.class.php on line 19, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:31:28.976594 2018] [:error] [pid 12050] [client ::1:52818] PHP Notice: Undefined index: root in /var/www/html/openemr/library/classes/Installer.class.php on line 20, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:31:28.976612 2018] [:error] [pid 12050] [client ::1:52818] PHP Notice: Undefined index: rootpass in /var/www/html/openemr/library/classes/Installer.class.php on line 21, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:31:28.976631 2018] [:error] [pid 12050] [client ::1:52818] PHP Notice: Undefined index: login in /var/www/html/openemr/library/classes/Installer.class.php on line 22, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:31:28.976649 2018] [:error] [pid 12050] [client ::1:52818] PHP Notice: Undefined index: pass in /var/www/html/openemr/library/classes/Installer.class.php on line 23, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:31:28.976666 2018] [:error] [pid 12050] [client ::1:52818] PHP Notice: Undefined index: dbname in /var/www/html/openemr/library/classes/Installer.class.php on line 24, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:31:28.976683 2018] [:error] [pid 12050] [client ::1:52818] PHP Notice: Undefined index: collate in /var/www/html/openemr/library/classes/Installer.class.php on line 25, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:31:28.976702 2018] [:error] [pid 12050] [client ::1:52818] PHP Notice: Undefined index: source_site_id in /var/www/html/openemr/library/classes/Installer.class.php on line 27, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:31:28.976719 2018] [:error] [pid 12050] [client ::1:52818] PHP Notice: Undefined index: clone_database in /var/www/html/openemr/library/classes/Installer.class.php on line 28, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:31:28.976737 2018] [:error] [pid 12050] [client ::1:52818] PHP Notice: Undefined index: development_translations in /var/www/html/openemr/library/classes/Installer.class.php on line 29, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:32:02.811662 2018] [:error] [pid 12051] [client ::1:52820] PHP Notice: Undefined index: source_site_id in /var/www/html/openemr/library/classes/Installer.class.php on line 27, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:32:02.811787 2018] [:error] [pid 12051] [client ::1:52820] PHP Notice: Undefined index: clone_database in /var/www/html/openemr/library/classes/Installer.class.php on line 28, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:32:02.811812 2018] [:error] [pid 12051] [client ::1:52820] PHP Notice: Undefined index: development_translations in /var/www/html/openemr/library/classes/Installer.class.php on line 29, referer: http://localhost/openemr/setup.php
[Wed Jan 24 19:32:02.812639 2018] [:error] [pid 12051] [client ::1:52820] PHP Fatal error: Call to undefined function mysql_connect() in /var/www/html/openemr/library/classes/Installer.class.php on line 422, referer: http://localhost/openemr/setup.php

@123dssj,

mysql_connect — Open a connection to a MySQL Server.

This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. Instead, the MySQLi or PDO_MySQL extension should be used. so you have to downgraded the php version from PHP5.6 to below PHP5.5.

More here: http://php.net/manual/en/function.mysql-connect.php

Thanks,
ViSolve

Thanks for pointing that out. Can I change the setup.php to use mysqli_connect instead

hi @123dssj ,
That was actually a very large project to convert the entire codebase to mysqli_connect and was not just related to setup.php.
-brady

@123dssj,

As mentioned by Brady the process of converting mysql_connect to mysqli_connect is not very easy. You can follow either of the options below which will make your life easy:
1.Update the OpenEMR Version to 5.0 from OpenEMR 4.0 [OR]
2. Downgraded the php version below 5.5

Thanks,
ViSolve