[pkgsrc/trunk]: pkgsrc/www/php-glpi Add basic mysql setup instructions.

[hauke <hauke%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/efe8bc822455
branches:  trunk
changeset: 365567:efe8bc822455
user:      hauke <hauke%pkgsrc.org@localhost>
date:      Thu Jul 20 15:52:02 2017 +0000

description:
Add basic mysql setup instructions.

diffstat:

 www/php-glpi/MESSAGE |  27 ++++++++++++++++++++++-----
 1 files changed, 22 insertions(+), 5 deletions(-)

diffs (41 lines):

diff -r 2ffafdc6c142 -r efe8bc822455 www/php-glpi/MESSAGE
--- a/www/php-glpi/MESSAGE      Thu Jul 20 13:20:21 2017 +0000
+++ b/www/php-glpi/MESSAGE      Thu Jul 20 15:52:02 2017 +0000
@@ -1,15 +1,32 @@
 ===========================================================================
-$NetBSD: MESSAGE,v 1.2 2017/07/18 15:19:05 hauke Exp $
+$NetBSD: MESSAGE,v 1.3 2017/07/20 15:52:02 hauke Exp $
+
+GLPI requires a web server set up to run PHP scripts;
+${PREFIX}/share/examples/glpi/http-glpi.conf is a sample 
+configuration for Apache. 
+
+In addition, you need access to a MySQL server. Create a MySQL gpli user, 
+and as that user create a database:
 
-To run GLPI, you need a web server set up to run PHP scripts;
-${PREFIX}/share/examples/glpi/http-glpi.conf is a sample 
-configuration for Apache. In addition, you need access to a MySQL server.
+# mysql -u root -p 
+Enter password: <your_mysql_root_passwd>
+
+mysql> CREATE DATABASE glpi; 
+mysql> CREATE USER 'glpi'@'<web_server_host_name>'; 
+mysql> GRANT ALL PRIVILEGES ON glpi.* TO 'glpi'@'<web_server_host_name>'
+               IDENTIFIED BY '<your_glpi_passwd>'; 
+mysql> FLUSH PRIVILEGES; 
+mysql> EXIT 
+Bye 
+# 
 
 To set up or upgrade GLPI, activate the setup page:
 
 cd ${PREFIX}/share/glpi/install && mv install.php.disabled install.php
 
-Then, open <http://localhost/glpi>.
+Then, open <http://localhost/glpi>. Follow the instructions, enter the
+above glpi user's credentials, and select the newly created glpi
+database.
 
 Rename install.php when you are done.