Moving to nginx

Visto 215 veces
Saltar al primer mensaje no leído

Ferriol Barbena Matas

no leída,
4 ene 2015, 17:32:244/1/15
a siwapp...@googlegroups.com
Hi,

I'm moving siwapp to a nginx server and I'm having troubles. I install and when I access through the web throws an 500 error. Looking in the logs, it seems is a primary key violation but this doesn't happens in the original copy running in apache... I don't understand why this error occurs. Somebody knows this problem ?
The log is

2015/01/04 22:15:42 [error] 428#0: *90136 FastCGI sent in stderr: "PHP message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'xxxxxxx de xxxxxx xxxxxx' for key 'cstm_idx'" while reading response header from upstream, client: II.PPP.II.PPP, server: xxxxxxx.xxxxxx.com, request: "GET / HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "xxxxxxx.xxxxxx.com"
2015/01/04 22:15:42 [error] 428#0: *90136 FastCGI sent in stderr: "PHP message: Action "sf/sf_default" does not exist.
PHP message: PHP Fatal error:  Uncaught exception 'Doctrine_Connection_Mysql_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'xxxxxxx de xxxxxx xxxxxx' for key 'cstm_idx'' in /var/www/xxxxxx.com/xxxxxxx/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php:1082
Stack trace:
#0 /var/www/xxxxxx.com/xxxxxxx/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection/Statement.php(269): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Statement))
#1 /var/www/xxxxxx.com/xxxxxxx/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php(1042): Doctrine_Connection_Statement->execute(Array)
#2 /var/www/xxxxxx.com/xxxxxxx/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php(687): Doctrine_Connection->exec('INSERT INTO cus...', Array)
#3 /var/www/xxxxxx.com/xxxxxxx/lib/ven" while reading response header from upstream, client: II.PPP.II.PPP, server: xxxxxxx.xxxxxx.com, request: "GET /sf/sf_default/css/screen.css HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "xxxxxxx.xxxxxx.com", referrer: "https://xxxxxxx.xxxxxx.com/"
2015/01/04 22:15:42 [error] 428#0: *90136 FastCGI sent in stderr: "PHP message: Action "sf/sf_default" does not exist.
PHP message: PHP Fatal error:  Uncaught exception 'Doctrine_Connection_Mysql_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'xxxxxxx de xxxxxx xxxxxx' for key 'cstm_idx'' in /var/www/xxxxxx.com/xxxxxxx/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php:1082
Stack trace:
#0 /var/www/xxxxxx.com/xxxxxxx/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection/Statement.php(269): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Statement))
#1 /var/www/xxxxxx.com/xxxxxxx/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php(1042): Doctrine_Connection_Statement->execute(Array)
#2 /var/www/xxxxxx.com/xxxxxxx/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php(687): Doctrine_Connection->exec('INSERT INTO cus...', Array)
#3 /var/www/xxxxxx.com/xxxxxxx/lib/ven" while reading response header from upstream, client: II.PPP.II.PPP, server: xxxxxxx.xxxxxx.com, request: "GET /sf/sf_default/images/sfTLogo.png HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "xxxxxxx.xxxxxx.com", referrer: "https://xxxxxxx.xxxxxx.com/"
2015/01/04 22:15:42 [error] 428#0: *90140 FastCGI sent in stderr: "PHP message: Action "sf/sf_default" does not exist.
PHP message: PHP Fatal error:  Uncaught exception 'Doctrine_Connection_Mysql_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'xxxxxxx de xxxxxx xxxxxx' for key 'cstm_idx'' in /var/www/xxxxxx.com/xxxxxxx/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php:1082
Stack trace:
#0 /var/www/xxxxxx.com/xxxxxxx/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection/Statement.php(269): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Statement))
#1 /var/www/xxxxxx.com/xxxxxxx/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php(1042): Doctrine_Connection_Statement->execute(Array)
#2 /var/www/xxxxxx.com/xxxxxxx/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php(687): Doctrine_Connection->exec('INSERT INTO cus...', Array)
#3 /var/www/xxxxxx.com/xxxxxxx/lib/ven" while reading response header from upstream, client: II.PPP.II.PPP, server: xxxxxxx.xxxxxx.com, request: "GET /sf/sf_default/images/icons/tools48.png HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "xxxxxxx.xxxxxx.com", referrer: "https://xxxxxxx.xxxxxx.com/"

And the NGINX config:

upstream dddddd_fffffffffff {
  server dddddd.fffffffffff.com;
}

server {
   listen 80;
   server_name dddddd.fffffffffff.com;
  
   rewrite ^(.*) https://$server_name$request_uri? permanent;

}

server {
    listen 443 ssl;
    server_name dddddd.fffffffffff.com;
    root /var/www/fffffffffff.com/dddddd/web; ## <-- Your only path reference.

    ssl_certificate /etc/nginx/ssl/server.crt;
    ssl_certificate_key /etc/nginx/ssl/server.key;

    gzip_static on;

    location ~ ^/(index|frontend|frontend_dev|backend|backend_dev)\.php$ {
      include fastcgi_params;
      fastcgi_split_path_info ^(.+\.php)(/.+)$;
      fastcgi_param PATH_INFO $fastcgi_path_info;
      fastcgi_param PATH_TRANSLATED $document_root$fastcgi_path_info;
      fastcgi_param HTTPS on;
      fastcgi_pass   127.0.0.1:9000;
    }
     
    location / {
      index index.php;
      try_files $uri /index.php?$args;
    }

    access_log  /var/log/nginx/dddddd.fffffffffff.com_access.log  gzip buffer=32k;
    error_log  /var/log/nginx/dddddd.fffffffffff.com_error.log warn;
}


Thanks in advance !
Responder a todos
Responder al autor
Reenviar
0 mensajes nuevos