Topic on Project:Support desk

Dear all

it seems that the users in my mediawiki (http://www.surveillance-citoyenne.fr/mediawiki/index.php?title=Accueil) do not appear in phpMyAdmin (Version information: 4.1.14) making it difficult to manage privileges etc... Anyone know where does this come from ?

Thank you in advance

Users are stored in the user table

Thank you for your quick answer.

But, this is precisely my problem. Users don't appear in my users tables

I just have a number appearing 4572696b but this doesn't match any username

It is like my phpmyadmin (access via wamp) don't communicate with the online medawiki ?

Thank you for any help

Your wiki seems to have currently 4 users. That means the user table should contain 4 rows. If that's not the case, maybe you're querying the wrong server/database

Thank you afain for your prompt answers !

I have 5 database

• information_schema
• mysql
• performance_schema
• surveillance_citoyenne
• test

When I select the user table of "surveillance_citoyenne" database, I only have one row with user name : 4572696b ?? Other tables only have user "root" ...

Thank you in advance

You may be pointing to a wrong mysql server (a testing one or whatever). That's easy to test, just rename some of the tables like user and page, to something else, and if the wiki is not completely broken after that you're definitively not querying the same database/server as the wiki.

Thank you ! Indeed renaming the tables don't affect the wiki.

So how can I access the good mysqlserver? (I currently click on the green wampicon on my pc and then on phpmyadmin; or http://localhost/phpmyadmin/)

That's tricky to explain. In LocalSettings.php there are the database connection settings like Manual:$wgDBserver. In phpmyadmin you should look at the server settings in the config.ing,php file, and see if they match.

Thank you !

What is supposed to match ? I can't find find Database server or name in my config.inc,php file (See below).

$cfg['Servers'][$i]['verbose'] = 'mysql wampserver';

//$cfg['Servers'][$i]['auth_type'] = 'cookie';

$cfg['Servers'][$i]['auth_type'] = 'config';

$cfg['Servers'][$i]['user'] = 'root';

$cfg['Servers'][$i]['password'] = '';

/* Server parameters */

$cfg['Servers'][$i]['host'] = '127.0.0.1';

$cfg['Servers'][$i]['connect_type'] = 'tcp';

$cfg['Servers'][$i]['compress'] = false;

/* Select mysql if your server does not have mysqli */

$cfg['Servers'][$i]['extension'] = 'mysqli';

$cfg['Servers'][$i]['AllowNoPassword'] = true;

From your config.inc.php file, the server ($wgDBserver) is 127.0.0.1 and the username ($wgDBuser) is root. For this user, a password ($wgDBpassword) is not used. The only thing, which you do not find in config.inc.php is the database name, which your wiki is using ($wgDBname).

Thank you ! Well when I try to match server, user and password between the two files... phpmyadmin just doesn't work ... Any other suggestions ?

Also, I just discoverd that I have access to another phpmyadmin database via my ovhpanel https://phpmyadmin.ovh.net

The only database available give me 10 username with passwords but everything is crypted :

1 4572696b 3263323361663765356265653331613061303838633032623835653636316238

?