Announcement

Collapse
No announcement yet.

'openexchange'@'localhost' hat keine Zugriffsberechtigung

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 'openexchange'@'localhost' hat keine Zugriffsberechtigung

    Hi folks,

    i'm a new user of open xchange. I followed step by step the installation process described here:
    http://oxpedia.org/wiki/index.php?title=Open-Xchange_Installation_Guide_for_Debian_5.0

    Now, before I will begin, here some information about my system:
    I'm using a virtual server system, with a debian lenny image:

    Code:
    $ uname  -r 2.6.18-028stab068.5
    
    $ dpkg -l | grep postfix
    ii  postfix                                  2.5.5-1.1                  High-performance mail transport agent
    ii  postfix-mysql                            2.5.5-1.1                  MySQL map support for Postfix
    
    $  dpkg -l | grep dovecot
    ii  dovecot-common                           1:1.0.15-2.3+lenny1        secure mail server that supports mbox and ma
    ii  dovecot-imapd                            1:1.0.15-2.3+lenny1        secure IMAP server that supports mbox and ma
    
    $ dpkg -l | grep mysql
    ii  libdbd-mysql-perl                        4.007-1+lenny1             A Perl5 database interface to the MySQL data
    ii  libmysqlclient15off                      5.0.51a-24+lenny3          MySQL database client library
    ii  mysql-client                             5.0.51a-24+lenny3          MySQL database client (metapackage depending
    ii  mysql-client-5.0                         5.0.51a-24+lenny3          MySQL database client binaries
    ii  mysql-common                             5.0.51a-24+lenny3          MySQL database common files
    ii  mysql-server                             5.0.51a-24+lenny3          MySQL database server (metapackage depending
    ii  mysql-server-5.0                         5.0.51a-24+lenny3          MySQL database server binaries
    ii  open-xchange-genconf-mysql               6.16.1.0-3                 Stores a set of generic options in the mysql
    ii  php5-mysql                               5.2.6.dfsg.1-1+lenny8      MySQL module for php5
    ii  postfix-mysql                            2.5.5-1.1                  MySQL map support for Postfix
    
    
    $ dpkg -l | grep open-xchange
    ii  open-xchange                             6.16.1.0-3                 Open-Xchange server scripts and configuratio
    ii  open-xchange-activation                  1.1.1-25                   Bundled version of the Java Activation Frame
    ii  open-xchange-admin                       6.16.1.0-3                 Open Xchange Admin Daemon containing command
    ii  open-xchange-admin-client                6.16.1.0-3                 The Open Xchange Admin Daemon RMI client lib
    ii  open-xchange-admin-doc                   6.16.1.0-3                 Documentation for the Open Xchange RMI clien
    ii  open-xchange-admin-lib                   6.16.1.0-3                 The Open Xchange Admin Daemon Bundle client 
    ii  open-xchange-admin-plugin-hosting        6.16.1.0-3                 Open Xchange Admin Hosting Plugin
    ii  open-xchange-admin-plugin-hosting-client 6.16.1.0-3                 The Open Xchange Admin Hosting RMI client li
    ii  open-xchange-admin-plugin-hosting-doc    6.16.1.0-3                 Documentation for the Open Xchange RMI clien
    ii  open-xchange-admin-plugin-hosting-lib    6.16.1.0-3                 The Open Xchange Admin Hosting Bundle client
    ii  open-xchange-authentication-database     6.16.1.0-3                 The Open-Xchange Database Authentication
    ii  open-xchange-cache                       6.16.1.0-3                 The Open-Xchange Server Caching Bundle
    ii  open-xchange-calendar                    6.16.1.0-3                 Calendar Module
    ii  open-xchange-calendar-printing           6.16.1.0-3                 Printing calendars via templating
    ii  open-xchange-charset                     6.16.1.0-3                 charset bundle
    ii  open-xchange-common                      6.16.1.0-3                 jar files and OSGi bundles commonly used by 
    ii  open-xchange-configjump-generic          6.16.1.0-3                 The Open-Xchange generic ConfigJump
    ii  open-xchange-configjump-generic-gui      6.16.1.0-3                 The Open-Xchange generic ConfigJump GUI comp
    ii  open-xchange-configread                  6.16.1.0-3                 The Open-Xchange Server Config Bundle
    ii  open-xchange-contactcollector            6.16.1.0-3                 The contact collector collects eMail address
    ii  open-xchange-control                     6.16.1.0-3                 The Open-Xchange Server Control Bundle
    ii  open-xchange-conversion                  6.16.1.0-3                 The Open-Xchange Conversion Bundle
    ii  open-xchange-conversion-engine           6.16.1.0-3                 The Open-Xchange Conversion Engine Bundle
    ii  open-xchange-conversion-servlet          6.16.1.0-3                 The Open-Xchange Conversion Servlet
    ii  open-xchange-crypto                      6.16.1.0-3                 Provides cryptography services to bundles in
    ii  open-xchange-data-conversion-ical4j      6.16.1.0-3                 The Open-Xchange data conversion iCal4j impl
    ii  open-xchange-dataretention               6.16.1.0-3                 The Open-Xchange Server Data Retention Bundl
    ii  open-xchange-easylogin                   6.16.1.0-3                 Open-Xchange Easylogin
    ii  open-xchange-genconf                     6.16.1.0-3                 The Open-Xchange Server Generic Configuratio
    ii  open-xchange-genconf-mysql               6.16.1.0-3                 Stores a set of generic options in the mysql
    ii  open-xchange-global                      6.16.1.0-3                 global bundle
    ii  open-xchange-group-managerequest         6.16.1.0-3                 The Open-Xchange Server Group Management Req
    ii  open-xchange-gui                         6.16.1.0-3                 Package containing the AJAX gui
    ii  open-xchange-gui-themes-default          6.16.1.0-3                 Package containing the default themes
    ii  open-xchange-gui-wizard-plugin           6.16.1.0-3                 Open-Xchange GUI Wizard Server Plug-In.
    ii  open-xchange-gui-wizard-plugin-gui       6.16.1.0-3                 Open-Xchange GUI Wizard Plug-In.
    ii  open-xchange-i18n                        6.16.1.0-3                 The Open-Xchange i18n Bundle
    ii  open-xchange-imap                        6.16.1.0-3                 The Open-Xchange Server IMAP Bundle
    ii  open-xchange-jcharset                    1.3.0-63                   jcharset bundle
    ii  open-xchange-mailfilter                  6.16.1.0-3                 Open Xchange Mailfilter Plugin
    ii  open-xchange-management                  6.16.1.0-3                 The Open-Xchange Management Bundle
    ii  open-xchange-messaging                   6.16.1.0-3                 The Open-Xchange Messaging Bundle
    ii  open-xchange-monitoring                  6.16.1.0-3                 The Open-Xchange Monitoring Bundle
    ii  open-xchange-online-help-de              6.16.1.0-3                 Package containing german OX online help
    ii  open-xchange-online-help-en              6.16.1.0-3                 Package containing english OX online help
    ii  open-xchange-online-help-fr              6.16.1.0-3                 Package containing french OX online help
    ii  open-xchange-passwordchange-database     6.16.1.0-3                 The Open-Xchange Password Change Database Bu
    ii  open-xchange-passwordchange-servlet      6.16.1.0-3                 The Open-Xchange Password Change Servlet
    ii  open-xchange-pop3                        6.16.1.0-3                 The Open-Xchange Server POP3 Bundle
    ii  open-xchange-publish                     6.16.1.0-3                 Interfaces defining the OX publication API
    ii  open-xchange-publish-basic               6.16.1.0-3                 Basic OSGi based implementation of the publi
    ii  open-xchange-publish-infostore-online    6.16.1.0-3                 Publishes a single infostore document extern
    ii  open-xchange-publish-json                6.16.1.0-3                 HTTP-API Interface implementation for public
    ii  open-xchange-publish-microformats        6.16.1.0-3                 Publishes a set of objects in OXMF externall
    ii  open-xchange-push                        6.16.1.0-3                 The Open-Xchange Push Bundle
    ii  open-xchange-push-udp                    6.16.1.0-3                 The Open-Xchange Server Push UDP Bundle
    ii  open-xchange-report-client               6.16.1.0-3                 Open-Xchange reporting client.
    ii  open-xchange-resource-managerequest      6.16.1.0-3                 The Open-Xchange Server Resource Manage Requ
    ii  open-xchange-server                      6.16.1.0-3                 The Open-Xchange Server Bundle
    ii  open-xchange-sessiond                    6.16.1.0-3                 The Open-Xchange Server Session Daemon
    ii  open-xchange-settings-extensions         6.16.1.0-3                 The Open-Xchange Settings Extensions
    ii  open-xchange-smtp                        6.16.1.0-3                 The Open-Xchange Server SMTP Bundle
    ii  open-xchange-spamhandler-default         6.16.1.0-3                 The Open-Xchange Default Spam Handler
    ii  open-xchange-sql                         6.16.1.0-3                 SQL Builder API
    ii  open-xchange-subscribe                   6.16.1.0-3                 Basic OSGi based implementation of the subsc
    ii  open-xchange-subscribe-crawler           6.16.1.0-3                 Subscribe Crawler feeds
    ii  open-xchange-subscribe-json              6.16.1.0-3                 HTTP-API Interface implementation for subscr
    ii  open-xchange-subscribe-microformats      6.16.1.0-3                 Subscribe Microformat feeds
    ii  open-xchange-templating                  6.16.1.0-3                 Provides access to the templating subsystem
    ii  open-xchange-themes-default              6.16.1.0-3                 Package containing the default themes
    ii  open-xchange-threadpool                  6.16.1.0-3                 The Open-Xchange Thread Pool Bundle
    ii  open-xchange-unifiedinbox                6.16.1.0-3                 The Open-Xchange Server Unified INBOX Bundle
    ii  open-xchange-user-json                   6.16.1.0-3                 The Open-Xchange user JSON interface bundle
    ii  open-xchange-xerces-sun                  6.16.1.0-3                 Xerces Compat for Sun Java
    ii  open-xchange-xml                         6.16.1.0-3                 XML Services
    The root database user don't have a password, like described in the howto.

    Step-by-Step Description here:

    Code:
    $ /opt/open-xchange/sbin/initconfigdb --configdb-pass=ahBdKs -a
    
    $ /opt/open-xchange/sbin/oxinstaller --no-license --servername=oxserver --configdb-pass=ahBdKs --master-pass=uKsoW --ajp-bind-port=localhost
    
    $ /etc/init.d/open-xchange-admin start
    
    $ /opt/open-xchange/sbin/registerserver -n oxserver -A oxadminmaster -P uKsoW
    
    $ /opt/open-xchange/sbin/registerfilestore -A oxadminmaster -P uKsoW -t file:/var/opt/ox_datei_ablage
    
    $ /opt/open-xchange/sbin/registerdatabase -A oxadminmaster -P uKsoW -n oxdatabase -p pIkdN -m true
    
    $ /etc/init.d/open-xchange-groupware start
    
    $ /opt/open-xchange/sbin/createcontext -A oxadminmaster -P uKsoW -c 1 -u oxadmin -d "Context Admin" -g Admin -s User -p mNweSx -L defaultcontext -e oxadmin@help.ch -q 1024 --access-combination-name=all
    This ends at console in:

    Code:
    context 1 could not be created: 
    Server response:
     Error unmarshaling return; nested exception is: 
    	java.lang.ClassNotFoundException: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException (no security manager: RMI class loader disabled)
    Code:
    $ tail -f /var/log/open-xchange/open-xchange-admin.log.0
    Caused by: java.sql.SQLException: Benutzer 'openexchange'@'localhost' hat keine Zugriffsberechtigung (verwendetes Passwort: Ja)
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:910)
    	at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3923)
    	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1273)
    	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2181)
    	... 33 more
    Now I need help - At the moment I'm at this position.

    Thank you for your help!

    greets,
    Adrian Badertscher

  • #2
    Hi Adrian,

    please check what Java Version is running on that machine "java -version".

    Thanks

    Comment


    • #3
      Hi Martin,

      the following version is on my Debian Lenny:
      http://packages.debian.org/lenny/sun-java6-jre

      Thank you for your support!

      greets,
      Adrian Badertscher

      Originally posted by Martin Braun View Post
      Hi Adrian,

      please check what Java Version is running on that machine "java -version".

      Thanks

      Comment


      • #4
        The error messages tells, that the user "openexchange" cannot connect to the database. Those values are set when calling initconfigdb. If i'm not mistaken, you need to set "ahBdKs" as -p when calling registerdatabase.

        Greetings

        Comment


        • #5
          Hi Martin,

          Thanks again.
          You mean, that I need to insert the configDB password, for registring the Database?

          But in the wiki is something like this:

          http://oxpedia.org/wiki/index.php?title=Open-Xchange_Installation_Guide_for_Debian_5.0
          Code:
          $ /opt/open-xchange/sbin/initconfigdb --configdb-pass=db_password -a
          $ /opt/open-xchange/sbin/registerserver -n oxserver -A oxadminmaster -P admin_master_password
          I've made it like:

          Code:
          $ /opt/open-xchange/sbin/initconfigdb --configdb-pass=ahBdKs -a
          $ /opt/open-xchange/sbin/registerserver -n oxserver -A oxadminmaster -P uKsoW
          Greets,
          Adrian Badertscher

          Comment


          • #6
            I mean register*database* where the wiki says:
            Code:
            $ /opt/open-xchange/sbin/initconfigdb --configdb-pass=[B]db_password[/B] -a
            $ /opt/open-xchange/sbin/registerdatabase -A oxadminmaster -P admin_master_password -n oxdatabase -p [B]db_password[/B] -m true
            You did:
            Code:
            $ /opt/open-xchange/sbin/initconfigdb --configdb-pass=[B]ahBdKs[/B] -a
            $ /opt/open-xchange/sbin/registerdatabase -A oxadminmaster -P uKsoW -n oxdatabase -p [B]pIkdN[/B] -m true
            The lowercase -p defines the password used to access the databases through user "openexchange".

            Greetings

            Comment


            • #7
              Das scheint mir genau derselbe Fehler wie im Thread Cannot get connection to config DB.

              Comment


              • #8
                Originally posted by Martin Braun View Post
                I mean register*database* where the wiki says:
                Code:
                $ /opt/open-xchange/sbin/initconfigdb --configdb-pass=[B]db_password[/B] -a
                $ /opt/open-xchange/sbin/registerdatabase -A oxadminmaster -P admin_master_password -n oxdatabase -p [B]db_password[/B] -m true
                You did:
                Code:
                $ /opt/open-xchange/sbin/initconfigdb --configdb-pass=[B]ahBdKs[/B] -a
                $ /opt/open-xchange/sbin/registerdatabase -A oxadminmaster -P uKsoW -n oxdatabase -p [B]pIkdN[/B] -m true
                The lowercase -p defines the password used to access the databases through user "openexchange".

                Greetings
                Guten Morgen Martin,

                jetzt sehe ich das Problem. Du sprichst gar nicht von registerserver, sondern von registerdatabase... Bei registerdatabase müsste man das configdb Passwort eingeben - Dabei habe ich ein eigenes Passwort mit gegeben, da ich davon ausging dass ein weiterer Benutzer angelegt wird.

                Vielen herzlichen Dank für den Support!

                Gruss,
                Adrian Badertscher

                Comment

                Working...
                X