Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Henrik on April 18, 2001, 03:31:57 PM

Title: Think I screwed up Mysql...
Post by: Henrik on April 18, 2001, 03:31:57 PM

Hi!
I tried to install PHP Nuke and played around a little bit with mysql. I saw some earlier post on how to install php nuke and how to create a user in mysql... I tried a little bit but did'nt have any luck. I didn't put much energy to it because I hadn't time to RTFM and didn't find any easy docs on how to install php nuke... So I gave up pretty quick :-)

Now I noticed that I cannot reach my webmail anymore... I get this message:
Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /home/httpd/horde-phplib/db_mysql.inc on line 73

I think I created a user and changed password, because I can't acsses mysqladm anymore :-(

So my stupid question is if there is a way to reset all changes in mysql and get back to normal again? I know I haven't explained this so good but any hints would be nice...

Thanks,
Henrik

Title: Re: Think I screwed up Mysql...
Post by: Alejandro on April 18, 2001, 09:17:52 PM

Henrick
if you think your question is stupid wait to hear this answer:

you could try with a reinstalation disk (create one just now, to keep all accounts ibays and so....) and do a desktop pc backup of your server.
then  reintall it with that disk and restore the backup from the desktop pc.
it would bring up a "factory default" server but with all data and account info you have just now, the only loose is updates and additional software you have added to your box, (if you are interested in some statics you should save manually log files etc.
)

the hole process takes only 45 min and is a good way to repair unknown modified files

hoping be stupid enough! ;)
alejandro

Title: Re: Think I screwed up Mysql...
Post by: Henrik on April 18, 2001, 09:47:17 PM

I have too much software and stuff that I don't want to loose... is there a way to just reset mysql?

Title: Re: Think I screwed up Mysql...
Post by: Dan Brown on April 18, 2001, 09:55:45 PM

http://www.mysql.com/documentation/mysql/bychapter/manual_Problems.html#Resetting_permissions

Title: Re: Think I screwed up Mysql...
Post by: Sergei Slobodov on May 23, 2001, 07:06:59 AM

I have noticed an error similar to this ("Error ...blah.. in /home/httpd/horde-phplib/db_mysql.inc on line 73") after editing php.ini with pico from command line. It turns out, pico helpfully wraps lines at column 80 by default, confusing php completely. After I unwrapped the long lines (with vi or mc edit, or even pico itself), the error disappeared. Wasted a few hours before I figured that out.

The error message is even more confusing because the problem is in php setup, not in mysql, so reinstalling mysql doesn't help a bit.

Hope this post will save somebody a few frustrating hours.

Sergei

Title: Re: Think I screwed up Mysql...
Post by: Erik on January 09, 2002, 03:44:49 AM

Hi Sergei,

I have just experienced the same problem. Quick question; how do you unwrap lines using PICO.

Thanks for any help, this problem has driven me crazy for the better part of the day seeing as there are 75 email accounts on the server.

Best,
Erik

Title: Re: Think I screwed up Mysql...
Post by: Dan Brown on January 09, 2002, 03:52:15 AM

Well, pico -w [filename] will let you edit a file without wrapping lines.  If you have a file that's already wrapped and you want to unwrap it, you'd have to do it manually.

Title: Re: Think I screwed up Mysql...
Post by: Erik on January 09, 2002, 04:19:59 AM

This is probably a very silly question, but how do I know if the lines are wrapped in pico?