Posts by oekowalti

oekowalti · Mar 30th 2016

Hello @Nuxwin:
I still has the following error after having changed the file 'Shared.php':

Code

Dear admin,
An exception has been thrown in file/var/www/imscp/gui/library/Functions/Shared.php at line 2724:
=================================================================
SQLSTATE[42000]: Syntax error or access violation: 1141 There is no such grant defined for user 't3_alb_user' on host 'localhost'
Query was:
REVOKE ALL PRIVILEGES ON `t3_alb_neu`.* FROM 't3_alb_user'@'localhost'
=================================================================
Debug backtrace:---------------
File: /var/www/imscp/gui/library/Functions/Shared.php at line 686Function: exec_query()File: /var/www/imscp/gui/library/Functions/Shared.php at line 731Function: sql_delete_user()File: /var/www/imscp/gui/public/client/sql_database_delete.php at line44Function: delete_sql_database()
Additional information:----------------------
Http User Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0)Gecko/20100101 Firefox/45.0Request Uri: /client/sql_database_delete.php?id=78Http Referer: https://91.214.168.30:4443/client/sql_manage.phpRemote Addr: 178.199.5.228Server Addr: 91.214.168.30
____________________________________________________________i-MSCP Exception Mail Writer
Note: You will not receive further emails for this exception in the next 24 hours.

Display More

oekowalti · Mar 29th 2016

@Nuxwin:
Distro is Jessie, all packages updatet.
SQL-Server is working. But what do you mean with 'in use'?

May be this constallation is responsible fo the error:

oekowalti · Mar 29th 2016

Beim Löschen einer Datenbank erhalte ich den folgenden Fehler:

Code

Dear admin,
An exception has been thrown in file/var/www/imscp/gui/library/Functions/Shared.php at line 2724:
=================================================================
SQLSTATE[42000]: Syntax error or access violation: 1141 There is no such grant defined for user 't3_alb_user' on host 'localhost'
Query was:
REVOKE ALL PRIVILEGES ON `t3_alb_neu`.* FROM 't3_alb_user'@'localhost'
=================================================================
Debug backtrace:---------------
File: /var/www/imscp/gui/library/Functions/Shared.php at line 686Function: exec_query()File: /var/www/imscp/gui/library/Functions/Shared.php at line 731Function: sql_delete_user()File: /var/www/imscp/gui/public/client/sql_database_delete.php at line44Function: delete_sql_database()
Additional information:----------------------
Http User Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0)Gecko/20100101 Firefox/45.0Request Uri: /client/sql_database_delete.php?id=78Http Referer: https://91.214.168.30:4443/client/sql_manage.phpRemote Addr: 178.199.5.228Server Addr: 91.214.168.30
____________________________________________________________i-MSCP Exception Mail Writer
Note: You will not receive further emails for this exception in the next 24 hours.

Display More

Offenbar geht es um fehlende Privilegien.
Dieses Problem eilt nicht, ich wollte einfach nicht mehr benötigte Datenbank löschen.

Was ist zu tun?

oekowalti · Mar 21st 2016

Hello @Nuxwin

With that patch it works!

Thanks very much for your help.

oekowalti · Mar 21st 2016

Hallo

Bisher war es möglich über den Menüpunkt Domains --> Zertifikat verwalten, ein selbst-signiertes Zertifikat zu erzeugen.

Seit der Version 1.2.17 von i-MSCP erhalte ich beim Feld SSL-Status den Eintrag: Ungültiges SSL-Zertifikat.

Im Log 'SSLcertificate_module_sub.log' erhalte ich die folgenden Zeilen:

Code

[Mon Mar 21 11:11:42 2016] [error] iMSCP::File::get: Unable to open : No such file or directory
[Mon Mar 21 11:11:42 2016] [error] iMSCP::OpenSSL::ImportCaBundle: Could not read file

Auch der Versuch, ein mit 'letsencrypt' erzeugtes Zertfikat mit copy & paste einzufügen, war erfolglos.

Mache ich etwas falsch oder liegt es am neuen Release von i-MSCP (1.2.17)?

Herzlichen Dank im Voraus für weiterhelfende Infos.

oekowalti · Mar 6th 2016

@Nuxwin

The new result is:

; Default Value: nothing is defined by default except the values in php.ini and
; specified at startup with the -d argument
php_admin_value[open_basedir] = /usr/bin/:/usr/local/sbin/:/usr/local/bin/:/usr/sbin/:/bin/:/var/www/apps/:/var/www/virtual/oeko-admin.ch/:/usr/share/php
php_admin_value[upload_tmp_dir] = /var/www/virtual/oeko-admin.ch/phptmp
...

; Custom values
php_admin_value[max_execution_time] = 240
...
php_admin_value[disable_functions] =
php_value[always_populate_raw_post_data] = -1
php_value[max_input_vars] = 1500

All is perfect!
You did a great job.

Have a good sunday.
Walter

oekowalti · Mar 6th 2016

@Nuxwin

result is:
PHP_FPM_POOLS_LEVEL = per_user

oekowalti · Mar 6th 2016

@Nuxwin

The whole file is attached.

oekowalti · Mar 5th 2016

@Nuxwin

I tried your code (without changes) and receive this configuration (only last lines):

; Default Value: nothing is defined by default except the values in php.ini and
; specified at startup with the -d argument
php_admin_value[open_basedir] = /usr/bin/:/usr/local/sbin/:/usr/local/bin/:/usr/sbin/:/bin/:/var/www/apps/:/var/www/virtual/oeko-admin.ch/:/usr/share/php
php_admin_value[upload_tmp_dir] = /var/www/virtual/oeko-admin.ch/phptmp
php_admin_value[session.save_path] = /var/www/virtual/oeko-admin.ch/phptmp
php_admin_value[soap.wsdl_cache_dir] = /var/www/virtual/oeko-admin.ch/phptmp
php_admin_value[sendmail_path] = /usr/sbin/sendmail -t -i -f webmaster@oeko-admin.ch

; Custom values
php_admin_value[max_execution_time] = 30
php_admin_value[max_input_time] = 60
php_admin_value[memory_limit] = 128M
php_value[error_reporting] = 24575
php_flag[display_errors] = off
php_admin_value[post_max_size] = 10M
php_admin_value[upload_max_filesize] = 9M
php_admin_flag[allow_url_fopen] = off
php_admin_value[disable_functions] =
php_value[always_populate_raw_post_data] = -1

You see, some parameters were set correctly and other were not:
always_populate_raw_post_da: ok.
open_basedir: ok.
max_execution_time: not ok.
max_input_vars: not set.

Please show me the problem.

oekowalti · Mar 5th 2016

Hallo

Ich habe das gleiche Problem.
Die oberen, globalen Einträge mit "*" werden richtig gesetzt, die unteren für die Domain 'domain.ch' jedoch nicht.
Sieht jemand, was ich falsch mache:

Shell-Script

my %configOptions = (
'*' => { # Any PHP configuration added here will apply to the domain only
'open_basedir' => '/usr/bin/:/usr/local/sbin/:/usr/local/bin/:/usr/sbin/:/bin/:/var/www/apps/:{HOME_DIR}/:{PEAR_DIR}'
},
'*' => { # Any PHP configuration option added here will apply globally.
disable_functions' => ''
},
'*' => { # Any PHP configuration option added here will apply globally.
'always_populate_raw_post_data' => '-1'
},
'domain.ch' => { # Any PHP configuration added here will apply to the domain only
'php_admin_value[open_basedir]' => '/usr/bin/:/usr/local/sbin/:/usr/local/bin/:/usr/sbin/:/bin/:/var/www/apps/:{HOME_DIR}/:{PEAR_DIR}'
},
'domain.ch' => { # Any PHP configuration option added here will apply globally.
'php_admin_value[disable_functions]' => ''
},
'domain.ch' => { # Any PHP configuration option added here will apply globally.
'php_value[always_populate_raw_post_data]' => '-1'
},
'domain.ch' => { # Any PHP configuration option added here will apply globally.
'php_admin_value[max_execution_time]' => '240'
},
'domain.ch' => { # Any PHP configuration option added here will apply globally.
'php_admin_value[max_input_vars]' => '1500'
}
);

Display More

Gehe ich richtig in der Annahme, dass sich die Konfiguration in der Datei "/etc/php5/fpm/domain.ch.conf" zeigen sollte?

Posts by oekowalti

Fehler beim Löschen einer Datenbank

Fehler beim Löschen einer Datenbank

Fehler beim Löschen einer Datenbank

Nach Update auf 1.2.17 - Ungültiges SSL-Zertifikat

Nach Update auf 1.2.17 - Ungültiges SSL-Zertifikat

Listener php confoptions

Listener php confoptions

Listener php confoptions

Listener php confoptions

Listener php confoptions