Set up the HRM database¶
Preparing the database for the HRM consists of two steps, first the corresponding user needs to be created and configured and then the database itself has to be created and prepared for the HRM.
Create the HRM database user¶
Unless the database user for the HRM is already existing, you need to create it and assign the corresponding permissions.
MySQL¶
The following command will create a new MySQL user hrm
and grant the
permissions to a database hrm@localhost
using the mysql
command line
tool. Of course, you can also use a database management tool like
phpmyadmin
to perform this task if you prefer. Make sure to adjust the
password for the new database user so it matches the one from your
configuration files.
# start the mysql command line client and connect as root:
mysql -u root -p
# now from within the client, create the database user:
CREATE USER 'hrm'@'localhost' IDENTIFIED BY 'dbpasswd';
# grant permissions to the user:
GRANT ALL ON hrm.* to 'hrm'@'localhost';
exit;
PostgreSQL¶
su postgres -c "createuser -e -P -d -A -S -R -N hrm"
su postgres -c "createdb hrm"
MD5 host authentication has to be enabled explicitly on Fedora. This can be done using the following commands:
sudo -s
echo "host all hrm 127.0.0.1/32 md5" >> /var/lib/pgsql/data/pg_hba.conf
service postgresql restart
Create or update the database¶
Run the php script $HRM_SETUP/dbupdate.php
from the shell to create and
populate the HRM database. The same command can be used to perform an upgrade
of the database when the HRM version is upgraded:
cd $HRM_SETUP
php dbupdate.php
If the database does not exist, it will be created using the information stored in the $HRM_CONFIG/hrm_client_config.inc
and filled with content for the latest revision. If it exists, it will be updated from whichever revision it currently has.