LinuxQuestions.org - ERROR: Unknown user 'www' !

- Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)

- - ERROR: Unknown user 'www' ! (https://www.linuxquestions.org/questions/linux-software-2/error-unknown-user-www-736165/)

ERROR: Unknown user 'www' !

Hi...
I'm trying to install Vhcs:

Code:

ubuntu@ubuntu-laptop:/$ sudo /var/www/vhcs2/engine/setup/./vhcs2-setup



    Welcome to VHCS2 '2.4 Rhea' Setup Dialog.



    This program will set up VHCS2 system on your server.

...

...

and at the end, when it asks for the email.. i get this error

Code:

    Please enter admininistrator email address: a@a.a

ERROR: Unknown user 'www' !

ubuntu@ubuntu-laptop:/$

how do I edit or add users ?

Code:

adduser

look it up in the man pages!

Code:

man adduser

Thnx,
I added user 'www'
but now i have other error ;/

Code:

    Please enter admininistrator email address: admin@aaa.com

ERROR: External command '/usr/local/bin/mysql --host=localhost --user=root --pass=qwasqw < /tmp/db.sql 1>/tmp/db.sql.stdout 2>/tmp/db.sql.stderr' returned '127' status !

ubuntu@ubuntu-laptop:~$

what shall i do :S ?

Code:

ubuntu@ubuntu-laptop:~$ head /tmp/db.sql.stderr

sh: /usr/local/bin/mysql: not found

Do you have MySQL installed?

Is it installed in the location your application expects?

Do you have the mysql-client package installed?
jdk

i created directiry

Code:

mkdir /usr/local/bin/mysql

and then i get other error

Code:

    Please enter admininistrator email address: admin@a.com

ERROR: External command '/usr/local/bin/mysql --host=localhost --user=root --pass=qwer56 < /tmp/db.sql 1>/tmp/db.sql.stdout 2>/tmp/db.sql.stderr' returned '126' status !

ubuntu@ubuntu-laptop:/usr/local/bin$ head /tmp/db.sql.stderr

sh: /usr/local/bin/mysql: Permission denied

ubuntu@ubuntu-laptop:/usr/local/bin$

Quote:

Originally Posted by DiGiGoth (Post 3589653)

i created directiry

Code:

mkdir /usr/local/bin/mysql

and then i get other error

Code:

    Please enter admininistrator email address: admin@a.com

ERROR: External command '/usr/local/bin/mysql --host=localhost --user=root --pass=qwer56 < /tmp/db.sql 1>/tmp/db.sql.stdout 2>/tmp/db.sql.stderr' returned '126' status !

ubuntu@ubuntu-laptop:/usr/local/bin$ head /tmp/db.sql.stderr

sh: /usr/local/bin/mysql: Permission denied

ubuntu@ubuntu-laptop:/usr/local/bin$

1. You cannot write to /usr/local except as root or using sudo.
2. You don't create a folder, you download the mysql-client package.
3. It won't go in /usr/local/bin it will go in /usr/bin unless you want to compile it yourself.
Cheers,
jdk

sudo apt-get install mysql-server-5.0 mysql-client-5.0

You are missing a software package - i. e. MySQL and its development libraries. You will not be able to proceed until you have installed and correctly configured and started MySQL. See the above post - once MySQL is installed and running, you should be able to proceed.

rylan76 ! u were right !

ok ... i fixed all this and that

now i get this

Code:

    Please enter admininistrator email address: a@a.a

ERROR: Unable to connect SQL server !

ubuntu@ubuntu-laptop:~$

i didnt try to do anything before posting...

Is the MySQL server running?

I. e. if you do

Code:

ps -A | grep mysql

you should see

Code:

 1955 ?        00:00:00 mysqld_safe

 1976 ?        00:00:00 mysqld

 1987 ?        00:00:00 mysqld

 1988 ?        00:00:00 mysqld

 1989 ?        00:00:00 mysqld

 1990 ?        00:00:00 mysqld

 1991 ?        00:00:00 mysqld

 1999 ?        00:00:00 mysqld

 2000 ?        00:00:00 mysqld

 2002 ?        00:00:00 mysqld

 2003 ?        00:00:00 mysqld

 3292 ?        00:00:04 mysqld

 3346 ?        00:00:04 mysqld

[rylan@development ~]$

I. e. you probably need to start your MySQL server. After you have successfully installed the packages above, do the following, as root, in a terminal window:

Code:

#groupadd mysql

#useradd -g mysql mysql

Now, you need to find where your APT install of the MySQL directories took place. You need to now run the script mysql_install_db in the MySQL installation's "scripts" folder.

To find where the "mysql_install_db" script was installed, do, as root, in a terminal:

Code:

# find / -name mysql_install_db

For example, on my system:

Code:

[root@development ~]# find / -name mysql_install_db

/usr/local/mysql/scripts/mysql_install_db

So, on your system, change into the directory indicated (in the case above it is /usr/local/mysql/scripts) and run the mysql_install_db script by typing its name and the username parameter it needs, i. e.

Code:

[root@development ~]# cd /usr/local/mysql/scripts

[root@development ~]# mysql_install_db --user=mysql

This will install the base MySQL tables it needs to run.

Now, all that is needed is to start the server:

Code:

[root@development ~]# /usr/local/mysql/bin/mysqld_safe --user=mysql &

Put the above line in your /etc/rc.local so that the server will be started each time you boot your system.

Check that MySQL is running:

Code:

[rylan@development scripts]$ ps -A | grep mysql

 1955 ?        00:00:00 mysqld_safe

 1976 ?        00:00:00 mysqld

 1987 ?        00:00:00 mysqld

 1988 ?        00:00:00 mysqld

 1989 ?        00:00:00 mysqld

 1990 ?        00:00:00 mysqld

 1991 ?        00:00:00 mysqld

 1999 ?        00:00:00 mysqld

 2000 ?        00:00:00 mysqld

 2002 ?        00:00:00 mysqld

 2003 ?        00:00:00 mysqld

 3292 ?        00:00:04 mysqld

 3346 ?        00:00:04 mysqld

 3544 ?        00:00:00 mysqld

[rylan@development scripts]$

Note that you might have more or less mysqld processes, depending on the precise version you have installed.

MySQL should now be available on your system to an application that needs to use it.

Hmmm... seems like its up and running ...

Code:

ubuntu@ubuntu-laptop:~$ sudo  ps -A | grep mysql

 2832 ?        00:00:00 mysqld_safe

 2874 ?        00:00:03 mysqld

ubuntu@ubuntu-laptop:~$ groupadd mysql

groupadd: group mysql exists

ubuntu@ubuntu-laptop:~$ useradd -g mysql mysql

useradd: user mysql exists

ubuntu@ubuntu-laptop:~$ sudo find / -name mysql_install_db

/usr/bin/mysql_install_db

ubuntu@ubuntu-laptop:~$ cd /usr/bin/

ubuntu@ubuntu-laptop:/usr/bin$ sudo mysqld_safe --user=mysql &

[1] 10873

ubuntu@ubuntu-laptop:/usr/bin$ nohup: ignoring input and redirecting stderr to stdout

mysqld_safe[10918]: A mysqld process already exists



[1]+  Exit 1                  sudo mysqld_safe --user=mysql

ubuntu@ubuntu-laptop:/usr/bin$

why does the process "mysqld_safe" still running after i stop mysql ?
if its reffering only to the mysql server, then how do i restart it ?

Code:

ubuntu@ubuntu-laptop:~$ cd

ubuntu@ubuntu-laptop:~$ sudo /etc/init.d/mysql stop

 * Stopping MySQL database server mysqld                                [ OK ]

ubuntu@ubuntu-laptop:~$ sudo ps xa | grep mysql

 2832 ?        S      4:52 /bin/sh /usr/bin/mysqld_safe

12054 pts/0    S<+    0:00 grep mysql

ubuntu@ubuntu-laptop:~$ service mysqld stop

$mysqld: unrecognized service

is any installation missing ?

No, from what you posted, your installation only needed to be started - you did not need to do the useradd and groupadd bits. This is the thing with package managers - in my Fedora 11 install, the package manager did NOT create the mysql group and user when the MySQL 5 package was installed, so I had to do that myself (as I showed you). Apparently, your Ubuntu manager DID go a step further and already created the mysql user and group.

As for the rest of the post, I don't think the service is still running, look at your output:

Code:

mysqld_safe[10918]: A mysqld process already exists



[1]+  Exit 1                  sudo mysqld_safe --user=mysql <------------

ubuntu@ubuntu-laptop:/usr/bin$

That clearly reports the the service has stopped.

This too:

Code:

ubuntu@ubuntu-laptop:~$ sudo ps xa | grep mysql

 2832 ?        S      4:52 /bin/sh /usr/bin/mysqld_safe

12054 pts/0    S<+    0:00 grep mysql

ubuntu@ubuntu-laptop:~$ service mysqld stop

[b]$mysqld: unrecognized service[b] <------------

Remember, sometimes it might take your MySQL instance a second or two to end - i. e. you might say "stop" but it'll only stop after 30 seconds or even longer if it is loaded or busy. After stopping or starting it, wait at least half a minute and then verify that it is either running or dead.

Once you have started it, though, does your app now work? Vhcs?