MySQL running on another host - installation failure

[AdamLis]

Hi!

Version: today’s trunk (2007-01-15).

In my header.inc.php there is section:

    /* eGroupWare domain-specific db settings */
    $GLOBALS['egw_domain']['egw_trunk_1501'] = array(
            'db_host' => '192.168.2.33',
            'db_port' => '3306',
            'db_name' => 'egw_trunk_1501',
            'db_user' => 'egw_trunk_1501',
            'db_pass' => 'egw_trunk_1501',
            // Look at the README file
            'db_type' => 'mysql',
            // This will limit who is allowed to make configuration modifications
            'config_user'   => 'admin',
            'config_passwd' => '21232f297a57a5a743894a0e4a801fc3'
    );

Webserver is running on 192.168.2.34. I can’t make Step 1 on “Setup page”. Error message says:
Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user ‘egw_trunk_1501’@‘192.168.2.34’ (using password: YES) in /var/www/egw_trunk_1501/phpgwapi/inc/adodb/drivers/adodb-mysql.inc.php on line 366

Address 192.168.2.34 isn’t typed anywhere in header.inc.php - so I assume that some very clever functions tries
to take “localhost” as MySQL server. Of course there is no running MySQL on 192.168.2.34.

Maybe noone installs eGroupWare where webserver and database engine runs separately?

Could anyone point me where problemous code line? I only get:
Warning: Cannot modify header information - headers already sent by (output started at /var/www/egw_trunk_1501/phpgwapi/inc/adodb/drivers/adodb-mysql.inc.php:366) in /var/www/egw_trunk_1501/setup/inc/class.setup_html.inc.php on line 117

adodb-mysql.inc.php:366 is _pconnect funcion. There is no _pconnect call at class.setup_html.inc.php

Thanks;
AdamLis;

[pv1]

AdamLis wrote:

            'db_host' => '192.168.2.33',

Webserver is running on 192.168.2.34. I can’t make Step 1 on “Setup page”.
Error message says:
Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user
’egw_trunk_1501’@‘192.168.2.34’ (using password: YES) in
/var/www/egw_trunk_1501/phpgwapi/inc/adodb/drivers/adodb-mysql.inc.php on
line 366

Address 192.168.2.34 isn’t typed anywhere in header.inc.php

it means, that a connection is made from egw_trunk_1501@192.168.2.34
not to 192.168.2.34

You have to set proper permissions on the mysql-server, what does

mysql -u egw_trunk_1501 -p -h 192.168.2.33 say (done from the

webserver-host)? Can you connect with your password?

Peter
Pte

–
for proper viewing, take red pill now!
gpg @ http://ps1.at/~peter

[Jean-Pierre_Schwicke]

Hello

Webserver is running on 192.168.2.34. I can’t make Step 1 on “Setup
page”. Error message says:
Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied
for user ‘egw_trunk_1501’@‘192.168.2.34’ (using password: YES) in
/var/www/egw_trunk_1501/phpgwapi/inc/adodb/drivers/adodb-mysql.inc.php
on line 366

Address 192.168.2.34 isn’t typed anywhere in header.inc.php - so I
assume that some very clever functions tries
to take “localhost” as MySQL server. Of course there is no running
MySQL on 192.168.2.34.

Maybe noone installs eGroupWare where webserver and database engine
runs separately?

You need to grant the remote user access to your database:

GRANT ALL ON egw_trunk_1501.* to ‘egw_trunk_1501’@'192.168.2.34’
IDENTIFIED BY ‘egw_trunk_1501’;

Regards.

Jean-Pierre

–
HILOTEC Engineering + Consulting AG - Langnau im Emmental
Energietechnik und Datensysteme: Server, PCs, Linux, Telefonanlagen,
VOIP, Hosting, Datenbanken, Entwicklung, Komplettlösungen für KMUs
Tel: +41 34 402 74 00 - http://www.hilotec.com/

---

Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net’s Techsay panel and you’ll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

---

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users

[AdamLis]

AdamLis wrote: > 'db_host' => '192.168.2.33', > Webserver is running on 192.168.2.34. I can't make Step 1 on "Setup page". > Error message says: > Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user > 'egw_trunk_1501'@'192.168.2.34' (using password: YES) in > /var/www/egw_trunk_1501/phpgwapi/inc/adodb/drivers/adodb-mysql.inc.php on > line 366 > > Address 192.168.2.34 isn't typed anywhere in header.inc.php

it means, that a connection is made from egw_trunk_1501@192.168.2.34
not to 192.168.2.34

You have to set proper permissions on the mysql-server, what does

mysql -u egw_trunk_1501 -p -h 192.168.2.33 say (done from the

webserver-host)? Can you connect with your password?

[/quote]

Thanks a lot. MySQL ideas are really weird. I’d never assume that
"for user name@host " may mean something else that “for user
name who tries to log on host”.

I’ll check and correct permissions tommorow. Thanks.

AdamLis;