Links

Mac OSX

Installation for Mac using XAMPP

Installation

  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. 1.
    Ensure that the MySQL/MariaDB server is running. (see step 3)
  2. 2.
    Open a new terminal.
  3. 3.
    Use the mysqladmin command-line utility to alter the MySQL/MariaDB password, using the following syntax: mysqladmin --user=root password "newpassword"
  4. 4.
    The mysqladmin command-line utility is located within the bin/ subdirectory of the XAMPP installation directory, typically /Applications/XAMPP.
  5. 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. 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. 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';
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

  1. 1.
    Edit php.ini with TextEdit: Path: /Applications/XAMPP/xamppfiles/etc/php.ini Change: date.timezone=Europe/Berlin to: date.timezone=America/Chicago
  2. 2.
    Restart server

CHANGE LOGIN DEFAULT DATABASE TO NONE

  1. 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

SAVE/ BACK-UP and RESTORE DATABASE

See this page: