Hi i found out today that ISPConfig doesnt create databases anymore that are created from web-site-administration .. inside ISPConfig it looks ok .. but no databases are created .. deleting existing ones works .. but not for new ones ( no limits ) - i am still able to create via phpmyadmin aso. ispconfig.log doesnt show me useful debug on this .. the only MYSQL-related lines that occour read: 16.05.2006 - 18:05:09 => INFO - /root/ispconfig/scripts/lib/config.lib.php, Line 427: MySQL FLUSH PRIVILEGES thats it :-/ are databases created on schedule or instantly ? .. maybe i missed something ? please comment ! tnx4reply -c-
I guess your mysql user that you specified during ISPConfig setup has not the permission to create databases.
well .. that is root .. and i can delete already created ones out of ISPC but not create any anymore.. via phpmyadm (root as well ) it is possible to create them .. so its not the mysqld-part .. there should also be an error in the ispconfig.log - but there isnt :-( update: i delete the DBs "web11_db1 web11_db2" and created "web13_db1 web14_db1 and web15_db1" .. after a few hours ( not after 5 mins or so) i could see "some" of the new databases in the Filesystem and on phpmyadmin, but not all .. :-/ ,while in IDPConfig they all show up .. and one of those databases even shows up as web14?db1 (on fs and phpmyadmin ) -> "?" instead of "_" in ispconfig its name ist ok (with "_" ) but even after removing this badnamed db , creating dbs out of ispconfig is still not possible thats wagg -c-
i would like to get some debug information on this .. but dont know how to set it up so ispconfig would show up the errors for "NOT" creating the dbs .. how can i debug this tnx4reply
have to split this(>10000 chars): strace /root/ispconfig/php/php - /root/ispconfig/scripts/writeconf.php execve("/root/ispconfig/php/php", ["/root/ispconfig/php/php", "-", "/root/ispconfig/scripts/writeconf.php"], [/* 15 vars */]) = 0 uname({sys="Linux", node="km20937-01.keymachine.de", ...}) = 0 brk(0) = 0x8496000 old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40017000 access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) open("/etc/ld.so.preload", O_RDONLY) = -1 ENOENT (No such file or directory) open("/root/ispconfig/openssl/lib/tls/i686/mmx/cmov/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/root/ispconfig/openssl/lib/tls/i686/mmx/cmov", 0xbfffef18) = -1 ENOENT (No such file or directory) open("/root/ispconfig/openssl/lib/tls/i686/mmx/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/root/ispconfig/openssl/lib/tls/i686/mmx", 0xbfffef18) = -1 ENOENT (No such file or directory) open("/root/ispconfig/openssl/lib/tls/i686/cmov/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/root/ispconfig/openssl/lib/tls/i686/cmov", 0xbfffef18) = -1 ENOENT (No such file or directory) open("/root/ispconfig/openssl/lib/tls/i686/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/root/ispconfig/openssl/lib/tls/i686", 0xbfffef18) = -1 ENOENT (No such file or directory) open("/root/ispconfig/openssl/lib/tls/mmx/cmov/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/root/ispconfig/openssl/lib/tls/mmx/cmov", 0xbfffef18) = -1 ENOENT (No such file or directory) open("/root/ispconfig/openssl/lib/tls/mmx/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/root/ispconfig/openssl/lib/tls/mmx", 0xbfffef18) = -1 ENOENT (No such file or directory) open("/root/ispconfig/openssl/lib/tls/cmov/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/root/ispconfig/openssl/lib/tls/cmov", 0xbfffef18) = -1 ENOENT (No such file or directory) open("/root/ispconfig/openssl/lib/tls/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/root/ispconfig/openssl/lib/tls", 0xbfffef18) = -1 ENOENT (No such file or directory) open("/root/ispconfig/openssl/lib/i686/mmx/cmov/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/root/ispconfig/openssl/lib/i686/mmx/cmov", 0xbfffef18) = -1 ENOENT (No such file or directory) open("/root/ispconfig/openssl/lib/i686/mmx/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/root/ispconfig/openssl/lib/i686/mmx", 0xbfffef18) = -1 ENOENT (No such file or directory) open("/root/ispconfig/openssl/lib/i686/cmov/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/root/ispconfig/openssl/lib/i686/cmov", 0xbfffef18) = -1 ENOENT (No such file or directory) open("/root/ispconfig/openssl/lib/i686/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/root/ispconfig/openssl/lib/i686", 0xbfffef18) = -1 ENOENT (No such file or directory) open("/root/ispconfig/openssl/lib/mmx/cmov/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/root/ispconfig/openssl/lib/mmx/cmov", 0xbfffef18) = -1 ENOENT (No such file or directory) open("/root/ispconfig/openssl/lib/mmx/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/root/ispconfig/openssl/lib/mmx", 0xbfffef18) = -1 ENOENT (No such file or directory) open("/root/ispconfig/openssl/lib/cmov/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/root/ispconfig/openssl/lib/cmov", 0xbfffef18) = -1 ENOENT (No such file or directory) open("/root/ispconfig/openssl/lib/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/root/ispconfig/openssl/lib", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0 open("/etc/ld.so.cache", O_RDONLY) = 3 fstat64(3, {st_mode=S_IFREG|0644, st_size=31182, ...}) = 0 old_mmap(NULL, 31182, PROT_READ, MAP_PRIVATE, 3, 0) = 0x40018000 close(3) = 0 access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) open("/lib/tls/libcrypt.so.1", O_RDONLY) = 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\360\t\0"..., 512) = 512 fstat64(3, {st_mode=S_IFREG|0644, st_size=18876, ...}) = 0 old_mmap(NULL, 181692, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40020000 old_mmap(0x40025000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x4000) = 0x40025000 old_mmap(0x40026000, 157116, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x40026000 close(3) = 0 open("/root/ispconfig/openssl/lib/libmysqlclient.so.14", O_RDONLY) = -1 ENOENT (No such file or directory) access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) open("/usr/lib/libmysqlclient.so.14", O_RDONLY) = 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0`\306\0"..., 512) = 512 fstat64(3, {st_mode=S_IFREG|0644, st_size=1066312, ...}) = 0 old_mmap(NULL, 1080032, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x4004d000 old_mmap(0x4008c000, 815104, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x3e000) = 0x4008c000 old_mmap(0x40153000, 6880, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x40153000 close(3) = 0 open("/root/ispconfig/openssl/lib/libz.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) open("/usr/lib/libz.so.1", O_RDONLY) = 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\200\27"..., 512) = 512 fstat64(3, {st_mode=S_IFREG|0644, st_size=67468, ...}) = 0 old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40155000 old_mmap(NULL, 70528, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40156000 old_mmap(0x40167000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x10000) = 0x40167000 close(3) = 0 open("/root/ispconfig/openssl/lib/libresolv.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) open("/lib/tls/libresolv.so.2", O_RDONLY) = 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\220)\0"..., 512) = 512 fstat64(3, {st_mode=S_IFREG|0644, st_size=64924, ...}) = 0 old_mmap(NULL, 73640, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40168000 old_mmap(0x40177000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0xf000) = 0x40177000 old_mmap(0x40178000, 8104, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x40178000 close(3) = 0 open("/root/ispconfig/openssl/lib/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or directory) access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) open("/lib/tls/libm.so.6", O_RDONLY) = 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\00005\0\000"..., 512) = 512 fstat64(3, {st_mode=S_IFREG|0644, st_size=134496, ...}) = 0 old_mmap(NULL, 136976, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x4017a000 old_mmap(0x4019b000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x20000) = 0x4019b000 close(3) = 0 open("/root/ispconfig/openssl/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) open("/lib/tls/libdl.so.2", O_RDONLY) = 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\320\32"..., 512) = 512 fstat64(3, {st_mode=S_IFREG|0644, st_size=9872, ...}) = 0 old_mmap(NULL, 8632, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x4019c000 old_mmap(0x4019e000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x2000) = 0x4019e000 close(3) = 0 open("/root/ispconfig/openssl/lib/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) open("/lib/tls/libnsl.so.1", O_RDONLY) = 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0 <\0\000"..., 512) = 512 fstat64(3, {st_mode=S_IFREG|0644, st_size=73304, ...}) = 0 old_mmap(NULL, 80544, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x4019f000 old_mmap(0x401b0000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x11000) = 0x401b0000 old_mmap(0x401b1000, 6816, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x401b1000 close(3) = 0
open("/root/ispconfig/openssl/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory) access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) open("/lib/tls/libc.so.6", O_RDONLY) = 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0`Z\1\000"..., 512) = 512 fstat64(3, {st_mode=S_IFREG|0755, st_size=1254660, ...}) = 0 old_mmap(NULL, 1264972, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x401b3000 old_mmap(0x402dd000, 36864, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x129000) = 0x402dd000 old_mmap(0x402e6000, 7500, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x402e6000 close(3) = 0 old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x402e8000 set_thread_area({entry_number:-1 -> 6, base_addr:0x402e88e0, limit:1048575, seg_32bit:1, contents:0, read_exec_only:0, limit_in_pages:1, seg_not_present:0, useable:1}) = 0 munmap(0x40018000, 31182) = 0 rt_sigaction(SIGPIPE, {SIG_IGN}, {SIG_DFL}, 8) = 0 brk(0) = 0x8496000 brk(0x84b7000) = 0x84b7000 brk(0) = 0x84b7000 open("/etc/localtime", O_RDONLY) = 3 fstat64(3, {st_mode=S_IFREG|0644, st_size=837, ...}) = 0 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40018000 read(3, "TZif\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\10\0\0\0\10"..., 4096) = 837 close(3) = 0 munmap(0x40018000, 4096) = 0 open("/root/ispconfig/php//php-cli.ini", O_RDONLY) = -1 ENOENT (No such file or directory) open("/root/ispconfig/php/php-cli.ini", O_RDONLY) = -1 ENOENT (No such file or directory) open("/root/ispconfig/php//php.ini", O_RDONLY) = 3 getcwd("/home/admispconfig/ispconfig", 4096) = 29 lstat64("/root", {st_mode=S_IFDIR|0700, st_size=4096, ...}) = 0 lstat64("/root/ispconfig", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0 lstat64("/root/ispconfig/php", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0 lstat64("/root/ispconfig/php/php.ini", {st_mode=S_IFREG|0644, st_size=38519, ...}) = 0 ioctl(3, SNDCTL_TMR_TIMEBASE or TCGETS, 0xbfffe2f8) = -1 ENOTTY (Inappropriate ioctl for device) fstat64(3, {st_mode=S_IFREG|0644, st_size=38519, ...}) = 0 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40018000 read(3, " PHP: \n\n;;;;;;;;;;;\n; WARNING ;\n;"..., 8192) = 8192 read(3, "owed_env_vars = PHP_\n\n; This dir"..., 8192) = 8192 read(3, "ype = \"text/html\"\n;default_chars"..., 8192) = 8192 read(3, "rd as well.\nmysql.default_passwo"..., 8192) = 8192 read(3, " include them here, the rewriter"..., 8192) = 5751 read(3, "", 4096) = 0 read(3, "", 8192) = 0 close(3) = 0 munmap(0x40018000, 4096) = 0 brk(0) = 0x84b7000 brk(0x84d8000) = 0x84d8000 brk(0) = 0x84d8000 brk(0x84f9000) = 0x84f9000 open("/etc/nsswitch.conf", O_RDONLY) = 3 fstat64(3, {st_mode=S_IFREG|0644, st_size=465, ...}) = 0 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40018000 read(3, "# /etc/nsswitch.conf\n#\n# Example"..., 4096) = 465 read(3, "", 4096) = 0 close(3) = 0 munmap(0x40018000, 4096) = 0 open("/root/ispconfig/openssl/lib/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("/etc/ld.so.cache", O_RDONLY) = 3 fstat64(3, {st_mode=S_IFREG|0644, st_size=31182, ...}) = 0 old_mmap(NULL, 31182, PROT_READ, MAP_PRIVATE, 3, 0) = 0x40018000 close(3) = 0 access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) open("/lib/tls/i686/mmx/cmov/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/lib/tls/i686/mmx/cmov", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/lib/tls/i686/mmx/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/lib/tls/i686/mmx", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/lib/tls/i686/cmov/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/lib/tls/i686/cmov", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/lib/tls/i686/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/lib/tls/i686", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/lib/tls/mmx/cmov/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/lib/tls/mmx/cmov", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/lib/tls/mmx/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/lib/tls/mmx", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/lib/tls/cmov/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/lib/tls/cmov", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/lib/tls/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/lib/tls", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0 open("/lib/i686/mmx/cmov/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/lib/i686/mmx/cmov", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/lib/i686/mmx/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/lib/i686/mmx", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/lib/i686/cmov/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/lib/i686/cmov", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/lib/i686/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/lib/i686", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/lib/mmx/cmov/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/lib/mmx/cmov", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/lib/mmx/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/lib/mmx", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/lib/cmov/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/lib/cmov", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/lib/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/lib", {st_mode=S_IFDIR|0755, st_size=12288, ...}) = 0 open("/usr/lib/tls/i686/mmx/cmov/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/tls/i686/mmx/cmov", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/usr/lib/tls/i686/mmx/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/tls/i686/mmx", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/usr/lib/tls/i686/cmov/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/tls/i686/cmov", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/usr/lib/tls/i686/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/tls/i686", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/usr/lib/tls/mmx/cmov/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/tls/mmx/cmov", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/usr/lib/tls/mmx/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/tls/mmx", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/usr/lib/tls/cmov/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/tls/cmov", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/usr/lib/tls/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/tls", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/usr/lib/i686/mmx/cmov/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/i686/mmx/cmov", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/usr/lib/i686/mmx/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/i686/mmx", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/usr/lib/i686/cmov/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/i686/cmov", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0 open("/usr/lib/i686/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/i686", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0 open("/usr/lib/mmx/cmov/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/mmx/cmov", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/usr/lib/mmx/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/mmx", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/usr/lib/cmov/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib/cmov", 0xbfffedd0) = -1 ENOENT (No such file or directory) open("/usr/lib/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/lib", {st_mode=S_IFDIR|0755, st_size=36864, ...}) = 0 munmap(0x40018000, 31182) = 0 open("/root/ispconfig/openssl/lib/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("/etc/ld.so.cache", O_RDONLY) = 3 fstat64(3, {st_mode=S_IFREG|0644, st_size=31182, ...}) = 0 old_mmap(NULL, 31182, PROT_READ, MAP_PRIVATE, 3, 0) = 0x40018000 close(3)
close(3) = 0 access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory) open("/lib/tls/libnss_files.so.2", O_RDONLY) = 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\200\35"..., 512) = 512 fstat64(3, {st_mode=S_IFREG|0644, st_size=34748, ...}) = 0 old_mmap(NULL, 38044, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x402e9000 old_mmap(0x402f2000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x8000) = 0x402f2000 close(3) = 0 munmap(0x40018000, 31182) = 0 open("/etc/protocols", O_RDONLY) = 3 fcntl64(3, F_GETFD) = 0 fcntl64(3, F_SETFD, FD_CLOEXEC) = 0 fstat64(3, {st_mode=S_IFREG|0644, st_size=2478, ...}) = 0 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40018000 read(3, "# Internet (IP) protocols\n#\n# Up"..., 4096) = 2478 close(3) = 0 munmap(0x40018000, 4096) = 0 open("/etc/protocols", O_RDONLY) = 3 fcntl64(3, F_GETFD) = 0 fcntl64(3, F_SETFD, FD_CLOEXEC) = 0 fstat64(3, {st_mode=S_IFREG|0644, st_size=2478, ...}) = 0 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40018000 read(3, "# Internet (IP) protocols\n#\n# Up"..., 4096) = 2478 close(3) = 0 munmap(0x40018000, 4096) = 0 brk(0) = 0x84f9000 brk(0x851a000) = 0x851a000 setitimer(ITIMER_PROF, {it_interval={0, 0}, it_value={0, 0}}, NULL) = 0 setitimer(ITIMER_PROF, {it_interval={0, 0}, it_value={0, 0}}, NULL) = 0 rt_sigaction(SIGPROF, {0x81ce570, [PROF], SA_RESTORER|SA_RESTART, 0x401dba18}, {SIG_DFL}, 8) = 0 rt_sigprocmask(SIG_UNBLOCK, [PROF], NULL, 8) = 0 open("-", O_RDONLY) = -1 ENOENT (No such file or directory) write(2, "Could not open input file: -.\n", 30Could not open input file: -. ) = 30 setitimer(ITIMER_PROF, {it_interval={0, 0}, it_value={0, 0}}, NULL) = 0 setitimer(ITIMER_PROF, {it_interval={0, 0}, it_value={300, 0}}, NULL) = 0 rt_sigaction(SIGPROF, {0x81ce570, [PROF], SA_RESTORER|SA_RESTART, 0x401dba18}, {0x81ce570, [PROF], SA_RESTORER|SA_RESTART, 0x401dba18}, 8) = 0 rt_sigprocmask(SIG_UNBLOCK, [PROF], NULL, 8) = 0 exit_group(1) = ?
Hi can you please guide me .. i am looking for the place in the libaries where ISPConfig creates the databases for customers .. i want to debug this ( i think its a php5-issue ) tnx4reply -c-
Hi there, it might be for interrest that i have another database-related issue with ISPConfig & PHP5 .. i think thats someway related .. just FYI:http://www.roundcubeforum.net/index.php?topic=482.15 -c-
I dont think it is an PHP5 issue. There are several thousand ISPConfig installations, all running the same php5 version that is configured identically and the database creation works for them. The databases where created in: /root/ispconfig/scripts/lib/config.lib.php starting with line 143.
i just reinstalled ispconfig 2.2.2 from scratch and tried to track the problem down .. i started to happen again , after i deleted a site-datebase , emptied the recycliebin and recreated the site-database .. it stopped creating databases.. deleting is possible , but my ispconfig never clears the mysql/user table after deleting a database/db-user pair .. i can see t in my mysql.log that the mysql-user to access the database is being created ... also can find it in the database .. i need feedback of the following sequence: @mysql_query("CREATE DATABASE DEFAULT CHARACTER SET utf8 ".$new_db); it just runs through my log without error ... but in fact the DB is NOT being created .. please help me in debugging .. how can is see more debug on this CREATE-sequence tnx4reply -c-
so it is really not creating that database but any other entries ( like user in mysql/users and isp_datenbanken ) .. so i guess its a mysql problem i have debian-sarge with following packages: Code: ii libmysqlclient12 4.0.24-10sarge1 ii libmysqlclient14 4.1.11a-4sarge2 ii libmysqlclient14-dev 4.1.11a-4sarge2 ii mysql-client-4.1 4.1.11a-4sarge2 ii mysql-common-4.1 4.1.11a-4sarge2 ii mysql-server-4.1 4.1.11a-4sarge2 maybe i should downgrade my mysql .. i am really finished
I don't think it's a problem with the MySQL version, but anyway you can try to downgrade and see if that solves your problem.
oh well .. i still hope so .. but i would prefer a 4.1 solution since have my db-backups on that version .. after reinstalling (perfect-sarge-setup) and downgrading to 5.0.4 ( phpmyadmin & POST bug in PHP5.1.3! ) an restoring the dbs .. all is at mess .. unknow document type (for all my customers and forms ) .. even css (!) is working crappy (roundcube.pkg) really i keep trying .. such bad luck but how many tables a default installation should have 53 or 52 ?
after a reseller ceated a DB it wasnt accessable .. it show up in the filesystem Code: drwx------ 2 mysql mysql 4096 2006-05-25 20:56 web15?db1 so he created his db by phpmyadmin Code: drwx------ 2 mysql mysql 4096 2006-05-24 10:30 web15_db1 i dont want to play around with this too much , because after a complete new sysup after PERFECT-SARGE-HOWTO it didnt happen again - until now .. well ich can still create the Databases , good luck .. so how can the DB-Name provided by ISPConfig change this way ? i have no idea since all other databases have good namings tnx4comment -c-
