febrero 24, 2015

Instalar apache php mysql en Fedora 21


Installing Apache2 With PHP5 And MySQL Support On Fedora 21 (LAMP)

Version 1.0
Author: Srijan Kishore <s [dot] kishore [at] ispconfig [dot] org>
Follow howtoforge on Twitter
Last edited 12/Dec/2014

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a Fedora 21 server with PHP5 support (mod_php) and MySQL support.

1 Preliminary Note

In this tutorial I use the hostname server1.example.com with the IP address 192.168.0.100. These settings might differ for you, so you have to replace them where appropriate.


2 Installing MySQL/MariaDB 5

To install MariaDB, we do this:

yum install mariadb mariadb-server

Then we create the system startup links for MariaDB (so that MariaDB starts automatically whenever the system boots) and start the MariaDB server:

systemctl enable mariadb.service

Further start the service of mysql

systemctl start mariadb.service

Run

mysql_secure_installation

to set a password for the user root (otherwise anybody can access your MySQL database!):

[root@server1 ~]# mysql_secure_installation
/usr/bin/mysql_secure_installation: line 379: find_mysql_client: command not found

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): <-- ENTER
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] <-- ENTER
New password: <-- yourrootsqlpassword
Re-enter new password: <-- yourrootsqlpassword
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] <-- ENTER
 ... 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] <-- ENTER
 ... 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] <-- ENTER
 - 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] <-- ENTER
 ... 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!
[root@server1 ~]#


3 Installing Apache2

Apache2 is available as a Fedora package, therefore we can install it like this:

yum install httpd

Now configure your system to start Apache at boot time...

systemctl enable httpd.service

... and start Apache:

systemctl start httpd.service

Next we need to add the Apache service override in Firewall-cmd as follows:

 firewall-cmd --set-default-zone=public

firewall-cmd --permanent --zone=public --add-service=http
firewall-cmd --permanent --zone=public --add-service=https
firewall-cmd --reload


Now direct your browser to http://192.168.0.100, and you should see the Apache2 placeholder page:

Apache's default document root is /var/www/html on Fedora, and the configuration file is /etc/httpd/conf/httpd.conf. Additional configurations are stored in the /etc/httpd/conf.d/ directory.


4 Installing PHP5

We can install PHP5 and the Apache PHP5 module as follows:

yum install php

We must restart Apache afterwards:

systemctl restart httpd.service

5 Testing PHP5 / Getting Details About Your PHP5 Installation

The document root of the default web site is /var/www/html. We will now create a small PHP file (info.php) in that directory and call it in a browser. The file will display lots of useful details about our PHP installation, such as the installed PHP version.

nano /var/www/html/info.php

<?php
phpinfo();
?>

