I have tried to install this for 1.9 but nothing seems to have happened.
Is there something else I need to do

Sarah

Hi Sarah

If you haven't found it yet, go to Site Administration > Server and you should see it in there.

Regards
H

Thanks for this. Did this get into the core and go out again?

What permissions should be on the mysql folder etc. I am getting an error.

Wrong permissions on configuration file, should not be world writable!

I just read here to report you if I found the plug-in was responsible of an "Incomplete page displayed when I click "Turn Editing On". I had big truobles during upgrades from 1.6 to 1.8 because of this plug-in as documented in this post.

I just installed a new 1.9 (1.9 + (Build: 20080425)) and have the same problem as Sarah. I visit notifications and get no note regarding tables being set up and no link in the server tab.

Doh!...ignore that I uploaded to the wrong folder.

Thank you very much Martin Dougiamas. It is so easy to install and works very well on my Moodle1.9 (PHP4.0/MySql4.1)

When I was using the complete Windows version of Moodle 1.8.3 I found that I automatically had phpMyAdmin as a part of Moodle, which is nice. I recently upgraded to 1.9.1+ (generic download), and it seems to be working OK so far, but I no longer have this bonus. So I decided to download it and install it. I downloaded the zip file and extracted all to the admin folder of my Moodle 1.9.1+ site. Now when I log in as admin and go to the admin menu, server submenu, sure enough, Database is on the menu. So I click on it and get

Sorry, but you do not currently have permissions to do that (Change site configuration)

Not exactly the same problem as SQ, CM, or DC reported, but somewhat similar to CM's. When I clicked on the "More info. about this error" link, it says

This is a general error that indicates the current user account does not have permission to do what you were attempting.

Excuse me, but I'm the one and only administrator for the Moodle site on my very own PC! What blinking role capabilities do I need to add???????????????

How silly of me, to ask what capability I lack! The error msg. tells me that already: Change site configuration (moodle/site:config in a system context). I know that because I have been studying the source code of admin/mysql/frame.php, which is where you are taken when you click on the Database link on the server menu. The (practically) first thing it does is check for that capability by calling require_capability, a function defined in lib/accesslib.php.

Several other functions defined in the same file get called after that (they call each other), which I was able to follow without too much trouble until I got to has_capability_in_accessdata. This does a lot of thngs based on $USER->access; $USER is a global variable whose value is an object representing the current user (the one I was logged in as), but since the user table (mdl_user) has not access column, I have no idea where that property of the object comes from. This would require a great deal more research.

So I'm going back to sleep. Maybe I'll finish this debugging session after I wake up.

BTW before I started, I set my debug level in Moodle to DEVELOPER (wishful thinking?) and changed php.ini to define an error log file. After I got the error, I checked both that error log and the Apache error log. No clue in either one that anything was amiss. But the Apache access log showed, after a couple of accesses to admin/mysql/frame.php, an attempted access to admin/mysql/index.php (which definitely exists) with an HTTP code of 404. Hmmm. Funny I didn't get an error msg. about that. I wonder if the two errors are at all related ...

RLE

Sorry. I forgot to mention that I confirmed, by looking at the role capabilities table mdl_role_capabilities, that I do have the moodle/site:config capability in a system context. I know from looking at the role table that my role (administrator) has an id of 1, and the system context (level 10) has an id of1 in the mdl_context table. So here is a list of my site capabilities in a system context:

mysql> select * from mdl_role_capabilities where roleid=1 and contextid=1 and le
ft(capability,12)='moodle/site:';
+-----+-----------+--------+-------------------------------+------------+-------
-------+------------+
| id | contextid | roleid | capability | permission | timemo
dified | modifierid |
+-----+-----------+--------+-------------------------------+------------+-------
-------+------------+
| 8 | 1 | 1 | moodle/site:doanything | 1 | 1182
673055 | 0 |
| 9 | 1 | 1 | moodle/site:config | 1 | 1182
673055 | 0 |
| 10 | 1 | 1 | moodle/site:readallmessages | 1 | 1182
673055 | 0 |
| 12 | 1 | 1 | moodle/site:approvecourse | 1 | 1182
673055 | 0 |
| 14 | 1 | 1 | moodle/site:import | 1 | 1182
673055 | 0 |
| 16 | 1 | 1 | moodle/site:backup | 1 | 1182
673055 | 0 |
| 18 | 1 | 1 | moodle/site:restore | 1 | 1182
673055 | 0 |
| 20 | 1 | 1 | moodle/site:manageblocks | 1 | 1182
673056 | 0 |
| 23 | 1 | 1 | moodle/site:accessallgroups | 1 | 1182
673056 | 0 |
| 26 | 1 | 1 | moodle/site:viewfullnames | 1 | 1182
673056 | 0 |
| 29 | 1 | 1 | moodle/site:viewreports | 1 | 1182
673056 | 0 |
| 31 | 1 | 1 | moodle/site:trustcontent | 1 | 1182
673056 | 0 |
| 32 | 1 | 1 | moodle/site:uploadusers | 1 | 1182
673056 | 0 |
| 154 | 1 | 1 | moodle/site:doclinks | 1 | 1182
673058 | 0 |
| 168 | 1 | 1 | moodle/site:mnetlogintoremote | 1 | 1182
673058 | 0 |
| 423 | 1 | 1 | moodle/site:sendmessage | 1 | 1220
613985 | 0 |
| 425 | 1 | 1 | moodle/site:langeditmaster | -1 | 1220
613986 | 0 |
| 426 | 1 | 1 | moodle/site:langeditlocal | 1 | 1220
613986 | 0 |
| 427 | 1 | 1 | moodle/site:viewparticipants | 1 | 1220
613986 | 0 |
+-----+-----------+--------+-------------------------------+------------+-------
-------+------------+
19 rows in set (0.44 sec)

