Installed Phpmyadmin today on a brand new raq4 with all the required updates from Cobalt Applied. I also installed MySQL version 3.23.37. I changed the default password after the install.
PHP Release 4.0.6 is the version I have installed.

Today I installed the phpmyadmin pkg. When I open the servername/phpMyAdmin/ page, I get the following error messages:

Warning: Variable passed to reset() is not an array or object in /home/phpMyAdmin/libraries/common.lib.php on line 286

Warning: Variable passed to each() is not an array or object in /home/phpMyAdmin/libraries/common.lib.php on line 287

Is there any initial config I need to get PHPmyadmin started?

Line 286 & 287 are as follows:
reset($cfgServers);
while (list($key, $val) = each($cfgServers)) {

Thanks for the help.
Dave

I'm not that familar with the cobalt .pkg version, but normally config.inc.php needs to be udated.

Frank

I am curioius to where you got the .pkg file for phpadmin....

Keith

Originally posted by kmurrey
I am curioius to where you got the .pkg file for phpadmin....


And I'm even more curioius about why you would need/want a .pkg file. You just have to untar/unzip phpMyAdmin, upload it to your server and edit 1 config file.

Frank

Originally posted by ffeingol


And I'm even more curioius about why you would need/want a .pkg file.
Frank

I am guessing its a "comfort" level thing going with a .pkg. Just like Linus and his blankie. Phpmyadmin is relatively easy to set up, and the .pkg package is rather old. Try the newer one...I believe its 2.2.3. Makes setting up a central copy easier.

I can't seem to get this setup either.

My question is: how do I know what the stduser and stdpass is?

I haven't set up a user and a password - how do I do that?

MySql is installed (shows support in PHP).

The installs for PHPadmin seems easy - I have the files on my server. I just don't know how to set configs that it is asking for.

___________________
Keith

Hey everyone,

I installed PHPMyAdmin and MySQL the other day, but I'm having trouble setting up an admin account...

So far I haven't been able to log on to the system... Here's the error I'm getting:

Error
MySQL said:


MySQL Connection Failed: Access denied for user: 'admin@localhost' (Using password: YES)

This is my setup for the config.inc file:

/**
* Server(s) configuration
*/
// The $cfgServers array starts with $cfgServers[1]. Do not use $cfgServers[0].
// You can disable a server config entry by setting host to ''.
$cfgServers[1]['host'] = 'localhost'; // MySQL hostname
$cfgServers[1]['port'] = ''; // MySQL port - leave blank for default port
$cfgServers[1]['socket'] = ''; // Path to the socket - leave blank for default socket
$cfgServers[1]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')
$cfgServers[1]['stduser'] = 'admin'; // MySQL standard user settings (this user must have read-only
$cfgServers[1]['stdpass'] = 'mypassword'; // access to the "mysql/user" and "mysql/db" tables)
$cfgServers[1]['auth_type'] = 'cookie'; // Authentication method (config, http or cookie based)?
$cfgServers[1]['user'] = ''; // MySQL user
$cfgServers[1]['password'] = ''; // MySQL password (only needed with 'config' auth)
$cfgServers[1]['only_db'] = ''; // If set to a db-name, only this db is displayed at left frame
// It may also be an array of db-names
$cfgServers[1]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname
$cfgServers[1]['bookmarkdb'] = ''; // Bookmark db - leave blank for no bookmark support
$cfgServers[1]['bookmarktable'] = ''; // Bookmark table - leave blank for no bookmark support
$cfgServers[1]['relation'] = ''; // table to describe the relation between links (see doc)
// - leave blank for no relation-links support

$cfgServers[2]['host'] = '';
$cfgServers[2]['port'] = '';
$cfgServers[2]['socket'] = '';
$cfgServers[2]['connect_type'] = 'tcp';
$cfgServers[2]['stduser'] = '';
$cfgServers[2]['stdpass'] = '';
$cfgServers[2]['auth_type'] = 'config';
$cfgServers[2]['user'] = 'root';
$cfgServers[2]['password'] = '';
$cfgServers[2]['only_db'] = '';
$cfgServers[2]['verbose'] = '';
$cfgServers[2]['bookmarkdb'] = '';
$cfgServers[2]['bookmarktable'] = '';
$cfgServers[2]['relation'] = '';

$cfgServers[3]['host'] = '';
$cfgServers[3]['port'] = '';
$cfgServers[3]['socket'] = '';
$cfgServers[3]['connect_type'] = 'tcp';
$cfgServers[3]['stduser'] = '';
$cfgServers[3]['stdpass'] = '';
$cfgServers[3]['auth_type'] = 'config';
$cfgServers[3]['user'] = 'root';
$cfgServers[3]['password'] = '';
$cfgServers[3]['only_db'] = '';
$cfgServers[3]['verbose'] = '';
$cfgServers[3]['bookmarkdb'] = '';
$cfgServers[3]['bookmarktable'] = '';
$cfgServers[3]['relation'] = '';

// If you have more than one server configured, you can set $cfgServerDefault
// to any one of them to autoconnect to that server when phpMyAdmin is started,
// or set it to 0 to be given a list of servers without logging in
// If you have only one server configured, $cfgServerDefault *MUST* be
// set to that server.
$cfgServerDefault = 1; // Default server (0 = no default server)
$cfgServer = '';
unset($cfgServers[0]);


I also performed this process to add a user to MySQL: http://www.mysql.com/doc/A/d/Adding_users.html

The user I attempted to add (not sure if it worked, but I followed all of the steps as described) used the same username and password as the PHPMyAdmin 'stduser' above....


Any suggestions??

Thanks!!

Colin

I downloaded the phpmyadmin.pkg file from:
http://www.cobaltworld.com/modules.php?op=modload&name=Downloads&file=index&req=viewdownloaddetails&lid=5&ttitle=CobaltWorld_phpMyAdmin

I will try some of the edits to the config file to get it to work.

Dave

gappedout:

when mysql is installed from source, there is only the user root installed, with no password. So initially use the username root and an empty password. However this is a big security risk, so I would recommend immediately changing the password, and using a different account to root. If you installed the package from pkg.nl.cobalt.com, the root password will be set to 'cobalt-mysql'

In this day and age it is almost unacceptable to not us phpMyAdmin's advanced authentication mechanism.

It works beautifully..

Here's how it works.. In config.inc.php

Set the auth_type to 'http' as seen below:

$cfgServers[1]['auth_type'] = 'http';

DO NOT enter ANY passwords.. (no stduser no root etc). You do NOT need them.

Just point your browser to where phpMyAdmin is intalled and it will pop up a password box.

Enter your ****MYSQL**** username and password in there. You will have access to all databases that your MySQL account can access. The good thing is, without any further configuration, your customers will be able to access their (AND ONLY THEIR) databases also.

All you need to remember is that MySQL users and the system users are totally UNRELATED. You may have a completely different username and password for those two.


PS: On the older versions the configuration parameter was something else.. There is enough documentation in the config file though. All you need to do is set the authentication mode to 'ADVANCED'.


*NoComment*