Now we call that file in a browser (e.g. http://192.168.0.100/info.php):

As you see, PHP5 is working, and it's working through the Apache 2.0 Handler, as shown in the Server API line. If you scroll further down, you will see all modules that are already enabled in PHP5. MySQL is not listed there which means we don't have MySQL support in PHP5 yet.


6 Getting MySQL Support In PHP5

To get MySQL support in PHP, we can install the php-mysql package. It's a good idea to install some other PHP5 modules as well as you might need them for your applications. You can search for available PHP5 modules like this:

yum search php

Pick the ones you need and install them like this:

yum install php-mysqlnd php-mssql php-opcache

Now restart Apache2:

systemctl restart httpd.service

Now reload http://192.168.0.100/info.php in your browser and scroll down to the modules section again. You should now find lots of new modules there, including the MySQL module:

7 phpMyAdmin

phpMyAdmin is a web interface through which you can manage your MySQL databases.

phpMyAdmin can be installed as follows:

yum install phpmyadmin

Now we configure phpMyAdmin. We change the Apache configuration so that phpMyAdmin allows connections not just from localhost (by commenting out everything in the <Directory /usr/share/phpMyAdmin/> stanza and adding the line Require all granted):

nano /etc/httpd/conf.d/phpMyAdmin.conf

<Directory /usr/share/phpMyAdmin/>
#   AddDefaultCharset UTF-8

#   <IfModule mod_authz_core.c>
#     # Apache 2.4
#     <RequireAny>
#       Require ip 127.0.0.1
#       Require ip ::1
#     </RequireAny>
#   </IfModule>
#   <IfModule !mod_authz_core.c>
#     # Apache 2.2
#     Order Deny,Allow
#     Deny from All
#     Allow from 127.0.0.1
#     Allow from ::1
#   </IfModule>
     Require all granted
</Directory>

Restart Apache:

systemctl restart httpd.service

Afterwards, you can access phpMyAdmin under http://192.168.0.100/phpmyadmin/:

8 Links

    Apache: http://httpd.apache.org/
    PHP: http://www.php.net/
    MySQL: http://www.mysql.com/
    Fedora: http://fedoraproject.org/
    phpMyAdmin: http://www.phpmyadmin.net/

Fuente: https://www.howtoforge.com/fedora-21-apache-mysql-php-lamp

Agregar cockpit al firewall

[root@webtest ~]# firewall-cmd --permanent --zone=public --add-service=cockpit
success
[root@webtest ~]# firewall-cmd --reload
success
[root@webtest ~]# firewall-cmd --list-services
cockpit dhcpv6-client ssh


febrero 23, 2015

febrero 09, 2015

Pdf R&OS error en $pdf->ezText

[Mon Feb 09 18:47:14 2015] [error] [client xxx.xxx.xxx.xxx] PHP Notice:  Undefined index:  in /var/www/html/class.pdf.php on line 1934
[Mon Feb 09 18:47:14 2015] [error] [client xxx.xxx.xxx.xxx] PHP Notice:  Undefined index:  in /var/www/html/class.pdf.php on line 2421
[Mon Feb 09 18:47:14 2015] [error] [client xxx.xxx.xxx.xxx] PHP Notice:  Undefined index:  in /var/www/html/class.pdf.php on line 1631







El error se presenta porque falta la fuente 

Hay que checar si la carpeta de la fuente /Helvetica.afm no está o le falta permiso de ejecución para otros 775

febrero 04, 2015

Error AH00052

[Wed Feb 04 14:36:09.792546 2015] [core:notice] [pid 25706] AH00052: child pid 29809 exit signal Segmentation fault (11)

[Wed Feb 04 18:01:55.064195 2015] [core:notice] [pid 25706] AH00052: child pid 14228 exit signal Segmentation fault (11)

[Wed Feb 04 18:01:55.064254 2015] [core:notice] [pid 25706] AH00052: child pid 16502 exit signal Bus error (7)

editando
/etc/httpd/conf.modules.d/00-base.conf

y comentando
#LoadModule reqtimeout_module modules/mod_reqtimeout.so


https://community.bitnami.com/t/apache-2-4-and-php-5-4-getting-connection-reset-errors-in-the-browser/3715/5

Listar todos los módulos cargados por apache

Para listar todos los módulos cargados en apache se puede usar el comando siguiente:

apachectl -t -D DUMP_MODULES

Fuente:
https://adminuser.wordpress.com/2008/06/12/list-all-the-loaded-modules-apache/

febrero 03, 2015

get_records_sql regresa sólo un registro

get_records_sql returns only one result

get_records_sql regresa sólo una fila porque agrupa si son iguales las filas regresadas.

Es decir para los siguientes registros;

tabla alumnos
id, nombre, apellido
1, Richard, Site
2, Richard, Vázquez
3, Richard, Leal

si se ejecuta el query

get_records_sql( "SELECT nombre FROM alumnos")

el único resultado será "Richard".

Mientras que si se ejecuta el query

get_records_sql( "SELECT id,nombre FROM alumnos")

Ya no agrupará el resultado y dará una salida de
1, Richard
2, Richard
3, Richard

¿Cómo poner el conteo de las filas en una consulta en MySql?

 ¿Cómo poner el conteo de las filas en una consulta en MySql? SELECT  @rownum := @rownum + 1 AS contador,  /*Contador*/ t.*  /* nombre d...