RLE

To sum it all up, I am being spanked, so to speak, by the require_capability function, for not having a capability that I clearly do have. Why? That's the $64,000,000 question.

RLE

Richard, This is a server folder permissions issue.

the folder admin/mysql is probably owned by root or whomever you uploaded as. It needs to be owned by the user, the owner of the site.

chown someusername:someusername mysql

if you are in ssh or putty and do an ls -l you'll see

drwxr-xr-x 8 root root 4096 Oct 30 08:06 mysql

if that is the case then do the chown as above, or just re-upload the mysql folder as the user rather than root.

Richard, a cue:
I think key are users of MySql... in my case, only root user could access to DB... And we are inside moodle, as admin, trying to access to Mysql DB, which maybe don't recognize it like its own root user or one of its users...

Please, tell me if I am in the correct way (In MySQL I enabled users at localhost to access to moodle DB and then I could use phpMyAdmin module inside my moodle )!
Good luck!

Thank you! It works with Moodle 1.9.3plus and that's one less password I have to remember.

I have moodlev 1.7 can i use this with that? also where do i unzip it? In administration I have a link called 'site files' would it be in there? cheers

DS & C. Martinez,

After a month I have finally seen your comments responding to mine. Since it took each of us a month to reply to the other, I will attempt to reply to you with private Moodle messages.

Thx for your comments.

RLE

DS & C. Martinez & the rest of the gang of Moodlers reading this page,

Oops! I miscalculated. It has actually been two months in my case. Sorry about that.

RLE

To whom it may concern,

I tried adding a comment by clicking the "add comment" link, but that took me to a totally different page for a different plugin altogether. So I got to this page by constructing the URL by hand (http://moodle.org/mod/data/view.php?d=13&rid=448&filter=1&addcomment=1).
I sent my comments to DS & C. Martinez on 12/29/08 as promised. After almost two weeks with no response, I thought I would share those comments with the rest of you.

Here is my comment to CM:

<!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline; text-underline:single;} span.content {mso-style-name:content;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> I don't think so, because the DB is owned by the MySQL user root, and the MySQL user Moodle accesses it as is root. Otherwise, Moodle wouldn't work at all. I am logged into Moodle as admin, but that is the Moodle user name, not a MySQL user name.

What MySQL query or command did you use to "enable users at localhost to access the Moodle DB"? If you tell me, I will try it, and let you know if it works.

Thx.

====================== End of comment ===========================

Here is my comment to DS:

<!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} span.content {mso-style-name:content;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> With all due respect, if you had read my comments you would know that your comment is inapplicable to my situation on several levels.

For one thing, the Moodle site in question is on my own PC so I have no need for ssh to access it. Secondly, my PC runs Windows, not *nix, so it would be difficult to run the commands you suggest. Thirdly, since the site is on my PC, I didn't upload it at all. I downloaded the zip file from moodle.org and extracted it on my PC into the admin folder.

But thx anyway.

About an hour later:

<!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} span.content {mso-style-name:content;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> You say it is a folder issue and C. Martinez says it is a MySQL user issue. I have just right clicked on the mysql subfolder of admin and clciked Properties. There is no indication of an owner at all in any of the three tabs (General, Sharing, Customize).

In the Sharing tab, it says network access to the C drive has been disabled, but if I want to share the folder with other local users of my PC, I should drag it to Shared Folders. Then it says to make it private, click on the following check box, but the check box is disabled. Finally, it says I can enable sharing on a network, but I declined the invitation.

====================== End of comments ===========================

RLE

Great. What a great HTML editor. Not only did it stuff a bunch of useless style definition garbage into my last comment, it removed parts of what I did type, like the URL I used to leave a comment in the first place, and the opening line that said, "Here is my comment to CM:" And to add insult to injury, I can't even edit it!!!!! This is worse than the Tracker.

RLE

Just thought some of you might like to know what happened last night when I finally bit the bullet and got around to trying to debug this thing and find out why it says I don't have a capability that I have. In preparation, I edited php.ini and turned error logging on. Before that, I had looked at the logs for the previous occasions (October, December) when I had tried to get the phpMyAdmin plugin to work before. Nothing. That's why I edited php.ini, and found logging had been turned off, so I turned it on. Then I fired up Apache, visited my Moodle site, logged in as admin, and navigated the Admin. menu to Database. Now, I said to myself, when it tells me I don't have the capability to do that, I'll be able to find out why. Right? Wrong! Guess what happened? It ran phpMyAdmin! Go figure.

Appliances always refuse to fail when the repairman comes.

RLE

Hi,

i've install it and, when i go to server--> data base  it appears:

"Session Replace: " in a new window.... and nothing else

¿?