Current time: 11-01-2024, 09:15 AM Hello There, Guest! (LoginRegister)


Post Reply 
mysql error during install
Author Message
sirwiz Offline
Junior Member
*

Posts: 18
Joined: Feb 2008
Reputation: 0
Post: #1
mysql error during install
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?
02-11-2008 08:46 PM
Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #2
RE: mysql error during install
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...
(This post was last modified: 02-11-2008 08:48 PM by joximu.)
02-11-2008 08:47 PM
Visit this user's website Find all posts by this user Quote this message in a reply
sirwiz Offline
Junior Member
*

Posts: 18
Joined: Feb 2008
Reputation: 0
Post: #3
RE: mysql error during install
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 Wink

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
02-11-2008 09:28 PM
Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #4
RE: mysql error during install
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
02-11-2008 09:42 PM
Visit this user's website Find all posts by this user Quote this message in a reply
sirwiz Offline
Junior Member
*

Posts: 18
Joined: Feb 2008
Reputation: 0
Post: #5
RE: mysql error during install
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
02-11-2008 10:00 PM
Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #6
RE: mysql error during install
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
02-11-2008 10:17 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)