On Thu, 2005-06-16 at 09:22 +0200, Per Engelbrecht wrote: > James Strandboge wrote: > > On Wed, 2005-06-15 at 11:30 +0200, Nico Meijer wrote: > > > >>Hi Kiraly, > >> > >> > >>>mysql error: Can't create/write to file '/tmp/ > >>>#sql_4c99_0.MYD' (Errcode: 9) > >> > >>MySQL problem. > >> > >>Simple suggestions, not idiot-proof: > > > > > > I prefer this on OpenBSD 3.6 (should be same on 3.7): > > > > Add to /etc/login.conf: > > # > > # for mysql to work right > > # > > mysql:\ > > :datasize=infinity:\ > > :maxproc=infinity:\ > > :openfiles-cur=2048:\ > > :openfiles-max=8192:\ > > :stacksize-cur=8M:\ > > :localcipher=blowfish,8:\ > > :tc=default: > > > > sudo vipw and change the login class for _mysql to 'mysql'. > > Hmm .. why don't you just add a _mysql loginprofile in login.conf in the > first place instead of adding "oldstyle" mysql and then change pw db. > Seems backwards to me.
I don't know how it is on 3.7 (like I said, this is on 3.6), but you have to update master.passwd with the new login class, since the default _mysql user doesn't have a login class specified. Whether you name that class in login.conf 'mysql' or '_mysql' is a matter of preference (though admittedly '_mysql' looks better). Jamie
