Results 1 to 6 of 6

Thread: [SOLVED] java.sql.SQLException

  1. #1
    kevint is offline Member
    Join Date
    May 2008
    Posts
    14
    Rep Power
    7

    Default [SOLVED] java.sql.SQLException

    I created an account on web interface and I can't delete it, view his email ( because of freeze's loading page).


    Reason :

    2008-05-23 11:52:36,949 INFO [LmtpServer-1276] [ip=10.1.60.203;] mailbox - Recoverable exception getting mailbox for xxxxxx@xxxxxx
    com.zimbra.common.service.ServiceException: system failure: createMailboxDatabase(24)
    ExceptionId:LmtpServer-1276:1211536356948:2c7a26cffae713c9
    Code:service.FAILURE
    at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:253)
    at com.zimbra.cs.db.DbMailbox.createMailboxDatabase(D bMailbox.java:227)
    at com.zimbra.cs.db.DbMailbox.createMailbox(DbMailbox .java:135)
    at com.zimbra.cs.mailbox.MailboxManager.createMailbox (MailboxManager.java:669)
    at com.zimbra.cs.mailbox.MailboxManager.getMailboxByA ccountId(MailboxManager.java:290)
    at com.zimbra.cs.mailbox.MailboxManager.getMailboxByA ccountId(MailboxManager.java:226)
    at com.zimbra.cs.mailbox.MailboxManager.getMailboxByA ccount(MailboxManager.java:211)
    at com.zimbra.cs.lmtpserver.ZimbraLmtpBackend.deliver MessageToLocalMailboxes(ZimbraLmtpBackend.java:271 )
    at com.zimbra.cs.lmtpserver.ZimbraLmtpBackend.deliver (ZimbraLmtpBackend.java:136)
    at com.zimbra.cs.lmtpserver.LmtpHandler.processMessag eData(LmtpHandler.java:375)
    at com.zimbra.cs.lmtpserver.TcpLmtpHandler.continueDA TA(TcpLmtpHandler.java:67)
    at com.zimbra.cs.lmtpserver.LmtpHandler.doDATA(LmtpHa ndler.java:364)
    at com.zimbra.cs.lmtpserver.LmtpHandler.processComman d(LmtpHandler.java:174)
    at com.zimbra.cs.lmtpserver.TcpLmtpHandler.processCom mand(TcpLmtpHandler.java:61)
    at com.zimbra.cs.tcpserver.ProtocolHandler.processCon nection(ProtocolHandler.java:160)
    at com.zimbra.cs.tcpserver.ProtocolHandler.run(Protoc olHandler.java:128)
    at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Wo rker.run(Unknown Source)
    at java.lang.Thread.run(Thread.java:619)
    Caused by: java.sql.SQLException: Can't create database 'mboxgroup24' (errno: 13)



    Is there an issue ?

    Thx.

  2. #2
    bonadio is offline Loyal Member
    Join Date
    Oct 2007
    Location
    Brazil
    Posts
    88
    Rep Power
    7

    Default

    This error looks like that the user could not be created, or at least his database
    Did you change any permission on zimbra's mysql user?

  3. #3
    dkarp is offline Zimbra Employee
    Join Date
    Aug 2005
    Posts
    1,433
    Rep Power
    11

    Default

    There may be a permissions issue or a disk space issue. If zmfixperms.pl is available in your distribution, try shutting down Zimbra and running it.
    Bugzilla - Wiki - Downloads - Before posting... Search!

  4. #4
    kevint is offline Member
    Join Date
    May 2008
    Posts
    14
    Rep Power
    7

    Default

    Ok, i'm gonna try zmfixperms.pl.

    Thx.

    I have some errors with this script :

    Operation not permitted or Permission denied

    Any idea ?
    Last edited by kevint; 05-25-2008 at 11:59 PM.

  5. #5
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,485
    Rep Power
    56

    Default

    Quote Originally Posted by kevint View Post
    I have some errors with this script :

    Operation not permitted or Permission denied
    Run it as root:

    Code:
    chown -R zimbra:zimbra /opt/zimbra
    /opt/zimbra/libexec/zmfixperms --verbose --extended
    The --extended option may take a while as it does the store,index,backup directories as well.
    Last edited by phoenix; 05-26-2008 at 12:34 AM.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  6. #6
    kevint is offline Member
    Join Date
    May 2008
    Posts
    14
    Rep Power
    7

    Default

    Ok I run it as root but now I have the problem :

    Host zimbra.odb.fr
    Starting ldap...Done.
    FAILED
    cp: accessing `/opt/zimbra/openldap-data/DB_CONFIG': Permission denied
    Failed to start slapd. Attempting debug start to determine error.
    backend_startup_one: bi_db_open failed! (-1)

    ls -al /opt/zimbradata/
    ...
    drwxr-x--- 4 root root 4096 May 26 01:15 openldap-data
    ...
    And all files in openldap-data are owned by zimbra:zimbra

    In fact, my important directory(with this sub-directories : backup conf db index log logger openldap-data postfix redolog store)
    are link in other directy name zimbradata which are in netapp.

    How can I resolve this problem of LDAP ?
    It is very important and urgent ?

    Thx.


    EDIT : zmfixperms allow me to remove user in web interface so it works even if this script destroy my zimbra permissions.
    chown -R zimbra:zimbra /opt/zimbradata/openldap-data resolve the problem

    Thx all
    Last edited by kevint; 05-26-2008 at 01:30 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. zmmailboxdctl is stopped frequently..
    By tamilnandhu in forum Installation
    Replies: 13
    Last Post: 04-12-2008, 08:59 AM
  2. Tomcat broken after upgrade to 4
    By dotslashroot in forum Migration
    Replies: 13
    Last Post: 01-31-2007, 06:05 PM
  3. Seeming variety of problems on suse-9.1
    By Crexis in forum Installation
    Replies: 52
    Last Post: 03-04-2006, 12:19 AM
  4. Mailbox not starting on Fedora Core 3
    By Dijital in forum Installation
    Replies: 12
    Last Post: 09-21-2005, 11:28 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •