mysql error during install

[sirwiz]

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?

[joximu]

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...

[sirwiz]

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

[joximu]

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

[sirwiz]

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

[joximu]

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