MediaWiki installation
Feb 25, 08 by Juan Lebrijo about Wiki, blog
At this article we will see how to install MediaWiki over a LAMP server, in my server, over Debian Etch. MediaWiki is a software to mount wikis, PHP developed. A wiki is a collaborative web site hich can be edited by some people at same time. My interests is due to manage my documentation and index it efficiently. Concrete, writing the big texts, the little ones serve this blog. At the beginning, and as usually, I leave, as usually, my reference table: Origin http://meta.wikimedia.org/wiki/Portada/Es Repository http://www.mediawiki.org/wiki/Download Package mediawiki-1.11.1.tar.gz Documentation Instalation: http://meta.wikimedia.org/wiki/Help:Installation General: http://meta.wikimedia.org/wiki/Help:Contents Permissions: http://devpit.org/wiki/Installing_Mediawiki Files Configuration: LocalSettings.php Unzip the package, move the directory to the web root and give permissions to the apache user: 
tar -zxvf mediawiki-1.11.1.tar.gz
cp -r mediawiki-1.11.1 /var/www/wiki
chown -R www-data:www-data /var/www/wiki
Then we will create the database and the administrator user: 
elite:/var/www# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 12022
Server version: 5.0.32-Debian_7etch1-log Debian etch distributionType 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> create database wiki;
Query OK, 1 row affected (0.00 sec)

mysql> grant all on wiki.* to 'wikiadmin'@'localhost' identified by 'contraseña-super-segura';
Query OK, 0 rows affected (0.06 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.03 sec)

mysql> quit
Bye
Finally we will install by browser: http://mydomain/wiki
  • Site name: lebrijo.com
  • Language: ES
  • Admin user: admin/password
  • DB user: wikiadmin/pasword
Generate the configuration file and move it to root directory, then delete the config directry to save the security of your site: 
mv config/LocalSettings.php .
rm -r config/
We can access to our wiki from the URL: http://www.mydomain.com/wiki
Joomla! installation
Feb 20, 08 by Juan Lebrijo about Joomla!, blog
joomla_logo_black.jpg 7.21 KB
In this article i explain how do I install joomla, it is a CMS (Content Management System) for general purpose portals based on PHP+MySQL technologies. Warning: if you want install th Joomla version with spanish administration system, download entire opackage from here: Joomla_1.0.13-spanish-premium.tar.gz, here. As usually I keep mi traditional refference note: Origin http://joomla.org/ Repository Download: http://joomlacode.org/gf/project/joomla/frs/ Modules: http://www.module.joomlademo.de/index.php Themes: themes Translations: todos los lenguajes Extensions: http://extensions.joomla.org/ Paquete Joomla_1.0.13-Stable-Full_Package.tar.gz Documentation (Spanish) Administration: http://ayuda.joomlaspanish.org/ayuda-joomla/ Documentation (English) Help: http://help.joomla.org/ For developers: http://dev.joomla.org/ Go to the oficial web and download the package. Unzip it in our server: 
tar -zxvf Joomla_1.0.13-Stable-Full_Package.tar.gz
cp -r Joomla_1.0.13-Stable-Full_Package /var/www
chown -R www-data:www-data /var/www
With this action we are installing joomla in our web root. Create the portal data base: 
elite:~# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 7748
Server version: 5.0.32-Debian_7etch1-log Debian etch distribution

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> create database joomla;
Query OK, 1 row affected (0.00 sec)

mysql> grant all on joomla.* to 'joomla_admin'@'localhost' identified by 'contraseña-super-segura';
Query OK, 0 rows affected (0.04 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.04 sec)

mysql> quit
Bye
Then continue the installation with the web assistance going to the URL: http://www.mydomain.com.
  • Pass the requirements test. In my installation I must add the following parameter to my PHP configuration: session.auto_start = 0.
  • Accept the GPL license.
  • Write the DDBB data connection.
  • Site data and administrator password.
  • Be careful: delete the installation directory
rm -r /var/www/installation/
Finally we can acceed to the administration wev through the link: http://www.mydomain.com/administrator/index.php
Instalación de Joomla!
Feb 20, 08 by Juan Lebrijo about Joomla!, blog
joomla_logo_black.jpg 7.21 KB
En este artículo instalamos joomla que es un CMS (Content Management System) para portales de propósito general basado en PHP+MySQL. Aviso: si deseas tener la versión de Joomla con la parte de administración incluida en español bájate el paquete de español entero: Joomla_1.0.13-spanish-premium.tar.gz, aquí. Como siempre os dejo mi ficha de referencias: Origen http://joomla.org/ Repositorio Wpress: http://joomlacode.org/gf/project/joomla/frs/ Modulos: http://www.module.joomlademo.de/index.php Presentaciones: themes Traducción: todos los lenguajes Extensiones: http://extensions.joomla.org/ Paquete Joomla_1.0.13-Stable-Full_Package.tar.gz Documentación (Castellano) Administración: http://ayuda.joomlaspanish.org/ayuda-joomla/ Documentación (Inglés) Ayuda: http://help.joomla.org/ Desarrolladores: http://dev.joomla.org/ Vamos a la web oficial y descargamos el paquete: . Lo descomprimiremos en el directorio dentro de la raíz de nuestro servidor: 
tar -zxvf Joomla_1.0.13-Stable-Full_Package.tar.gz
cp -r Joomla_1.0.13-Stable-Full_Package /var/www
chown -R www-data:www-data /var/www
De esta manera estamos instalando el portal en el raíz de nuestra web. Creamos la base de datos del portal: 
elite:~# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 7748
Server version: 5.0.32-Debian_7etch1-log Debian etch distribution

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> create database joomla;
Query OK, 1 row affected (0.00 sec)

mysql> grant all on joomla.* to 'joomla_admin'@'localhost' identified by 'contraseña-super-segura';
Query OK, 0 rows affected (0.04 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.04 sec)

mysql> quit
Bye
Luego continuamos la instalación a través de la web con el proceso automático tecleando en nuestro navegador: http://www.midominio.com.
  • Pasamos un test de requisitos: en mi instalación de PHP tuve que arreglar el siguiente parámetro: session.auto_start = 0.
  • Aceptamos la licencia GPL.
  • Ponemos los datos de la base de datos.
  • Datos de sitio y contraseña de administrador.
  • OJO: por seguridad borrar el directorio de instalación
rm -r /var/www/installation/
Finalmente podemos acceder a la web de administración a través del enlace: http://www.midominio.com/administrator/index.php