Current time: 12-23-2024, 07:38 PM Hello There, Guest! (LoginRegister)


Post Reply 
ispcp on slackware failed
Author Message
dr-who Offline
Newbie
*

Posts: 7
Joined: Feb 2008
Reputation: 0
Post: #1
ispcp on slackware failed
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
(This post was last modified: 02-28-2008 11:53 PM by dr-who.)
02-28-2008 10:45 PM
Find all posts by this user Quote this message in a reply
dr-who Offline
Newbie
*

Posts: 7
Joined: Feb 2008
Reputation: 0
Post: #2
RE: ispcp on slackware failed
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)
02-28-2008 11:14 PM
Find all posts by this user Quote this message in a reply
gOOvER Offline
Banned

Posts: 3,561
Joined: Jul 2007
Post: #3
RE: ispcp on slackware failed
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.
02-28-2008 11:56 PM
Visit this user's website Find all posts by this user Quote this message in a reply
dr-who Offline
Newbie
*

Posts: 7
Joined: Feb 2008
Reputation: 0
Post: #4
RE: ispcp on slackware failed
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
02-29-2008 12:03 AM
Find all posts by this user Quote this message in a reply
sirwiz Offline
Junior Member
*

Posts: 18
Joined: Feb 2008
Reputation: 0
Post: #5
RE: ispcp on slackware failed
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.
(This post was last modified: 02-29-2008 05:02 AM by sirwiz.)
02-29-2008 04:30 AM
Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #6
RE: ispcp on slackware failed
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.
02-29-2008 09:32 AM
Visit this user's website Find all posts by this user Quote this message in a reply
sirwiz Offline
Junior Member
*

Posts: 18
Joined: Feb 2008
Reputation: 0
Post: #7
RE: ispcp on slackware failed
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.
02-29-2008 10:33 AM
Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #8
RE: ispcp on slackware failed
thanks for helping.
I also don't know if that is the point but maybe we'll find it...

/J
02-29-2008 12:26 PM
Visit this user's website Find all posts by this user Quote this message in a reply
dr-who Offline
Newbie
*

Posts: 7
Joined: Feb 2008
Reputation: 0
Post: #9
RE: ispcp on slackware failed
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
03-01-2008 08:15 AM
Find all posts by this user Quote this message in a reply
sirwiz Offline
Junior Member
*

Posts: 18
Joined: Feb 2008
Reputation: 0
Post: #10
RE: ispcp on slackware failed
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.
03-02-2008 01:42 AM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 2 Guest(s)