main.php: missing parameter: is_superuser

[gkman]

hello,
since i have updated my Firefox to ver. 3.6
my PMA had showed the error >> main.php: missing parameter: is_superuser
as soon after i have entered my password and gotten in (please notice this is on my local server -Apache)
any way the problem doesn't appear to happen in IE8

i tried upgrading PMA to version 3.2.5 but nothing changed ( i hadn't changed back to the older version)
PMA sent me to FAQ 2.8 but i didn't understand a thing.

please help me fix this problem. i hate IE

[thewebhostingdi]

Please make sure that you have set the appropriate path in your php.ini file on the below mentioned location:

session.save_path=/serverphp/session

[criterion9]

@OP: Have you tried any of these steps?

Here are a few points to check:

* In config.inc.php, try to leave the $cfg['PmaAbsoluteUri'] directive empty. See also FAQ 4.7.
* Maybe you have a broken PHP installation or you need to upgrade your Zend Optimizer. See http://bugs.php.net/bug.php?id=31134.
* If you are using Hardened PHP with the ini directive varfilter.max_request_variables set to the default (200) or another low value, you could get this error if your table has a high number of columns. Adjust this setting accordingly. (Thanks to Klaus Dorninger for the hint).
* In the php.ini directive arg_separator.input, a value of ";" will cause this error. Replace it with "&;".
* If you are using Hardened-PHP, you might want to increase request limits.
* The directory specified in the php.ini directive session.save_path does not exist or is read-only.


Additionally, upgrading FF should have nothing to do with the server-side config files...are you sure you didn't change/upgrade anything else?

[gkman]

thewebhostingdi, i didnt understand what you suggested..im kinda new to all of this..

besides i keep seeing "zend optimizer" what is it?

also i just realized that windows opens a crash message on Apache sometimes when i try logging in to PMA. can that have any thing to do with it??

[criterion9]

Did you use a precompiled installer for you apache/mysql/php/pma stack (i.e. wamp, etc) or did you install each manually?

[gkman]

manually

[criterion9]

Did you edit the distribution php.ini file at all? What does the session.save_path look like?

[gkman]

; session.save_path = "/tmp"

[criterion9]

session.save_path = "c:\temp"


Then make sure that directory exists.

[gkman]

it did help however i got a windows crash message again:
---------------

Error signature:
szAppName : Apache.exe szAppVer : 2.0.52.0 szModName : php5ts.dll
szModVer : 5.2.9.9 offset : 0009c8bd

included filse:
C:\DOCUME~1\Gidon_2\LOCALS~1\Temp\WER68b5.dir00\Apache.exe.mdmp
C:\DOCUME~1\Gidon_2\LOCALS~1\Temp\WER68b5.dir00\appcompat.txt

------------

should this concern me?

[criterion9]

I would uninstall and start over. Install Apache first, then PHP. If you use the windows binary installer for PHP it will automatically append the appropriate content to your apache .conf. Once that is completed download the zip file for PHP and unzip into the installed php folder to enable any missing modules.


I was confused by your first post stating that you were only getting errors in FF and that IE was fine and that the errors only started when you upgraded your FF version. None of those statements had anything to do with the problem as they would all be client-side problems and you have a server configuration problem. Did you have this server working with PMA before or have you just started to use PMA?

[gkman]

i had it working with PMA before. it also confused me. can it be that IE has some special features to deal with it?

[criterion9]

Your issue is a server configuration issue and client-side browsers will have no bearing on that. It is possible that the error message is being hidden in IE8 somehow but IE cannot fix an issue on the server. Did you try reinstalling Apache and PHP?

[gkman]

not yet.. but it is working fine even though the error message.. so I'm just gonna wait and see how it turns out.

thank you for all your help..it is much easier to work now.

[criterion9]

I would reinstall PHP. It seems like the apache module in your current install seems corrupted. You can just download the zip and overwrite your PHP install folder. Make sure to stop Apache before you overwrite the .dll so it won't stumble on it. Let me know if that fixes your issue.

[gkman]

i reinstalled Apache and overwrite the PHP install folder. but the problem still there.

i also noted that after i log into PMA a small message at the bottom appeared:

The additional features for working with linked tables have been deactivated. To find out why click here.

i open the link and it showed:

Server: localhost
$cfg['Servers'][$i]['pmadb'] ... not OK [ Documentation ]
$cfg['Servers'][$i]['relation'] ... not OK [ Documentation ]
General relation features: Disabled

$cfg['Servers'][$i]['table_info'] ... not OK [ Documentation ]
Display Features: Disabled

$cfg['Servers'][$i]['table_coords'] ... not OK [ Documentation ]
$cfg['Servers'][$i]['pdf_pages'] ... not OK [ Documentation ]
Creation of PDFs: Disabled

$cfg['Servers'][$i]['column_info'] ... not OK [ Documentation ]
Displaying Column Comments: Disabled
Browser transformation: Disabled

$cfg['Servers'][$i]['bookmarktable'] ... not OK [ Documentation ]
Bookmarked SQL query: Disabled

$cfg['Servers'][$i]['history'] ... not OK [ Documentation ]
SQL history: Disabled

$cfg['Servers'][$i]['designer_coords'] ... not OK [ Documentation ]
Designer: Disabled


should this concern me?

[criterion9]

What kind of install had you done for MySQL?

[gkman]

i used the config wizard with the standers settings if thats what you mean...

[criterion9]

Did you complete the config for PMA? Earlier versions didn't have it but the last few started using a configuration where you need to set it up before you use it.

[gkman]

what do you mean?

[criterion9]

Well...when I first started using PMA you could just unzip it and go. Now you have to complete the configuration (web based) for it to function properly. Did you complete the configuration (http://wiki.phpmyadmin.net/pma/Quick_Install#With_setup_script)?

[gkman]

i didnt use the web based configuration. i did however created a file named config.inc.php and pasted this :
<?php
$cfg['blowfish_secret'] = 'ba17c1ec07d65003'; // use here a value of your choice

$i=0;
$i++;
$cfg['Servers'][$i]['auth_type'] = 'cookie';
?>

[criterion9]

I would recommend using the web based configuration tool. If you insist using the manual process see the manual (http://wiki.phpmyadmin.net/pma/Quick_Install#Manually) for the required values.

[gkman]

i think i going to uninstall everything and install from the beginning with all the latest versions

[gkman]

i reinstalled everything but i have a problem
the server works fine until i add the lines to the httpd doc

LoadModule php5_module "D:/Program Files/PHP/php5apache2.dll"
AddType application/x-httpd-php .php
# configure the path to php.ini
PHPIniDir "D:/Program Files/Apache Software Foundation/Apache2.2/conf"

and then it refuses to work
the php is version 5.3.1
apache is 2.2.14
mysql 5.1

other wise i think everything is set fine

[gkman]

never mined just found out that i needed to add

LoadFile "C:/Program Files/php/php5ts.dll"

[gkman]

im now trying to instal PMa through the wizard like you rcommended
but i am getting two messages:

Bzip2
Bzip2 compression and decompression requires functions (bzopen, bzcompress) which are unavailable on this system.

and:

Insecure connection
You are not using a secure connection; all data (including potentially sensitive information, like passwords) is transferred unencrypted! If your server is also configured to accept HTTPS requests follow this link to use a secure connection.

how do i fix this?

[criterion9]

You can ignore the secure connection as long as you aren't using a publically available address. The other problem means you need to enable the bzip module. Look in the php.ini file for the modules and remove the ; from in front of the desired module.

[gkman]

i found the module and got rid of the problem but PMA still doesn't work. it take forever to load and then the page stays completely blank

if it helps this is what my config.inc file looks like

<?php
/*
* Generated configuration file
* Generated by: phpMyAdmin 3.2.5 setup script by Piotr Przybylski <piotrprz@gmail.com>
* Date: Thu, 11 Feb 2010 17:17:08 +0200
*/

/* Servers configuration */
$i = 0;

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['ssl'] = true;
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'XXXXXXX';

/* End of servers configuration */

$cfg['blowfish_secret'] = '4b741f1a68ab69.27588293';
$cfg['DefaultLang'] = 'en-utf-8';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
?>

[criterion9]

Did you restart apache? Did apache give you any startup errors (i.e. module not found, etc)?

[gkman]

yes, no
it lets me only sometimes to go into the log page (where i need to type in a user name and password) though it takes a long time- too long
and then it takes for ever to load and then turns up blank

[criterion9]

yes, no

huh?

[gkman]

yes i restarted Apache . no i hadn't got any start up errors

[gkman]

i think i found the root of my problem.
i think i haven't got MySql set up correctly. but i don't know why.
i made a page with a simple code:

<?php
mysql_connect("localhost", "root", "XXXXXX") or die(mysql_error());
echo "Connected to MySQL<br />";
?>

the output of this code is:

Warning: mysql_connect() [function.mysql-connect]: [2002] A connection attempt failed because the connected party did not (trying to connect via tcp://localhost:3306) in D:\LocalHost\index.php on line 8

Warning: mysql_connect() [function.mysql-connect]: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. in D:\LocalHost\index.php on line 8

Fatal error: Maximum execution time of 60 seconds exceeded in D:\LocalHost\index.php on line 8

i am positive i have my password set right

[criterion9]

Is MySQLd running?

[gkman]

i don't know. what is it?

[criterion9]

Is one of your running processes MySQL server? Did you install the DB server as a service or for manual running?

[gkman]

i installed it as a service. and yes mysqld is running.
i think the problem might be in configuring php.ini because it was a bit different setup than other versions when i configured php with Apache so maybe it is different with mysql as well

[criterion9]

Did you enable the mysql module in your php.ini? Does the appropriate .dll file exist in your 'ext' directory?

[gkman]

yes. i have enabled
extension=php_bz2.dll
extension=php_mbstring.dll
extension=php_mysql.dll
extension=php_mysqli.dll

i even copied the libmysql ( from php 5.2 ) file to windows system32 folder 'ext' folder and to the main php directory
i read i needed to do so in the install file that comes with php

[criterion9]

Try uninstalling mysql, rebooting, and reinstalling it?

[gkman]

I tried to uninstall it reboot and install again>> still didn't work
So I made a little test
I kept the php.ini file as it is now and the rest of the php files changed back to previous version and it worked. then I upgraded the php version while keeping the same php.ini file and it doesn't work again!

now I know there is more settings to do with php 5.3.1 then other versions like other settings I had to do with apache

I just need to find out what it is

It is important to say that aside then the problem with myself php work great so I don't think it has to do with a bad copy since I also downloaded it a few times

[criterion9]

Copy your existing php.ini file to a backup and use the distributed php.ini that 5.3.1 came with. Then if you are having trouble with the settings you can look at your old version to check specific values (such as max_upload_size, etc).

[gkman]

I did like you said still doesn't work. So I added to the httpd file the Line >> loadfile dlmysql ( or what ever the true name is) now it works only sometimes. How do I make it to work allways??

[criterion9]

I suggested you edit your php.ini file. What do you mean you edited your httpd file to enable mysql?

[gkman]

i did edit the php.ini file but nothing happend.
so i read again the install.txt file and saw that in order to enable mysql you need the lidmysql ( or whatever the name is) file from previous versions. but it was already in the php folder so i just added the line >> loadfile lidmysql.dll
to the httpd file
but now it seems to work when it feels like it...

[criterion9]

Enabling the module in your php.ini file and restarting your web server should've been all you needed to do. I've never used "loadfile lidmysql.dll" in my httpd file ever and my scripts almost all use a database.

[gkman]

Apparently I was wrong.
I rechecked when mysql works. It works if first I run php 5.2.0 and right after I upgrade and run php 5.3.1
I am absolutely sure of this since I used the phpinfo() function to check this.

[criterion9]

So this issue is now resolved? If so can you mark the thread resolved (Thread Tools->Mark Thread Resolved)?

[gkman]

no, the server still works on and off. one time it works the seconed it doesnt

[criterion9]

Is it all applications run on the server or a single one in particular that work off and on?

[gkman]

php works fine until i use the mysql_connect function

[criterion9]

That sounds like it might be either incorrect usage of the function, an old module (did you download the zip file I suggested a few posts back that has the PHP src and all modules?), or an incorrect configuration.

Are you able to connect to and use MySQL separately from PHP?

[gkman]

what zip file...i didnt see you mentioned a zip file

[criterion9]

I could've swarn I advised you to download the "VC6 x86 Thread Safe" version from php.net (http://windows.php.net/download/) and unzip the contents into your PHP directory. Maybe I was confused with another similar thread.

[gkman]

that is what i am useing

[criterion9]

You downloaded the zip file with all the extensions in it?

[gkman]

Yes. I think the problem is with windows that isn't loading something on startup though I don't know what it can be because I add php to windows path