site - databases

Discussion in 'Installation/Configuration' started by trueshanti, May 16, 2006.

  1. trueshanti

    trueshanti New Member

    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-
     
  2. till

    till Super Moderator

    I guess your mysql user that you specified during ISPConfig setup has not the permission to create databases.
     
  3. trueshanti

    trueshanti New Member

    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-
     
    Last edited: May 16, 2006
  4. falko

    falko Super Moderator

    Which ISPConfig version do you use?
     
  5. trueshanti

    trueshanti New Member

    2.2.2

    tnx

    -c-
     
  6. falko

    falko Super Moderator

    What's the output of
    Code:
    strace /root/ispconfig/php/php - /root/ispconfig/scripts/writeconf.php
    ?
     
  7. trueshanti

    trueshanti New Member

    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
     
  8. trueshanti

    trueshanti New Member

    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
     
  9. trueshanti

    trueshanti New Member

    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;;;;;;;;;;;\nWARNING ;\n;"..., 8192) = 8192
    read(3, "
    owed_env_vars PHP_\n\nThis 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
    (0x400180004096)                = 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|0644st_size=465, ...}) = 0
    mmap2
    (NULL4096PROT_READ|PROT_WRITEMAP_PRIVATE|MAP_ANONYMOUS, -10) = 0x40018000
    read
    (3"# /etc/nsswitch.conf\n#\n# Example"..., 4096) = 465
    read
    (3""4096)                       = 0
    close
    (3)                                = 0
    munmap
    (0x400180004096)                = 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|0644st_size=31182, ...}) = 0
    old_mmap
    (NULL31182PROT_READMAP_PRIVATE30) = 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|0755st_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|0755st_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|0755st_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|0755st_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|0755st_size=36864, ...}) = 0
    munmap
    (0x4001800031182)               = 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|0644st_size=31182, ...}) = 0
    old_mmap
    (NULL31182PROT_READMAP_PRIVATE30) = 0x40018000
    close
    (3)
     
  10. trueshanti

    trueshanti New Member

    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) = ?
     
  11. till

    till Super Moderator

    The strace output is OK so far, no segfaults.
     
  12. trueshanti

    trueshanti New Member

    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-
     
  13. trueshanti

    trueshanti New Member

  14. till

    till Super Moderator

    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.
     
  15. trueshanti

    trueshanti New Member

    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-
     
  16. trueshanti

    trueshanti New Member

    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
     
    Last edited: May 21, 2006
  17. falko

    falko Super Moderator

    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.
     
  18. trueshanti

    trueshanti New Member

    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 ?
     
  19. falko

    falko Super Moderator

    It's 52 tables.
     
  20. trueshanti

    trueshanti New Member

    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 ?:confused:

    i have no idea since all other databases have good namings

    tnx4comment

    -c-
     

Share This Page