Re: Binary builds for AIX

[Antony T Curtis]

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 noticed that there is no binary builds for AIX any more.
What would be the best way to install a current version of MySQL  
(5.5)  on AIX?

Specifically I am looking for instructions for AIX 6.1 and/or 7.1
Thanks,
Peter


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=antony.cur...@ieee.org




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: trying to change wait_timeout

[Bruce Ferrell]

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:


- Original Message -


From: "Bruce Ferrell"
To: mysql@lists.mysql.com
Sent: Thursday, 8 September, 2011 3:10:16 AM
Subject: trying to change wait_timeout

I've read the documentation on MySQL for version 5.1 and it says all
I have to do is to place the following:
wait_timeout=xxx
under [mysqld]


That, and restart the service, of course. You *did* think of restarting
the service, I trust? :-p

That being said, it is also a dynamic variable, so if you didn't restart,
prefer not to restart *and* are certain your config file is correct; you can
also do "set global wait_timeout=xxx" to have it take effect immediately for
all new sessions. Yes, that means you'll have to disconnect/reconnect to see
the change in your own session.


Good question to ask.  Yes, I did restart mysql.  Both before and after
show variables like 'wait_time%' returns 28800.  Most confusing.




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?**
unsub=eroomy...@gmail.com





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MySQL daemons restarting every 7 minutes

[Reindl Harald]

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 \
> : severity auth.info \
> : twist /bin/echo "You are not welcome to use %d from %h."
> 
> The twist command breaks it. In theory this is just meant to send a custom 
> message back to the application calling
> the tcp wrapper library. I'm not sure if this should work in theory or not, 
> but the twist command is also meant to
> close the connection so possibly the behaviour I see is normal and just not 
> compatible with MySQL.
> 
> Anyway, its not a great default for FreeBSD given that MySQL also installs by 
> default with support for tcp
> wrappers. The two together results in a broken configuration.

well, and that is why i said nobody is using hosts.allow in real life
if you want to protect anything use packet-filters

i have seen so many peopole typing something in hosts.allow and not
realizing that the service is not using tcp-wrappers which means
there is no protection - additionaly most peopole doe snot test
their configurations really well

the point of "not testing configurations" affects you too because
if you would have tested this the issue would have been happened
after the first connection long before go in production



signature.asc
Description: OpenPGP digital signature

Re: MySQL daemons restarting every 7 minutes

[a . smith]

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 "You are not welcome to use %d from %h."

The twist command breaks it. In theory this is just meant to send a  
custom message back to the application calling the tcp wrapper  
library. I'm not sure if this should work in theory or not, but the  
twist command is also meant to close the connection so possibly the  
behaviour I see is normal and just not compatible with MySQL.


Anyway, its not a great default for FreeBSD given that MySQL also  
installs by default with support for tcp wrappers. The two together  
results in a broken configuration.


thanks Andy.




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MySQL daemons restarting every 7 minutes

[Reindl Harald]

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 is NOT a 
>> mysqld issue
>>
> 
> I've already established that the issue is MySQL in conjuration with certain 
> config in hosts.allow. I have also
> resolve my problem. I only continue looking at this for curiosity, because 
> Walter asked me to do some other test
> and to do my part for MySQL and the community. Also given MySQL supports tcp 
> wrappers, it should work or that code
> should be remove from MySQL...

REMOVE IT to see if this is the problem

"should be remove from MySQL" is another question and depends on where the error
is triggered, if it is the tcp-wrapper from BSD and not happening on another OS
there has to be notihing removed from mysql because it is on BSD side

remove and disable all crap around mysqld (tcp-wrappers, crond, watchdogs...)
to locate the poblem and if mysqld runs normal after that enable one after
one to look what exactly is triggering the problem - this is the way debugging
works since computers exists






signature.asc
Description: OpenPGP digital signature

Re: MySQL daemons restarting every 7 minutes

[a . smith]

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 issue is MySQL in conjuration with  
certain config in hosts.allow. I have also resolve my problem. I only  
continue looking at this for curiosity, because Walter asked me to do  
some other test and to do my part for MySQL and the community. Also  
given MySQL supports tcp wrappers, it should work or that code should  
be remove from MySQL...





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MySQL daemons restarting every 7 minutes

[Reindl Harald]

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 and reproduce the problem. I 
> checked and it seems the verbose
> option only works in conjunction with --help.
>
> Playing around with a couple of tools that are installed on FreeBSD, I ran 
> via truss and ktrace to see if there
> was anything obvious before the process dies but not really. In ktrace you 
> can see that it gets as far as
> deciding that the remote connection should not be allowed then rapidly just 
> dies:
>
>
>  78353 echo GIO   fd 1 wrote 44 bytes
>"You are not welcome to use mysqld from tau.
>"
>  78353 echo RET   writev 44/0x2c
>  78353 echo CALL  sigprocmask(SIG_BLOCK,0x800638400,0x7fffebd0)
>  78353 echo RET   sigprocmask 0
>  78353 echo CALL  sigprocmask(SIG_SETMASK,0x800638410,0)
>  78353 echo RET   sigprocmask 0
>  78353 echo CALL  sigprocmask(SIG_BLOCK,0x800638400,0x7fffeb80)
>  78353 echo RET   sigprocmask 0
>  78353 echo CALL  sigprocmask(SIG_SETMASK,0x800638410,0)
>  78353 echo RET   sigprocmask 0
>  78353 echo CALL  exit(0)
>
>
> Interesting also to see it exits with status 0 :S. What would be the best 
> tool to debug this further?

"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




signature.asc
Description: OpenPGP digital signature

Re: MySQL daemons restarting every 7 minutes

[a . smith]

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 option only works in  
conjunction with --help.


Playing around with a couple of tools that are installed on FreeBSD, I  
ran via truss and ktrace to see if there was anything obvious before  
the process dies but not really. In ktrace you can see that it gets as  
far as deciding that the remote connection should not be allowed then  
rapidly just dies:



 78353 echo GIO   fd 1 wrote 44 bytes
   "You are not welcome to use mysqld from tau.
   "
 78353 echo RET   writev 44/0x2c
 78353 echo CALL  sigprocmask(SIG_BLOCK,0x800638400,0x7fffebd0)
 78353 echo RET   sigprocmask 0
 78353 echo CALL  sigprocmask(SIG_SETMASK,0x800638410,0)
 78353 echo RET   sigprocmask 0
 78353 echo CALL  sigprocmask(SIG_BLOCK,0x800638400,0x7fffeb80)
 78353 echo RET   sigprocmask 0
 78353 echo CALL  sigprocmask(SIG_SETMASK,0x800638410,0)
 78353 echo RET   sigprocmask 0
 78353 echo CALL  exit(0)


Interesting also to see it exits with status 0 :S. What would be the  
best tool to debug this further?


thanks Andy.




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MySQL daemons restarting every 7 minutes

[walter harms]

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 or so enabled ?
>>
> 
> Ok so made a script as you suggested, and it is called from mysqld_safe.
> So that is what is restarting mysqld.
> 
when can establish that here is no interference from outside
we need to reduce more since you are running mysqld_safe - that is nice -
can you see the parameters who mysqld is started ?
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.

> With regard to is it doing a proper shutdown, no it isn't. It restarts
> instantly when triggered by a remote connection, and for example I see
> no "InnoDB: Starting shutdown..." info logged by mysqld.
> 
> I'm not using LDAP or NIS.
So it must be a local problem  (at least it has nothing todo with auth)

re,
 wh
> 
> Andy.
> 
> 
> 
> 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MySQL daemons restarting every 7 minutes

[a . smith]

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 is called from  
mysqld_safe. So that is what is restarting mysqld.


With regard to is it doing a proper shutdown, no it isn't. It restarts  
instantly when triggered by a remote connection, and for example I see  
no "InnoDB: Starting shutdown..." info logged by mysqld.


