search for: database_us

...aliases || exit 1 root: youremail EOF See: http://medon.htt-consult.com/Centos7-armv7.html But with postfixadmin I stumbled onto a problem. The following: cat <<EOF>/usr/share/postfixadmin/config.local.php || exit 1 <?php $CONF['database_type'] = 'mysqli'; $CONF['database_user'] = 'postfix'; $CONF['database_password'] = 'xyz'; $CONF['database_name'] = 'postfix'; $CONF['configured'] = true; ?> EOF produces: cat <<EOF>/usr/share/postfixadmin/config.local.php || exit 1 <?php ['database_type'] =...

...pache2-mpm-itk but it is not going to be installed E: Broken packages Error: Command mysql is missing Error: /Stage[main]/Nagiosql/Mysql::Db[db_nagiosql]/Database[db_nagiosql]/ensure: change from absent to present failed: Command mysql is missing Error: /Stage[main]/Nagiosql/Mysql::Db[db_nagiosql]/Database_user[nagiosql_user@localhost]: Provider mysql is not functional on this host Error: Could not prefetch database_grant provider ''mysql'': Command mysql is missing Notice: /Stage[main]/Nagiosql/Mysql::Db[db_nagiosql]/Database_grant[nagiosql_user@localhost/db_nagiosql]: Dependency Databa...

...> See: http://medon.htt-consult.com/Centos7-armv7.html > > But with postfixadmin I stumbled onto a problem. The following: > > cat <<EOF>/usr/share/postfixadmin/config.local.php || exit 1 > <?php > $CONF['database_type'] = 'mysqli'; > $CONF['database_user'] = 'postfix'; > $CONF['database_password'] = 'xyz'; > $CONF['database_name'] = 'postfix'; > > $CONF['configured'] = true; > ?> > EOF > > produces: > > cat <<EOF>/usr/share/postfixadmin/config.local.php...

...s in /var/opt/lib/pe-puppet/lib/facter/pe_version.rb info: Loading facts in /var/opt/lib/pe-puppet/lib/facter/custom_auth_conf.rb info: Loading facts in /var/opt/lib/pe-puppet/lib/facter/facter_dot_d.rb err: Could not retrieve catalog from remote server: Error 400 on SERVER: Duplicate declaration: Database_user[gxuser@db.demo.com] is already declared in file /etc/puppetlabs/puppet/modules/mysql/manifests/db.pp at line 62; cannot redeclare at /etc/puppetlabs/puppet/modules/mysql/manifests/db.pp:62 on node demo warning: Not using cache on failed catalog err: Could not retrieve catalog; skipping run )...

...ql replication user through the mysql module, but I seem to be unable to divine the correct way to do this. I''ve tried a number of different variations, but my user doesn''t get the repl_slave_priv on my user table... This is the relevant part of my manifest: ----------------- database_user { "repl_slave@%": password_hash => mysql_password('' ... ''), } database_grant { "repl_slave@%/*.*": privileges => [''repl_slave_priv''], } ---------------- The puppet run doesn''t raise an error, it says: notice: /Stag...

...aliases || exit 1 root: youremail EOF See: http://medon.htt-consult.com/Centos7-armv7.html But with postfixadmin I stumbled onto a problem.? The following: cat <<EOF>/usr/share/postfixadmin/config.local.php || exit 1 <?php $CONF['database_type'] = 'mysqli'; $CONF['database_user'] = 'postfix'; $CONF['database_password'] = 'xyz'; $CONF['database_name'] = 'postfix'; $CONF['configured'] = true; ?> EOF produces: cat <<EOF>/usr/share/postfixadmin/config.local.php || exit 1 <?php ['database_type'] =...

...The only thing that I don't have working is that my current pop3 server (NTMail) has case insensitve usernames. Dovecot doesn't. I was hoping there was just an option to turn on, but I didn't see one, and unfortunately I don't know enough C to change to lc($submitted_user) eq lc($database_user) like I would in perl :-) I do have control over generating the passwd file, and it is currently generating the users to lowecase in the file, so just lc($submitted_user) eq $database_user would work well enough. Unfortunately I don't know enough C to do that, so I thought I would ask if an...

Hello, What would you think of moving database, database_grant and database_user types and providers from puppetlabs-mysql to its own module (puppetlabs-dbproviders for example) so that we can develop providers for others RDBMS ? I''d like to develop providers for postgresql, so I think it makes sense to put this types/providers in its own module. best regards,...

Hi everyone, I am new to Puppet and try to make some simple "automation things". I have succeed with apache2, ssh modules, but have problems with Puppetlabs mysql module. It installs mysql server, changes/creates admin user password, but does not create database and user. I cannot find anything wrong in logs (--debug --verbose). I see that manifests is read, but no db/user in mysql.

On Tue, 2017-02-21 at 10:50 -0500, Robert Moskowitz wrote: > cat <<EOF>/usr/share/postfixadmin/config.local.php || exit 1 > <?php > $CONF['database_type'] = 'mysqli'; > $CONF['database_user'] = 'postfix'; > $CONF['database_password'] = 'xyz'; > $CONF['database_name'] = 'postfix'; > > $CONF['configured'] = true; > ?> > EOF KMs method of escaping every $ in the here document works but a simpler method is to esc...

...ound that my old sysntax for database_grant is not compatible with mysql_grant. So, if I had something like: mysql_database{ [ ''biosql'' , ''biosql-test'' ] : ensure => present, require => Class[''mysql::server''], } database_user { ''biocore@%.XXXXX'' : password_hash => mysql_password(''XXXXX'') ; } database_grant { [ ''biocore@%.XXXXXX/biosql'' , ''biocore@%.XXXX/biosql-test'' ] : p...

...and change permissions AllowOverwrite yes <Limit ALL SITE_CHMOD> AllowAll </Limit> # The passwords in MySQL are encrypted using CRYPT SQLAuthTypes Plaintext Crypt SQLAuthenticate users groups # used to connect to the database # databasename at host database_user user_password SQLConnectInfo ftp at localhost proftpd Duk30fZh0u # Here we tell ProFTPd the names of the database columns in the "usertable" # we want it to interact with. Match the names with those in the db SQLUserInfo ftpuser userid passwd uid gid homedir shell # Here we...

...in.com'), +) + +MANAGERS = ADMINS + +DATABASE_ENGINE = 'sqlite3' # 'postgresql_psycopg2', 'postgresql', 'mysql', 'sqlite3' or 'oracle'. +DATABASE_NAME = '/tmp/database.db' # Or path to database file if using sqlite3. +DATABASE_USER = '' # Not used with sqlite3. +DATABASE_PASSWORD = '' # Not used with sqlite3. +DATABASE_HOST = '' # Set to empty string for localhost. Not used with sqlite3. +DATABASE_PORT = '' # Set to empty string for default. Not use...