Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / lazarus / 2011-05

wiki.lazarus.freepascal.org have problem with mysql connection

13 messages · 6 people · –

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

ik

Hello,

I have tried to access the wiki, and it gives the following error message: Lazarus-ccr has a problem

*Sorry! This site is experiencing technical difficulties.*

Try waiting a few minutes and reloading.

(Can't contact the database server: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (localhost))

This is on the wiki.lazarus.freepascal.org domain.

Ido

LINESIP - Opening the source for communication
http://www.linesip.com
http://www.linesip.co.il
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20110502/52b2b028/attachment.html>

Reply by email

Graeme Geldenhuys
to ik
ik wrote
(Can't contact the database server: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (localhost))

I can confirm this problem. They should have used Firebird RDBMS instead. ;-)

Regards,
- Graeme -

fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal http://fpgui.sourceforge.net/

Reply by email

Florian Klaempfl
to Graeme Geldenhuys
Graeme Geldenhuys wrote 8 lines
On 02/05/2011 18:15, ik wrote: > > (Can't contact the database server: Can't connect to local MySQL server > through socket '/var/run/mysqld/mysqld.sock' (2) (localhost)) I can confirm this problem. They should have used Firebird RDBMS instead. ;-)

Won't help in case of a corrupted file system ;)

Reply by email

Graeme Geldenhuys
to Florian Klaempfl
Florian Klaempfl wrote
Won't help in case of a corrupted file system ;)

Ever heard of backups? ;-)

All our servers have the following setup that works very well for us: An OS drive (only contains the OS - in our case Linux), and all data is stored on a separate RAID disk set (two or more drives with mirroring enabled). Replacing/Reinstalling the OS takes 30 minutes, restoring config files takes <5 minutes. A faulty RAID disk is simply a swap-out and it rebuilds itself. Each Friday one RAID disk gets swapped with an off-site spare disk. You only need to loose data once, then you learn to protect it like crazy. ;-)

Regards,
- Graeme -

fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal http://fpgui.sourceforge.net/

Reply by email

ik
to Graeme Geldenhuys
Graeme Geldenhuys wrote 15 lines
On 03/05/2011 13:14, Florian Klaempfl wrote: > > Won't help in case of a corrupted file system ;) Ever heard of backups? ;-) All our servers have the following setup that works very well for us: An OS drive (only contains the OS - in our case Linux), and all data is stored on a separate RAID disk set (two or more drives with mirroring enabled). Replacing/Reinstalling the OS takes 30 minutes, restoring config files takes <5 minutes. A faulty RAID disk is simply a swap-out and it rebuilds itself. Each Friday one RAID disk gets swapped with an off-site spare disk. You only need to loose data once, then you learn to protect it like crazy. ;-)

Raid is not a backup, it can still screw everything up. If you have invalid buffer content, it will just be copied to all of the other disks. For storage you have other types to work with such as NAS and SAN.

Show quoted text 10 lines
Regards, - Graeme - -- fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal http://fpgui.sourceforge.net/

Ido

Show quoted text 7 lines
-- _______________________________________________ Lazarus mailing list http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20110503/93d3b256/attachment.html>

Reply by email

Florian Klaempfl
to Graeme Geldenhuys: Ever heard of backups? ;-) All our servers have the following setup that works very well…
Graeme Geldenhuys wrote 5 lines
On 03/05/2011 13:14, Florian Klaempfl wrote: > > Won't help in case of a corrupted file system ;) Ever heard of backups? ;-)

We have daily backups but it was not needed to restore a backup, but linux remounted the fs read-only so mysql stopped obviously to work ...

Show quoted text 9 lines
All our servers have the following setup that works very well for us: An OS drive (only contains the OS - in our case Linux), and all data is stored on a separate RAID disk set (two or more drives with mirroring enabled). Replacing/Reinstalling the OS takes 30 minutes, restoring config files takes <5 minutes. A faulty RAID disk is simply a swap-out and it rebuilds itself. Each Friday one RAID disk gets swapped with an off-site spare disk. You only need to loose data once, then you learn to protect it like crazy. ;-)