I'm not using LDAP or NIS.

Andy.




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MySQL daemons restarting every 7 minutes

[a . smith]

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 a remote connect  
from another server...


reproduceable or was it a lucky hit once?

if mysqld crashs ypu see normally something in the mysqld-error-log  
or in the syslog
of the machine, until now ypu provided no silngle line about a crash  
from any log


Yes its reproduceable as I mentioned. I have provided all info from  
the mysqld-error-log already, I haven't provided anything from syslog  
as there is nothing there, as I mentioned. If you don't believe me I  
can't provide it to you...





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MySQL daemons restarting every 7 minutes

[walter harms]

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 script like
>>
>> #!/bin/sh
>> echo "mysqld ..." | logger -t TEST
>>
>>
>> see what happens in /var/log/syslog (you get the idea).
>>
> 
> Hi,
> 
>   its FreeBSD so no run levels other than single user and up/multi user.
> And FreeBSD has no Solaris like SMF like monitoring of daemons so I can
> be fairly certain that the RC script is not being called by anything. I
> do use PSMON but this will advise me if its taken action, and Ive tested
> with PSMON stopped also.
> As I said I can get it to restart just by doing a remote connect from
> another server...
> 
Sorry, I am a late starter in the thread ...

What i would like to understand is:
is it a "propper" shutdown ? (So far i understand yes, so the idea of a starter 
script)
Does it concern target mysqld only ? (therefore the script)
Since my first idea was that something was calling the starter script
we will modify the dummy a bit.

 #!/bin/sh
 while true
 do
   echo "mysqld ..." | logger -t TEST
   sleep 1m
  done

This will make sure that you see a msg every minute. If you trigger something 
it will try
to kill the script.

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 ?

re,
 wh

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MySQL daemons restarting every 7 minutes

[Reindl Harald]

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 a remote server, guess what? Mysql daemons restarted in exactly the way 
> I was seeing each 7 mins, each time
> just by simply running:
> 
> mysql -h tau
> 
> 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)?

> As I said I can get it to restart just by doing a remote connect from another 
> server...

reproduceable or was it a lucky hit once?

if mysqld crashs ypu see normally something in the mysqld-error-log or in the 
syslog
of the machine, until now ypu provided no silngle line about a crash from any 
log






signature.asc
Description: OpenPGP digital signature

Re: MySQL daemons restarting every 7 minutes

[a . smith]

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 happens in /var/log/syslog (you get the idea).



Hi,

  its FreeBSD so no run levels other than single user and up/multi  
user. And FreeBSD has no Solaris like SMF like monitoring of daemons  
so I can be fairly certain that the RC script is not being called by  
anything. I do use PSMON but this will advise me if its taken action,  
and Ive tested with PSMON stopped also.
As I said I can get it to restart just by doing a remote connect from  
another server...


Andy.




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MySQL daemons restarting every 7 minutes

[walter harms]

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, dropped em all and the
> issue persisted.
> I stopped crond, even tho Id already looked in crontab and was satisfied
> it wasn't the culprit. Problem persisted.
> I then removed the mysql data dir, and my.cnf and restarted with a blank
> config. Problem still persisted.
> Turned on the general log, nothing happening (as nothing legit was still
> pointing to the DB on this server). Problem persisted.
> 
> 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 a remote server, guess what? Mysql
> daemons restarted in exactly the way I was seeing each 7 mins, each time
> just by simply running:
> 
> mysql -h tau
> 
> Odd that, so I added a mysql specific line to the hosts.allow (which is
> not necessary as all services are blocked on the last line anyway).
> Tested that, no no more crashing. Odd!
> The hosts.allow file is the stock FreeBSD updated to not allow all:all
> and to use denyhosts (ssh blocked).
> 
> Additional info, using tcpdump I could see that the every 7 min crashes
> were not in fact caused by any connections from other hosts, MySQL was
> crashing regardless.
> 


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 happens in /var/log/syslog (you get the idea).

