Resolved phpMyAdmin reject 200

[Frank.P]

I dont know what happend ¿?¿¿?¿??¿​

I can see al tablet, but show rejected error and I cannot see any select sql​

 

[Martin Dias]

Not same error code but try to increase the memory limit:

https://support.plesk.com/hc/en-us/articles/360000448773-Unable-to-open-a-large-table-via-phpMyAdmin-in-Plesk-Error-in-Processing-Request

also do you get in the Plesk log more information?

 

[Frank.P]

Not same error code but try to increase the memory limit:

https://support.plesk.com/hc/en-us/articles/360000448773-Unable-to-open-a-large-table-via-phpMyAdmin-in-Plesk-Error-in-Processing-Request

also do you get in the Plesk log more information?

Thanks , but not work.

I try in a new db and show same error. MySql or MariaDb work without problem , but phpMyAdmin not work

 

[Frank.P]

No log about that in C:\Program Files (x86)\Plesk\admin\logs

 

[Martin Dias]

yes on that folder there should be a php_error file

 

[Frank.P]

yes on that folder there should be a php_error file

Yes, but txt file not show error about that.

 

[Frank.P]

I found the problem. The new cookie standar with parameter SameSite

I use a rewtite to set this new parameter to None

The cookie phpMyAdmin_https need this in moderm browsers

Now all work

 

[siri120]

Hey everyone,
Can someone please explain the following post to me:
https://support.plesk.com/hc/en-us/...pMyAdmin-in-Plesk-Error-in-Processing-Request/
I was looking for the solution to some problems.
Thanks

 

[Jeff HANRIOT]

I found the problem. The new cookie standar with parameter SameSite

I use a rewtite to set this new parameter to None

The cookie phpMyAdmin_https need this in moderm browsers

Now all work

Thats would be great if you could explain us how you did it ? Facing the same issue ..
Thanks in advance

 

[Frank.P]

FIRST METHOD:

- Connect to RPD
- Open Notepad
- Open File : C:\Windows\System32\inetsrv\config\applicationHost.config
- Search code "<proxy"
- Bellow paste this code :

<rewrite>
<outboundRules>
<clear />
<rule name="AddSecureCookieFlag" preCondition="" enabled="true">
<match serverVariable="RESPONSE_Set_Cookie" pattern=".*" />
<conditions logicalGrouping="MatchAll" trackAllCaptures="true">
<add input="{HTTPS}" pattern="on" />
</conditions>
<action type="Rewrite" value="{R:0}; secure" />
</rule>
<rule name="AddSameSiteCookieFlag" preCondition="" enabled="true">
<match serverVariable="RESPONSE_Set_Cookie" pattern=".*" />
<conditions logicalGrouping="MatchAll" trackAllCaptures="true">
<add input="{HTTPS}" pattern="on" />
</conditions>
<action type="Rewrite" value="{R:0}; SameSite=None" />
</rule>
</outboundRules>
</rewrite>

SECOND METHOD:

- Connect to RPD
- Open IIS Manager
- Go to Server
- Go to Rewite URL



- Click on Add new rule
- Select Blanck Outbound



- Variable Name : RESPONSE_Set_Cookie
- Pattern : .*
- Condicion : {HTTPS} and Pattern : on
- Action: Rewrite and Value : {R:0}; secure






- Add second Rule
- Variable Name : RESPONSE_Set_Cookie
- Pattern : .*
- Condicion : {HTTPS} and Pattern : on
- Action: Rewrite and Value : {R:0}; SameSite=None






When add the 2 rules and go back see this :