ispCP - Board - Support
[ERLEDIGT] Can't create database 'test' (errno: 13) - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega International Area (/forum-22.html)
+--- Forum: German Corner (/forum-26.html)
+--- Thread: [ERLEDIGT] Can't create database 'test' (errno: 13) (/thread-1716.html)

Pages: 1 2

[ERLEDIGT] Can't create database 'test' (errno: 13) - Snatch - 11-04-2007 05:17 PM

Hallo,

habe einen zweiten User angelegt,
Wenn ich mit diesem user eine DB anlegen möchte bekomme
ich diesen Fehler
Code:
Can't create database 'test' (errno: 13)

User1 kann jedoch DBs anlegen.

Im AdminPannel sehe ich das
Code:
SQL users      0 / 2
Also sollten doch beide User angelegt sein.

Gruß
Snatch

RE: Can't create database 'test' (errno: 13) - gOOvER - 11-04-2007 06:53 PM

Wie nun?? Welchen user hast Du angelegt und welchen willst Du benutzen???

SQL users 0 / 2 <- Das heißt ja, das noch keine angelegt wurden Wink

RE: Can't create database 'test' (errno: 13) - jmeyerdo - 11-04-2007 06:57 PM

Hi!

Snatch Wrote:Wenn ich mit diesem user eine DB anlegen möchte bekomme
ich diesem Fehler
Code:
Can't create database 'test' (errno: 13)

Hast Du mal einen anderen Datenbank-Namen probiert? Wenn ich es richtig sehe, ist die Datenbank "test" standardmäßig bei mysql mit angelegt.

VG, Jens

RE: Can't create database 'test' (errno: 13) - gOOvER - 11-04-2007 08:09 PM

jmeyerdo Wrote:Hast Du mal einen anderen Datenbank-Namen probiert? Wenn ich es richtig sehe, ist die Datenbank "test" standardmäßig bei mysql mit angelegt.

Das könnte auch sein. Wenn Du "test" vorher nicht per PMA gelöscht hast, kannst Die DB nicht anlegen...... Smile


mfg

Torsten

RE: Can't create database 'test' (errno: 13) - Snatch - 11-04-2007 08:21 PM

Also,

User 1:
celebritymarkt.net
Hat eine DB namens celebritymarkt und diese läuft unter dem user dem DB-user Boss und kann ohne Probleme angelegt werden. Ist auch in Verwendung.

Danach wurde User2 angelegt im Reseller Menü

User 2:
celebritymarkt.org
will eine DB (name egal, geht bei allen Namen nicht)
Kann keine DB anlegen (Fehler siehe oben)

Des weiteren kann User1 auch keine weiteren DBs mehr anlegen.
Nur die eine die er bereits vorher angelegt hatte läuft.
Namen sind egal, nichts geht. Immer gleicher Fehler.

Quote:Wie nun?? Welchen user hast Du angelegt und welchen willst Du benutzen???

SQL users 0 / 2 <- Das heißt ja, das noch keine angelegt wurden
Kann ja dann auch nicht stimmen, weil user1 ja ne DB hat und diese auch verwendet.
Das Forum läuft ja drauf.

RE: Can't create database 'test' (errno: 13) - bb21 - 11-04-2007 08:23 PM

was sagt die mysql log?

RE: Can't create database 'test' (errno: 13) - Snatch - 11-04-2007 08:32 PM

Hier der Vorgang des Anlagens bist zum Fehler aus der mysql.log

Code:
071104 11:30:15          9 Connect     root@localhost on
              9 Init DB     ispcp
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'encoding'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'We are sorry, but the system is currently under maintenance.\nPlease try again later.'
              9 Query       select
            lang, layout
        from
            user_gui_props
        where
            user_id = '3'
              9 Query       SELECT
        name, value
    FROM
        config
              9 Query       DELETE FROM login WHERE lastaccess < 1194170415
              9 Query       SELECT session_id FROM login WHERE session_id='O3LOQ1zx5W7Y3pdTgz914E5bwg7'
              9 Query       select
            *
        from
            admin, login
        where
                admin.admin_name = 'celebritymarkt.net'
            and
                admin.admin_pass = '11e41c111bd6468812ac65b316830fd6'
            and
                admin.admin_type = 'user'
            and
                admin.admin_id = '3'
            and
                login.session_id = 'O3LOQ1zx5W7Y3pdTgz914E5bwg7'
              9 Query       update
            login
        set
            lastaccess = 1194172215
        where
            session_id = 'O3LOQ1zx5W7Y3pdTgz914E5bwg7'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'ispCP - Client/Add SQL Database'
              9 Query       SELECT
            admin_id, created_by, admin_type
        FROM
            admin
        WHERE
            admin_id = '3'
              9 Query       SELECT
            logo
        FROM
            user_gui_props
        WHERE
            user_id= '2'
              9 Query       select
            domain_id,
            domain_name,
            domain_gid,
            domain_uid,
            domain_created_id,
            domain_created,
            domain_last_modified,
            domain_mailacc_limit,
            domain_ftpacc_limit,
            domain_traffic_limit,
            domain_sqld_limit,
            domain_sqlu_limit,
            domain_status,
            domain_alias_limit,
            domain_subd_limit,
            domain_ip_id,
            domain_disk_limit,
            domain_disk_usage,
            domain_php,
            domain_cgi
        from
            domain
        where
            domain_admin_id = '3'
              9 Query       select
            count(sqld_id) as cnt
        from
            sql_database
        where
            domain_id = '1'
              9 Query       select distinct
            t1.sqlu_name
        from
            sql_user as t1, sql_database as t2
        where
            t2.domain_id = '1'
          and
            t2.sqld_id = t1.sqld_id
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'General information'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Change password'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Change personal data'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Manage domains'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Add subdomain'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Email and FTP accounts'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Add mail user'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Add FTP user'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Manage SQL'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Error pages'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Add SQL database'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Domain statistics'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Daily backup'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Support system'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'New ticket'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Logout'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'PhpMyAdmin'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Webmail'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Filemanager'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Webtools'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Protected areas'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Web statistics'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Group/User management'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Overview'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Email Accounts'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'FTP Accounts'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Language'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Catch all'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Add alias'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Update Hosting Package'
              9 Query       select
            *
        from
            custom_menus
        where
            menu_level = 'user'
          or
            menu_level = 'all'
              9 Query       select
            domain_id,
            domain_name,
            domain_gid,
            domain_uid,
            domain_created_id,
            domain_created,
            domain_last_modified,
            domain_mailacc_limit,
            domain_ftpacc_limit,
            domain_traffic_limit,
            domain_sqld_limit,
            domain_sqlu_limit,
            domain_status,
            domain_alias_limit,
            domain_subd_limit,
            domain_ip_id,
            domain_disk_limit,
            domain_disk_usage,
            domain_php,
            domain_cgi
        from
            domain
        where
            domain_admin_id = '3'
              9 Query       select
            *
        from
            custom_menus
        where
            menu_level = 'user'
          or
            menu_level = 'all'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Database name'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Use numeric ID'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Before the name'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'After the name'
              9 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Add'
              9 Quit      
