No se puede crear la configuración del servidor web Apache

Created:

2016-11-16 13:19:09 UTC

Modified:

2017-08-16 18:29:04 UTC

2

Was this article helpful?


Have more questions?

Enviar una solicitud

No se puede crear la configuración del servidor web Apache

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 12.0 for Linux
  • Plesk 11.0 for Linux
  • Plesk 11.5 for Linux
  • Plesk 10.4 for Linux/Unix
  • Plesk 10.3 for Linux/Unix

Síntomas

Los síntomas pueden ser los siguientes:

1. El verificador previo a la actualización de Parallels Plesk Panel muestra la siguiente advertencia:

WARNING: Reference between several subscriptions and APS applications has been broken.


2. Cuando se realizan cambios en la configuración de los objetos de Parallels Plesk Panel que implican la recreación del archivo de configuración del servidor web Apache, se obtiene el siguiente error:

Error: New files of configuration for Apache web server were not built due to errors in configuration templates. The detailed error message was e-mailed to you, so please check the e-mail, fix the errors, and click here to retry generating configuration.

Resolución

Para resolver el problema es necesario corregir las referencias dañadas de la base de datos:
1 . Cree un volcado de la base de datos psa:

# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` psa > /var/lib/psa/dumps/psadump.kb112815.`date "+%Y-%m-%d_%H:%M"`.sql

2. Examine el error de configuración en la base de datos de Parallels Plesk Panel:

mysql> select id,objectId,status,description from Configurations where status="error";
+-----+----------+--------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id  | objectId | status | description                                                                                                                                                                 |
+-----+----------+--------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|   5 |        1 | error  | Template processing failed: file = /usr/local/psa/admin/conf/templates/default/domainVhost.php, error = SQLSTATE[HY093]: Invalid parameter number: no parameters were bound |
| 195 |       96 | error  | Template processing failed: file = /usr/local/psa/admin/conf/templates/default/domainVhost.php, error = SQLSTATE[HY093]: Invalid parameter number: no parameters were bound |
| 205 |      101 | error  | Template processing failed: file = /usr/local/psa/admin/conf/templates/default/domainVhost.php, error = SQLSTATE[HY093]: Invalid parameter number: no parameters were bound |
| 835 |      434 | error  | Template processing failed: file = /usr/local/psa/admin/conf/templates/default/domainVhost.php, error = SQLSTATE[HY093]: Invalid parameter number: no parameters were bound |
| 837 |      435 | error  | Template processing failed: file = /usr/local/psa/admin/conf/templates/default/domainVhost.php, error = SQLSTATE[HY093]: Invalid parameter number: no parameters were bound |
+-----+----------+--------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
5 rows in set (0.00 sec)

3. Cree una lista de los contextos dañados de las aplicaciones APS. Tenga en cuenta que subscriptionId debería ser igual MainSubscriptionId o AdditionalSubscriptionId :
mysql> select aps.id, pleskId, subscriptionId, s.id as MainSubscriptionId, su.id as AddSubscriptionId  from apsContexts aps left join domains d on d.id=aps.pleskId left join domains w on w.id = d.webspace_id left join Subscriptions s on s.object_id=d.id left join Subscriptions su on su.object_id = w.id where (subscriptionId!=s.id and su.id is null) or (subscriptionId!=su.id and s.id is null) or aps.subscriptionId is null;
+----+---------+----------------+--------------------+-------------------+
| id | pleskId | subscriptionId | MainSubscriptionId | AddSubscriptionId |
+----+---------+----------------+--------------------+-------------------+
|  2 |       1 | 0 | 1 |              NULL |
|  3 |      96 | 96 | 75 |              NULL |
|  4 |     101 | 101 | 79 |              NULL |
|  5 |     434 | 0 |               NULL | 75 |
|  6 |     435 | NULL |               NULL | 75 |
+----+---------+----------------+--------------------+-------------------+
5 rows in set (0.00 sec)


4. Modifique el contexto dañado de las aplicaciones APS del paso nº 3:
mysql> update apsContexts set subscriptionId= 1 where pleskId= 1 ;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> update apsContexts set subscriptionId= 75 where pleskId= 96 ;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> update apsContexts set subscriptionId= 79 where pleskId= 101 ;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> update apsContexts set subscriptionId= 75 where pleskId= 434 ;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> update apsContexts set subscriptionId= 75 where pleskId= 435 ;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

5. Recree de forma forzada todos los archivos de configuración del servidor web Apache:
# /usr/local/psa/admin/sbin/httpdmng --reconfigure-all
¿Tiene más preguntas? Enviar una solicitud
Inicie sesión para dejar un comentario.