+- 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: Problem getting ispcp to work please help (/thread-2559.html)
RE: Problem getting ispcp to work please help - Adel - 03-02-2008 12:21 PM
Adel Wrote:hello againgOOvER 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.
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
RE: Problem getting ispcp to work please help - Breaki - 03-02-2008 12:28 PM
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
RE: Problem getting ispcp to work please help - Adel - 03-02-2008 12:46 PM
Breaki Wrote:not shure whats wrong, but it looks like the setup created 2 files (maybe with a solution or the error in it?):Thanks Breaki for your reply.
- /tmp/db.sql.stdout
- /tmp/db.sql.stderr
if they are there pls post them
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.
RE: Problem getting ispcp to work please help - Breaki - 03-02-2008 07:03 PM
hm... you allready set up a mysql password for root with
Code:
mysqladmin -u root password YOUR_PASSWORDbefore 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
RE: Problem getting ispcp to work please help - gOOvER - 03-02-2008 11:01 PM
Did you enter the correct mysql password in setup? Did you setup the passwort as Breaki said?
RE: Problem getting ispcp to work please help - Adel - 03-03-2008 04:25 AM
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
RE: Problem getting ispcp to work please help - joximu - 03-03-2008 05:04 AM
So, the password which is used to connect to mysql is correct?
You can connect to mysql manually?
RE: Problem getting ispcp to work please help - Adel - 03-03-2008 07:46 AM
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
RE: Problem getting ispcp to work please help - joximu - 03-03-2008 08:21 AM
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/access-denied.html
/J
RE: Problem getting ispcp to work please help - Breaki - 03-03-2008 08:29 AM
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 -pCode:
mysql -u root -pYOUR_PASSWORDGreetz