mysql - XAMPP + OSX + Virtualhosts + change user in httpd.conf = phpmyadmin create database not working -


i have installed xampp on osx lion. because want serve folder 1 of development folders have added virtualhost /applications/xampp/xamppfiles/etc/extra/httpd-vhosts.conf

<virtualhost *:80> serveradmin email@gmail.com documentroot "/users/myosxusername/documents/dir/dir/htdocs" servername qmh errorlog "logs/qmh-error_log" customlog "logs/qmh-access_log" common </virtualhost>

and added entry hosts file

127.0.0.1 qmh

because of permission issue server accessing directory /users/myosxusername/documents/dir/dir/htdocs have changed user in httpd.conf myosxusername

user myosxusername group admin # previous setting below # user nobody # group nobody

after changes virtual hosts work fine. problem when use phpmyadmin create new database error message

db_create.php: missing parameter: new_db

if change user to:

user nobody group nobody

then phpmyadmin works fine, virtualhost directory cannot accessed due permission issue.

i assume somehow have tell apache not use new user mysql access somehow? appreciated. thanks

see item 2.8 phpmyadmin faq (http://wiki.phpmyadmin.net/pma/faq_2.8)

  • in php.ini directive session.save_path , upload_tmp_dir, if these directories don't exist, read-only or not accessable (f.e. due base_dir restrictions) error occur. see trk
    • php installed packages (eg. rpm) might set permissions on these directories assumed user (eg. 'apache'). - users of other web servers, eg lighttpd, may need change ownership of these directories (eg. 'lighttpd').
    • on windows, if php using directories session.save_path , upload_tmp_dir somewhere within main "temp" directory, must create directories yourself; unlike other windows programs php not create them itself.
  • if using hardened-php (/suhosin patch) ini directive varfilter.max_request_variables set default (200) or low value, error if table has high number of columns. adjust setting accordingly ( request limits, klaus dorninger hint).
  • in config.inc.php, try leave $cfg['pmaabsoluteuri'] directive empty. see faq 4.7.
  • maybe have broken php installation or need upgrade zend optimizer. see http://bugs.php.net/31134.
  • in php.ini directive arg_separator.input, value of ";" cause error. replace "&;".

(tip https://serverfault.com/questions/385465/phpmyadmin-missing-parameter)


Comments

Post a Comment

Popular posts from this blog

javascript - backbone.js Collection.add() doesn't `construct` (`initialize`) an object -

<!doctype html public "-//w3c//dtd xhtml 1.0 strict//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-strict.dtd"> <html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script> <script src="http://documentcloud.github.com/underscore/underscore-min.js"></script> <script src="http://documentcloud.github.com/backbone/backbone-min.js"></script> </head> <body> <button id="cmd_create_event" name="cmd_create_event" type="button">create new `event`</button> <script type="text/javascript"> var eventmodel = backbone.model.extend({ initialize : function() { console.log("`event` initialized. id: " + this.cid); this.bind("change:status", function() { console.log(this.get("status") + " value `status`"); }); this.bind("error", function(model, e...
Read more

php - Get uncommon values from two or more arrays -

is there function in php give array of uncommon values 2 or more arrays? for example: $array1 = array( "green", "red", "blue"); $array2 = array( "green", "yellow", "red"); .... $result = function_needed($array1, $array2,...); print_r($result); should give output: array("blue", "yellow", ...); use array_diff , array_merge : $result = array_merge(array_diff($array1, $array2), array_diff($array2, $array1)); here's demo. for multiple arrays, combine callback , array_reduce : function unique(&$a, $b) { return $a ? array_merge(array_diff($a, $b), array_diff($b, $a)) : $b; } $arrays = array( array('green', 'red', 'blue'), array('green', 'yellow', 'red') ); $result = array_reduce($arrays, 'unique'); and here's demo of that.
Read more

Adding duplicate array rows in Php -

i create function in php adds rows of array shared column value. so input. $test = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); and output. $testduplicatefree = array( array("c", 7, 9), array("test", 5, 6) ) ); i'm thinking function combine_duplicates($array,$col){ ... ... return $duplicatefreearray; } where $col duplicate free array. so, in case, combine_duplicates($test,0); would me desired output. this. <?php function combine_duplicates($array,$col) { $index = array(); foreach ($array $row) { $key = $row[$col]; if (!isset($index[$key])) { $index[$key] = $row; } else { ($i = 0; $i < count($row); ++$i) { if ($i != $col) { $index[$key][$i] += $row[$i]; } } } } return array_values($index); } $array = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); print_r(combine_duplicates($array, 0)); try here: http://codepad.org/mdhesqhi
Read more