+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: System Setup & Installation (/forum-32.html)
+--- Thread: ispcp on slackware failed (/thread-2594.html)
Pages: 1 2
ispcp on slackware failed - dr-who - 02-28-2008 10:45 PM
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
RE: ispcp on slackware failed - dr-who - 02-28-2008 11:14 PM
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)
RE: ispcp on slackware failed - gOOvER - 02-28-2008 11:56 PM
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.
RE: ispcp on slackware failed - dr-who - 02-29-2008 12:03 AM
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
RE: ispcp on slackware failed - sirwiz - 02-29-2008 04:30 AM
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.
RE: ispcp on slackware failed - joximu - 02-29-2008 09:32 AM
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.
RE: ispcp on slackware failed - sirwiz - 02-29-2008 10:33 AM
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.
RE: ispcp on slackware failed - joximu - 02-29-2008 12:26 PM
thanks for helping.
I also don't know if that is the point but maybe we'll find it...
/J
RE: ispcp on slackware failed - dr-who - 03-01-2008 08:15 AM
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
RE: ispcp on slackware failed - sirwiz - 03-02-2008 01:42 AM
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.