Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Blocker Blocker
    • Resolution: Invalid
    • Affects Version/s: 5.0.0-dev
    • Component/s: Documentation, Install
    • Labels:
    • Environment:

      Operating System: RHEL 6.3
      PHP Version: 5.3.3
      Database and version: MySQL 5.1.61
      Browser (and version): Firefox 16.0

      Description

      After installing eZ Publish 4.7 I followed the document in doc.ez.no (http://doc.ez.no/eZ-Publish/Upgrading/Upgrading-to-5.0/Upgrading-from-4.7-to-5.0) and (install.md) to upgrade to eZ Publish 5.0 however I keep getting the following error in var/log/error.log

      "
      [ Nov 02 2012 16:27:08 ] [192.168.2.204] eZMySQLiDB:
      Connection error: Couldn't select the database. Please try again later or inform the system administrator.
      Access denied for user ''@'localhost' to database 'none'
      "

      I've copied ezpublish.yml.example to ezpublish.yml and updated the fields to match my configuration.

        Issue Links

          Activity

          Hide
          Damien Pobel (Inactive) added a comment -

          could you copy/paste your ezpublish.yml and ezpublish_<the_environment_you_are_using>.yml ?

          Show
          Damien Pobel (Inactive) added a comment - could you copy/paste your ezpublish.yml and ezpublish_<the_environment_you_are_using>.yml ?
          Hide
          Pedro Resende (Inactive) added a comment - - edited

          Damien: Here it is, this was tested with today's build #87

          ezpublish:
              siteaccess:
                  # Available siteaccesses
                  list:
                      - ezdemo_site
                      - fre
                      - ezdemo_site_admin
                      - eng
                      - ezflow_site
                      - ezflow_site_admin
                  # Siteaccess groups. Use them to group common settings.
                  groups:
                      ezdemo_group: [ezdemo_site, fre, ezdemo_site_admin, eng, ezflow_site, ezflow_site_admin]
                      frontend_group: [ezdemo_site, fre, ezflow_site, eng]
                  default_siteaccess: ezflow_site
                  match:
                      Map\URI:
                          ezdemo_site: ezdemo_site
                          ezdemo_site_admin: ezdemo_site_admin
                          fre: fre
                          ezflow_site: ezflow_site
                          ezflow_site_admin: ezflow_site_admin
                          eng: eng
                      Map\Host:
                          ezpublish.dev: ezdemo_site
                          admin.ezpublish.dev: ezdemo_site_admin
           
              imagemagick:
                  enabled: true
                  # Absolute path to ImageMagick "convert" binary
                  path: /usr/bin/convert
           
              # System settings, grouped by siteaccess and/or siteaccess group
              system:
                  ezdemo_group:
                      database:
                          type: mysql
                          user: ezp
                          password: ezp
                          server: localhost
                          database_name: ezp47
                      languages: [eng-GB]
                  frontend_group:
                      # Session name will be common for all siteaccesses members of this group
                      # It means that session will be shared for frontend siteaccesses, but not with backoffice
                      session_name: MyFrontendSessionName
                  ezdemo_site:
                      content:
                          view_cache: true
                          ttl_cache: true
                          default_ttl: 30
                      location_view:
                          full:
                              smallFolder:
                                  template: eZDemoBundle:full:small_folder.html.twig
                                  match:
                                      Identifier\ContentType: small_folder
                                      Identifier\ParentContentType: [landing_page, frontpage]
                      # Define here your image variations (formerly known as "image aliases")
                      image_variations:
                          my_image_variation:
                              reference: ~
                              filters:
                                  - {name: geometry/scaledownonly, params: [400, 350]}
                          my_cropped_variation:
                              reference: my_mage_variation
                              filters:
                                  - {name: geometry/scalewidthdownonly, params: [300]}
                                  - {name: geometry/crop, params: [200, 200, 0, 0]}
                  ezdemo_site_admin:
                      # Bypass UrlAliasRouter to use the admin interface since everything needs to run via the legacy kernel
                      url_alias_router: false
          
          

          Show
          Pedro Resende (Inactive) added a comment - - edited Damien: Here it is, this was tested with today's build #87 ezpublish: siteaccess: # Available siteaccesses list: - ezdemo_site - fre - ezdemo_site_admin - eng - ezflow_site - ezflow_site_admin # Siteaccess groups. Use them to group common settings. groups: ezdemo_group: [ezdemo_site, fre, ezdemo_site_admin, eng, ezflow_site, ezflow_site_admin] frontend_group: [ezdemo_site, fre, ezflow_site, eng] default_siteaccess: ezflow_site match: Map\URI: ezdemo_site: ezdemo_site ezdemo_site_admin: ezdemo_site_admin fre: fre ezflow_site: ezflow_site ezflow_site_admin: ezflow_site_admin eng: eng Map\Host: ezpublish.dev: ezdemo_site admin.ezpublish.dev: ezdemo_site_admin   imagemagick: enabled: true # Absolute path to ImageMagick "convert" binary path: /usr/bin/convert   # System settings, grouped by siteaccess and/or siteaccess group system: ezdemo_group: database: type: mysql user: ezp password: ezp server: localhost database_name: ezp47 languages: [eng-GB] frontend_group: # Session name will be common for all siteaccesses members of this group # It means that session will be shared for frontend siteaccesses, but not with backoffice session_name: MyFrontendSessionName ezdemo_site: content: view_cache: true ttl_cache: true default_ttl: 30 location_view: full: smallFolder: template: eZDemoBundle:full:small_folder.html.twig match: Identifier\ContentType: small_folder Identifier\ParentContentType: [landing_page, frontpage] # Define here your image variations (formerly known as "image aliases") image_variations: my_image_variation: reference: ~ filters: - {name: geometry/scaledownonly, params: [400, 350]} my_cropped_variation: reference: my_mage_variation filters: - {name: geometry/scalewidthdownonly, params: [300]} - {name: geometry/crop, params: [200, 200, 0, 0]} ezdemo_site_admin: # Bypass UrlAliasRouter to use the admin interface since everything needs to run via the legacy kernel url_alias_router: false
          Hide
          Damien Pobel (Inactive) added a comment -

          @Pedro: and what about the file ezpublish_<your_environment>.yml ?

          Note: it's not needed to restrict access to this kind of comment

          Show
          Damien Pobel (Inactive) added a comment - @Pedro: and what about the file ezpublish_<your_environment>.yml ? Note: it's not needed to restrict access to this kind of comment
          Hide
          Pedro Resende (Inactive) added a comment - - edited

          @Damien: That's the problem, there isn't mentioned on install.md, nor on http://doc.ez.no/eZ-Publish/Upgrading/Upgrading-to-5.0/Upgrading-from-4.7-to-5.0, that you need a ezpublish_prod.yml file. I found this out after making a clean installation of eZ Publish 5.0. Just created a new issue with that https://jira.ez.no/browse/EZP-19981.
          Now it's working.

          ezpublish_prod.yml

          ezpublish:
              siteaccess:
                  default_siteaccess: eng
                  list:
                      - ezflow_site
                      - eng
                      - ezflow_site_admin
                      - iphone
                  groups:
                      ezflow_site_clean_group:
                          - ezflow_site
                          - eng
                          - ezflow_site_admin
                          - iphone
                  match:
                      URIElement: '1'
              system:
                  ezflow_site_clean_group:
                      database:
                          type: mysql
                          user: ezp
                          password: ezp
                          server: localhost
                          database_name: ezp
                      var_dir: var/ezflow_site_clean
                  eng:
                      url_alias_router: false
                      image_variations:
                          small:
                              reference: null
                              filters:
                                  - { name: geometry/scaledownonly, params: [100, 160] }
                          medium:
                              reference: null
                              filters:
                                  - { name: geometry/scaledownonly, params: [200, 290] }
                          listitem:
                              reference: null
                              filters:
                                  - { name: geometry/scaledownonly, params: [130, 190] }
                          articleimage:
                              reference: null
                              filters:
                                  - { name: geometry/scaledownonly, params: [170, 350] }
                          articlethumbnail:
                              reference: null
                              filters:
                                  - { name: geometry/scaledownonly, params: [70, 150] }
                          gallerythumbnail:
                              reference: null
                              filters:
                                  - { name: geometry/scaledownonly, params: [105, 100] }
                          galleryline:
                              reference: null
                              filters:
                                  - { name: geometry/scaledownonly, params: [70, 150] }
                          imagelarge:
                              reference: null
                              filters:
                                  - { name: geometry/scaledownonly, params: [550, 730] }
                          large:
                              reference: null
                              filters:
                                  - { name: geometry/scaledownonly, params: [360, 440] }
                          rss:
                              reference: null
                              filters:
                                  - { name: geometry/scale, params: [88, 31] }
                          logo:
                              reference: null
                              filters:
                                  - { name: geometry/scaleheight, params: [36] }
                          infoboximage:
                              reference: null
                              filters:
                                  - { name: geometry/scalewidth, params: [75] }
                          billboard:
                              reference: null
                              filters:
                                  - { name: geometry/scalewidth, params: [764] }
                  ezflow_site_admin:
                      url_alias_router: false
                  ezflow_site:
                      url_alias_router: false
                  iphone:
                      url_alias_router: false
              imagemagick:
                  enabled: true
                  path: /usr/bin/convert
          imports:
              -
                  resource: ezpublish.yml
          

          Show
          Pedro Resende (Inactive) added a comment - - edited @Damien: That's the problem, there isn't mentioned on install.md, nor on http://doc.ez.no/eZ-Publish/Upgrading/Upgrading-to-5.0/Upgrading-from-4.7-to-5.0 , that you need a ezpublish_prod.yml file. I found this out after making a clean installation of eZ Publish 5.0. Just created a new issue with that https://jira.ez.no/browse/EZP-19981 . Now it's working. ezpublish_prod.yml ezpublish: siteaccess: default_siteaccess: eng list: - ezflow_site - eng - ezflow_site_admin - iphone groups: ezflow_site_clean_group: - ezflow_site - eng - ezflow_site_admin - iphone match: URIElement: '1' system: ezflow_site_clean_group: database: type: mysql user: ezp password: ezp server: localhost database_name: ezp var_dir: var/ezflow_site_clean eng: url_alias_router: false image_variations: small: reference: null filters: - { name: geometry/scaledownonly, params: [100, 160] } medium: reference: null filters: - { name: geometry/scaledownonly, params: [200, 290] } listitem: reference: null filters: - { name: geometry/scaledownonly, params: [130, 190] } articleimage: reference: null filters: - { name: geometry/scaledownonly, params: [170, 350] } articlethumbnail: reference: null filters: - { name: geometry/scaledownonly, params: [70, 150] } gallerythumbnail: reference: null filters: - { name: geometry/scaledownonly, params: [105, 100] } galleryline: reference: null filters: - { name: geometry/scaledownonly, params: [70, 150] } imagelarge: reference: null filters: - { name: geometry/scaledownonly, params: [550, 730] } large: reference: null filters: - { name: geometry/scaledownonly, params: [360, 440] } rss: reference: null filters: - { name: geometry/scale, params: [88, 31] } logo: reference: null filters: - { name: geometry/scaleheight, params: [36] } infoboximage: reference: null filters: - { name: geometry/scalewidth, params: [75] } billboard: reference: null filters: - { name: geometry/scalewidth, params: [764] } ezflow_site_admin: url_alias_router: false ezflow_site: url_alias_router: false iphone: url_alias_router: false imagemagick: enabled: true path: /usr/bin/convert imports: - resource: ezpublish.yml

            People

            • Assignee:
              Unassigned
              Reporter:
              Pedro Resende (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 hour
                1h