Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 7th July 2009, 17:26
tom tom is offline
Senior Member
 
Join Date: Apr 2006
Posts: 492
Thanks: 8
Thanked 8 Times in 7 Posts
Default use of phpmyadmin crashes the ispconfig server

What I've done? I've only tried to edit a table with phpmyadmin. I does'nt belong to a special table. I noticed it with several tables. Even if nothing was changed but afer using the safe button sshd breaks the connektion, apache disapears and other demons too.

Have you ever noticed thinks like that?
Could it be a faulty phpmyadmin version?

I'm using phpMyAdmin - 2.11.8.1deb5+lenny1
Reply With Quote
Sponsored Links
  #2  
Old 7th July 2009, 17:47
Mark_NL Mark_NL is offline
Senior Member
 
Join Date: Sep 2008
Location: The Netherlands
Posts: 912
Thanks: 12
Thanked 100 Times in 96 Posts
Default

i think it's because fo the suhosin plugin that comes default with php5, when you log on phpmyadmin, look on the bottom of the right pane, there should be a notice about it (with a link to what you should change)
Reply With Quote
  #3  
Old 8th July 2009, 14:53
tom tom is offline
Senior Member
 
Join Date: Apr 2006
Posts: 492
Thanks: 8
Thanked 8 Times in 7 Posts
Default

The only things I see in the right column on the start page is

Code:
phpMyAdmin - 2.11.8.1deb5+lenny1

    * MySQL-Client-Version: 5.0.51a
    * Verwandte php-Erweiterungen: mysql
    *
      Sprache - Language Info:
    *
      Oberflächendesign:
    *
      Schriftgröße:
    * phpMyAdmin-Dokumentation
    * phpMyAdmin Wiki
    * Offizielle phpMyAdmin-Homepage
    * [ChangeLog] [Subversion][Lists]
Reply With Quote
  #4  
Old 8th July 2009, 15:15
Mark_NL Mark_NL is offline
Senior Member
 
Join Date: Sep 2008
Location: The Netherlands
Posts: 912
Thanks: 12
Thanked 100 Times in 96 Posts
Default

goto /etc/php5/apache2/conf.d/

do you have a file called suhosin.ini in it?

if so, check these values:

suhosin.sql.bailout_on_error = off

suhosin.request.max_vars = 400
suhosin.request.max_totalname_length = 512
suhosin.request.max_array_index_length = 128
suhosin.post.max_vars = 400
suhosin.post.max_totalname_length = 512
suhosin.post.max_array_index_length = 128

