Discussion :

[Tristanae]

Bonjour,

j'ai créé une application web sur un Xampp (donc avec un MySQL). L’entreprise souhaite pour des raison de sécurité et de norme faire passer l'application sur un Ubuntu 16.04 avec PostgreSQL (Symfony 3.1.4 et PHP Version 7.0.15-0ubuntu0.16.04.4). Précision PostgreSQL ce trouve sur un serveur dédié et l'application elle même est sur un serveur web différent
Le problème est que je n'arrive pas à me connecter sur mon application depuis.

Quand je me connecte l'application m'affiche

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
 
Authentication request could not be processed due to a system problem.

Malheureusement le message est trop vague et n'aide pas trop.
j'ai regarder dans les log et ça ne m'avance pas plus.

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
 
[2017-07-13 16:56:12] request.INFO: Matched route "{route}". {"route":"fos_user_security_check","route_parameters":{"_controller":"FOS\\UserBundle\\Controller\\SecurityController::checkAction","_route":"fos_user_security_check"},"request_uri":"http://xx.xxx.xx.xxx/rubis/web/app_dev.php/login_check","method":"POST"} []
[2017-07-13 16:56:12] doctrine.DEBUG: SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.locked AS locked_9, t0.expired AS expired_10, t0.expires_at AS expires_at_11, t0.confirmation_token AS confirmation_token_12, t0.password_requested_at AS password_requested_at_13, t0.roles AS roles_14, t0.credentials_expired AS credentials_expired_15, t0.credentials_expire_at AS credentials_expire_at_16, t0.id AS id_17, t0.dn AS dn_18, t0.name AS name_19, t0.language AS language_20 FROM fos_user t0 WHERE t0.username_canonical = ? LIMIT 1 ["formateur"] []
[2017-07-13 16:56:12] doctrine.DEBUG: SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.locked AS locked_9, t0.expired AS expired_10, t0.expires_at AS expires_at_11, t0.confirmation_token AS confirmation_token_12, t0.password_requested_at AS password_requested_at_13, t0.roles AS roles_14, t0.credentials_expired AS credentials_expired_15, t0.credentials_expire_at AS credentials_expire_at_16, t0.id AS id_17, t0.dn AS dn_18, t0.name AS name_19, t0.language AS language_20 FROM fos_user t0 WHERE t0.username_canonical = ? LIMIT 1 ["formateur"] []
[2017-07-13 16:56:12] security.INFO: Authentication request failed. {"exception":"[object] (Symfony\\Component\\Security\\Core\\Exception\\AuthenticationServiceException(code: 0): Notice: unserialize(): Error at offset 9 of 30 bytes at /var/www/rubis/vendor/symfony/symfony/src/Symfony/Component/Security/Core/Authentication/Provider/DaoAuthenticationProvider.php:94, Symfony\\Component\\Debug\\Exception\\ContextErrorException(code: 0): Notice: unserialize(): Error at offset 9 of 30 bytes at /var/www/rubis/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ArrayType.php:58)"} []
[2017-07-13 16:56:12] security.DEBUG: Authentication failure, redirect triggered. {"failure_path":"/login"} []
[2017-07-13 16:56:12] request.INFO: Matched route "{route}". {"route":"fos_user_security_login","route_parameters":{"_controller":"FOS\\UserBundle\\Controller\\SecurityController::loginAction","_route":"fos_user_security_login"},"request_uri":"http://xx.xxx.xx.xxx/rubis/web/app_dev.php/login","method":"GET"} []
[2017-07-13 16:56:12] security.INFO: Populated the TokenStorage with an anonymous Token. [] []
[2017-07-13 16:56:13] request.INFO: Matched route "{route}". {"route":"_wdt","route_parameters":{"_controller":"web_profiler.controller.profiler:toolbarAction","token":"cf8f2c","_route":"_wdt"},"request_uri":"http://xx.xxx.xx.xxx/rubis/web/app_dev.php/_wdt/cf8f2c","method":"GET"} []
[2017-07-13 16:56:14] request.INFO: Matched route "{route}". {"route":"_profiler","route_parameters":{"_controller":"web_profiler.controller.profiler:panelAction","token":"cf8f2c","_route":"_profiler"},"request_uri":"http://xx.xxx.xx.xxx/rubis/web/app_dev.php/_profiler/cf8f2c?panel=translation","method":"GET"} []
[2017-07-13 16:56:14] request.INFO: Matched route "{route}". {"route":"_profiler_search_bar","route_parameters":{"_controller":"web_profiler.controller.profiler:searchBarAction","_route":"_profiler_search_bar"},"request_uri":"http://xx.xxx.xx.xxx/rubis/web/app_dev.php/_profiler/search_bar?panel=translation","method":"GET"} []

