cSRF token not valid

anu_raghun

Hi! We have a local server running Providence. Every time we try to upload an image/media file it halts and shows 'cSRF token not valid'. Any ideas as to what might be causing this? Much appreciated!

devonhayley

I'm having this problem as well! The error code I get is:

DatabaseException: Lock wait timeout exceeded; try restarting transaction

Did you manage to resolve this?

seth

Do you get CSRF or the database exception? Or both?

devonhayley

Hey Seth,

Yesterday I was getting both, and today when I try to save a media representation, the rest of the record saves immediately and the media representation disappears completely like it was never there.

darrigan

Hi, As I understood some messages about this recurrent "CSRF token" problem, it should be linked to the cache of navigator. May be your files in cache were updated...

devonhayley

Hi Darrigan,

I'm pretty novice at all this stuff. Could you expand on what you mean by cache of navigator?

Thanks!

darrigan

Well, I'm sorry, may be "navigator" is not the right word in english. I mean "web browser". Look at this: https://en.wikipedia.org/wiki/Web_cache and this: https://en.wikipedia.org/wiki/Wikipedia:Bypass_your_cache

Bye!

devonhayley

Thanks for clarifying! I wonder if this is something that can be improved server-side, or if it can only be fixed client-side through my browser. I will look into this.

devonhayley

To update, I ran into the CSFR token problem, tried clearing my cache from my Chrome browser, and then tried saving the media representation again, only to receive an "uncaught fatal error" message. Checked my Providence log, and it gave me the "ERROR --> DatabaseException: Lock wait timeout exceeded; try restarting transaction code" again.

silvia

Did you solve this? We have a similar problem ...

seth

Silvia: how often does this happen to you? And what version are you running?

jim82

Hi. I have the same problem : Every time I want to upload an image it halts and shows 'cSRF token not valid'.

I click on "choose file" and then "save", it turns a while and then reload the page without having updated with the image.

Is it a problem of parameter? A timeout of something so?

jim82

but problem doesn't seem to be linked exclusively to 'cSRF token not valid' because this message doesn't appear always. Sometimes, page is reloaded saying that it's saved but no image there in!

seth

How large is the image? And what are

and

settings in your php.ini set to? These two parameters govern the maximum upload size that your PHP installation will allow. When files exceed that PHP stops handling request parameters and you can get errors like that. The default is 2mb, which is often too low. Try setting them to higher values. Both will need to be set, and

must be equal to or greater than

Seth

jim82

I could solve the problem by increasing size of upload_max_filesize in /etc/php/7.2/apache2/php.ini.

seth

You should try that if it's set low.

jim82

Hi Seth, sorry but this problem of Csrf and media not loaded occurs again.

In php.ini, I have

upload_max_filesize = 40M

post_max_size = 48M

but when I want to upload a media, it doesn't do anything and show the message "CSRF token is not valid"

Media size are less than 15 Mb

It works only with file size below 2Mb. Why, as max_filesize is 40M?

I edited the php.ini of /etc/php/7.4/apache2.

I think it's the good file?

Do I have to change something else? or change a value for timeout?

Thanks in advance

seth

Please make sure the settings file you're modifying is actually being used by your php installation. Try temporarily adding this line in your setup.php file and reloading:

You should get output with details of your configuration, including the file being loaded and the current values of

and

. I'd bet they'll be the defaults. The output will also tell you what php.ini file(s) have been loaded . Make sure you're editing those, and make sure you restart the server after you edit.