Mac OSX
Installation for Mac using XAMPP
Installation
Install XAMPP: https://www.apachefriends.org/index.html
Copy/extract Open Enventory into Applications/XAMPP/htdocs/ . Write down the folder name because this will be the web address. In this case the folder is named ‘open_enventory’
3. Open Applications/XAMPP manager. Start MySQL and Apache.
4. Change mysql root password by following these steps:
Ensure that the MySQL/MariaDB server is running. (see step 3)
Open a new terminal.
Use the mysqladmin command-line utility to alter the MySQL/MariaDB password, using the following syntax:
mysqladmin --user=root password "newpassword"
The mysqladmin command-line utility is located within the bin/ subdirectory of the XAMPP installation directory, typically /Applications/XAMPP.
Or, if a password has already been previously set and you’d like to change it to a new one, you can use the following syntax:
mysqladmin --user=root --password=oldpassword password "newpassword"
For example, to change the root password from 12345 to gue55me, you would execute:
/Applications/XAMPP/bin/mysqladmin --user=root --password=12345 password "gue55me"
5. Test that your password change has been accepted, by attempting to connect to the MySQL/MariaDB server using the mysqlcommand-line client in the same directory. For example, you could use the command below to connect to the server and return the results of a calculation: (make sure you use your own password instead of “gue55me”)
Steps 6 & 7 are for phpmyadmin set up. They are optional. You don’t need to do this if you just want to set up Open Enventory
6. Change the permission for Applications/XAMPP/xamppfiles/phpmyadmin so that you/your_account have the read and write access, through right click, Get Info (or Cmd-I)
7. Use TextEdit to edit file config.inc.php. Locate:
$cfg['Servers'][$i]['auth_type'] = 'config';
and change to:
$cfg['Servers'][$i]['auth_type'] = 'cookie';
8. Using a web browser, go to: http://localhost/open_enventory/
In Database: put in the name for your database server
Log in with username ‘root’ and set password Notice the error messages
9. Under Warning above notice the place of the temp folder (in this case /var/folders/87/…)
10. Go to that folder containing the openenv.log (in this case: T with the path as following in Finder (file maybe hidden):
/var/folders/87/b98_ym4x1r91ldysmq8r29kc0000gn/T/
11. Set permission for everyone to Read&Write for this folder (e.g. “T”)
12. Look-up file php.ini. Should be in Applications/XAMPP/xamppfiles/etc/
And change to:
error_reporting=E_ALL & ~E_NOTICE
13. Restart Apache and SQL in XAMPP manager
14. Restart the web browser and go the server website at: http://localhost/open_enventory/ - In Database: put in the name for your database server - Log in with username ‘root’ and set password
CHANGE TIME ZONE
Edit php.ini with TextEdit: Path:
/Applications/XAMPP/xamppfiles/etc/php.ini
Change:date.timezone=Europe/Berlin
to:date.timezone=America/Chicago
Restart server
CHANGE LOGIN DEFAULT DATABASE TO NONE
Edit lib_global_funcs.php with TextEdit: Path:
/Applications/XAMPP/xamppfiles/htdocs/open_enventory/
Change:if ($db_name=="") { $db_name="storage";
to:
if ($db_name=="") { $db_name="";
2. Restart server
SAVE/ BACK-UP and RESTORE DATABASE
See this page:
Database Backup and RestoreLast updated