(i've used these values for testing purpouse and seem to work, they probably could be better finetuned .. ah well it works ;-)
Reply With Quote
  #5  
Old 9th July 2009, 01:22
tom tom is offline
Senior Member
 
Join Date: Apr 2006
Posts: 492
Thanks: 8
Thanked 8 Times in 7 Posts
Default

locate suhosin.ini shows no suhosin.ini at all. Is that default in ISPConfig for debian lenny?


locate php.ini shows
Code:
h1:/etc/php5# locate php.ini
/etc/php5/apache2/php.ini
/etc/php5/cgi/php.ini
/etc/php5/cli/php.ini
/usr/share/doc/php5-common/examples/php.ini-dist
/usr/share/doc/php5-common/examples/php.ini-paranoid
/usr/share/doc/php5-common/examples/php.ini-recommended
/usr/share/php5/php.ini-dist
/usr/share/php5/php.ini-dist.cli
I'm even not sure about the concept of the diffrend php versions of ISPC3 like fast-cgi, php, suphp and where to configure it differently?
Reply With Quote
  #6  
Old 9th July 2009, 10:44
Mark_NL Mark_NL is offline
Senior Member
 
Join Date: Sep 2008
Location: The Netherlands
Posts: 912
Thanks: 12
Thanked 100 Times in 96 Posts
Default

Hmm, then i guess you don't have suhosin installed (it does come default with php5 lenny)

phpinfo(); can tell you if it's loaded as well.

(the reason why i'm focussing on suhosin, is because i had the same problem, but changing those suhosin settings fixed it )

Last edited by Mark_NL; 9th July 2009 at 10:46.
Reply With Quote
  #7  
Old 10th July 2009, 14:05
tom tom is offline
Senior Member
 
Join Date: Apr 2006
Posts: 492
Thanks: 8
Thanked 8 Times in 7 Posts
Default

Suhosin is included:
Code:
This server is protected with the Suhosin Patch 0.9.6.2
Copyright (c) 2006 Hardened-PHP Project
But I don't see the suhosin directives with phpinfo()

1. What is the default in ISPConfig3 are any php or suhosin files been copied or edited? In my old php.ini the suhosin directives are in the php.ini. Should it be differend in to files php.ini and suhosin.ini?

2. How to use and where to configure the differed php options which comes whith ISPConfig3?
It should be possible to edit php-fcgi, mop-php etc. one by one and even differently for every website. But where and how to configure? What is the ISPConig3 concept for that?

3. Does somebody else have noticed a server crash after using phpmyadmin? I can reproduce it, but the envirement is'nt unusual so I think I sould not be the only one who can crash the whole server be edding a table with phpmyqdmin.

Quote:
h1:~# uname -a Linux h1.adx.de 2.6.18-028stab060.8 #1 SMP Mon Feb 9 20:25:36 MSK 2009 i686 GNU/Linux
MySQL-Datenbank 5.0.51a
PHP 5.2.9-0.dotdeb.2
Debian Lenny on Virtuozzo

Last edited by tom; 10th July 2009 at 14:17.
Reply With Quote
  #8  
Old 10th July 2009, 14:26
Mark_NL Mark_NL is offline
Senior Member
 
Join Date: Sep 2008
Location: The Netherlands
Posts: 912
Thanks: 12
Thanked 100 Times in 96 Posts
Default

1. Your suhosin settings are default (on a debian lenny with ispconfig 3 installation): /etc/php5/apache2/conf.d/suhosin.ini

2. I _think_ it's done through the apache directive textarea per website. (but i'm not sure)

3. Well i've never had the problem of crashing the complete server when editing a table in phpmyadmin
Reply With Quote
  #9  
Old 10th July 2009, 14:47
tom tom is offline
Senior Member
 
Join Date: Apr 2006
Posts: 492
Thanks: 8
Thanked 8 Times in 7 Posts
Default

Quote:
Originally Posted by Mark_NL View Post
1. Your suhosin settings are default (on a debian lenny with ispconfig 3 installation): /etc/php5/apache2/conf.d/suhosin.ini
...
You mean default is that there sould be an suhosin.ini file? But why I have no suhosin.ini at all as default? Could you post youre default suhosin.ini?

Last edited by tom; 10th July 2009 at 14:50.
Reply With Quote
  #10  
Old 10th July 2009, 15:18
Mark_NL Mark_NL is offline
Senior Member
 
Join Date: Sep 2008
Location: The Netherlands
Posts: 912
Thanks: 12
Thanked 100 Times in 96 Posts
 
Default

mark@hosting03:/etc/php5/apache2/conf.d$ cat suhosin.ini
; configuration for php suhosin module
extension=suhosin.so

;;;;;;;;;;;;;;;;;;;
; Module Settings ;
;;;;;;;;;;;;;;;;;;;
; the following values are the internal default settings and set implicit
; feel free to modify to your needs

[suhosin]
; Logging Configuration
;suhosin.log.syslog.facility = 9
;suhosin.log.syslog.priority = 1
;suhosin.log.script = 0
;suhosin.log.phpscript = 0
;suhosin.log.script.name =
;suhosin.log.phpscript.name =
;suhosin.log.use-x-forwarded-for = off

; Executor Options
;suhosin.executor.max_depth = 0
;suhosin.executor.include.max_traversal = 0
;suhosin.executor.include.whitelist =
;suhosin.executor.include.blacklist =
;suhosin.executor.func.whitelist =
;suhosin.executor.func.blacklist =
;suhosin.executor.eval.whitelist =
;suhosin.executor.eval.blacklist =
;suhosin.executor.disable_emodifier = off
;suhosin.executor.allow_symlink = off

; Misc Options
;suhosin.simulation = off
;suhosin.apc_bug_workaround = off
suhosin.sql.bailout_on_error = off
;suhosin.sql.user_prefix =
;suhosin.sql.user_postfix =
;suhosin.multiheader = off
;suhosin.mail.protect = 0
;suhosin.memory_limit = 0

; Transparent Encryption Options
;suhosin.session.encrypt = on
;suhosin.session.cryptkey =
;suhosin.session.cryptua = on
;suhosin.session.cryptdocroot = on
;suhosin.session.cryptraddr = 0
;suhosin.session.checkraddr = 0
;suhosin.cookie.encrypt = on
;suhosin.cookie.cryptkey =
;suhosin.cookie.cryptua = on
;suhosin.cookie.cryptdocroot = on
;suhosin.cookie.cryptraddr = 0
;suhosin.cookie.checkraddr = 0
;suhosin.cookie.cryptlist =
;suhosin.cookie.plainlist =

; Filtering Options
;suhosin.filter.action =
;suhosin.cookie.max_array_depth = 100
;suhosin.cookie.max_array_index_length = 64
;suhosin.cookie.max_name_length = 64
;suhosin.cookie.max_totalname_length = 256
;suhosin.cookie.max_value_length = 10000
;suhosin.cookie.max_vars = 100
;suhosin.cookie.disallow_nul = on
;suhosin.get.max_array_depth = 50
;suhosin.get.max_array_index_length = 64
;suhosin.get.max_name_length = 64
;suhosin.get.max_totalname_length = 256
;suhosin.get.max_value_length = 512
;suhosin.get.max_vars = 100
;suhosin.get.disallow_nul = on
;suhosin.post.max_array_depth = 100
suhosin.post.max_array_index_length = 128
;suhosin.post.max_name_length = 64
suhosin.post.max_totalname_length = 512
;suhosin.post.max_value_length = 65000
suhosin.post.max_vars = 400
;suhosin.post.disallow_nul = on
;suhosin.request.max_array_depth = 100
suhosin.request.max_array_index_length = 128
suhosin.request.max_totalname_length = 512
;suhosin.request.max_value_length = 65000
suhosin.request.max_vars = 400
;suhosin.request.max_varname_length = 64
;suhosin.request.disallow_nul = on
;suhosin.upload.max_uploads = 25
;suhosin.upload.disallow_elf = on
;suhosin.upload.disallow_binary = off
;suhosin.upload.remove_binary = off
;suhosin.upload.verification_script =
;suhosin.session.max_id_length = 128
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISPconfig setup - DNS, router and general access problems ingvar Installation/Configuration 6 31st July 2010 14:13
Connection dropped by IMAP server gublym Server Operation 5 23rd January 2009 10:47
phpmyadmin problem on ubuntu mail server virtual domains almeister9 HOWTO-Related Questions 1 19th September 2008 17:52
Install ISPConfig on CentOS Server, in brief gfts Tips/Tricks/Mods 11 4th April 2006 09:29
Email - Ueb-Miau mazhar Installation/Configuration 5 21st December 2005 11:01


All times are GMT +2. The time now is 07:27.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.