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

This post was last modified: 03-02-2008 11:30 PM by BeNe.

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
  

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.

This post was last modified: 03-02-2008 02:33 PM by Adel.

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

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

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

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

This post was last modified: 03-03-2008 07:50 AM by Adel.

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

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

and enter your password on prompt, or

without the space between -p and your password.

Greetz