bugGNU Thales - Bugs: bug #9301, Using a remote MySQL server makes...

 
 

bug #9301: Using a remote MySQL server makes thales lose reliability.

Submitted by:  None
Submitted on:  Fri 11 Jun 2004 12:50:08 PM UTC  
 
Category: NoneSeverity: 3 - Normal
Item Group: NoneStatus: Wont Fix
Privacy: PublicAssigned to: None
Open/Closed: Closed

Add a New Comment(Rich Markup)
   

You are not logged in

Please log in, so followups can be emailed to you.

 

Wed 30 Jun 2004 04:44:28 PM UTC, comment #4:

Closing this bug. Using a remote MySQL server is just a bad idea.

Lucas Nussbaum <lnu>
Project Member
Tue 29 Jun 2004 10:50:14 AM UTC, comment #3:

Have a look at the db.c file and to db_connecto() .
But i don't think this will work, because each time thales links to the network, his uplink sends him all necessery informations to fill the database. It will have loads of duplicate entries, and fuck all your database, in fact i think thales should die instead of destroying your computer :)

Hervé Rousseau <munsternet>
Project Member
Thu 17 Jun 2004 05:11:26 PM UTC, comment #2:

Okey,...

Next question

How can i change Thales, so it would not clean the DB at startup. because its going down very often, and i want to keep track of stuff, but now it cleaning the DB at evry startup.

Dennis <fr33man>
Sat 12 Jun 2004 06:48:01 AM UTC, comment #1:

Are you running MySQL on the same box as Thales ? if not, it might not work very well, since Thales is very mysql-expensive.

Anonymous
Fri 11 Jun 2004 12:50:08 PM UTC, original submission:

I get this verry often, and thales goes down then.
I use Unreal 3.2 and Auspices Services.

[Jun 11 14:27:36.117356 2004] >SQL : INSERT INTO user (nick, realname, hostname, hiddenhostname, username, connecttime, servid) VALUES('Aloys','BorgIRC NL user','62-177-249-86.static.bbeyond.nl','*','Aloys',FROM_UNIXTIME('1086956757'),'2881')
[Jun 11 14:27:36.117468 2004] IRC context : NICK Aloys 2 1086956757 Aloys 62-177-249-86.static.bbeyond.nl irc.chatvalley.nl 0 +iwx * :BorgIRC NL user
[Jun 11 14:27:36.117490 2004] FATAL: Query failed: Lost connection to MySQL server during query
[Jun 11 14:27:36.117536 2004] >IRC : chatstats.0n-the.net GLOBOPS :FATAL ERROR! Query failed: Lost connection to MySQL server during query (IRC context : NICK Aloys 2 1086956757 Aloys 62-177-249-86.static.bbeyond.nl irc.chatvalley.nl 0 +iwx * :BorgIRC NL user)

it looks like the mysql is down, but that isnt the case.

plz help
because i realy want to use thales.

Anonymous

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach File(s):
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follow 3 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Wed 30 Jun 2004 04:44:28 PM UTClnuStatusNone=>Wont Fix
  Open/ClosedOpen=>Closed
  SummaryFATAL ERROR!=>Using a remote MySQL server makes thales lose reliability.

Back to the top


Powered by Savane 3.1-cleanup1