Re: EMERGENCY - need to secure my server against an ongoing SPAMMER

From: Bob Brennan (rbrennan96_at_gmail.com)
Date: 03/13/05

  • Next message: Les Mikesell: "Re: Linking Wired and Wireless network..."
    Date: Sun, 13 Mar 2005 19:18:38 +0000
    To: For users of Fedora Core releases <fedora-list@redhat.com>
    
    

    > On Sun, 13 Mar 2005, Bob Brennan wrote:
    >
    > > My remaining problems are:
    > > 1) how to open up *safe* relays for legitimate users, the preferred
    > > method being pop-b4-smtp because it is widely supported.
    > > 2) how to get mysql up and running again. The log-reported missing was
    > > in fact there and valid, even when replaced by a backup. I am
    > > currently trying uninstalls and reinstalls but not having a lot of
    > > luck. Most of my sites are dynamic and heavily rely on MySql.
    >
    > I recall that the problem you reported was that, when you typed "service
    > mysqld start", you got a message about "Timeout error...". When this
    > happens, what does "service mysqld status" report?
    >
    > Depending on what you've done to your configuration, this may not mean
    > that mysqld actually failed. What failed is a little piece of the
    > startup script that pings the server until it comes up:
    >
    > /usr/bin/mysqladmin -uUNKNOWN_MYSQL_USER ping
    >
    > The failure message occurs if the ping fails after 10 tries (1/sec).
    >
    > The initial mysql database installed with the mysql-server RPM has two
    > users defined. One is "root" and the other is "". If you removed "" or
    > set a password for it, then the ping will fail and you'll get the message,
    > even if if the server started successfully.
    >
    > I'm no MySQL expert, but if you are concerned about a user with no
    > password, I'll just note that that user also has no privileges.

    That's what I thought it was too Matthew - since the hosts.frm file
    contains the users and passwords. So I copied all hosts.* files from a
    known good working installation and it made no difference.

    Putting back the old files I noticed the log error was specifically
    "could not *read* hosts.frm" even though it was obviously there and
    obviously valid. I tested my theory on the good working machine by
    renaming hosts.frm - mysqld would not start but the error was "could
    not *find* hosts.frm". Aha! So I started thinking it has to do with
    access rights, disabled SELinux, and hey presto mysqld works again. It
    is obviously an Up2Date change to SELinux that didn't take effect
    until I rebooted, and now I need to narrow down the policy in question
    in order to re-enable SELinux without crippling my databases.

    Thanks for the suggestions - it put me in the right direction.

    bob

    -- 
    fedora-list mailing list
    fedora-list@redhat.com
    To unsubscribe: http://www.redhat.com/mailman/listinfo/fedora-list
    

  • Next message: Les Mikesell: "Re: Linking Wired and Wireless network..."

    Relevant Pages

    • Re: Cant start mysql on FC3
      ... Dan Kovacik wrote: ... mysqld was unable to access the necessary files. ... I just have to figure out what SELinux is and how to ... properly configure it to play nice with mysql. ...
      (Fedora)
    • Re: SELinux and MySQL
      ... If I try to access a mysql database with SELinux enabled, ... the SELinux MySQL context lacked the magic SELinux ... So when the original MySQL init.d script was run directly, ...
      (RedHat)
    • Re: [SLE] I HAD IT WORKING! MySQL under SuSE 9.0 Woes
      ... 040413 07:10:29 mysqld started ... 040413 7:10:32 Can't init databases ... Starting service MySQL ... Preparing host table ...
      (SuSE)
    • Re: mysql ??
      ... >>Mike I seem to be making some head way, I have the server running a sock ... > Definitely looks like a grant table problem. ... this is the weakest point in the mysql install procedure - you ... > the whole permission system while I muck with getting mysqld set up ...
      (alt.os.linux.suse)
    • MySQL 4.0.18 server problem on FreeBSD 5.2-Current
      ... 040323 19:52:50 mysqld restarted ... 040323 19:52:50 InnoDB: Started ... I tried with linuxthreads-2.2.3_15 and linuxthreads-2.2.3_13 but mysql ... I even tried to downgrade mysql server to 4.0.17 but same error. ...
      (freebsd-current)