9 May
2008
9 May
'08
7:42 a.m.
Try this: in libraries/tbl_triggers.lib.php, replace
$triggers = PMA_DBI_get_triggers($db, $table);
by
$triggers = false;
-----Original Message-----
From: Rekrutacja <rekrutacja119(a)gmail.com>
To: phpMyAdmin Developer <phpmyadmin-devel(a)lists.sourceforge.net>
Date: Fri, 09 May 2008 02:55:33 +0200
Subject: Re: [Phpmyadmin-cvs] [Phpmyadmin-devel] DisableIS in
any ideas how to remove it maybe ?
-------- Original Message --------
Subject: Re: [Phpmyadmin-cvs] [Phpmyadmin-devel] DisableIS in
Date: Wed, 07 May 2008 03:16:45 +0200
From: Rekrutacja <rekrutacja119(a)gmail.com>
CC: phpmyadmin-devel(a)lists.sourceforge.net
References: <1210114234.67ad30bcMarc.Delisle(a)cegepsherbrooke.qc.ca>
i don't. what part do i need to change to disable it? i thought it would
need a lot of changes to get rid of it.
Marc Delisle wrote:
Yes, there are security issues, see our security page
on phpmyadmin.net.
The full date for implementing this is unknown.
By the way, do you have triggers? If not you could just disable this part of the code to
avoid this query.
-----Original Message-----
From: Rekrutacja <rekrutacja119(a)gmail.com>
To: phpmyadmin-cvs(a)lists.sourceforge.net
Date: Tue, 06 May 2008 14:55:32 +0200
Subject: Re: [Phpmyadmin-cvs] [Phpmyadmin-devel] DisableIS in
yes, but you said 'so I merged the change and the doc reference' , and
then asked me if it is faster now, so i assumed you changed something.
anyways, it didn't help, and yes, i have many many databases.
i'm using latest 2.6 pma branch now to avoid it, is there any security
issues with this old pma?
does DisableIS is going to be implemented fully soon?
Marc Delisle wrote:
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/java…
_______________________________________________
Phpmyadmin-cvs mailing list
Phpmyadmin-cvs(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-cvs
I think Sebastian answered previously that the
DisableIS setting is not fully implemented. Also, please provide more information: do you
have a large number of databases/tables?
-----Original Message-----
From: Rekrutacja <rekrutacja119(a)gmail.com>
To: phpmyadmin-cvs(a)lists.sourceforge.net
Date: Mon, 05 May 2008 16:29:48 +0200
Subject: Re: [Phpmyadmin-cvs] [Phpmyadmin-devel] DisableIS in
so, any news? my server is still affected, i've tried latest 3.0
version, snapshot from 5th may, and it is still happening.
got this for example:
Query | 37 | checking permissions | SELECT TRIGGER_SCHEMA,
TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT,
EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS
WHERE TRIGGER_SCHEMA= 'test99' and EVENT_OBJECT_TABLE =
'phpbb_poll_options' |
i suppose it's turned on, the only place i see this options is
libraries/config.default.php
# grep DisableIS libraries/config.default.php
$cfg['Servers'][$i]['DisableIS'] = true;
#
so i suppose it's enough.
why it's not working?
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/java…
_______________________________________________
Phpmyadmin-cvs mailing list
Phpmyadmin-cvs(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-cvs
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/java…
_______________________________________________
Phpmyadmin-cvs mailing list
Phpmyadmin-cvs(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-cvs
>>
The EVENT_OBJECT_SCHEMA seems to always have the same content as
>> TRIGGER_SCHEMA, but I just noticed that in the MySQL manual they
>> suggest using TRIGGER_SCHEMA in the WHERE clause as you suggested,
>> so I merged the change and the doc reference (for version 2.11.7)
>>
>>
http://phpmyadmin.svn.sourceforge.net/viewvc/phpmyadmin/branches/QA_2_11/ph…
>>
>> Rekrutacja, is it faster this way on your server?
> i've tried latest 3.0-dev version, from svn (did checkout just few
> minutes ago), and it is still slow.
>
> Query | 30 | checking permissions | SELECT TRIGGER_SCHEMA,
> TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT,
> EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS
> WHERE TRIGGER_SCHEMA= 'test99' and EVENT_OBJECT_TABLE =
'phpbb2_confirm'
whats your MySQL server version?
5.0.51a-3 , from debian package