Mac OSX
Installation for Mac using XAMPP
- 1.
- 2.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:
- 1.Ensure that the MySQL/MariaDB server is running. (see step 3)
- 2.Open a new terminal.
- 3.Use the mysqladmin command-line utility to alter the MySQL/MariaDB password, using the following syntax:
mysqladmin --user=root password "newpassword" - 4.The mysqladmin command-line utility is located within the bin/ subdirectory of the XAMPP installation directory, typically /Applications/XAMPP.
- 5.For example, to change the MySQL/MariaDB root password from its default empty value to the password gue55me, you would execute:
/Applications/XAMPP/bin/mysqladmin --user=root password "gue55me"
- 6.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" - 7.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”)
/Applications/XAMPP/bin/mysql --user=root --password=gue55me -e "SELECT 1+1"
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';- 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_NOTICE13. 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
- 1.Edit php.ini with TextEdit: Path:
/Applications/XAMPP/xamppfiles/etc/php.iniChange:date.timezone=Europe/Berlinto:date.timezone=America/Chicago - 2.Restart server
- 1.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
See this page:
Last modified 3yr ago