Well, you can loose the data of one week in the scenario of a corrupted file system.

Reply by email

Graeme Geldenhuys
to ik: Raid is not a backup, it can still screw everything up. If you have invalid buffer…
ik wrote
Raid is not a backup, it can still screw everything up. If you have invalid buffer content, it will just be copied to all of the other disks. For storage you have other types to work with such as NAS and SAN.

True, and why we have off-site backups as well. But a high quality disk controller [and other hardware too], and file systems with parity checking built-in (think ZFS, Btrfs etc) goes a long way to prevent issues as you describe.

As for Florian's issue with the "corrupted file system". I would highly suggest he investigates why the problem occurred in the first place, so that it can _truly_ be fixed. The wonderful world of Windows Administrators have corrupted the minds of so many system admins with the advice: "reboot and the problem should be fixed". That's the worst advice ever, and it fixes nothing!

Paul Venezia said it best: "When in doubt, reboot? Not Unix boxes" http://www.infoworld.com/t/unix/when-in-doubt-reboot-not-unix-boxes-061

Regards,
- Graeme -

fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal http://fpgui.sourceforge.net/

Reply by email

Florian Klaempfl
to Graeme Geldenhuys
Graeme Geldenhuys wrote
As for Florian's issue with the "corrupted file system". I would highly suggest he investigates why the problem occurred in the first place, so that it can _truly_ be fixed.

The machine suffered multiple UPS failures recently and one suspision is that the fsck run did not find all errors. Further, it is a years old Ubuntu 6.06 LTS install which ran first on a physical machine and later on the image was imported into a xen vm. Moving all services to another vm with a fresh and new ubuntu install (windows trick ;)) is on our todo list. But you know ...

Show quoted text 13 lines
The wonderful world of Windows Administrators have corrupted the minds of so many system admins with the advice: "reboot and the problem should be fixed". That's the worst advice ever, and it fixes nothing! Paul Venezia said it best: "When in doubt, reboot? Not Unix boxes" http://www.infoworld.com/t/unix/when-in-doubt-reboot-not-unix-boxes-061 Regards, - Graeme -

Reply by email

Graeme Geldenhuys
to Florian Klaempfl
Florian Klaempfl wrote
The machine suffered multiple UPS failures recently and one suspision is that the fsck run did not find all errors.

In 2008/9 we had serious amounts of power failures (rolling blackouts) - thanks to our corrupt government. We switched all our servers to using JFS, as our internal testing proved it to be most resilient to various types of failures (disclaimer: that was our conclusion, but others may differ - rather do your own testing).

Further, it is a years old Ubuntu 6.06 LTS install which ran first on a physical machine and later

:-) Our motto is if it ain't broken, don't fix it! All our Linux servers still run Ubuntu 6.06 LTS and they are rock solid.

Regards,
- Graeme -

fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal http://fpgui.sourceforge.net/

Reply by email

waldo kitty
to Graeme Geldenhuys: I can confirm this problem. They should have used Firebird RDBMS instead. ;-) - Graeme -…
Graeme Geldenhuys wrote 8 lines
On 02/05/2011 18:15, ik wrote: > > (Can't contact the database server: Can't connect to local MySQL server > through socket '/var/run/mysqld/mysqld.sock' (2) (localhost)) I can confirm this problem. They should have used Firebird RDBMS instead. ;-)

and, FWIW, no database backend for internet stuffings should ever be accessed on localhost... database servers should reside on a backend server separate from the frontend server(s)... from a security standpoint, running a database server on the same machine as the frontend is just very very very bad juju that could lead to a security nightmare :?

Reply by email

