Wie waren noch die Antworten auf die ersten beiden Fragen aus dem zweiten Post dieses Thread?
Meinst du das, was in Post 4 steht?
Wie waren noch die Antworten auf die ersten beiden Fragen aus dem zweiten Post dieses Thread?
als 32768 setzt.
BTW: Was steht denn im MySQL error log?
l
2014-08-19 10:01:29 22219 [Note] /usr/sbin/mysqld: Normal shutdown
2014-08-19 10:01:29 22219 [Note] Giving 3 client threads a chance to die gracefully
2014-08-19 10:01:29 22219 [Note] Event Scheduler: Purging the queue. 0 events
2014-08-19 10:01:29 22219 [Note] Shutting down slave threads
2014-08-19 10:01:31 22219 [Note] Forcefully disconnecting 0 remaining clients
2014-08-19 10:01:31 22219 [Note] Binlog end
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'partition'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'BLACKHOLE'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_METRICS'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_CMP'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'INNODB_TRX'
2014-08-19 10:01:31 22219 [Note] Shutting down plugin 'InnoDB'
2014-08-19 10:01:31 22219 [Note] InnoDB: FTS optimize thread exiting.
2014-08-19 10:01:31 22219 [Note] InnoDB: Starting shutdown...
2014-08-19 10:01:33 22219 [Note] InnoDB: Shutdown completed; log sequence number 40745109742
2014-08-19 10:01:33 22219 [Note] Shutting down plugin 'ARCHIVE'
2014-08-19 10:01:33 22219 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-08-19 10:01:33 22219 [Note] Shutting down plugin 'MRG_MYISAM'
2014-08-19 10:01:33 22219 [Note] Shutting down plugin 'MyISAM'
2014-08-19 10:01:33 22219 [Note] Shutting down plugin 'MEMORY'
2014-08-19 10:01:33 22219 [Note] Shutting down plugin 'CSV'
2014-08-19 10:01:33 22219 [Note] Shutting down plugin 'sha256_password'
2014-08-19 10:01:33 22219 [Note] Shutting down plugin 'mysql_old_password'
2014-08-19 10:01:33 22219 [Note] Shutting down plugin 'mysql_native_password'
2014-08-19 10:01:33 22219 [Note] Shutting down plugin 'binlog'
2014-08-19 10:01:33 22219 [Note] /usr/sbin/mysqld: Shutdown complete
140819 10:01:33 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140819 10:01:34 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2014-08-19 10:01:35 5609 [Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 32978)
2014-08-19 10:01:35 5609 [Warning] Buffered warning: Changed limits: table_cache: 407 (requested 16384)
2014-08-19 10:01:35 5609 [Warning] You need to use --log-bin to make --binlog-format work.
2014-08-19 10:01:35 5609 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2014-08-19 10:01:35 5609 [Note] Plugin 'FEDERATED' is disabled.
2014-08-19 10:01:35 5609 [ERROR] Function 'innodb' already exists
2014-08-19 10:01:35 5609 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2014-08-19 10:01:35 5609 [ERROR] Function 'federated' already exists
2014-08-19 10:01:35 5609 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2014-08-19 10:01:35 5609 [ERROR] Function 'blackhole' already exists
2014-08-19 10:01:35 5609 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2014-08-19 10:01:35 5609 [ERROR] Function 'archive' already exists
2014-08-19 10:01:35 5609 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2014-08-19 10:01:35 5609 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-08-19 10:01:35 5609 [Note] InnoDB: The InnoDB memory heap is disabled
2014-08-19 10:01:35 5609 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-08-19 10:01:35 5609 [Note] InnoDB: Compressed tables use zlib 1.2.7
2014-08-19 10:01:35 5609 [Note] InnoDB: Using Linux native AIO
2014-08-19 10:01:35 5609 [Note] InnoDB: Using CPU crc32 instructions
2014-08-19 10:01:35 5609 [Note] InnoDB: Initializing buffer pool, size = 4.0G
2014-08-19 10:01:35 5609 [Note] InnoDB: Completed initialization of buffer pool
2014-08-19 10:01:35 5609 [Note] InnoDB: Highest supported file format is Barracuda.
2014-08-19 10:01:35 5609 [Note] InnoDB: 128 rollback segment(s) are active.
2014-08-19 10:01:35 5609 [Note] InnoDB: Waiting for purge to start
2014-08-19 10:01:35 5609 [Note] InnoDB: 5.6.19 started; log sequence number 40745109742
/usr/sbin/mysqld: File '/etc/mysql/slow-query.log' not found (Errcode: 13 - Permission denied)
2014-08-19 10:01:35 5609 [ERROR] Could not use /etc/mysql/slow-query.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
2014-08-19 10:01:35 5609 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2014-08-19 10:01:35 5609 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2014-08-19 10:01:35 5609 [Note] Server socket created on IP: '127.0.0.1'.
2014-08-19 10:01:35 5609 [Note] Event Scheduler: Loaded 0 events
2014-08-19 10:01:35 5609 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.19-1~dotdeb.1-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian)
2014-08-19 10:01:35 5609 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2014-08-19 10:01:35 5609 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2014-08-19 10:01:35 5609 [Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 32978)
2014-08-19 10:01:35 5609 [Warning] Buffered warning: Changed limits: table_cache: 407 (requested 16384)
root soft nofile 102400
root hard nofile 102400
mysql soft nofile 102400
mysql hard nofile 102400
ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 257373
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 102400
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 257373
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
cat /etc/security/limits.conf
# /etc/security/limits.conf
#
#Each line describes a limit for a user in the form:
#
#<domain> <type> <item> <value>
#
#Where:
#<domain> can be:
# - an user name
# - a group name, with @group syntax
# - the wildcard *, for default entry
# - the wildcard %, can be also used with %group syntax,
# for maxlogin limit
# - NOTE: group and wildcard limits are not applied to root.
# To apply a limit to the root user, <domain> must be
# the literal username root.
Habt ihr das übersehen? Dass für root auch wirklich root angegeben werden muss, steht doch unübersehbar drin in der /etc/security/limits.conf:
"To apply a limit to the root user, <domain> must be the literal username root."
#Where:
#<domain> can be:
# - an user name
# - a group name, with @group syntax
# - the wildcard *, for default entry
# - the wildcard %, can be also used with %group syntax,
# for maxlogin limit
#
#<type> can have the two values:
# - "soft" for enforcing the soft limits
# - "hard" for enforcing hard limits
Gegenfrage: Nenne mir mal ein Szenario wo PAM sinnvoll und besser ist als die Boardmittel der Anwendung?
Ich glaube nicht, dass Unifex da irgend etwas falsch gemacht hat
Darum war ich umso überraschter über den Hinweis, denn in keinem Tutorial war darauf ein Hinweis vergeben.
Allerdings glaube ich weiterhin, dass es fummelig wird, PAM aus einem existierenden Debian komplett auszubauen, weil da die ganzen Pakete gegen libpam.so gelinkt sind.
Richtig, aber dafür gibt es ja ganz einfache Lösungen die gleichzeitig auch fast alle anderen Probleme von Debian auf einen Schlag beheben: Slackware oder source-based Distros ala Gentoo
Keine Ahnung, vielleicht hast Du ja eine andere Lösung mit anderen ProblemenWarum kommt mir jetzt der legendäre "Now you have two problems"-Thread[1] von Jamie Zawinski et.al. in den Sinn? ;-)
We use essential cookies to make this site work, and optional cookies to enhance your experience.