Para manejar esta base de conocimiento hoy veremos como instalar phpMyFAQ en un servidor Linux Centos paso a paso. phpMyFAQ es un proyecto desarrollado en php que usa un motor de bases de datos y en sus ultimas versiones agrega muchas características como conectar con las redes sociales mas populares (facebook, twitter, etc)
Requerimientos
-Instalamos dependencias
yum install wget mariadb-server mariadb httpd
yum install --enablerepo=remi-php56 php-gd php-pecl-jsonc php-common php-mbstring php-xml php-mysql
-Modificamos el conf de php
vi /etc/php.ini
register_globals = off
safe_mode = off
memory_limit = 128M
-Activamos el servicio y lo ejecutamos
systemctl enable mariadb.service
systemctl start mariadb.service
-Aseguramos la configuración de MariaDB. Los defaults son suficiente, solo colocamos contraseña a la cuenta root de MariaDB
mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MariaDB to secure it, we'll need the current
password for the root user. If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none):
OK, successfully used password, moving on...
Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.
Set root password? [Y/n]
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
... Success!
By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n]
... Success!
Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n]
... Success!
By default, MariaDB comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n]
- Dropping test database...
... Success!
- Removing privileges on test database...
... Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n]
... Success!
Cleaning up...
All done! If you've completed all of the above steps, your MariaDB
installation should now be secure.
Thanks for using MariaDB!
-Ingresamos a MariaDB como root, creamos una db para phpMyFAQ y un usuario admin para ella con su contraseña
mysql -u root -p
create database faqdb;
GRANT ALL ON faqdb.* TO faqusr@localhost IDENTIFIED BY 'contraseña';
flush privileges;
exit;
-Activamos y ejecutamos el servicio
systemctl enable httpd.service
systemctl start httpd.service
-Nos cambiamos el directorio html de apache y descargamos phpMyFAQ
cd /var/www/html
yum install --enablerepo=remi-php56 php-gd php-pecl-jsonc php-common php-mbstring php-xml php-mysql
-Modificamos el conf de php
vi /etc/php.ini
register_globals = off
safe_mode = off
memory_limit = 128M
MariaDB
-Activamos el servicio y lo ejecutamos
systemctl enable mariadb.service
systemctl start mariadb.service
-Aseguramos la configuración de MariaDB. Los defaults son suficiente, solo colocamos contraseña a la cuenta root de MariaDB
mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MariaDB to secure it, we'll need the current
password for the root user. If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none):
OK, successfully used password, moving on...
Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.
Set root password? [Y/n]
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
... Success!
By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n]
... Success!
Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n]
... Success!
By default, MariaDB comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n]
- Dropping test database...
... Success!
- Removing privileges on test database...
... Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n]
... Success!
Cleaning up...
All done! If you've completed all of the above steps, your MariaDB
installation should now be secure.
Thanks for using MariaDB!
-Ingresamos a MariaDB como root, creamos una db para phpMyFAQ y un usuario admin para ella con su contraseña
mysql -u root -p
create database faqdb;
GRANT ALL ON faqdb.* TO faqusr@localhost IDENTIFIED BY 'contraseña';
flush privileges;
exit;
Apache httpd
-Activamos y ejecutamos el servicio
systemctl enable httpd.service
systemctl start httpd.service
phpMyFAQ
-Nos cambiamos el directorio html de apache y descargamos phpMyFAQ
cd /var/www/html
wget -c http://download.phpmyfaq.de/phpMyFAQ-2.8.26.tar.gz
-Descomprimimos el archivo
tar xzvf phpMyFAQ-2.8.26.tar.gz
-Creamos directorios necesarios de phpMyFAQ, cambiamos sus permisos y activamos a apache como owner de todos los directorios
mkdir phpmyfaq/attachments
mkdir phpmyfaq/data
mkdir phpmyfaq/images
chmod 775 phpmyfaq/attachments phpmyfaq/data phpmyfaq/images
chown -R apache.apache phpmyfaq/
-Abrimos un browser y navegamos a http://ip-servidor-centos/phpmyfaq. En la pagina que veremos elegimos:
Database server: MariaDB 5.x
Database hostname: localhost
Database user: faqusr
Database password: contraseña
Database name: faqdb
Default lenguaje: Spanish
Permision level: Basic
Your Name: Tu nombre
Your email address: Tu email
Your login name: usuario admin
Your password: contraseña de admin
Retype password: volvemos a escribir la contraseña de admin
Damos click al botón Click to install phpMyFAQ
-Después de un rato (en que aprovechamos para ir por un café) ya tendremos nuestro phpMyFAQ instalado. Se nos pedirá llenar una encuesta para los desarrolladores, algo útil para retroalimentarlos. Damos click al link admin section para entrar como administrador
-En la nueva pagina entramos con el usuario creado
-La pagina principal al ingresar como admin nos mostrara estadísticas. Desde allí podemos entrar a crear categorías, usuarios, etc
-Nuestro servidor linux centos 7 con phpMyFAQ esta listo para comenzar a alimentarlo con conocimiento
-Este conocimiento podrá ser consultado desde la pagina principal http://servidor-linux-centos/phpmyfaq
-Ya terminado de configurar el phpMyFAQ eliminamos el archivo update.php
rm phpmyfaq/install/update.php
Ya tenemos nuestro servidor listo para ingresar información, conocimiento que con el tiempo nos servira para solucionar problemas, ya conocías phpMyFAQ? que tal te ha parecido?, escríbeme en los comentarios aquí debajo y pasa la voz compartiendo el tweet.
Como instalar #phpMyFAQ en #Linux #Centos paso a paso ~ videoJuegos y Open Source https://t.co/t3CI2pjGM1 pic.twitter.com/zYWxFQ9aHA
— Manuel Cabrera C (@drivemeca) March 1, 2016
Disfrútenlo.