Florian Klämpfl
to waldo kitty
waldo kitty wrote 16 lines
On 5/3/2011 04:49, Graeme Geldenhuys wrote: > On 02/05/2011 18:15, ik wrote: >> >> (Can't contact the database server: Can't connect to local MySQL server >> through socket '/var/run/mysqld/mysqld.sock' (2) (localhost)) > > > I can confirm this problem. They should have used Firebird RDBMS > instead. ;-) and, FWIW, no database backend for internet stuffings should ever be accessed on localhost... database servers should reside on a backend server separate from the frontend server(s)... from a security standpoint, running a database server on the same machine as the frontend is just very very very bad juju that could lead to a security nightmare :?

We are still waiting for volounteer full time admins to pop up not only doing the work for free but also supplying machines for free so we can follow all good practice rules regarding backups, redundancy etc.

Reply by email

ik
to Florian Klämpfl
Florian Kl?mpfl wrote 22 lines
Am 03.05.2011 21:54, schrieb waldo kitty: > On 5/3/2011 04:49, Graeme Geldenhuys wrote: >> On 02/05/2011 18:15, ik wrote: >>> >>> (Can't contact the database server: Can't connect to local MySQL server >>> through socket '/var/run/mysqld/mysqld.sock' (2) (localhost)) >> >> >> I can confirm this problem. They should have used Firebird RDBMS >> instead. ;-) > > and, FWIW, no database backend for internet stuffings should ever be > accessed on localhost... database servers should reside on a backend > server separate from the frontend server(s)... from a security > standpoint, running a database server on the same machine as the > frontend is just very very very bad juju that could lead to a security > nightmare :? We are still waiting for volounteer full time admins to pop up not only doing the work for free but also supplying machines for free so we can follow all good practice rules regarding backups, redundancy etc.

I'm willing to add a mirror at one of the VPS that I have if you are interested.

Show quoted text 7 lines
-- _______________________________________________ Lazarus mailing list http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus

Ido

LINESIP - Opening the source for communication
http://www.linesip.com
http://www.linesip.co.il
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20110504/13bf1030/attachment.html>

Reply by email

Helmut Hartl
to Florian Klämpfl: We are still waiting for volounteer full time admins to pop up not only doing the work…
Florian Kl?mpfl wrote 17 lines
Am 03.05.2011 21:54, schrieb waldo kitty: > On 5/3/2011 04:49, Graeme Geldenhuys wrote: >> On 02/05/2011 18:15, ik wrote: >>> (Can't contact the database server: Can't connect to local MySQL server >>> through socket '/var/run/mysqld/mysqld.sock' (2) (localhost)) >> >> I can confirm this problem. They should have used Firebird RDBMS >> instead. ;-) > and, FWIW, no database backend for internet stuffings should ever be > accessed on localhost... database servers should reside on a backend > server separate from the frontend server(s)... from a security > standpoint, running a database server on the same machine as the > frontend is just very very very bad juju that could lead to a security > nightmare :? We are still waiting for volounteer full time admins to pop up not only doing the work for free but also supplying machines for free so we can follow all good practice rules regarding backups, redundancy etc.

Regarding machines:
We still offer virtual machines at http://fpcfun.firmos.at/node/1 on this machine http://fpcfun.firmos.at/node/4.
We have some 4TB of free space on a FreeBSD NAS
And 100 MBit/ symmetrical up and downlink in a datacenter. Theoretically our bandwith usage is unlimited.
But of course the content must be fully legal.
(even a mail misconfiguration and a abuse report can *theoretically* lead to a downtake from our isp)

What I / We cannot offer at the moment is realistic full time admin support. We can however help with admin task but only on FreeBSD machines. (Less maintenance neccessary out of the box and KnowHow,Stability).

So the machines are in principle only usable for willing and trustworthy admins.

Currently we host msegui.org / lazarus.firmos.at (forum) / zeos.firmos.at and various build and test machines.

helmut

Reply by email