I'm running RHEL6 and downlaoded the tar.gz file. I ran the setup.sh script as root and a bunch of stuff dumped  to the screen. I have some ERROR messages at the default database stage (see below) which I would like to address. Any helpful hints?

Cheers,
Jenifer

>>Check to make sure you can see index.php
>>Press [enter] to continue
>>phpMyAdmin installed, but must be configured
>>Go tophpMyAdmin/setup to add the local DB server
>>Press [enter] to continue
>>----------------- Copying nidb program/html files -----------------
>>Copying nidb program files
>>Creating default database
>>ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
>>ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

It sounds like something specific to RedHat 6. Perhaps the mysql config file is different than in CentOS. The error is basically saying it can't connect to MySQL to load the default database. It could be any number of reasons why it can't connect. Check a few things first:
Type (as root)
And see if the database actually starts. If it doesn't start, we'll need to find out why. If it does start, try to login using
What happens when you try those things?

You can also try this command, which will force MySQL to generate a new config file (run as root)

I'm also curious what happens when you load http://localhost/phpMyAdmin from the server?

> service mysql restart
mysql: unrecognized service

Since my RHEL6 box was already in use, I was not able to follow the step-by-step guide posted for brand new boxes being installed and configured for the 1st time. So it looks like I need to grab mysql?

Yes. You can install the packages using the following commands (as root):










Then try rerunning the NIDB install

Thanks! I was able to follow your directions for yum updates I needed. I followed up with another install of NIDB.
stdout is pasted below to the cmds you suggested...looks like I'm still missing a key piece (mysqli)?
Any additional advice?
Jenifer

[root@localhost bin]# mysql -uroot -ppassword
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.61 Source distribution

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

phpMyAdmin - Error

The [url=http://localhost/phpMyAdmin/url.php?url=http%3A%2F%2Fphp.net%2Fmanual%2Fen%2Fbook.mysqli.php&lang=en&collation_connection=utf8_general_ci&token=5a5eb95d6faba9f71cf4953144fae94e]mysqli[/url]
extension is missing. Please check your PHP configuration.
href="Documentation.html#faqmysql" target="documentation">class="icon ic_b_help" />

Try running

Most of these PHP packages are specified as part of the CentOS installation. This info about required packages is good to know for future users though.

1) Looks like RHEL6 prefers "mysqld"  instead of "mysql" for starting/stopping service (see below).
[root@localhost ~]# service mysqld restart
Stopping mysqld:                                           [  OK  ]
Starting mysqld:                                           [  OK  ]

2) Looks like your suggested login cmd returns good output (see below). What's the next step in this test drive?
Many Thanks,
Jenifer

[root@localhost ~]# mysql -uroot -ppassword
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.61 Source distribution

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

So the next step would be to go to http://localhost/ from the browser and see what you can see. Chances are you'll see some sort of error, but you may get lucky and it works.

But, you can also re-run the install script, which *should* try to do everything over again, including loading the database and copying the program files.

Let me know what happens with both those scenarios!

1) Test drive started with a splash screen (Login to Olin Systems).
Error message returned after I attempted a login with nidb credentials and my unix credentials:
Fatal error: Call to undefined function posix_getpwnam() in /var/www/html/login.php on line 197

I'll try re-running the nidb install script and let you know the result.

Many Thanks for your efforts to help with RHEL6 install!

Jenifer

During the nidb install script, I'm prompted to "Go to..." (location pasted below)
https://localhost.localdomain:10000
and then do some stuff...
then go to Others -> PHP Configuration -> Manage -> Other Settings ... change PHP Timezone to your timezone
then go to Others -> PHP Configuration -> Manage -> Error Logging ... change Expression for error types = E_ALL & ~E_DEPRECATED & ~E_NOTICE

However, I get an error screen (see below) when I paste that location into my web-browser (firefox)
Is there a simple fix?

Many Thanks,
Jenifer

Secure Connection Failed
         
An error occurred during a connection to localhost.localdomain:10000.

SSL received a record that exceeded the maximum permissible length.

(Error code: ssl_error_rx_record_too_long)

    *   The page you are trying to view can not be shown because the authenticity of the received data could not be verified.

    *   Please contact the web site owners to inform them of this problem. Alternatively, use the command found in the help menu to report this broken site.




        
        
      


      
     


2012-10-12 11:56:27 (7.63 MB/s) - “webmin-1.590-1.noarch.rpm.2” saved [18926818/18926818]

warning: webmin-1.590-1.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 11f63c51: NOKEY
    package webmin-1.590-1.noarch is already installed
------ Manually configure PHP variables ------
Go to https://localhost.localdomain:10000
then go to Others -> PHP Configuration -> Manage -> Other Settings ... change PHP Timezone to your timezone
then go to Others -> PHP Configuration -> Manage -> Error Logging ... change Expression for error types = E_ALL & ~E_DEPRECATED & ~E_NOTICE

