1. Introduction
2. Requirements
3. How to use the tool
4. Structure of the exported file
5. Related install infos
   1. Install syspass on docker
   2. Install syspass export tool software requirements

The tool allows to export the syspass(https://www.syspass.org/) database passwords and some linked infos into a CSV or JSON file.

To use this tool you need:

1. the possibility to access to the syspass database
2. the masterkey of syspass

Before start install the requirements software

Use the tool:

1. enter in the syspassExportTool folder
2. run the command: php export.php <MASTERKEY-PASSWORD>
3. wait for the message: FILE CREATED!

The CSV or JSON columns foreach exported account are:

• id
• User Group
• User Name
• Client Name
• Account Name
• login
• url
• pass
• key
• notes
• dateAdd
• isPrivate
• isPrivateGroup
• passDate
• passDecrypt <== this value represent the DECRYPTED PASSWORD
• tags

1. clone the project: git clone https://github.com/fabiottini/syspassExportTool.git
2. run the docker-compose in the docker folder: docker-compose up -d
3. when all of 3 containers are up and running go to web interface to continue the installation http://127.0.0.1:3000:
   • CONFIGURE BBDD section:
     • User: root
     • Password: (the same as docker-compose file)
     • database name: syspass
     • Server BBDD for syspass: db
4. At the end of syspass installation, i suggesto to apply this FIX to allows syspass to run without database connection problem.
   • THE PROBLEM:
     Sometimes when you restart the container the syspass container ip change and the syspass application CAN NOT access to the db that have internally a fixed ip for the syspass user.
   • The steps to apply the FIX are:
     1. open the page: http://127.0.0.1:3003 (phpmyadmin interface)
     2. enter with (or those you fillin in the docker-compose file):
        • username: root
        • password: syspass
     3. enter in the Accounts Users section and change the host permission of the user sp_<some code> to %
5. run docker-compose down to switch off all the container
6. comment in the file docker-compose.yml the phpmyadmin section (for more security):

  # phpmyadmin: 
  #   image: phpmyadmin/phpmyadmin
  #   container_name: passwordDBPHP
  #   depends_on:
  #     - db
  #   links: 
  #     - db
  #   ports:
  #     - 3003:80
  #   environment:
  #     - MYSQL_ROOT_PASSWORD: syspass

7. enjoy syspass

1. enter in syspassExportTool folder
2. Install Composer and mysql for php:
   1. apt update && apt-get install curl php-cli php-mbstring php7.0-mysql git unzip
   2. curl -sS https://getcomposer.org/installer -o composer-setup.php
   3. php -r "if (hash_file('SHA384', 'composer-setup.php') === '669656bab3166a7aff8a7506b8cb2d1c292f042046c5a994c43155c0be6190fa0355160742ab2e1c88d40d5be660b410') { echo 'Installer verified'; } else { echo 'Installer corrupt'; unlink('composer-setup.php'); } echo PHP_EOL;"
   4. composer require
3. Edit the mysql parameters in the export.php file:

$hostname   ="127.0.0.1";
$port       ="3002";
$dbname     ="syspass";
$user       ="root";
$password   ="syspass";