re,
 wh




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MySQL daemons restarting every 7 minutes

[a . smith]

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 tho Id already looked in crontab and was  
satisfied it wasn't the culprit. Problem persisted.
I then removed the mysql data dir, and my.cnf and restarted with a  
blank config. Problem still persisted.
Turned on the general log, nothing happening (as nothing legit was  
still pointing to the DB on this server). Problem persisted.


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 a remote server, guess what? Mysql  
daemons restarted in exactly the way I was seeing each 7 mins, each  
time just by simply running:


mysql -h tau

Odd that, so I added a mysql specific line to the hosts.allow (which  
is not necessary as all services are blocked on the last line anyway).  
Tested that, no no more crashing. Odd!
The hosts.allow file is the stock FreeBSD updated to not allow all:all  
and to use denyhosts (ssh blocked).


Additional info, using tcpdump I could see that the every 7 min  
crashes were not in fact caused by any connections from other hosts,  
MySQL was crashing regardless.


Still don't know why this would suddenly appear as an issue, or why I  
don't see this issue on other identically configured servers... :S


thanks Andy.




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MySQL daemons restarting every 7 minutes

[Reindl Harald]

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...

Am 10.09.2011 06:33, schrieb Singer X.J. Wang:This doesn't look like a MySQL 
issue. Verify that there's no rogue
scripts that shutdowns MySQL...


On Fri, Sep 9, 2011 at 13:07, mailto:a.sm...@ukgrid.net>> 
wrote:

No need for that really is there? I posted what was requested.
The part for the shutdown:

110909 17:27:31  InnoDB: Starting shutdown...
110909 17:27:32  InnoDB: Shutdown completed; log sequence number 1589339
110909 17:27:32 [Note] /usr/local/libexec/mysqld: Shutdown complete

110909 17:27:32 mysqld_safe mysqld from pid file /var/db/mysql/tau.pid ended

110909 17:27:35 mysqld_safe Starting mysqld daemon with databases from 
/var/db/mysql
110909 17:27:35 InnoDB: The InnoDB memory heap is disabled
110909 17:27:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins
110909 17:27:35 InnoDB: Compressed tables use zlib 1.2.3
110909 17:27:35 InnoDB: Initializing buffer pool, size = 2.0G
110909 17:27:36 InnoDB: Completed initialization of buffer pool
110909 17:27:36 InnoDB: highest supported file format is Barracuda.
110909 17:27:36  InnoDB: Waiting for the background threads to start
110909 17:27:37 InnoDB: 1.1.8 started; log sequence number 1589339
110909 17:27:37 [Note] Slave SQL thread initialized, starting replication 
in log 'mysql-bin.002830' at position
293541, relay log './tau-relay-bin.000920' position: 253
110909 17:27:37 [Note] Event Scheduler: Loaded 0 events
110909 17:27:37 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.5.15'  socket: '/tmp/mysql.sock'  port: 3306  Source 
distribution
110909 17:27:37 [Note] Slave I/O thread: connected to master 
'slave_user@kappa:3306',replication started in log
'mysql-bin.002830' at position 293541







-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=w...@singerwang.com





signature.asc
Description: OpenPGP digital signature

Re: Binary builds for AIX

[walter harms]

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 best */
3. make
if it complains try to fix it
4. make check
/* i do not remember the exact target but this runs the test
and should also be found with INSTALL
*/
5. make install
note that you still have to make sure that the db will start at boot

do not blame me if something fails, i have not used AIX since 4.1.

re,
 wh


Am 09.09.2011 17:22, schrieb Peter Gershkovich:
> I noticed that there is no binary builds for AIX any more. 
> What would be the best way to install a current version of MySQL (5.5)  on 
> AIX?
> Specifically I am looking for instructions for AIX 6.1 and/or 7.1 
> Thanks,
> Peter
> 
>  

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MySQL daemons restarting every 7 minutes

[a . smith]

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://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Update on inner join - looks good to me, where did I go wrong?

[Dotan Cohen]

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://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org