Phpmyadmin instalation - Cannot modify header information

Phpmyadmin instalation - Cannot modify header information

am 09.04.2006 23:44:37 von Ciuciu

Hello!

I was instaling a small web service for a friend (on his computer, only
remote ssh access). I managed to set up apache2 with php support and
mysql running as well (we had few problems with that, since slackware
instalator did not changed permissions.. but it's fine now)

anyway it looks like that:


> [obibox:root]:[/home/ciuciu]: mysql_config --version
> 4.1.14
>
> [obibox:root]:[/home/ciuciu]: mysql -h localhost -u root -p
> Enter password:
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 65 to server version: 4.1.14
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
So I assume that mysql works correctly


and.. for 3hour right now i'm trying to install the f****ing phpmyadmin...

I instaled the 2.8.x version, and after configuring (it DOES NOT HAVE
any DEFAULT setup) I recive that error:

Warning: Cannot modify header information - headers already sent by
(output started at
/var/www/htdocs/phpadm/libraries/Config.class.php(351) : eval()'d
code:43) in /var/www/htdocs/phpadm/libraries/auth/config.auth.lib.php on
line 82

ERROR

MySQL returned message:
#1251 - Client does not support authentication protocol requested by
server; consider upgrading MySQL client

WTF? What client (apache? mysql? or maybe php?) and waht server (again
apache, mysql or php). I don't need to upgrade mysql, I already have it
running.

I tried to install the older version of phpmysqdmin (sometghign around
2.6. i just copied it from running instalation.. and it just keeps
asking me for login/password.. i get bored after 20th time)


the config.ini.php file looks like that:
> /* Server ********************* */
> $i++;
> $cfg['Servers'][$i]['host'] = 'localhost';
> $cfg['Servers'][$i]['extension'] = 'mysql';
> $cfg['Servers'][$i]['connect_type'] = 'tcp';
> $cfg['Servers'][$i]['compress'] = false;
> $cfg['Servers'][$i]['controluser'] = 'root';
> $cfg['Servers'][$i]['controlpass'] = '*********';
> $cfg['Servers'][$i]['auth_type'] = 'config';
> $cfg['Servers'][$i]['user'] = 'root';
> $cfg['Servers'][$i]['password'] = '********';
> $cfg['Servers'][$i]['verbose'] = '';


I've found the forums at phpmyadmin the MOST unhelpful.. it jsut
generates error in search of EVERY query i asked, channels on irc were
EMPTY...

Now.. i got a bit annoyed...

Sry for long post, maybe someon knew WTF is going on..
Thank you in advance

Ciuciu

Re: Phpmyadmin instalation - Cannot modify header information

am 20.04.2006 11:27:55 von richard.a.fletcher

Here's a few things to try.

Change connect_type, if localhost you do not need tcp, and the cahnces
are mysql wont allow tcp connections by default.

The header error is because on line 351
/var/www/htdocs/phpadm/libraries/Config.class.php there is a print or
echo, and after that line something is trying to write some cookie info
or http headers. Since this is the config file then the chances are
that you put it there. Any thing outside is printed, so if
line 351 is "?> " then that extra space is the problem

The mysql support for php may not be new enough, it is a seperate item
to the mysql installation.