Hi!

John> Hi Monty, John> Got another incident of interest for you.

John> This morning 2 users complained that they could not login. John> They would see a "login error" message fed to them by John> their VB front end. This could be because of an error John> on connecting, or on an error during our custom login John> procedures where the program issues John> "select * from dm.users where A0 = '" & sUserName & "'" John> "use debtman"

John> On looking at "show processlist;", part only pasted below, John> I saw something interesting. John> Both users "janish" and "hellenr" are shown as connected, John> and they are shown as connecting at almost the same time: John> 1230 seconds ago and 1229 seconds ago. John> Does mysql have any known problems with 2 users John> logging in at the same moment in time ?

No. There is no restriction in how many times a user can be connected.

John> | 680 | lesterm | CLIENT4 | debtman | Sleep | 125 | NULL | NULL John> | John> | 681 | hazel | PC5A | debtman | Sleep | 1305 | NULL | NULL John> | John> | 682 | karlenep | CLIENT17 | debtman | Sleep | 1005 | NULL | NULL John> | John> | 683 | traceyo | PC19R | debtman | Sleep | 656 | NULL | NULL John> | John> | 684 | janish | PC13R | dm | Sleep | 1230 | NULL | NULL John> | John> | 685 | hellenr | CLIENT20 | dm | Sleep | 1229 | NULL | NULL John> | John> | 688 | jeffu | localhost | debtman | Sleep | 969 | NULL | NULL John> | John> | 690 | root | | mysql | Query | 0 | NULL | show
processli John> st |

Exactly what error did they get from MySQL when this happened?

By the way, we did release 3.23.18 a couple of days ago. Any change you can test this if this version works better for you?

Regards, Monty