Hello,
i'm (trying to) use hyperion and had a couple of quirks. Situation is
as follows:
mysql server: 10.200.2.10 (backend) (reference are set to the names in
the config files)
open-xchange install: 10.200.2.13 (office) (reference are set to the
names in the config files)
oxinstaller breaks at:
First the mysql auth stuff (which works fine imho)
the grants for mysql:
Now here is what happens when I execute the oxinstaller script:
The interesting line is imho:
because when the install script then does:
here it get's the info that the mysql server is on localhost where it
of course won't find anything listening. Manual change of said column
doesn't help as this is of course recreated on every run. grepping
around didn't lead me to where the localhost mysql url is inserted so
that I can change it. So i'm stuck here....
How do i tell the install script that i _don't_ want localhost but
backend as the `url` in `db_pool`?
i'm (trying to) use hyperion and had a couple of quirks. Situation is
as follows:
mysql server: 10.200.2.10 (backend) (reference are set to the names in
the config files)
open-xchange install: 10.200.2.13 (office) (reference are set to the
names in the config files)
oxinstaller breaks at:
Code:
initializing database (step 2/2) Server response: java.sql.SQLException: Server connection failure during transaction. Due to underlying exception: 'java.net.SocketException: java.lang.reflect.InvocationTargetException'. ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: java.lang.reflect.InvocationTargetException
Code:
$ mysql -u root -h [URL="http://10.200.2.10/"]10.200.2.10[/URL] Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 88 Server version: 5.0.32-Debian_7etch1-log Debian etch distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> Bye $ mysql -u openxchange -h [URL="http://10.200.2.13/"]10.200.2.13[/URL] ERROR 2003 (HY000): Can't connect to MySQL server on '[URL="http://10.200.2.13/"]10.200.2.13[/URL]' (111) $ mysql -u openxchange -h backend ERROR 1045 (28000): Access denied for user 'openxchange'@'[URL="http://office.openforce.com/"]office.openforce.com[/URL]' (using password: NO) $ mysql -u openxchange -h backend -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 89 Server version: 5.0.32-Debian_7etch1-log Debian etch distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> Bye
Code:
$ mysql -u root -h backend -e "show grants for 'openxchange'@'office'" +----------------------------------------------------------------------------------------------------------------------------------------------------------+ | Grants for openxchange@office | +----------------------------------------------------------------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'openxchange'@'office' IDENTIFIED BY PASSWORD '*xxxxx' WITH GRANT OPTION | +----------------------------------------------------------------------------------------------------------------------------------------------------------+
The interesting line is imho:
Code:
133 98 Query INSERT INTO db_pool VALUES (4,'jdbc:mysql://localhost/?useUnicode=true&characterEnc oding=UTF-8&autoReconnect=true&useUnicode=true&useServerPrepStmts=false&useTimezone=true&serverTimezone=UTC&connectTime out=15000&socketTimeout=15000','com.mysql.jdbc.Driver','openexchange','xxx')
Code:
140 98 Query SELECT url,driver,login,password,name,db_pool_id FROM db_pool where name = 'open-xc hange-db' LIMIT 1
of course won't find anything listening. Manual change of said column
doesn't help as this is of course recreated on every run. grepping
around didn't lead me to where the localhost mysql url is inserted so
that I can change it. So i'm stuck here....
How do i tell the install script that i _don't_ want localhost but
backend as the `url` in `db_pool`?
Comment