071104 11:30:18         10 Connect     root@localhost on
             10 Init DB     ispcp
             10 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'encoding'
             10 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'We are sorry, but the system is currently under maintenance.\nPlease try again later.'
             10 Query       select
            lang, layout
        from
            user_gui_props
        where
            user_id = '3'
             10 Query       SELECT
        name, value
    FROM
        config
             10 Query       DELETE FROM login WHERE lastaccess < 1194170418
             10 Query       SELECT session_id FROM login WHERE session_id='O3LOQ1zx5W7Y3pdTgz914E5bwg7'
             10 Query       select
            *
        from
            admin, login
        where
                admin.admin_name = 'celebritymarkt.net'
            and
                admin.admin_pass = '11e41c111bd6468812ac65b316830fd6'
            and
                admin.admin_type = 'user'
            and
                admin.admin_id = '3'
            and
                login.session_id = 'O3LOQ1zx5W7Y3pdTgz914E5bwg7'
             10 Query       update
            login
        set
            lastaccess = 1194172218
        where
            session_id = 'O3LOQ1zx5W7Y3pdTgz914E5bwg7'
             10 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'ispCP - Client/Add SQL Database'
             10 Query       SELECT
            admin_id, created_by, admin_type
        FROM
            admin
        WHERE
            admin_id = '3'
             10 Query       SELECT
            logo
        FROM
            user_gui_props
        WHERE
            user_id= '2'
             10 Query       select
            domain_id,
            domain_name,
            domain_gid,
            domain_uid,
            domain_created_id,
            domain_created,
            domain_last_modified,
            domain_mailacc_limit,
            domain_ftpacc_limit,
            domain_traffic_limit,
            domain_sqld_limit,
            domain_sqlu_limit,
            domain_status,
            domain_alias_limit,
            domain_subd_limit,
            domain_ip_id,
            domain_disk_limit,
            domain_disk_usage,
            domain_php,
            domain_cgi
        from
            domain
        where
            domain_admin_id = '3'
             10 Query       select
            count(sqld_id) as cnt
        from
            sql_database
        where
            domain_id = '1'
             10 Query       select distinct
            t1.sqlu_name
        from
            sql_user as t1, sql_database as t2
        where
            t2.domain_id = '1'
          and
            t2.sqld_id = t1.sqld_id
             10 Query       select
            domain_id
        from
            domain
        where
            domain_admin_id = '3'
             10 Query       show databases
             10 Query       create database `rbtrbtr`
             10 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'ispCP Error'
             10 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Back'
             10 Query       SELECT `msgstr` FROM `lang_English` WHERE `msgid` = 'Error Message'
             10 Quit


RE: Can't create database 'test' (errno: 13) - Snatch - 11-04-2007 08:37 PM

Wichtig:

wenn ich mit mit User1 der ja ne DB hat aber nun auch keine
mehr anlegen kann in PHPMyAdmin einloge,
Code:
Neue Datenbank anlegen: Dokumentation
Keine Rechte

Das gleiche beim user PMA, der ja bei der Installation eingerichtet wurde.

Nur der user root hat alle Rechte.

Komisch, denn beim ersten User ging noch alles.
Eine DB konnte ja angelegt werden.

RE: Can't create database 'test' (errno: 13) - Snatch - 11-04-2007 08:55 PM

So, Fehler gefunden.

Ich habe die /var/lib/mysql aus Performance Gründen
auf die 2te HDD gemountet. Dabei wurde das
Verzeichniss also root:root genommen.
Sollte aber user mysql:mysql haben.

Geht also wieder.

SQL databases 2 / 4 of unlimited

Gruß
Snatch

Gruß
Snatch

RE: Can't create database 'test' (errno: 13) - BeNe - 11-04-2007 09:18 PM

Gut, dann mache ich hier zu.

[Image: 77.png]

Greez BeNe