ispcp on slackware failed

[dr-who]

Hello i have a problem during the installation of ISPCP Rc3
everything is ok, but when it goes to insert the mysql there's a problem

here's the output

Activate AWStats. [no]:

Starting Installation...
ERROR: External command '/usr/bin/mysql --host=localhost --user=root --pass= < /tmp/db.sql 1>/tmp/db.sql.stdout 2>/tmp/db.sql.stderr' returned '127' status !
root@moris:/www/ispcp/engine/setup#


by the way returned '127' status ! this means that the table 'ispcs' (i used this one) doesn;t exist


i tried manually to insert this db and everything is ok, i don't know where is the problem and what can i do, please help me

root@moris:/www/ispcp/engine/setup# /usr/bin/mysql --host=localhost --user=root --pass= < /tmp/db.sql 1>/tmp/db.sql.stdout 2>/tmp/db.sql.stderr
root@moris:/www/ispcp/engine/setup#
it works manually

[dr-who]

I'm using
apache 2.2.8
php 5.2.5
mcrypt-2.6.7
mysql 5.0.26
distro slackware 11
kernel: 2.6.24.2-grsec (no selinux included, configured grsec to work with mysql)

[gOOvER]

RC3 don't support your Distri at the Moment. If you want to test ispCP please try the latest Nightly. I mean your Distri should be supported. But be careful: This is only for testing. Else you have to wait for RC4.

[dr-who]

gOOvER Wrote:RC3 don't support your Distri at the Moment. If you want to test ispCP please try the latest Nightly. I mean your Distri should be supported. But be careful: This is only for testing. Else you have to wait for RC4.

i have changed everything in the install scripts like: init directories, web directories, web users, ftp daemons because i don't work with proftpd, and many many, but i have a problem in importing the database into the mysql server

but ok i'll wait, until that i'll try this software on our Debian servers and RHEL servers, i just wanted to test it on our free hosting servers which are with Slackware

Thanks very much
i'll try the night svn
if it fail i'll wait to RC4

Regards dr-who
Technical Director of CNET Bulgaria

[sirwiz]

I have the identical problem on OpenSuSe 10.3.

And now i set up virtiual machine with debian etech and ?????

Starting Installation...
ERROR: External command '/usr/bin/mysql --host=localhost --user=root --pass= < /tmp/db.sql 1>/tmp/db.sql.stdout 2>/tmp/db.sql.stderr' returned '1' status !

and echo of db.sql.stderr:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

So this error isn't only on unsuported systems.

And then i reset sql password installation process is ok.

[joximu]

do you all use no password on mysql? (so the "... --user=root --pass= < /tmp/db.sql ..." is correct).

Or did you enter the valid mysql root (or user you created for ispcp) password?

The problem is: there are people having the same issue (also with debian) but we cannot reproduce.

[sirwiz]

If i have mysql passord and i enter it, install script get this error.

When i reset mysql root password to "null", so there was no password for mysql user, install goes OK.

Another install similar to first, and i run it without any problems. But, in second install i change in terminal client, translation of characters from my international to utf-8. I dont know that this is solution, but it was one of main changes during second install.

[joximu]

thanks for helping.
I also don't know if that is the point but maybe we'll find it...

/J

[dr-who]

joximu Wrote:thanks for helping.
I also don't know if that is the point but maybe we'll find it...

/J

mysql is working great
i tried to do it with root user in my mysql
i have a lot of db's =) just for try
exit status 127 is that the db doesn;t exist, but in the begin of the .db there's a create table; functions
dunno?

i'm waiting for rc4 =)
thanks

[sirwiz]

I probly found solution.

When you install Omega first you get msg about genereting database keys. This takes a lot of time, and if you do something on console, enter anything push key etc. etc., install script stop generating keys and go to the second stage of install without any error. And then i get databes error. If i wait without doing anything until stage 2 appears, script install Omega without any problems. I check it 5 times and all 5 times have the same result.