phpmyadmin

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
User avatar
shiznatix
DevNet Master
Posts: 2745
Joined: Tue Dec 28, 2004 5:57 pm
Location: Tallinn, Estonia
Contact:

phpmyadmin

Post by shiznatix »

Hey

I just installed phpmyadmin with success (super gasp!). Now when I goto the dir of its install I get

Error!
The configuration file now needs a secret passphrase (blowfish_secret).

now I looked at blowfish_secret file and it is
$cfg['blowfish_secret'] = '';

well that does not make any sence now does it?

What do I have to do to make this work? I googled this but did not come up with any answers.
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Post by pickle »

Not sure, but I'd guess put a password through blowfish, and store the result there. phpmyadmin will then blowfish the password you type in at the prompt and see if it's the same.

FYI - you can also set up phpmyadmin to use HTTP Basic authentication, and require the same username and password as your database - so you don't need to store another password elsewhere.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Blowfish is a hashing algorithm for your user password when using 'Cookie' based authentication. To use it, set the value to something.
phpMyAdmins config.inc.php wrote: /**
* The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If
* at least one server configuration uses 'cookie' auth_type, enter here a
* passphrase that will be used by blowfish. The maximum length seems to be 46
* characters.
*/

Code: Select all

<?php
$cfg['blowfish_secret'] = 'somethingtocrosshashwithshorterthan46chars';
?>
'Config' lets you open PMA using a predefined, authenticated user configuration (a valid MySQL username and password), 'Cookie' uses a login form to get in (this is where the blowfish is used).
User avatar
shiznatix
DevNet Master
Posts: 2745
Joined: Tue Dec 28, 2004 5:57 pm
Location: Tallinn, Estonia
Contact:

Post by shiznatix »

Super sweet, I changed it to config and everything worked just fine! God I love Linux...
Post Reply