1 Topic by pbonay

  • pbonay
  • Member
  • Offline

Topic: New User problems

I am new in the forum and to LabStore so I apologize if my questions are too simple. I have installed it and configured , the pages load well except the  add modules, when I click any add module, intead of appear the authorization required page appears a page saying that a host, username or password error in my system. In the config.php I have just changed the URL for my website, name of teh database and so on and left evrything else as default
Any suggestion. Thanks

2 Reply by testly

  • testly
  • Member
  • Offline

Re: New User problems

By 'when I click any add module', I assume you mean when you click any 'add' link to add an item like a cell-line or chemical.

It looks like there is a MySQL database connection error. Ensure that "config.php" is edited properly and the host, database, etc., names provided there are correct ones. If you can click on the links to 'cell-lines', 'proteins', etc., to see the list of those items, then your "config.php" file is okay.

The other possibility is that "config.php" is not getting 'included' properly -- somewhat similar to the case here. You can try changing the line 

include ("../config.php");

at the top of files "interface_creator/index_long.php", "interface_creator/index_short.php", and "interface_creator/index.php" to 

include ("./../config.php");

. If that doesn't work, try adding 

include(realpath(dirname(__FILE__).'/../config.php'));

instead.

3 Reply by pbonay

  • pbonay
  • Member
  • Offline

Re: New User problems

Thanks for your message, but the message still apperas when I click an add link:
"[01] Error: either host, username or password settings for the MySQL database server connection, or the MySQL database name and site url are not specified or incorrect. Please check parameters and ensure correct syntax in the config.php file. Also, check that MySQL server is functioning and that you can connect to it with the host, username or password settings. Ensure that the database you want to use exists on the MySQL server."
I have configured the config.php as per instructions, the database is called labstock as suggested, and the MySQL is running, the file labstock.sql is in the correct folder.
Also I receive the same error message when trying to open /interface_creator/admin.php.
Any help welcome and acknowledged in advance.

4 Reply by testly

  • testly
  • Member
  • Offline

Re: New User problems

"...labstock.sql is in the correct folder..."

The .sql file is meant for loading into the MySQL server when LabStoRe is being installed. Afterwards it has no value.

-------

Are you sure the labstock database was set up on the server? For installing and using LabStoRe, an empty 'labstock' database has to be first created on the server. Then, the 'labstock.sql' should be used to fill it with some necessary content. LabStoRe doesn't do these automatically. The MySQL user whose login name and password are used must have permission to use the 'labstock' database.