View Single Post
  #3  
Old 5th January 2008, 23:38
FXT FXT is offline
Junior Member
 
Join Date: Jul 2007
Posts: 22
Thanks: 3
Thanked 0 Times in 0 Posts
Default

Thank you for your answer, Falko. I couldn't check up on this over Christmas, thus the late reply.

hosts file question:

Quote:
Originally Posted by falko
It's not necessary, but saves a DNS lookup if your system uses servebox.example.com somewhere.
So If my server will not have a domain name, but just a non-routable LAN address, I should basically leave /etc/hosts alone (which i'm guessing is preferable)?
Or is it necessary to just change the file contents from the perfect setup like so:

Code:
127.0.0.1       localhost.localdomain localhost
192.168.1.222   servebox

# The following lines are desirable for IPv6 capable hosts
::1     ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
ff02::3 ip6-allhosts
This is an important clarification for me, whether to change anything in that file and if so, what exactly. As of the time of this post, I have restarted the perfect setup and not modified /etc/hosts/ at all.

Quote:
Originally Posted by falko
Run
Code:
echo "servebox.example.com" > /etc/hostname
/etc/init.d/hostname.sh start
Now both hostname and hostname -f should show servebox.example.com.
Assuming I do not have to change /etc/hosts, the hostname command should output only "servebox", correct?

MySQL Problem:

Quote:
Originally Posted by falko
Follow the steps in chapter 8 on http://www.howtoforge.com/perfect_se...pensuse10.3_p4 , beginning with As you've seen in the netstat output, MySQL is not only listening on localhost to fix the hostname in the MySQL database.
Quote:
Originally Posted by falko
If all applications that need the database are on the same host, then MySQL doesn't need to listen on all interfaces.
I have not modified /etc/mysql/my.cnf as per the perfect setup howto, because i only want mysql to listen on localhost. Given that change from the setup, is the command

Code:
mysqladmin -h server1.example.com -u root password yourrootsqlpassword
even necessary? In my case, the correct syntax would be:

Code:
mysqladmin -h servebox -u root password yourrootsqlpassword
?

My user DB looks like this:

Code:
+-----------+------------------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+
| Host      | User             | Password         | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections |
+-----------+------------------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+
| localhost | root             | 4db6dbb76d899aa6 | Y           | Y           | Y           | Y           | Y           | Y         | Y           | Y             | Y            | Y         | Y          | Y               | Y          | Y          | Y            | Y          | Y                     | Y                | Y            | Y               | Y                | Y                | Y              | Y                   | Y                  | Y                |          |            |             |              |             0 |           0 |               0 |                    0 |
| servebox  | root             |                  | Y           | Y           | Y           | Y           | Y           | Y         | Y           | Y             | Y            | Y         | Y          | Y               | Y          | Y          | Y            | Y          | Y                     | Y                | Y            | Y               | Y                | Y                | Y              | Y                   | Y                  | Y                |          |            |             |              |             0 |           0 |               0 |                    0 |
| localhost | debian-sys-maint | 0167e3a23156214d | Y           | Y           | Y           | Y           | Y           | Y         | Y           | Y             | Y            | Y         | Y          | Y               | Y          | Y          | Y            | Y          | Y                     | Y                | Y            | Y               | Y                | N                | N              | N                   | N                  | N                |          |            |             |              |             0 |           0 |               0 |                    0 |
+-----------+------------------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+
Does that make sense?

I'd like to continue the perfect setup now, and was wondering whether i should hold off until this mysql thing is solved or whether i can just go on installing. Is this something that can be fixed later? I know mySQL should be up and running by the time i install ISPConfig, at the latest.

Sorry for the long post, but this is mostly new to me, and i need help getting to grips with it.
Reply With Quote