Installation on SUSE 11.0 / Database Problems

[genius777]

Hello @ll,

I got a problem when setting up ox. I checked /opt/open-xchange/etc/groupware/configdb.properties and /opt/open-xchange/etc/admindaemon/configdb.properties but the login data for the database is set properly. For some reason the createcontext script doesn't use the database 'configdb' but 'configdb_#' instead.. (I also tried with other database names but it's the same, trying to access databasename_1, databasename_2 then..)

Anyone got a clue what might cause this error? Does the createcontext script access the database in another way than the other scripts do?

THANKS IN ADVANCE for any hint!

myHostName:~ # /opt/open-xchange/sbin/oxinstaller --servername=oxserver --configdb-pass=DB_PASSWORD --configdb-user=openexchange --master-pass=admin_master_password
setting up groupware configuration /opt/open-xchange/etc/groupware
..................................................
groupware daemon must now be restarted if already running
setting up admin daemon configuration /opt/open-xchange/etc/admindaemon
......................
*** RMI authentication is enabled
using oxadminmaster as master account
admin daemon must now be restarted if already running
myHostName:~ # /etc/init.d/open-xchange-admin restart
Shutting down open-xchange-admin daemon                               done
Starting open-xchange-admin daemon                                    done
myHostName:~ # /opt/open-xchange/sbin/registerserver -n oxserver -A oxadminmaster -P admin_master_password
server 2 registered
myHostName:~ # /opt/open-xchange/sbin/registerfilestore -A oxadminmaster -P admin_master_password -t file:///var/opt/filestore
filestore 3 registered
myHostName:~ # /opt/open-xchange/sbin/registerdatabase -A oxadminmaster -P admin_master_password -n configdb -p DB_PASSWORD -m true 
database 4 registered
myHostName:~ # /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 my@email.com -q 1024 --access-combination-name=all
context 1 could not be created: 
Server response:
 java.sql.BatchUpdateException: Access denied for user 'openexchange'@'localhost' to database 'configdb_6'
myHostName:~ # /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 my@email.com -q 1024 --access-combination-name=all
context 1 could not be created: 
Server response:
 java.sql.BatchUpdateException: Access denied for user 'openexchange'@'localhost' to database 'configdb_7'
myHostName:~ #

and so on... the number keeps incrementing (why?)

EDIT: I also added in mysql

 GRANT ALL PRIVILEGES ON `configdb`.* TO 'openexchange'@'localhost' WITH GRANT OPTION

to be sure there are sufficient rights.. but it didn't help...

[genius777]

sorry for opening this thread... I just had to give more privileges to openexchange mysql user

GRANT ALL PRIVILEGES ON *.* TO 'openexchange'@'localhost' IDENTIFIED BY PASSWORD '*9CF8CC5E681E7769530622A5A175C3070E657058' WITH GRANT OPTION

I just hope I may revoke them later again...

[Martin Heiland]

Hi,

sure you can change MySQL user permissions every time.