Welcome to Geeklog, Anonymous Friday, December 27 2024 @ 05:09 pm EST

Geeklog Forums

412 Precondition failed error when using the words "INSERT INTO" in story


Status: offline

slippery

Forum User
Newbie
Registered: 08/22/07
Posts: 3
I have geeklog 1.4.1 running on a web host, and have post about 20 stories so far. I was adding a story about MySQL, but if I use the words "INSERT INTO" in the story text (HTML formatted), I can't save or preview the story, I always get "Precondition failed" and have to use the back button and remove it.

I don't have the Bad Behavior plugin installed, just the default plugins.

Here is what I am trying to enter in the Body Text:

insert into user (Host, User, Password, Select_priv, Insert_priv,
Update_priv, Delete_priv) values ('%', 'remote', password('xxx'Wink,
'Y', 'Y', 'Y', 'Y'Wink;
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Do you happen to have mod_security installed on your webserver?

bye, Dirk
 Quote

Status: offline

slippery

Forum User
Newbie
Registered: 08/22/07
Posts: 3
Quote by: Dirk

Do you happen to have mod_security installed on your webserver?

bye, Dirk



I can't tell at the moment. Let me dig around on the host server to find out. Unfortunately, since it is hosted, I won't be able to remove it from the apache config if that is the problem.

Thanks for the info,
Keith
 Quote

Status: offline

slippery

Forum User
Newbie
Registered: 08/22/07
Posts: 3
Yes, mod_security is loaded by Apache, but I can't change the Apache configuration.

I was able to get around it by replacing the word "INTO" with HTML character entities, but that is quite ugly.

There may be a way to turn off mod_security with an .htaccess file, but this is the only time it has caused a problem and I'm not sure I want to turn off all protection.

If I had access to the mod_security rule list, I might be able to disable just the one rule it is hitting. Not sure if I want to spar with my web host over it, though.

Keith
 Quote

All times are EST. The time is now 05:09 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content