Après moult recherche je ne trouve pas la solution donc je viens demander un peu d'aide.

Voici le ficher de configue

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
 
# Doctrine Configuration
doctrine:
    dbal:
       default_connection: pgsql
       connections:
          #Postgresql
          pgsql:
             driver:   pdo_pgsql
             host:     "%psql_database_host%"
             port:     "%psql_database_port%"
             dbname:   "%psql_database_name%"
             user:     "%psql_database_user%"
             password: "%psql_database_password%"
             charset:  UTF8
    orm:
        #naming_strategy: doctrine.orm.naming_strategy.underscore
        #default_entity_manager: pqsql
        auto_generate_proxy_classes: "%kernel.debug%"
        #auto_mapping: true
        entity_managers:
            pgsql:
                naming_strategy: doctrine.orm.naming_strategy.underscore
                auto_mapping: true
                mappings:
                dql:
                    string_functions:
                       DATE_FORMAT: DoctrineExtensions\Query\Postgresql\DateFormat
                       FROM_UNIXTIME: DoctrineExtensions\Query\Postgresql\UnixTimestamp
                       SUBSTRING_INDEX: DoctrineExtensions\Query\Postgresql\SubstringIndex
                       CHAR_LENGTH: DoctrineExtensions\Query\Postgresql\CharLength
 
# Swiftmailer Configuration
swiftmailer:
    transport:  "%mailer_transport%"
    host:       "%mailer_host%"
    #username:   "%mailer_user%"
    #password:   "%mailer_password%"
    port:       "%mailer_port%"
    #encryption: "%mailer_encryption%"
    spool:     { type: memory }
 
assetic:
    debug:          "%kernel.debug%"
    use_controller: "%kernel.debug%"
    filters:
        cssrewrite: ~
 
knp_snappy:
    pdf:
        enabled:    true
        binary:     "%wkhtmltopdf_directory%\\wkhtmltopdf.exe"
        #binary:     "\"C:\\Program Files\\wkhtmltopdf\\bin\\wkhtmltopdf.exe\""
        #binary:     "\"C:/Program Files/wkhtmltopdf/bin/wkhtmltopdf.exe\""
        options:    []
    image:
        enabled:    true
        binary:     "%wkhtmltopdf_directory%\\wkhtmltoimage.exe"
        options:    []
    temporary_folder: "%kernel.cache_dir%\\snappy"
 
fos_user:
    db_driver: orm
    firewall_name: main
    user_class: Rubis\UserBundle\Entity\User
    registration:
        #form:
            #type:               rubis_accueil_adm_creaformation
            #name:   rubis_accueil_adm_creaformation
        #confirmation:
            #template:   RubisAccueilADMBundle:AccueilADM:Option.html.twig
 
fr3d_ldap:
    driver:
        host:                xxx
        port:                xxx
        username:            xxx
        password:            xxx
    user:
        baseDn: xxx
        filter: (&(ObjectClass=xxx))

Je vous remercie d'avance pour vos réponses .

[MehrezLabidi]

bonjour,
il se peut que la connexion entre les deux machines est interrompue ou inexistante.
pour symfony , mysql ou pg c'est la meme chose , juste le port qui change.
donc essayons de tester la connexion entre les deux machines avec un petit script php native pour la connexion pg

http://php.net/manual/fr/function.pg-connect.php