Alas, I mothballed my old RS/6000 AIX machine a few years ago. It was
getting quite old and only ran AIX 4.3
I had toyed with the idea of getting a more modern machine from ebay
but to be honest, I haven't had much time recently.
On 9 Sep 2011, at 08:22, Peter Gershkovich wrote:
I notice
That's the ticket! Thanks
On 09/08/2011 06:55 AM, Andrew Moore wrote:
Check that you're looking at the variable in the GLOBAL scope not the
SESSION scope.
SHOW GLOBAL VARIABLE ...
Andy
On Thu, Sep 8, 2011 at 11:34 AM, Bruce Ferrellwrote:
On 09/08/2011 02:56 AM, Johan De Meersman wrote:
Am 10.09.2011 19:21, schrieb a.sm...@ukgrid.net:
> Hi Walter/all,
>
> ok nailed it, the issue is the default hosts.allow installed on FreeBSD,
> and specifically the last section that
> denies everything. By default it looks like this:
>
> # The rest of the daemons are protected.
> ALL : ALL
Hi Walter/all,
ok nailed it, the issue is the default hosts.allow installed on
FreeBSD, and specifically the last section that denies everything. By
default it looks like this:
# The rest of the daemons are protected.
ALL : ALL \
: severity auth.info \
: twist /bin/echo "Y
Am 10.09.2011 19:02, schrieb a.sm...@ukgrid.net:
> Quoting Reindl Harald :
>
>>
>> "You are not welcome to use mysqld from tau" is NOT from mysqld
>> remove your hosts.allow/hosts.deny crap and replace it with firewall-rules
>> if the problem goes away make a bugreport on BSD side becahuse this
Quoting Reindl Harald :
"You are not welcome to use mysqld from tau" is NOT from mysqld
remove your hosts.allow/hosts.deny crap and replace it with firewall-rules
if the problem goes away make a bugreport on BSD side becahuse this
is NOT a mysqld issue
I've already established that the is
Am 10.09.2011 18:52, schrieb a.sm...@ukgrid.net:
> Quoting walter harms :
>
>> restart it with the same parameter on the command line and see what happens
>> the server support a verbos option (never used) perhaps it will tell you
>> more.
>>
>
> I can start mysqld direct from the command line an
Quoting walter harms :
restart it with the same parameter on the command line and see what happens
the server support a verbos option (never used) perhaps it will tell
you more.
I can start mysqld direct from the command line and reproduce the
problem. I checked and it seems the verbose
Am 10.09.2011 17:32, schrieb a.sm...@ukgrid.net:
> Quoting walter harms :
>
>> I still do not see why it is restarting ... there must be something
>> watching is disappear.
>> Just to be sure, you do from a remote host: mysql -hHOST -ume -e "show
>> tables" ?
>> long shot: Do you have LDAP, NIS
Quoting walter harms :
I still do not see why it is restarting ... there must be something
watching is disappear.
Just to be sure, you do from a remote host: mysql -hHOST -ume -e
"show tables" ?
long shot: Do you have LDAP, NIS or so enabled ?
Ok so made a script as you suggested, and it
Quoting Reindl Harald :
Odd that, so I added a mysql specific line to the hosts.allow
who is using hosts.allow for protection instead a firewall in front
of the machine
or iptables (linux) / ipf (bsd)?
Its used for denyhosts as I mentioned.
As I said I can get it to restart just by doing
Am 10.09.2011 16:25, schrieb a.sm...@ukgrid.net:
> Quoting walter harms :
>
>>
>> What i found odd that your mysqld actualy restarts.
>> Do you have it in some runlevel ? if yes stop and see
>> what happens.
>> If this does not work simple move the mysqld out of he way
>> and replace it with a s
Am 10.09.2011 16:07, schrieb a.sm...@ukgrid.net:
> Then I thought, what if I have hosts.allow misconfigured and its wide open
> maybe a remote system is connecting and
> messing with it. But hosts.allow was correct (mysql not listed, so denied by
> the last all:all). I tested connecting
> from
Quoting walter harms :
What i found odd that your mysqld actualy restarts.
Do you have it in some runlevel ? if yes stop and see
what happens.
If this does not work simple move the mysqld out of he way
and replace it with a script like
#!/bin/sh
echo "mysqld ..." | logger -t TEST
see what ha
Am 10.09.2011 16:07, schrieb a.sm...@ukgrid.net:
> Ok, this is pretty odd but I have found the problem.
>
> Today I have repointed all applications to a different DB server, so I
> have been free to do any testing on the problem server.
>
> I started by dropping the databases one by one, droppe
Ok, this is pretty odd but I have found the problem.
Today I have repointed all applications to a different DB server, so I
have been free to do any testing on the problem server.
I started by dropping the databases one by one, dropped em all and the
issue persisted.
I stopped crond, even t
i bet if he stops crond the problem is going away
anyways i have enough of this thread after "the part for the shutdown"
because if peopole are way too stupid to provide full logs (normally
in the first post) even after requested multiple times they should
learn their lessons the hard way...
It is some time since i used AIX but maybe this help.
So far i know has IBM moved to gnu-tools if not do it,
it will ease the pain. I assume that you have gcc etc running.
after downloading the latest version of mysql source.
1. unpack
2. ./configure
if it complains try to fix it
/* hope for the be
This was me restarting MySQL as was requested by Suresh...
Quoting "Singer X.J. Wang" :
This doesn't look like a MySQL issue. Verify that there's no rogue scripts
that shutdowns MySQL...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
On Sat, Sep 10, 2011 at 01:48, Carsten Pedersen wrote:
> `userTable.userid` => `userTable`.`userid`
>
Thank you Carsten. That was indeed the problem! Have a peaceful weekend.
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com
--
MySQL General Mailing List
For list archives: http:/
20 matches
Mail list logo
