Announcement

Collapse
No announcement yet.

After hostname change: DBP-0019

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

  • After hostname change: DBP-0019

    Hi, I have changes the hostname on my ubuntuserver, and likewise changed it in system.properties.

    It all worked perfectly.

    But now I wanted to create another user, and it said:

    Code:
    user in context 1 could not be created: 
    Server response:
     com.openexchange.admin.rmi.exceptions.PoolException: DBP-0019 Category=10 Message=Cannot resolve server id for server local. exceptionID=1340734165-4

    I then tried the command "listserver"

    it says:
    Code:
    Id Name    
     8 mail    
     2 oxserver

    where ID 8 mail is the new hostname and ID 2 oxserver is the old.


    Can I change id 2 to be mail? or is it something else that should be fixed?

  • #2
    Just installed Peter's admin Gui... wow looks promising.

    But... I then figured out, that it cant "Set the context".


    Then I tried to create new context at "1" but said
    "context c 1 already exists".

    Can I set the context somewhere manually?

    Comment


    • #3
      How do i change name of server id

      I have two server id's

      2=oxserver
      8=mail

      right now context 1 is linked to server id 2, but the server is now called mail which is id 8.

      Can i rename id 2 to mail?

      Comment


      • #4
        Hi,

        Contexts cannot be linked to server IDs. Server IDs describe a ox server or a cluster of servers that work together as an entity.

        You can change the server ID at the system.properties file of the groupware and admindaemon.

        Greetings

        Comment


        • #5
          I have allready set server to mail in system.properties


          When trying to create context it says:

          Code:
          /opt/open-xchange/sbin/createcontext -A oxadminmaster -P admin_master_password -c 1 -u oxadmin -d "Context Admin" -g Admin -s User -p admin_password -L defaultcontext -e oxadmin@example.com -q 1024 --access-combination-name=all
          context 1 could not be created: 
          Server response:
           Context already exists!

          When trying to create a user:

          Code:
          /opt/open-xchange/sbin/createuser -c 1 -A oxadmin -P admin_password -u user1 -d "Name namesen" -g Test -s User -p user1pass -e nn@namesen.dk --imaplogin nn@namesen.dk --imapserver 10.192.90.49:143 --smtpserver 10.192.90.49:25
          user in context 1 could not be created: 
          Server response:
           com.openexchange.admin.rmi.exceptions.PoolException: DBP-0002 Category=8 Message=Resolving database for context 1 and server 8 not possible! exceptionID=318493805-2

          Comment


          • #6
            The issue seems to be that no database is assigned. Can you please post the output of "listdatabase"?

            Thanks

            Comment


            • #7
              Here it is:

              Code:
              listdatabase -A oxadminmaster -P admin_master_password
              id name       hostname  master mid weight maxctx curctx hlimit max inital
               4 oxdatabase localhost true     0    100   1000      1 false  100      2

              Comment


              • #8
                Okay, please check whats the database status.

                mysql> select * from configdb.context_server2db_pool;

                or use listcontextsbydatabase to find out whats wrong here
                Last edited by Martin Heiland; 11-27-2009, 11:57 AM.

                Comment


                • #9
                  listcontextsbydatabase:

                  Code:
                  listcontextsbydatabase -n oxdatabase -A oxadminmaster -P admin_master_password
                  contexts for database oxdatabase could not be listed: 
                  Server response:
                   com.openexchange.admin.rmi.exceptions.PoolException: DBP-0002 Category=8 Message=Resolving database for context 1 and server 8 not possible! exceptionID=885869893-3

                  dont know how to connect through mysql.

                  Code:
                  mysql
                  Welcome to the MySQL monitor.  Commands end with ; or \g.
                  Your MySQL connection id is 12
                  Server version: 5.0.51a-3ubuntu5.4 (Ubuntu)
                  
                  Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
                  
                  mysql> select * from configdb.context_server2db_pool;
                  ERROR 1142 (42000): SELECT command denied to user ''@'localhost' for table 'context_server2db_pool'

                  Comment


                  • #10
                    I figured out how to connect to mysql

                    Code:
                     select * from configdb.context_server2db_pool;
                    +-----------+-----+-----------------+------------------+--------------+
                    | server_id | cid | read_db_pool_id | write_db_pool_id | db_schema    |
                    +-----------+-----+-----------------+------------------+--------------+
                    |         2 |   1 |               4 |                4 | oxdatabase_7 | 
                    +-----------+-----+-----------------+------------------+--------------+
                    1 row in set (0.01 sec)

                    Comment


                    • #11
                      My guess is that server id should be changed to 8 am I correct?

                      how to do this? the mysql way?

                      Comment


                      • #12
                        Wiiiiii, i fixed it...


                        solution to sql:

                        Code:
                        UPDATE configdb.context_server2db_pool SET server_id = replace( server_id, '2', '8' ) ;
                        Then i could fix the rest with Peters admin GUI

                        Comment

                        Working...
                        X