Paranoid and MySQL problem

Spam-detecting plug-in
Junior Member
Posts: 118
Joined: Thu Nov 15, 2007 12:02 pm
Location: Townsville, Australia

Paranoid and MySQL problem

Postby Stuart » Sat Sep 10, 2011 7:28 am

My server suffered a power outage and we had some MySQL problems relating to web databases. Paranoid has been affected and stopped working.

I tried reinstalling Paranoid with the existing database, and then a fresh install with the original database dropped. In both cases I get the errors on the attached files. When doing a fresh install Paranoid does not seem to be able to create a new database for itself.

I have restarted MySQL and rebooted the server but nothing seems to work. I updated MySQL to 5.5.15 if that could be causing any of this. I have been able to install new databases for other applications so MySQL is working. I have no idea what to do next so any thoughts would be a great help.

Stuart
Attachments
Paranoid v3 Error 1.jpg
Paranoid v3 Error.jpg
Stuart

Server 2003 R2 Std | hMailserver 5.3.4-B1913 | MySQL 5.5.19 | Apache 2.2.17 | PHP 5.3.5 | eWall 4.0.2.31 | Paranoid 3.0.18 |

Developer
User avatar
Posts: 4431
Joined: Tue Apr 20, 2004 3:43 pm

Postby Alexander Telegin » Sun Sep 11, 2011 8:31 am

It seems like Paranoid database was corrupted. I'd recommend repair with "mysqlcheck" command-line tool available with MySQL setup. You need to invoke two commands

Code: Select all
mysqlcheck -r paranoid
mysqlcheck -o paranoid


Also, Paranoid was tested with MySQL 4.x and I can't guarantee it works with 5.x.

Junior Member
Posts: 118
Joined: Thu Nov 15, 2007 12:02 pm
Location: Townsville, Australia

Postby Stuart » Sun Sep 11, 2011 11:36 am

Hi Alex

We have used MySQL 5 to run Paranoid for several years and have not had a problem until now. The commands do not work as after I run them I get;
Error 1064 (42000): You have an error in your SQL syntax:

I also tried "mysqlcheck -p --repair paranoid;" but got the same error message. I have not been able to work out what the correct syntax is for MySQL 5.5.15.
Stuart

Server 2003 R2 Std | hMailserver 5.3.4-B1913 | MySQL 5.5.19 | Apache 2.2.17 | PHP 5.3.5 | eWall 4.0.2.31 | Paranoid 3.0.18 |

Developer
User avatar
Posts: 4431
Joined: Tue Apr 20, 2004 3:43 pm

Postby Alexander Telegin » Sun Sep 11, 2011 12:09 pm

mysqlcheck is not a SQL command, this is command-line tool. I can check your system remotely if you wish.

Junior Member
Posts: 118
Joined: Thu Nov 15, 2007 12:02 pm
Location: Townsville, Australia

Postby Stuart » Sun Dec 11, 2011 2:40 am

Hi Alex

The server went down again and I am having the same problem with the "Bad Handshake" in the first image above but not the second.

I have run;
mysqlcheck -r paranoid -u root -p, and
mysqlcheck -o paranoid -u root -p

The checks all showed up as being OK.

Can you remember how you got it started previously.

Stuart
Stuart

Server 2003 R2 Std | hMailserver 5.3.4-B1913 | MySQL 5.5.19 | Apache 2.2.17 | PHP 5.3.5 | eWall 4.0.2.31 | Paranoid 3.0.18 |

Developer
User avatar
Posts: 4431
Joined: Tue Apr 20, 2004 3:43 pm

Postby Alexander Telegin » Sun Dec 11, 2011 5:20 am

If I remember correctly I dropped MySQL dll into Paranoid directory.

Junior Member
Posts: 118
Joined: Thu Nov 15, 2007 12:02 pm
Location: Townsville, Australia

Postby Stuart » Sun Dec 11, 2011 8:42 am

Hi Alex

I dropped "libmysql.dll" into the "paranoid" directory and I could start the service without any problem.

Thanks
Stuart:)
Stuart

Server 2003 R2 Std | hMailserver 5.3.4-B1913 | MySQL 5.5.19 | Apache 2.2.17 | PHP 5.3.5 | eWall 4.0.2.31 | Paranoid 3.0.18 |

Junior Member
Posts: 118
Joined: Thu Nov 15, 2007 12:02 pm
Location: Townsville, Australia

Postby Stuart » Thu Dec 15, 2011 7:51 am

I spoke too soon. When I added the libmysql.dll into the Paranoid directory I was then able to start the Paranoid service which was more than I could do before.

I am still unable to open Paranoid, when I try I get the Bad handshake error that I was getting before. Any thoughts on what I can try next?
Stuart

Server 2003 R2 Std | hMailserver 5.3.4-B1913 | MySQL 5.5.19 | Apache 2.2.17 | PHP 5.3.5 | eWall 4.0.2.31 | Paranoid 3.0.18 |

Developer
User avatar
Posts: 4431
Joined: Tue Apr 20, 2004 3:43 pm

Postby Alexander Telegin » Thu Dec 15, 2011 8:05 am

Stuart, you probably re-installed Paranoid and overwrote the custom version I installed. Please try version below, it has support for libmysql.dll:

http://downloads.sssolutions.net/Pnd3.0.18c.zip

Junior Member
Posts: 118
Joined: Thu Nov 15, 2007 12:02 pm
Location: Townsville, Australia

Postby Stuart » Thu Dec 15, 2011 8:57 am

Hi ALex

When I put these files into the Paranoid directory it started immediately. I can now access Pananoid and it is working happily with eWall again.

Thanks
Stuart

Server 2003 R2 Std | hMailserver 5.3.4-B1913 | MySQL 5.5.19 | Apache 2.2.17 | PHP 5.3.5 | eWall 4.0.2.31 | Paranoid 3.0.18 |

Next

Return to Paranoid - General

Who is online

Users browsing this forum: No registered users and 1 guest