{"action":"created","issue":{"url":"https://api.github.com/repos/puphpet/puphpet/issues/2130","labels_url":"https://api.github.com/repos/puphpet/puphpet/issues/2130/labels{/name}","comments_url":"https://api.github.com/repos/puphpet/puphpet/issues/2130/comments","events_url":"https://api.github.com/repos/puphpet/puphpet/issues/2130/events","html_url":"https://github.com/puphpet/puphpet/issues/2130","id":128414992,"number":2130,"title":"mariadb root password change is ignored (always 123)","user":{"login":"head82","id":2060042,"avatar_url":"https://avatars.githubusercontent.com/u/2060042?v=3","gravatar_id":"","url":"https://api.github.com/users/head82","html_url":"https://github.com/head82","followers_url":"https://api.github.com/users/head82/followers","following_url":"https://api.github.com/users/head82/following{/other_user}","gists_url":"https://api.github.com/users/head82/gists{/gist_id}","starred_url":"https://api.github.com/users/head82/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/head82/subscriptions","organizations_url":"https://api.github.com/users/head82/orgs","repos_url":"https://api.github.com/users/head82/repos","events_url":"https://api.github.com/users/head82/events{/privacy}","received_events_url":"https://api.github.com/users/head82/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-01-24T18:18:09Z","updated_at":"2016-01-26T12:19:03Z","closed_at":null,"body":"see custom password under: mariadb -> settings -> root_password\r\nafter vagrant up it's still \"123\" (fresh box created)\r\n\r\n```yaml\r\nvagrantfile:\r\n    target: local\r\n    vm:\r\n        box: puphpet/ubuntu1404-x64\r\n        box_url: puphpet/ubuntu1404-x64\r\n        hostname: myproject.local\r\n        memory: '2048'\r\n        cpus: '2'\r\n        chosen_provider: virtualbox\r\n        box_version: ''\r\n        network:\r\n            private_network: 192.168.122.20\r\n            forwarded_port:\r\n                vflnp_cv934ou2dj86:\r\n                    host: '8039'\r\n                    guest: '22'\r\n        post_up_message: ''\r\n        provider:\r\n            virtualbox:\r\n                modifyvm:\r\n                    natdnshostresolver1: false\r\n                showgui: '0'\r\n            vmware:\r\n                numvcpus: 1\r\n            parallels:\r\n                use_linked_clone: '0'\r\n                check_guest_tools: '0'\r\n                update_guest_tools: '0'\r\n        provision:\r\n            puppet:\r\n                manifests_path: puphpet/puppet/manifests\r\n                module_path: puphpet/puppet/modules\r\n                options:\r\n                    - '--verbose'\r\n                    - '--hiera_config /vagrant/puphpet/puppet/hiera.yaml'\r\n        synced_folder:\r\n            vflsf_r4lxy8rp8gip:\r\n                source: ./APP_ROOT\r\n                target: /var/www/my.project\r\n                sync_type: default\r\n                smb:\r\n                    smb_host: ''\r\n                    smb_username: ''\r\n                    smb_password: ''\r\n                    mount_options:\r\n                        dir_mode: '0775'\r\n                        file_mode: '0664'\r\n                rsync:\r\n                    args:\r\n                        - '--verbose'\r\n                        - '--archive'\r\n                        - '-z'\r\n                    exclude:\r\n                        - .vagrant/\r\n                        - .git/\r\n                    auto: 'true'\r\n                owner: www-data\r\n                group: www-data\r\n        usable_port_range:\r\n            start: 10200\r\n            stop: 10500\r\n    ssh:\r\n        host: null\r\n        port: null\r\n        private_key_path: null\r\n        username: vagrant\r\n        guest_port: null\r\n        keep_alive: true\r\n        forward_agent: false\r\n        forward_x11: false\r\n        shell: 'bash -l'\r\n        insert_key: false\r\n    vagrant:\r\n        host: detect\r\n    proxy:\r\n        http: ''\r\n        https: ''\r\n        ftp: ''\r\n        no_proxy: ''\r\n        enabled: ''\r\nserver:\r\n    install: '1'\r\n    packages:\r\n        - vim\r\n        - htop\r\n        - curl\r\n        - apache2-utils\r\n        - git\r\n        - unzip\r\nusers_groups:\r\n    install: '1'\r\n    groups: {  }\r\n    users: {  }\r\nlocale:\r\n    install: '1'\r\n    settings:\r\n        default_locale: de_DE.UTF-8\r\n        locales:\r\n            - de_DE.UTF-8\r\n            - en_GB.UTF-8\r\n            - en_US.UTF-8\r\n        timezone: Europe/Berlin\r\nfirewall:\r\n    install: '1'\r\n    rules: {  }\r\ncron:\r\n    install: '1'\r\n    jobs: {  }\r\nnginx:\r\n    install: '1'\r\n    settings:\r\n        default_vhost: 0\r\n        proxy_buffer_size: 128k\r\n        proxy_buffers: '4 256k'\r\n        proxy_connect_timeout: 600s\r\n        proxy_send_timeout: 600s\r\n        proxy_read_timeout: 600s\r\n        names_hash_bucket_size: 128\r\n    upstreams: {  }\r\n    vhosts: {  }\r\n    proxies: {  }\r\napache:\r\n    install: '0'\r\n    settings:\r\n        version: 2.4\r\n        user: www-data\r\n        group: www-data\r\n        default_vhost: true\r\n        manage_user: false\r\n        manage_group: false\r\n        sendfile: 0\r\n    modules:\r\n        - proxy_fcgi\r\n        - rewrite\r\n    vhosts:\r\n        av_f660amflw4u2:\r\n            servername: awesome.dev\r\n            serveraliases:\r\n                - www.awesome.dev\r\n            docroot: /var/www/awesome\r\n            port: '80'\r\n            setenv:\r\n                - 'APP_ENV dev'\r\n            setenvif:\r\n                - 'Authorization \"(.*)\" HTTP_AUTHORIZATION=$1'\r\n            custom_fragment: ''\r\n            ssl: '0'\r\n            ssl_cert: ''\r\n            ssl_key: ''\r\n            ssl_chain: ''\r\n            ssl_certs_dir: ''\r\n            ssl_protocol: ''\r\n            ssl_cipher: ''\r\n            directories:\r\n                avd_xkunpzh53epq:\r\n                    path: /var/www/awesome\r\n                    options:\r\n                        - Indexes\r\n                        - FollowSymlinks\r\n                        - MultiViews\r\n                    allow_override:\r\n                        - All\r\n                    require:\r\n                        - 'all granted'\r\n                    custom_fragment: ''\r\n                    files_match:\r\n                        avdfm_jj7l9rvlfqt5:\r\n                            path: \\.php$\r\n                            sethandler: 'proxy:fcgi://127.0.0.1:9000'\r\n                            custom_fragment: ''\r\n                            provider: filesmatch\r\n                    provider: directory\r\nphp:\r\n    install: '1'\r\n    settings:\r\n        version: '56'\r\n    modules:\r\n        php:\r\n            - cli\r\n            - intl\r\n            - mcrypt\r\n        pear: {  }\r\n        pecl: {  }\r\n    ini:\r\n        display_errors: 'On'\r\n        error_reporting: '-1'\r\n        session.save_path: /var/lib/php/session\r\n        date.timezone: UTC\r\n        shorto: 'On'\r\n        short_open_tag: 'On'\r\n        expose_php: 'Off'\r\n        post_max_size: 80M\r\n        upload_max_filesize: 20M\r\n        max_execution_time: '300'\r\n    fpm_ini:\r\n        error_log: /var/log/php-fpm.log\r\n    fpm_pools:\r\n        phpfp_2uv4hr2p0eti:\r\n            ini:\r\n                prefix: www\r\n                listen: '127.0.0.1:9000'\r\n                security.limit_extensions: .php\r\n                user: www-user\r\n                group: www-data\r\n                request_terminate_timeout: '300'\r\n    composer: '1'\r\n    composer_home: ''\r\nxdebug:\r\n    install: '0'\r\n    settings:\r\n        xdebug.default_enable: '1'\r\n        xdebug.remote_autostart: '0'\r\n        xdebug.remote_connect_back: '1'\r\n        xdebug.remote_enable: '1'\r\n        xdebug.remote_handler: dbgp\r\n        xdebug.remote_port: '9000'\r\nblackfire:\r\n    install: '0'\r\n    settings:\r\n        server_id: ''\r\n        server_token: ''\r\n        agent:\r\n            http_proxy: ''\r\n            https_proxy: ''\r\n            log_file: stderr\r\n            log_level: '1'\r\n        php:\r\n            agent_timeout: '0.25'\r\n            log_file: ''\r\n            log_level: '1'\r\nxhprof:\r\n    install: '1'\r\nwpcli:\r\n    install: '1'\r\n    version: v0.21.1\r\ndrush:\r\n    install: '0'\r\n    version: 6.3.0\r\nruby:\r\n    install: '1'\r\n    versions:\r\n        rv_dag6qgag119g:\r\n            default: '1'\r\n            bundler: '1'\r\n            version: 1.9.3\r\npython:\r\n    install: '1'\r\n    packages: {  }\r\n    versions: {  }\r\nnodejs:\r\n    install: '0'\r\n    settings:\r\n        version: '5'\r\n    npm_packages: {  }\r\nhhvm:\r\n    install: '0'\r\n    nightly: 0\r\n    composer: '1'\r\n    composer_home: ''\r\n    settings: {  }\r\n    server_ini:\r\n        hhvm.server.host: 127.0.0.1\r\n        hhvm.server.port: '9000'\r\n        hhvm.log.use_log_file: '1'\r\n        hhvm.log.file: /var/log/hhvm/error.log\r\n    php_ini:\r\n        display_errors: 'On'\r\n        error_reporting: '-1'\r\n        date.timezone: UTC\r\nmariadb:\r\n    install: '1'\r\n    settings:\r\n        version: '10.1'\r\n        root_password: 'password#1'\r\n        override_options: {  }\r\n    adminer: 0\r\n    users:\r\n        mariadbnu_fp315dblbkl1:\r\n            name: myproject-dev\r\n            password: 'password#1'\r\n    databases:\r\n        mariadbnd_ojyc5m3thfrm:\r\n            name: myproject-dev\r\n            sql: /vagrant/database/myproject-dev.sql\r\n    grants:\r\n        mariadbng_z0n2vxcawvw8:\r\n            user: myproject-dev\r\n            table: 'myproject-dev.*'\r\n            privileges:\r\n                - ALTER\r\n                - CREATE\r\n                - 'CREATE ROUTINE'\r\n                - 'CREATE TEMPORARY TABLES'\r\n                - 'CREATE VIEW'\r\n                - DELETE\r\n                - DROP\r\n                - EVENT\r\n                - EXECUTE\r\n                - INDEX\r\n                - INSERT\r\n                - 'LOCK TABLES'\r\n                - SELECT\r\n                - 'SHOW VIEW'\r\n                - TRIGGER\r\n                - UPDATE\r\nmysql:\r\n    install: '0'\r\n    settings:\r\n        version: '5.5'\r\n        root_password: '123'\r\n        override_options: {  }\r\n    adminer: 0\r\n    users:\r\n        mysqlnu_hi1ci5jvtn03:\r\n            name: dbuser\r\n            password: '123'\r\n    databases:\r\n        mysqlnd_sl8nk8y5mz1i:\r\n            name: dbname\r\n            sql: ''\r\n    grants:\r\n        mysqlng_eo7ykv3gsbwu:\r\n            user: dbuser\r\n            table: '*.*'\r\n            privileges:\r\n                - ALL\r\npostgresql:\r\n    install: '0'\r\n    settings:\r\n        global:\r\n            encoding: UTF8\r\n            version: '9.4'\r\n        server:\r\n            postgres_password: '123'\r\n    databases: {  }\r\n    users: {  }\r\n    grants: {  }\r\n    adminer: 0\r\nmongodb:\r\n    install: '0'\r\n    settings:\r\n        auth: 1\r\n        bind_ip: 127.0.0.1\r\n        port: '27017'\r\n    globals:\r\n        version: 2.6.0\r\n    databases: {  }\r\nredis:\r\n    install: '1'\r\n    settings:\r\n        port: '6379'\r\nsqlite:\r\n    install: '0'\r\n    adminer: 0\r\n    databases: {  }\r\nmailhog:\r\n    install: '1'\r\n    settings:\r\n        smtp_ip: 0.0.0.0\r\n        smtp_port: 1025\r\n        http_ip: 0.0.0.0\r\n        http_port: '8025'\r\n        path: /usr/local/bin/mailhog\r\nbeanstalkd:\r\n    install: '0'\r\n    settings:\r\n        listenaddress: 0.0.0.0\r\n        listenport: '11300'\r\n        maxjobsize: '65535'\r\n        maxconnections: '1024'\r\n        binlogdir: /var/lib/beanstalkd/binlog\r\n        binlogfsync: null\r\n        binlogsize: '10485760'\r\n    beanstalk_console: 0\r\nrabbitmq:\r\n    install: '0'\r\n    settings:\r\n        port: '5672'\r\n    users: {  }\r\n    vhosts: {  }\r\n    plugins: {  }\r\nelastic_search:\r\n    install: '0'\r\n    settings:\r\n        version: 2.1.0\r\n        java_install: true\r\n    instances:\r\n        esi_65awl9kfhlp9:\r\n            name: es-01\r\nsolr:\r\n    install: '0'\r\n    settings:\r\n        version: 4.10.2\r\n        port: '8984'\r\n```\r\n"},"comment":{"url":"https://api.github.com/repos/puphpet/puphpet/issues/comments/174978095","html_url":"https://github.com/puphpet/puphpet/issues/2130#issuecomment-174978095","issue_url":"https://api.github.com/repos/puphpet/puphpet/issues/2130","id":174978095,"user":{"login":"philipheimboeck","id":6714855,"avatar_url":"https://avatars.githubusercontent.com/u/6714855?v=3","gravatar_id":"","url":"https://api.github.com/users/philipheimboeck","html_url":"https://github.com/philipheimboeck","followers_url":"https://api.github.com/users/philipheimboeck/followers","following_url":"https://api.github.com/users/philipheimboeck/following{/other_user}","gists_url":"https://api.github.com/users/philipheimboeck/gists{/gist_id}","starred_url":"https://api.github.com/users/philipheimboeck/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/philipheimboeck/subscriptions","organizations_url":"https://api.github.com/users/philipheimboeck/orgs","repos_url":"https://api.github.com/users/philipheimboeck/repos","events_url":"https://api.github.com/users/philipheimboeck/events{/privacy}","received_events_url":"https://api.github.com/users/philipheimboeck/received_events","type":"User","site_admin":false},"created_at":"2016-01-26T12:19:03Z","updated_at":"2016-01-26T12:19:03Z","body":"Had the same issue and I think I found the problem: It seems like it is using the mysql root password instead of the one of mariadb.\r\n\r\n```\r\n// MariaDb.pp\r\n$root_password = array_true($mysql['settings'], 'root_password') ? {\r\n    true    => $mysql['settings']['root_password'],\r\n    default => $mysql::params::root_password\r\n  }\r\n```\r\n\r\nI guess it should be \r\n\r\n```\r\n// MariaDb.pp\r\n$root_password = array_true($mariadb['settings'], 'root_password') ? {\r\n    true    => $mariadb['settings']['root_password'],\r\n    default => $mysql::params::root_password\r\n  }\r\n```"}}