+- 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: mysql error during install (/thread-2400.html)
mysql error during install - sirwiz - 02-11-2008 08:46 PM
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 !
On Open SuSe 10.3 64
Any idea?
RE: mysql error during install - joximu - 02-11-2008 08:47 PM
Hi
please also post the content of the two mentioned err/log files... /tmp/db.sql.stdout and /tmp/db.sql.stderr
and remeber - ispcp is not yet optimized for distributions other than debian.
If you don't want to try'n'error you better wait until RC4...
RE: mysql error during install - sirwiz - 02-11-2008 09:28 PM
I know about not optymizing to other systems, but i want to check this panel, and maybe help in development.
'bout mysql error, i must start read logs befor posting posts
It just problem with mysql password on SuSe in install script.
I have problems with main::db_pass parameter. I do a fix in setup script.
Thx
RE: mysql error during install - joximu - 02-11-2008 09:42 PM
Hi sirwiz
hm, well... great if you want to help. I think the ispcp-setup should be ok (which ispcp version do you use?) - the different paths for named (instead of bind) etc are the main changes to be done...
/J
RE: mysql error during install - sirwiz - 02-11-2008 10:00 PM
Version RC3
Maybe diferents paths also, but ...
my $cmd = "$main::cfg{'CMD_MYSQL'} --host=$main::db_host --user=$main::db_user --pass=my_mysql_password_typed_hire < /tmp/db.sql 1>/tmp/db.sql.stdout 2>/tmp/db.sql.stderr"; - works
The same line with --pass=main::db_pass not working. I get msg: Access denied for user 'my_mysql_user_hire'@'localhost' (using password: NO)
So the reason is db_pass parameter in install script. I change the 2 lines with install db commands. And it works. But there is more connection to db during isntall, and after making db scripts exit with error msg: "ERROR: Unable to connect SQL server !". I chceck this script later and give you some advice what happened to db_pass paramater on Open Suse 10.3 64
RE: mysql error during install - joximu - 02-11-2008 10:17 PM
Hi sirwiz
you mean: --pass=$main::db_pwd
strange... well we have to find the problem.
I thought that this part was ok - so why is $main::db_pwd not set correctly?
Thanx for analyzing.
/J