thorolf godawa

Hi,

I was trying to get run MySQL together with Tomcat 5.0.30, Apache
2.0.53/PHP 4.3.10 and Innotek/Sun Java SDK 1.4.2-05 on eCS 1.2 with
XRGC005. But I very often got a SYS0008 (not enough memory for
processing) and after starting Apache and MySQL I was not able to start
other programs f. ex. firefox.exe, vpc.exe or ae.exe/e.exe, even cmd.exe
doesn't work.


OK, I was testing and trying a little more and finaly I got running at
least Apache 2.0.53/PHP 4.3.10 and MySQL 4.0.18 and 4.1.17!

And even Tomcat 5.0.30 with Java-SDK 1.4.2-05 is running but not yet
testet very well!


I tried it now on the same machine, but on my ACP2r with
FP5-installation, so it seems that the eComStation 1.2 with all the
useless "funny, bunny"-stuff kills too much needed ressources :-(((


But there are still a lot of problems:

First I start MySQL:

- mysqld.exe --console --old-passwords
-> mysqld.exe: ready for connections.
Version: '4.1.7' socket: '\socket\MySQL' port: 3306 Source
distribution

Second step always is creating a 'fresh' mysql-db and change the
root-password, for that I do the following:

- change into MySQL-bin-directory:

- mysql mysql
mysql> DELETE FROM user WHERE Host='localhost' AND User='';
-> Query OK, 1 row affected (0.38 sec)
mysql> quit
-> Bye
- mysqladmin -u root password mynewpasswd

- then I check the db-server:

- mysqladmin -u root --password=mynewpasswd version
-> mysqladmin Ver 8.41 Distrib 4.1.7, for pc-os2-emx on i386 ...
mysqlshow -u root --password=mynewpasswd mysql
-> Database: mysql
+---------------------------+
| Tables |
+---------------------------+
| columns_priv |
| db |
...
mysql -u root --password=mynewpasswd -e "select host,db,user from db"
mysql
-> +------+---------+------+
| host | db | user |
+------+---------+------+
| % | test | |
| % | test\_% | |
+------+---------+------+

Everything seems to works until here!


But I was not able to use MySQL 4.1.17 together with phpMyAdmin 2.6.2
because I can't login, possibly because auf the new password-algorithm.
The solutions seem to be switching to PHP 5 with php_mysqli.dll (that
doesn't exist on OS/2) or starting MySQL with "mysqld.exe --console
--old-passwords" what doesn't change anything in it's behaviour.


In the 'config.inc.php' of phpMyAdmin I set:

$cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin-2.6.2/';
//$cfg['PmaAbsoluteUri'] = 'http://thinkpad.local/phpMyAdmin-2.6.2/';
....
$cfg['Servers'][$i]['host'] = 'localhost';
//$cfg['Servers'][$i]['host'] = 'thinkpad.local';
....
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'mynewpasswd';
//$cfg['Servers'][$i]['auth_type'] = 'http';
//$cfg['Servers'][$i]['user'] = '';
//$cfg['Servers'][$i]['password'] = '';
....


With MySQL 4.1.17 I ONLY get (for 'config'):

MySQL said:
#1251 - Client does not support authentication protocol requested by
server; consider upgrading MySQL client

and for 'http' the never-ending-login-dialog!


Finally I could resolv this problem with changing the root-password as
follow (remember: I started the mysqld with the option '--old-passwords'!):

mysql -u root --password=mynewpasswd mysql
mysql> SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('mynewpasswd');


Now phpMyAdmin is starting if I open it with Firefox 1.0.3 or Opera
5.12, but I always get a SYS3171 in the 'startup.cmd' of Apache 2.0.53,
with the result that the apache-daemon crashes after some time :-(
I could verify this problem with all 2.6.x-versions (2.6.0-pl3,
2.6.1-pl3, 2.6.2, 2.6.2-pl1) of phpMyAdmin, only phpMyAdmin-2.5.7-pl1
seems to work better, I can view the structure, I can browse, delete
entries but if I try to insert a row or edit an user f.ex. I still get a
SYS3171!


So second try was using MySQL 4.0.18 with phpMyAdmin 2.6.2 but this
works only if I use auth_type = 'config', I would prefer 'http' but then
I'm not able to login localy as 'root', after the login nothing happens
and the login-screen comes back until I press ESC and than I get an
'Wrong username/password. Access denied.'.

And I still have the problem with the SYS3171 :-(

So how should I go on?

Thanks a lot,
--
To Answer please replace "invalid" with "de" !
Zum Antworten bitte "invalid" durch "de" ersetzen !


Chau y hasta luego,

Thorolf