priestjim/chef-phpmyadmin

An Opscode Chef cookbook for the popular MySQL management application PHPMyAdmin, including LWRPs

chef-phpmyadmin's Issues

"knife cookbook site install phpmyadmin" fails

"knife cookbook site install phpmyadmin" fails as follows:

Uncompressing phpmyadmin version 1.0.4.
ERROR: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received '2'
---- Begin output of tar zxvf /home/waltham/mychefrepo/cookbooks/phpmyadmin.tar.gz ----
STDOUT: 
STDERR: gzip: stdin: not in gzip format

This is because knife expect a gzip file, while the file is in fact compressed with bz2

please add link to github repo in opscode site

http://community.opscode.com/cookbooks/phpmyadmin

Link missing.

Still not autocreated by metadata.rb :(

Last version not available in the opscode community repro

The last version (1.0.6) is not available in the opscode community repository.

I noticed it when i installed the cookbook with berkshelf and run it with chef-solo. I became a error and i was surprised this bug was already closes. Berkshelf installed 1.0.5 instead of 1.0.6

http://community.opscode.com/cookbooks/phpmyadmin

default is missing mbstring

when running the recipe I receive:

ala-rntdbeo.wrs.com ================================================================================
ala-rntdbeo.wrs.com Recipe Compile Error
ala-rntdbeo.wrs.com ================================================================================
ala-rntdbeo.wrs.com
ala-rntdbeo.wrs.com Chef::Exceptions::RecipeNotFound
ala-rntdbeo.wrs.com --------------------------------
ala-rntdbeo.wrs.com could not find recipe module_mbstring for cookbook php
ala-rntdbeo.wrs.com
ala-rntdbeo.wrs.com Cookbook Trace:
ala-rntdbeo.wrs.com ---------------
ala-rntdbeo.wrs.com /var/chef/cache/cookbooks/phpmyadmin/recipes/default.rb:26:in `from_file'

Does not install required packages

Forgive me if this is out of the scope of this recipe, but why doesn't the recipe install the required php packages?

php-mbstring php-mcrypt php-gd php-mysql

Can't use password less login.

I'm using this cookbook inside a box that is used for development only, therefore MySQL doesn't use a root password.

However the dbinstance.inc.php.erb template sets the AllowNoPassword variable to false regardless whether there is a password or not. Due to this setting it is impossible to login to phpMyAdmin when a password less setup is used.

phpmyadmin in Vagrant

Hi,

I installed phpmyadmin in Vagrant synced_folder with owner: www-data and mount_options: ["dmode=751,fmode=777"]
When I opened phpmyadmin with browser, it made error as below

phpMyAdmin - Error
Wrong permissions on configuration file, should not be world writable!

I manually added following in config.inc.php to workaround and it is working

$cfg['CheckConfigurationPermissions'] = false;

Would it be better way to fix this issue?

Error:"I cannot read /etc/chef/client.pem, which you told me to use to sign requests!

This error occurs when using chef-solo (stack trace shows problem line at line 98)

 95:  # Blowfish Secret
 96:  unless node[:phpmyadmin][:blowfish_secret]
 97:    node.set['phpmyadmin']['blowfish_secret'] = Digest::SHA1.hexdigest(IO.read('/dev/urandom', 2048))
 98>>   node.save
 99:  end

Quick start tips...

Thanks priestjim for your cookbook. As quite a beginner, a had some hassles to get things up and running, but still it does not work... I'm working on a Ubuntu 14.04 with apache2 + mysql system, following the third chef tutorial. Maybe some information could be added to the readme to help new Chef users a bit further to get a minimal setup up and running.

In my recipe, I have added the following to setup php and phpmyadmin
Berksfile:

source 'https://supermarket.chef.io'

metadata
cookbook 'application_ruby', git: 'https://github.com/poise/application_ruby.git'
cookbook 'passenger_apache2', git:'https://github.com/hlogmans/passenger_apache2.git'
cookbook 'phpmyadmin', git: 'https://github.com/priestjim/chef-phpmyadmin.git'
cookbook 'php', git: 'https://github.com/priestjim/chef-php.git'

Then in the metadata.rb the correct depends.

In the recipe, these recipes are called (after setting up mysql & ruby application, those work fine):

include_recipe "php::default"
include_recipe "php::fpm"
include_recipe "phpmyadmin::default"

phpmyadmin_db 'Test DB' do
host '127.0.0.1'
port 3306
username 'root'
password root_password_data_bag_item['password']
hide_dbs %w{ information_schema mysql phpmyadmin performance_schema }
end

But with only above information, I have no clue how to access PhpMyAdmin using the browser. Is it integrated into Apache or not?

So I went on and created a virtual host for PMA (port 81), and then the php page is displayed (uncompiled php that is). So I presumed Apache has no clue about PHP.
To solve this, I followed the instructions in the earlier mentioned tutorial:

# Install the mod_php5 Apache module.
include_recipe 'apache2::mod_php5'

# Install php5-mysql.
package 'php5-mysql' do
  action :install
  notifies :restart, 'service[apache2]'
end

At first start, I now can access PMA using (host):81, but the actual login to mysql fails. When I try to restart apache by using sudo service apache2 restart I get the config warning Apache is running a threaded MPM, but your PHP Module is not compiled to be threadsafe. You need to recompile PHP. Probably there are two versions of PHP interfering with each other?

Update

As an alternative I removed all FPM and Ruby/application stuff. Added the 'php::apache2' include, and switched to

phpmyadmin_pmadb 'Test DB' do
  host '127.0.0.1'
  port 3306
  root_username 'root'
  root_password root_password_data_bag_item['password']
  pma_database 'phpmyadmin'
  pma_username 'root'
  pma_password 'silly4nothing'
  #hide_dbs %w{ information_schema mysql phpmyadmin performance_schema }
end

In MySQL I can see the created database (phpmysql), it has tables but no users. I cannot login using any credentials, and after doing a apache restart I get the MPM message again :(

could not find recipe module_mbstring for cookbook php

Hello,

I am a noob in Chef & social coding in github in general, so apologize if this issue is already resolved.

i tried to install default.rb recipe to my Vagrant instance in local machine using chef-solo, but I found this error:

================================================================================
Recipe Compile Error
================================================================================


Chef::Exceptions::RecipeNotFound
--------------------------------
could not find recipe module_mbstring for cookbook php

If I changed this line in default.rb recipe:

include_recipe 'php::module_mbstring'

to

include_recipe 'chef-php::module_mbstring'

The error is gone, but moves to the next module (I also installed your chef-php cookbook).

Should we change the dependencies to chef-php instead of php? Or is there a proper way to resolve the dependency?

Best regards,
Uqi

I cannot read /etc/chef/client.pem, which you told me to use to sign requests!

How can i fix this error?why do i need to install chef for phpmyadmin cookbook?