On Jan 10, 2008 3:24 PM, rob_mazur <[EMAIL PROTECTED]> wrote: > > On Jan 10, 2:51 pm, "David Grant" <[EMAIL PROTECTED]> wrote: > > I would work on it the other way around...tell mysql to put it's socket > > somewhere else... I'd be surprised if Suse's mysql package would put it > in > > /tmp by default. Maybe that's where your compiled version of mysql was > > putting it (might make sense, then the compiled mysql versions would > collide > > with other installed vesions). Remove the mysql rpm, delete /etc/mysql > (or > > similar, if it exists), then reinstall the rpm. > > > > Dave > > Yes, my MySQL binary installation is putting it in /tmp, you are > correct. I do not have a MySQL instance installed via RPM. > > I am reluctant to change my MySQL config to relocate mysql.sock, > because I have other apps (Java, Ruby, Perl) dependant on my existing > MySQL install(s)...not only on my devel boxes, but in production > (should I ever get that far in my Python venture). Though, I really > doubt it would cause a problem. But I bet my mysql command line > client would not like it being moved though when I try to connect to > MySQL without a host directive. > > I think that Django looks for the socket file only if it knows that it > is trying to connect to a local MySQL instance. So what I did was > change in settings.py: > DATABASE_HOST = 'localhost' > ...to... > DATABASE_HOST = '192.168.0.100' > > ...which is in fact the ip address of my current del box, and it seems > fine and working now. Again, I am still in the mode of pasting things > together to understand how it works, and then I will make some better > config decisions. > > I still want to know (some day) why the compiled version of MySQLdb > ins't working. Because if I ever need something newer than v. 1.2.0, > I will be stuck. Seems there are plenty of people having trouble with > that, but few-to-no solutions. At least, none that I am seeing right > now. > > Good thinking, changing it to an IP, I wouldn't have thought of that. If you want to be able to get whatever versions you want of packages try installing Gentoo. My only remaining gentoo box has an old mysql version (4.x) an old glibc, an an old gcc (3.x), and everything else including the kernel is very new. Try doing that with ubuntu or suse. (this is way off topic now for django-users so I apologize)
-- David Grant http://www.davidgrant.ca --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