Interesting... are you running the browser from within the server you are installing NIDB on? Like, you are logged on to the server and launch the browser there, or are you on a different PC with a browser?

If you are on the server itself, type http://127.0.0.1:10000 and it *should* redirect you to the correct https page. It may also give an error about needing to accept the certificate.

However, there may be something else going on. Maybe Webmin isn't installed correctly?

You don't really need Webmin to use the system. It just makes it easier (beleive it or not) to configure Linux.

You can edit /etc/php.ini and change your timezone (using one of these timezones: http://php.net/manual/en/timezones.php ) and also change the "error_reporting = ..." line to be "error_reporting = E_ALL & ~E_DEPRECATED & ~E_NOTICE"

For this problem, you'll need to do


You've got an NIDB login, so we're almost there!

I can feel that we are very close...

1) I'm on the server itself when I open web browser windows.
http://127.0.0.1:10000 takes me to a login portal
"You must enter a username and password to login to the Webmin server on 127.0.0.1."

2) http://localhost.localdomain/phpMyAdmin/... takes me to a config portal (config file appended below):
3) What's the next step?

/*
 * Generated configuration file
 * Generated by: phpMyAdmin 3.5.2 setup script
 * Date: Fri, 12 Oct 2012 15:14:07 -0500
 */

/* Servers configuration */
$i = 0;

/* Server: Cortex [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'Cortex';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['nopassword'] = true;
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';

/* End of servers configuration */

$cfg['blowfish_secret'] = '50772fa742dae5.30356381';
$cfg['DefaultLang'] = 'en';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
?>

Aha!
I think we made it!
See screencapture below :)

Excellent!

phpMyAdmin is a good tool for managing the SQL database which NIDB uses. Are you able to login to NIDB by going to http://localhost using the admin/password?

Unfortunately, I get an error message when I try to login to NDB via the Olin login portal (Fatal error reported is appended below):
Are you able to login to NIDB by going to http://localhost using the admin/password?
Fatal error: Call to undefined function posix_getpwnam() in /var/www/html/login.php on line 197

Any suggestions?
Jenifer

Have you tried? (as root)

[root@localhost installer]# yum install php-process
Loaded plugins: refresh-packagekit, rhnplugin
Setting up Install Process
Nothing to do
[root@localhost installer]#

Anything else I can check?

Try restarting apache

[root@localhost ~]# service httpd restart
Stopping httpd:                                            [  OK  ]
Starting httpd:                                            [  OK  ]
[root@localhost ~]#

Next, I tried the Olin login portal again. I now get a different message in the top left corner:
"Not a UNIX account, trying standard account". For my username & passwrd, I'm using the contents of the file:
 // NIDB login.php
 // Copyright (C) 2004 - 2012
 // Gregory A Book
 // Olin Neuropsychiatry Research Center, Hartford Hospital

Login to Olin Systems
Incorrect login. Make sure Caps Lock is not on
Username Your Linux username
Password Case sensitive
Leave me logged in (for 90 days)

The username for NIDB login should be "admin" and password "password"

Those are the values I am entering at the Olin login portal when I get the error message.

Interesting...
Ok, so lets try this:

Go to http://localhost/phpMyAdmin. Login with root/password

Go to the database list on the left and click 'nidb'. It will show a list of tables. Find the 'users' table. It should list out the rows in the users table, if not, click 'Browse' at the top of the page. Do any records show up, especially one with a username of 'admin'?

I'm thinking you may have downloaded an old version of the installer that didn't automatically setup the admin user account.

It looks like 1 row is populated in the users table under nidb.
Do the cell contents look okay?

	[url=http://localhost/phpMyAdmin/tbl_change.php?db=nidb&table=users&where_clause=%60users%60.%60user_id%60+%3D+1&clause_is_unique=1&sql_query=SELECT+%2A+FROM+%60users%60&goto=sql.php&default_action=update&token=411a64653831f80c7eaba8c2311b91d3] Edit[/url]	[url=http://localhost/phpMyAdmin/tbl_change.php?db=nidb&table=users&where_clause=%60users%60.%60user_id%60+%3D+1&clause_is_unique=1&sql_query=SELECT+%2A+FROM+%60users%60&goto=sql.php&default_action=insert&token=411a64653831f80c7eaba8c2311b91d3] Copy[/url]	[url=http://localhost/phpMyAdmin/sql.php?db=nidb&table=users&sql_query=DELETE+FROM+%60nidb%60.%60users%60+WHERE+%60users%60.%60user_id%60+%3D+1&message_to_show=The+row+has+been+deleted&goto=sql.php%3Fdb%3Dnidb%26table%3Dusers%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560users%2560%26message_to_show%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_structure.php%26token%3D411a64653831f80c7eaba8c2311b91d3&token=411a64653831f80c7eaba8c2311b91d3] Delete[/url]	1	admin	901924565	Standard	Administrator	admin@nidb.org	2012-10-10 16:46:02	0	1	1	0	2012-10-10 16:46:02