Problem getting ispcp to work please help

[Adel]

Adel Wrote:

gOOvER Wrote:Sorry to say this, but this is basic knowledge and this has nothing to do with ispCP. So we don't support such questions. Please ask google.

Hi gOOvER
I am sorry for the basic question, i am not
very advanced in linux,also it was just a mistake
to post it on this forum, i didn't pay attention
when i clicked on the forum in my favorites .
Thanks anyway for your help.

hello again
now i made a new installation and try again to install ispcp rc3 and
i got this error:
ERROR: External command '/usr/bin/mysql --host=localhost --user=root --pass=XXXXXX < /tmp/db.sql 1>/tmp/db.sql.stdout 2>/tmp/db.sql.stderr' returned '1' status !
what to do to make it work ?
Thanks very much again

[Breaki]

not shure whats wrong, but it looks like the setup created 2 files (maybe with a solution or the error in it?):

• /tmp/db.sql.stdout
• /tmp/db.sql.stderr
  

if they are there pls post them

[Adel]

Breaki Wrote:not shure whats wrong, but it looks like the setup created 2 files (maybe with a solution or the error in it?):

• /tmp/db.sql.stdout
• /tmp/db.sql.stderr
  

if they are there pls post them

Thanks Breaki for your reply.
db.sql.stderr:
ERROR 1044 (42000) at line 1: Access denied for user 'root'@'localhost' to database 'ispcp'
db.sql.stdout is empty.
I run mysql and it runs:
Starting MySQL database server: mysqld already running.
then i try to uninstall it and i got :
ERROR: Unable to connect SQL server !
Thanks again for your help.

[Breaki]

hm... you allready set up a mysql password for root with

Code:

mysqladmin -u root password YOUR_PASSWORD

before you start the ispcp_setup ?

is this now a fresh debian installation or is this your old one with vhcs? please give some more informations.

because if you do everything described here it works fine for me.

greetz

[gOOvER]

Did you enter the correct mysql password in setup? Did you setup the passwort as Breaki said?

[Adel]

gOOvER Wrote:Did you enter the correct mysql password in setup? Did you setup the passwort as Breaki said?

hello
Thanks to both of you for replying.
yes i setup the password for mysql, and i entered the correct one in ispcp setup,
I installed it again followed the debian ispcp installation and at the end it said
installed successfully, then i put in the address "admin.server1.mydomain.com"
as it says at the end of the installation, and i got "server not found ! , then i tried "server1.mydomain.com" & "www.mydomain.com" also what i got is a kind of script code No GUI for login page.
so i decide to uninstall and make a clean install again, it will not even uninstall
error "unable to connect to mysql server".
I tested mysql and it is running.
Thanks very much for your help

[joximu]

So, the password which is used to connect to mysql is correct?
You can connect to mysql manually?

[Adel]

joximu Wrote:So, the password which is used to connect to mysql is correct?
You can connect to mysql manually?

Hi joximu
Thanks yes the password is right and mysql can run, but there is one more thing
i have to say:
when i try to put again or change the pwd and i write:
mysql -u root -p mypassword i get:
Access denied for user root@localhost.
note: i write this on the terminal from the prompt server1#: should i write from some where else?
I am not expert in linux, i used to program with visual basic and foxpro
and this is my first try to have my own server, so sometimes i don't
understand things in linux, i just got used to it little now learned some
command from the forums, so always i will need detail explanation.
Thanks very much for helping

[joximu]

Hi Adel

it really seems that either you don't have the right password or the permissions in mysql are not as they should be...

You may load mysql without the users to correct the situation.
Maybe you should consult some mysql documnetation as
http://dev.mysql.com/doc/refman/5.0/en/a...enied.html

/J

[Breaki]

Adel Wrote:when i try to put again or change the pwd and i write:
mysql -u root -p mypassword i get:

the problem is, you are using the wrong command, imho you have to use

Code:

mysql -u root -p

and enter your password on prompt, or

Code:

mysql -u root -pYOUR_PASSWORD

without the space between -p and your password.

Greetz