Legal Case Management Help

• Installation
  • Setting up directory permissions
  • The SQL database connection
  • Personal information
• Cases
  • Introduction
  • Case participants
  • Case follow-ups
  • New case stage or status
• Clients
  • Introduction
  • Registration of clients
  • Registration of organisations
• Users
  • Introduction
  • User management
  • Role of administrators
• Tools
  • Agenda
  • Documents
• Site configuration
  • General information
  • Collaborative work
  • Office policy
  • Regional settings
• Archives
  • Introduction
  • Export archives
  • Import archives
• Reports
  • Introduction
  • Customizing a report
• Keywords
  • Introduction
  • Creating a new keyword group
  • Creating a new keyword
  • Removing or deleting a keyword
• About ...
  • Contributors
  • License and terms of use

Installation

The SQL database connection

This step consists of entering the necessary information for the connection of LCM to the SQL database server.

• Database address: this information should be “localhost”, but it could also be your site’s address (“www.mysite.org”) depending on the configuration of the server.
• Connection login: it is often the same login you use to upload your files by FTP or SSH.
• Connection password: it is often the same password as the one you use to access your site by FTP or SSH.

These settings cannot be invented: not knowing them means that your host has not given them to you. Therefore: if you do not have this information at hand you cannot continue.

• If you are not the server administrator: you must contact him/her directly. Some Internet hosts provide such information in an online guide or require a specific procedure for that.
• If you are the server administrator: you can create a database for LCM with the following commands:

$ mysql -u root
mysql> create database lcm;
mysql> grant all on lcm.* to lcm_user@localhost identified by 'mypassword';

In the above example, we create a database named “lcm” and later create a new user named “lcm_user” to whom we give full access to the “lcm” database.

The “lcm_user” and “mypassword” will then be the connection login and connection password respectively for continuing the installation.

Please note that the best way to connect to your database depends on your local server configuration.