After hostname change: DBP-0019

[thomasjohansen]

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:

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:

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?

[thomasjohansen]

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?

[thomasjohansen]

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?

[Martin Heiland]

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

[thomasjohansen]

I have allready set server to mail in system.properties


When trying to create context it says:

/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:

/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

[Martin Heiland]

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

Thanks

[thomasjohansen]

Here it is:

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

[Martin Heiland]

Okay, please check whats the database status.

mysql> select * from configdb.context_server2db_pool;

or use listcontextsbydatabase to find out whats wrong here

[thomasjohansen]

listcontextsbydatabase:

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.

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'

[thomasjohansen]

I figured out how to connect to mysql

 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)

[thomasjohansen]

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

how to do this? the mysql way?

[thomasjohansen]

Wiiiiii, i fixed it...


solution to sql:

UPDATE configdb.context_server2db_pool SET server_id = replace( server_id, '2', '8' ) ;

Then i could fix the rest with Peters admin GUI