Installing Buymanager and Setting Up MySQL

This guide provides a step-by-step process for installing Buymanager and configuring MySQL for its use. It covers directory setup, MySQL installation and configuration, and the Buymanager application installation.
 

Audience and prerequisites

• Audience: IT, Administrators or Buymanager user with basic server administration knowledge
• Prerequisites: 
  • Administrator rights on the server where Buymanager and MySQL will be installed.
  • The latest version of Buymanager installation file
  • MySQL version 8.4
  • If you are migrating an existing database, ensure you have sufficient disk space. You will need 3 times the size of your database in space. 

---

How to Install Buymanager

Directory Setup

1. Create a dedicated folder on your server —e.g., C:/Buymanager (the drive letter may vary depending on your system).
2. Ensure this newly created folder has Write/Read/Modify has permission enabled (Right-click the folder, go to "Properties" > "Security" tab > "Edit" > select the user/group > check "Full control" )
   Ensure you have the Write/Read/Modify permission on the MySQL folder (in Program Data > MySQL, once it´s install)
   
    
3. If you are installing Buymanager in a client/server configuration (install on user post), share this folder with all users who will access it. 
4. Inside the C:/Buymanager folder, create the following subdirectories:
   • Buymanager_server
   • Buymanager_data
   • Buymanager_download
5. Transfer the Buymanager installer files, your license file, and the database into C:\Buymanager\Buymanager_download.
   
    

MySQL 8.4 Installation

For installing MySQL 8.4, please refer to the dedicated MySQL upgrade article. 
 

MySQL Workbench Settings

1. Launch MySQL Workbench with administrator privileges. 
2. Verify/Create a local instance connection. 
3. Open the connection (i.e. root/Buymanager). 
4. Navigate to Instance > Options File.
   
5. Change the following parameters:
   • General > lower_case_table_names = 1  (This setting makes table names case-insensitive, which can be important for cross-platform compatibility)
   • InnoDB > innodb_buffer_pool_size = 2048M or 6144M for large Nego databases with ~100,000+ forecast rows.  (This setting impacts performance by controlling the amount of memory MySQL uses for caching data and indexes) 
   • InnoDB > innodb_log_file_size = 512M (This setting controls the size of InnoDB's redo log files, which are vital for crash recovery and can impact performance by optimizing how transaction changes are written to disk)
   • Networking > max_allowed_packet = 100M (This prevents errors with large queries or data transfers)

Save by clicking "Apply".

Important Note: If you are unable to save, there is likely a permissions issue (write/read/modify) on the directory where the my.ini file is located.

 

7. After saving changes, duplicate the connection:
   • Go to Edit Connection > Duplicate, and change the username to "Buymanager" instead of "root".

 

Ensure both the "Local instance MySQL84" and "Buymanager" connections.  point to the same directory for the my.ini file.

Database Directory Setup Verification

It is crucial to verify and, if necessary, adjust the database directory. 

• By default, the database is at C:/ProgramData/MySQL/MySQL Server 8.4/Data. If you need to change this location, update the directory path accordingly. 
• Important Note: 
  • The directory you choose, need to have must have Read, Write and Modify permissions. 
  • The NETWORK SERVICE account must be included in the list of authorized accounts for this directory. 
  • If you are migrating data, you must stop the MySQL service via Workbench, move the files/modify the directory parameter, and then restart the service.

Application Installation

1. Run the Buymanager executable file.
2. Select your preferred language.
   
    
3. Select the installation directory (e.g., C:\Buymanager\Buymanager_server).
   
4. Click Next to launch the installation. 
5. Launch the Buymanager application now installed. 

6. Use the configuration wizard to finalize the installation: 

   1. On server, enter the localhost IP 127.0.0.1 
   2. Port: 3306 (the one you used for MySQL) 
   3. Login and Password (the one you used to create the MySQL instance, i.e. Buymanager/Buymanager) 
   4. If you install the version 8.4 of MySQL, check the relevant field. Do not check if you are still using the MySQL 5.7 version. 
   5. Scheduler Base: keep empty for now. 
       

   
   
    

7. Check the "New database" and give it a name. 
   1. Note: the name should not contain any space or special characters. 
      
      
8. Click on the magnifying glass symbol to search and select for your database zip file. 

9. Click on "Install database" 

       IMPORTANT NOTE: During the installation of the Database, your server/ computer must NOT go into sleeping or screensaver mode. This will not create an immediate error, however data within the database will not be install. 

   

10. After you finish installing the database, you will be brought back the one Buymanager Login page. If you have multiple database, select the database you just install. Go to More > Activate License
    
    

11. Enter the text you received as a license file

    
    
     

You have now install Buymanager and users can login to their account. 

---

Common Errors and Tips

Here are some common issues you might encounter and how to resolve them. 

1. You are not able to change the settings on MySQL: 

     - You may not have the Read, Write, and Modify permissions on installation directories or used directories.

     - To solve, go to the directory, right-click, open its properties, and enable all rights.

   

2. You are not finding the repertoire/ folder (e.g MySQL folder). 

     -  Some folder may be hidden. 
     - Change the view to show Hidden Items 

   

3. Workbench unable to stop/start the MySQL server
   

     - The service may not have automatically start
     - Open your "Services" on your window, seach for the MySQL84 service, right click on it, to start them. 
   
    

    - Don’t forget to stop and restart the MySQL service in Workbench to apply parameter changes after. 
    

4. Error : Home Sceen Error
   
    - This usually signify a lack of space on your Disk (i.e. C:\ ) 
    - Add space to your Disk. 
    

5. Error "Insuficient right to access the file" 
   
    - This usually point to the permission right on the e database directory for the "NETWORK SERVICE" account
    - Add "NETWORK SERVICE" to the user group with Read, Write and Modify permission.