Re: Email Issues (was: Installing mysqldump)

2013-08-16 Thread Chris Bannister
On Wed, Aug 14, 2013 at 01:49:32AM +0200, Ralf Mardorf wrote:
 On Tue, 2013-08-13 at 17:14 -0600, Bob Proulx wrote:
  I don't know how well the box drawing characters will come through
 
 Perfectly here :).
 
5496 r  Aug09 Ethan Rosenberg (1.2K) Installing mysqldump
5497Aug09 Gary Roach  (1.7K) ├─
5498Aug09 To debian-user@ (2.4K) ├─
5499Aug10 Lisi Reisz  (1.3K) │ ├─
5500Aug11 Ethan Rosenberg (2.9K) │ ├─
5501Aug11 Lisi Reisz  (1.7K) │ │ ├─
5502Aug11 Ethan Rosenberg (2.0K) │ │ └─
5503Aug11 Ethan Rosenberg (0.8K) │ └─
5504Aug12 The_Ace (1.7K) │   ├─
5505 r  Aug12 Ethan Rosenberg (1.1K) │   └─
5506Aug12 To debian-user@ (1.6K) │ ├─
5507 r  Aug13 Ethan Rosenberg (2.5K) │ └─
5508Aug12 To debian-user@ (3.1K) │   ├─
5509 N  Aug13 Ethan Rosenberg (7.2K) │   └─
5510 N  Aug13 To debian-user@ (5.9K) │ └─
5511Aug11 Ethan Rosenberg (2.0K) └─
 
 
  I am sure this sounds critical.  Don't take it harshly.
 
 It's helpful for Ethan. Often I don't have the time to encrypt the
 jigsaw puzzle mails, maybe it's to time consuming for others too.

I presume you mean decrypt, but yes that is true, too hard to read, so
easy to delete.

-- 
If you're not careful, the newspapers will have you hating the people
who are being oppressed, and loving the people who are doing the 
oppressing. --- Malcolm X


-- 
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Archive: http://lists.debian.org/20130816085155.GH3771@tal



Re: Email Issues (was: Installing mysqldump)

2013-08-16 Thread Ralf Mardorf
On Fri, 2013-08-16 at 20:51 +1200, Chris Bannister wrote:
 On Wed, Aug 14, 2013 at 01:49:32AM +0200, Ralf Mardorf wrote:
  On Tue, 2013-08-13 at 17:14 -0600, Bob Proulx wrote:
   I am sure this sounds critical.  Don't take it harshly.
  
  It's helpful for Ethan. Often I don't have the time to encrypt the
  jigsaw puzzle mails, maybe it's to time consuming for others too.
 
 I presume you mean decrypt, but yes that is true, too hard to read, so
 easy to delete.

Oops :D.


-- 
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Archive: http://lists.debian.org/1376661094.690.31.camel@archlinux



Re: Quoting Style Re: Installing mysqldump

2013-08-15 Thread Lisi Reisz
Sorry, Ethan.  I don't normally keep doing this. :-(
Sent to list where it should have been in the first place.

On Wednesday 14 August 2013 17:35:07 Ethan Rosenberg, PhD wrote:
 Dear List -

 I appreciate your CONSTRUCTIVE criticism.  I surely do not wish to have
 my posts unanswered.

 Introduction -

 Industrial standard I think is, top quoting and styled email. This is
 the way my Thunderbird is set.  Mail list requirements are the reverse
 as I well know.  Therefore, I have to adjust Thunderbird to these
 requirements.

 To get unstyled, shift+write.

 Start email. Replying, unstyled, requires the send again option
 [CTRL+E]. The material above my reply is blue.

 Here is a sample email trail. Points to be noted are marked as follows

Ouch!  No!!!  Klaus explained to you how to do it at 11:12:51 today.  *Please* 
read, mark, learn and  inwardly digest.  This is *awful.*  Klaus has just 
tried again to tell you, at 22:22:08.  Please read it.  I repeat, this is 
completely unreadable.  (Literally.  I gave up trying to read it.)   If 
Icedove were set up correctly, you would also stop breaking threads.

You *must* be able to see that everyone else does it differently from you.  
Just set your email client up correctly.  You don't need to do anything else, 
except trim appropriately.  My email client, KMail 1.9.10, also has a setting 
for telling it if a folder contains a mailing list.  Icedove/Thunderbird may 
have something similar.

Lisi

  I separate emails with =
 ***
 SAMPLE EMAIL TRAIL.

 Dear List -

 I have a problem.

 TIA

 Ethan

 reply 

 Dear List -

 I have a two problems, #1 and #2

 TIA

 Ethan

 Poster1

 You shouild try A, B and C.

 HTH.

 Poster1

 note I quote the reply(s) if they are relevant.
 reply 


 Dear List -

 I have a problem.

 TIA

 Ethan

 Poster1

 You shouild try A, B and C.

 HTH.

 Poster1
 ===
 Poster1 -

 Thanks.

 A. Tried, no luck
 B. Fixed #1 only
 C  Fixed #2 only

 TIA

 Ethan
 ===
 reply
 snip

 You shouild try A, B and C.
 A. Tried, no luck
 B. Fixed #1 only
 C  Fixed #2 only

 Poster3-

 Show us logx, logy, and Logz

 HTH

 Poster3

 reply

 Poster3 -

 Thanks.

 snip

 Show us logx, logy, and Logz

 snip

 logx

 
 bla, bla bla
 

 logy

 /
 bla, ouch, bla
 /

 logz

 //
 oluch, bla, ouch.
 

 TIA

 Ethan

 **

 End of sample email trail 

 Please edit the above to the proper form.

 Ethan
 
 PS:

 Ralf -

 http://www.twitlonger.com/show/9rlesb

 PHENOMENAL


-- 
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Archive: http://lists.debian.org/201308151402.59574.lisi.re...@gmail.com



Re: Quoting Style Re: Installing mysqldump

2013-08-15 Thread Eduardo M KALINOWSKI

On Qui, 15 Ago 2013, Lisi Reisz wrote:

Just set your email client up correctly.  You don't need to do anything else,
except trim appropriately.


In the case of Icedove/Thunderbird, you don't even need to set  
anything[0]. By default it does correct quoting, you just have to  
press Reply to list (which is the default in the case of mailing  
lists), trim and add your comments. To get the weird emails Ethan  
sends, he must have (mis)configured something to different values than  
the default.


[0] Well, perhaps one needs to configure it to not send HTML, as it's  
somewhat too eager to use HTML. But this is not a problem with Ethan's  
mails.


--
%TAG%

Eduardo M KALINOWSKI
edua...@kalinowski.com.br



--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org

Archive: 
http://lists.debian.org/20130815133939.horde.jxtevmin-pawdocls4ud...@mail.kalinowski.com.br



Re: Quoting Style Re: Installing mysqldump

2013-08-15 Thread Bob Proulx
Ethan Rosenberg, PhD wrote:
 Industrial standard I think is, top quoting and styled email.

Not on technical mailing lists!  The standard is conversational
quoting.  Here are some guides that I just now found after a quick
search.

  http://www.netmeister.org/news/learn2quote.html
  http://email.about.com/cs/netiquettetips/qt/et090402.htm
  http://www.complang.tuwien.ac.at/anton/mail-news-errors.html
  http://lipas.uwasa.fi/~ts/http/quote.html
  http://www.holgermetzger.de/netscape/usenet.html
  http://catb.org/~esr/faqs/smart-questions.html

 This is the way my Thunderbird is set.  Mail list requirements are
 the reverse as I well know.  Therefore, I have to adjust Thunderbird
 to these requirements.

What version of Thunderbird are you using?  It is true that old
versions had some issues.  But if it is a recent version it should
just work.

 To get unstyled, shift+write.
 
 Start email. Replying, unstyled, requires the send again option
 [CTRL+E].

That is the root cause of the broken mail thread problems.  By
re-sending a previous message you are re-sending the previous headers
too.  This is what is causing threading to be so confused.  Now I
understand the previous thread breakage.

Please do not re-send previous messages after editing them.  Instead
simply list-reply to them.  I am pretty-sure that Thunderbird will
reply to the list appropriately.  But regardless you need to allow
Thunderbird to set up the threading properly.  Just do the normal
thing and follow-up and let Thunderbird do the right thing.

 The material above my reply is blue.

Blue?  You mean as in html email?  Colors will be lost entirely when
reading the mail as plain text.  Think about people using screen
readers.  Plain text is the standard.  I am one of many reading the
plain text content and any html color will be invisible to me.  Even
if I were reading the html I would be rendering it into a terminal and
so still would not see any colors.  And also html email is listed
specifically on the list of things not to send to the mailing list.

  http://www.debian.org/MailingLists/#codeofconduct

Bob


signature.asc
Description: Digital signature


Re: Installing mysqldump

2013-08-14 Thread Lisi Reisz
Sorry, Ethan.
On Tuesday 13 August 2013 Bob Proulx wrote:
 And your quoting is really painful.  I am sure it is not a
 problem with Thunderbird since other people use it successfully.

Please, someone who uses Thunderbird/Icedove, come to the rescue of the rest 
of us and tell Ethan how to sort his quoting out.  It is, as Bob says, 
painful.

Lisi




















On Tuesday 13 August 2013 06:03:28 Bob Proulx wrote:
 Ethan,

 I see that you are using Thunderbird.  A lot of people do.  But why
 are your messages always broken?  You never reply to the message you
 are quoting and seem to be replying to but the message before it.
 Strange.  And your quoting is really painful.  I am sure it is not a
 problem with Thunderbird since other people use it successfully.

 Ethan Rosenberg, PhD wrote:
  env COLUMNS=80 dpkg -l | grep mysql-server

 I had asked for the 'env COLUMNS=80 dpkg -l' so that the columns would
 not go out too far and would not be hard to read.

  iU  mysql-server  5.5.31+dfsg-0+wheezy1 all  
 MySQL database server (metapackage depending on the latest version) rc
   mysql-server-5.1  5.1.66-0+squeeze1 i386
  MySQL database server binaries and system database setup iF 
  mysql-server-5.5  5.5.31+dfsg-0+wheezy1 i386
  MySQL database server binaries and system database setup ii 
  mysql-server-core-5.5 5.5.31+dfsg-0+wheezy1 i386
  MySQL database server binaries

 But yours go out to column 144 so of course I know you didn't use the
 command I asked you to use.  Sigh.

 And the above clearly shows the problem.  I will chop it down.

   Desired=Unknown/Install/Remove/Purge/Hold

   | Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig
   |-pend / Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
   |
   ||/ Name   VersionDescription

  
 +++-==-==-=
=== iU  mysql-server5.5.31+dfsg-0+wheezy1
   rc  mysql-server-5.15.1.66-0+squeeze1
   iF  mysql-server-5.55.5.31+dfsg-0+wheezy1
   ii  mysql-server-core-5.5   5.5.31+dfsg-0+wheezy1

 mysql-server is Unpacked but not configured.  mysql-server-5.5 install
 is marked as Failed.  That is clearly bad.  You can't ignore these
 errors.

 I would try this first.  Needs root.

   apt-get install -f

 That should rerun the configuration of the failed packages.  Since it
 produced errors before it will probably produce errors again.  Post
 those errors.  They need to be fixed.

 After you get the new mysql server installed correctly then, and only
 then, purge the previous server.  Doing so will have the side effect
 of shutting down the server so it needs to be started again.  But
 don't do it until you have the new server installed correctly.

   dpkg --purge mysql-server-5.1
   service mysql start

 Bob


-- 
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Archive: http://lists.debian.org/201308141032.48132.lisi.re...@gmail.com



Re: Installing mysqldump

2013-08-14 Thread Klaus

On 14/08/13 10:32, Lisi Reisz wrote:

Sorry, Ethan.
On Tuesday 13 August 2013 Bob Proulx wrote:

And your quoting is really painful.  I am sure it is not a
problem with Thunderbird since other people use it successfully.


Please, someone who uses Thunderbird/Icedove, come to the rescue of the rest
of us and tell Ethan how to sort his quoting out.  It is, as Bob says,
painful.

Lisi


Ethan, Icedove should do all the quoting just fine by default. If you go 
to Edit -- Account Settings -- Composition  Addressing, put a tick mark 
into the box near Automatically quote the original message when 
replying, and select from the dropdown menu start my reply below the 
quote. That's all.


How have you included quotes in the past? Did you manually copy and 
paste them? Even that can be done, using Edit -- Paste as Quotation or 
Ctrl+Shift+O .



--
Klaus


--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org

Archive: http://lists.debian.org/520b5823.9060...@gmail.com



Re: Installing mysqldump

2013-08-14 Thread Ralf Mardorf
On Wed, 2013-08-14 at 10:32 +0100, Lisi Reisz wrote:
 Please, someone who uses Thunderbird/Icedove, come to the rescue of
 the rest of us and tell Ethan how to sort his quoting out.  It is, as
 Bob says, painful.

There isn't something to explain. I used Mozilla, Seamonkey, Thunderbird
and Icedove for many years, as for all MUAs I know, they provide reply
buttons and everything is done automagically for every Linux distro and
even for Windows.

Ethan needs to explain his work-flow when using Thunderbird, before we
could help. Perhaps there's a reason why to use the odd quotation style
that is used. I can't imagine any reason for this, so more information
is needed.

We don't need to be rescued, if it becomes to time consuming to read
Ethan's mails, we simply can ignore them. Ethan is aware that many
people are willing to help, ignoring the posting style and now there
shouldn't be any doubts that at least some of us, at very least me, stop
reading some of Ethan's mails, when it becomes to time consuming, hard
to understand.

http://www.twitlonger.com/show/9rlesb

Regards,
Ralf





-- 
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Archive: http://lists.debian.org/1376476106.1751.67.camel@archlinux



Re: Installing mysqldump

2013-08-14 Thread Ralf Mardorf
On Wed, 2013-08-14 at 11:12 +0100, Klaus wrote:
 How have you included quotes in the past? Did you manually copy and 
 paste them? Even that can be done, using Edit -- Paste as Quotation
 or Ctrl+Shift+O .

This can be done, but should be done with caution. I rarely sort my
mails by thread, but many people on this list do this by default.



-- 
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Archive: http://lists.debian.org/1376477183.1751.76.camel@archlinux



Quoting Style Re: Installing mysqldump

2013-08-14 Thread Ethan Rosenberg, PhD

Dear List -

I appreciate your CONSTRUCTIVE criticism.  I surely do not wish to have 
my posts unanswered.


Introduction -

Industrial standard I think is, top quoting and styled email. This is 
the way my Thunderbird is set.  Mail list requirements are the reverse 
as I well know.  Therefore, I have to adjust Thunderbird to these 
requirements.


To get unstyled, shift+write.

Start email. Replying, unstyled, requires the send again option 
[CTRL+E]. The material above my reply is blue.


Here is a sample email trail. Points to be noted are marked as follows 
 I separate emails with =

***
SAMPLE EMAIL TRAIL.

Dear List -

I have a problem.

TIA

Ethan

reply 

Dear List -

I have a two problems, #1 and #2

TIA

Ethan

Poster1

You shouild try A, B and C.

HTH.

Poster1

note I quote the reply(s) if they are relevant.
reply 


Dear List -

I have a problem.

TIA

Ethan

Poster1

You shouild try A, B and C.

HTH.

Poster1
===
Poster1 -

Thanks.

A. Tried, no luck
B. Fixed #1 only
C  Fixed #2 only

TIA

Ethan
===
reply
snip

You shouild try A, B and C.
A. Tried, no luck
B. Fixed #1 only
C  Fixed #2 only

Poster3-

Show us logx, logy, and Logz

HTH

Poster3

reply

Poster3 -

Thanks.

snip

Show us logx, logy, and Logz

snip

logx


bla, bla bla


logy

/
bla, ouch, bla
/

logz

//
oluch, bla, ouch.


TIA

Ethan

**

End of sample email trail 

Please edit the above to the proper form.

Ethan

PS:

Ralf -

http://www.twitlonger.com/show/9rlesb

PHENOMENAL



--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org

Archive: http://lists.debian.org/520bb1bb.5010...@hygeiabiomedical.com



Re: Quoting Style Re: Installing mysqldump

2013-08-14 Thread Ralf Mardorf
Tom wrote:
 Itchy wrote:
 Scratchy wrote:
 I'm hungry. [snip]
 I'm too.
 Let's cook Tux under the grill.

No, let's eat tofu.

Regards,
Jerry

Explaination:

First Tom wrote that he's hungry, then Itchy replied to be hungry too,
while doing this Itchy snipped irrelevant content, since Tom also wrote
about his flea collar. After that Scratchy mentioned to cook Tux and at
last Jerry recommended to eat veggie, or to eat a bad posting style
called tofu.

I should ask Jerry.

-- 
No cats!


-- 
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Archive: http://lists.debian.org/1376500565.21982.32.camel@archlinux



Re: Quoting Style Re: Installing mysqldump

2013-08-14 Thread Ralf Mardorf
Jerry wrote:
 No, let's eat tofu.

Hi Jerry,

does it mean that we should eat veggie, or is it some kind of figure of
speech for being against tofu posting style?

Ciao,
Ralf

PS: You might notice that the -sign is used no
#--- or anything else, that it can be read from
top to bottom, left to right ;) and that not only irrelevant text was
snipped, but also the signature.

-- 
I like cats :)


-- 
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Archive: http://lists.debian.org/1376500572.21982.33.camel@archlinux



Re: Quoting Style Re: Installing mysqldump

2013-08-14 Thread Ralf Mardorf
Oops, sorry, too many cats and mice.

Jerry wrote:
 Tom wrote:
  Itchy wrote:
  Scratchy wrote:
  I'm hungry. [snip]
  I'm too.
  Let's cook Tux under the grill.
 
 No, let's eat tofu.
 
 Regards,
 Jerry

CORRECTIONS:

 First SCRATCHY wrote that he's hungry, then Itchy replied to be hungry too,
 while doing this Itchy snipped irrelevant content, since SCRATCHY also wrote
 about his flea collar. After that Tom mentioned to cook Tux and at
 last Jerry recommended to eat veggie, or to eat a bad posting style
 called tofu.

Regards,
Ralf


-- 
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Archive: http://lists.debian.org/1376500830.21982.38.camel@archlinux



Re: Quoting Style Re: Installing mysqldump

2013-08-14 Thread Ethan Rosenberg, PhD

Oops, sorry, too many cats and mice.

Jerry wrote:

Tom wrote:
 Itchy wrote:
 Scratchy wrote:
 I'm hungry. [snip]
 I'm too.
 Let's cook Tux under the grill.

No, let's eat tofu.

Regards,
Jerry


CORRECTIONS:


First SCRATCHY wrote that he's hungry, then Itchy replied to be hungry too,
while doing this Itchy snipped irrelevant content, since SCRATCHY also wrote
about his flea collar. After that Tom mentioned to cook Tux and at
last Jerry recommended to eat veggie, or to eat a bad posting style
called tofu.


Regards,
Ralf

I still do not understand
and really wish to be helpful.

If you could actually edit my sample, it would be DEEPLY APPRECIATED.

TIA

Ethan
--



--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org

Archive: http://lists.debian.org/520bbec2.5080...@hygeiabiomedical.com



Re: Quoting Style Re: Installing mysqldump

2013-08-14 Thread Ralf Mardorf
Hi Ethan :)

now I reply to my own mail and fake that I'm you.

Btw. I'm sorry the  signs of my example were written by hand and not
done by the MUA reply option and so it seems not to work as expected.

Your last mail shouldn't look like
http://lists.debian.org/debian-user/2013/08/msg00503.html .
It should look like this:

On Wed, 2013-08-14 at 19:20 +0200, Ralf Mardorf wrote:
 Oops, sorry, too many cats and mice.
 [snip]
 CORRECTIONS:
 
  First SCRATCHY wrote that he's hungry, then Itchy replied to be hungry too,
  while doing this Itchy snipped irrelevant content, since SCRATCHY also wrote
  about his flea collar. After that Tom mentioned to cook Tux and at
  last Jerry recommended to eat veggie, or to eat a bad posting style
  called tofu.

I still do not understand
and really wish to be helpful.

If you could actually edit my sample, it would be DEEPLY APPRECIATED.

TIA

Ethan


-- 
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Archive: http://lists.debian.org/1376502511.5135.5.camel@archlinux



Re: Quoting Style Re: Installing mysqldump

2013-08-14 Thread Klaus

On 14/08/13 18:30, Ethan Rosenberg, PhD wrote:

I still do not understand
and really wish to be helpful.

If you could actually edit my sample, it would be DEEPLY APPRECIATED.

TIA

Ethan


Ethan

There are several aspects to this, maybe it's worth going through them 
one by one (this list is probably not exhaustive):


(1) Keeping emails in a thread together.
Your MUA does this for you, as long as you use the reply
function. Whereas what you do, using Ctrl-E (Edit-Message-
as-New), doesn't produce the correct references.
(2) Inserting a special character to indicate this is a quote.
Again, your email client (Icedove) does this for you, if you
use the reply function. It then inserts a   at the beginning
of each line of the quoted text, and other reader's email
clients can then format it on screen properly.
(3) Using plain text instead of HTML.
This is probably what you call unstyled versus styled. I
seem to remember that the FAQ for this list requests to use
plain text, though this doesn't seem to be adhered to very
strictly. Anyway, if Icedove is set-up to default to HTML,
then Shift-{Write, Reply, Reply to All, Reply to List}
will produce plain text mails. [1]
(4) Top versus bottom posting.
It is the convention here to keep the quote above your new
contribution. As described before, Icedove is easy to configure
to do this.

One other feature in Icedove I find useful when dealing with this sort
of thing is to have multiple identities. In Account Settings, find the
button Manage Identities. Each identity can have for instance
different quoting styles. [2]

 [1] http://kb.mozillazine.org/Plain_text_e-mail_%28Thunderbird%29
 [2] http://kb.mozillazine.org/Thunderbird_:_FAQs_:_Multiple_Identities

--
Klaus


--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org

Archive: http://lists.debian.org/520bf500.9030...@gmail.com



Re: Installing mysqldump

2013-08-13 Thread Ethan Rosenberg, PhD

Ethan,

I see that you are using Thunderbird.  A lot of people do.  But why
are your messages always broken?  You never reply to the message you
are quoting and seem to be replying to but the message before it.
Strange.  And your quoting is really painful.  I am sure it is not a
problem with Thunderbird since other people use it successfully.

Ethan Rosenberg, PhD wrote:

env COLUMNS=80 dpkg -l | grep mysql-server


I had asked for the 'env COLUMNS=80 dpkg -l' so that the columns would
not go out too far and would not be hard to read.


iU  mysql-server  5.5.31+dfsg-0+wheezy1 all  
MySQL database server (metapackage depending on the latest version)
rc  mysql-server-5.1  5.1.66-0+squeeze1 i386 
MySQL database server binaries and system database setup
iF  mysql-server-5.5  5.5.31+dfsg-0+wheezy1 i386 
MySQL database server binaries and system database setup
ii  mysql-server-core-5.5 5.5.31+dfsg-0+wheezy1 i386 
MySQL database server binaries


But yours go out to column 144 so of course I know you didn't use the
command I asked you to use.  Sigh.

And the above clearly shows the problem.  I will chop it down.

  Desired=Unknown/Install/Remove/Purge/Hold
  | 
Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend

  |/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
  ||/ Name   VersionDescription

+++-==-==-
  iU  mysql-server5.5.31+dfsg-0+wheezy1
  rc  mysql-server-5.15.1.66-0+squeeze1
  iF  mysql-server-5.55.5.31+dfsg-0+wheezy1
  ii  mysql-server-core-5.5   5.5.31+dfsg-0+wheezy1

mysql-server is Unpacked but not configured.  mysql-server-5.5 install
is marked as Failed.  That is clearly bad.  You can't ignore these
errors.

I would try this first.  Needs root.

  apt-get install -f

That should rerun the configuration of the failed packages.  Since it
produced errors before it will probably produce errors again.  Post
those errors.  They need to be fixed.

After you get the new mysql server installed correctly then, and only
then, purge the previous server.  Doing so will have the side effect
of shutting down the server so it needs to be started again.  But
don't do it until you have the new server installed correctly.

  dpkg --purge mysql-server-5.1
  service mysql start

Bob
===

Bob -

Thanks.

Here is the output from apt-get install -f




Reading package lists...
Building dependency tree...
Reading state information...
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
2 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Setting up mysql-server-5.5 (5.5.31+dfsg-0+wheezy1) ...
[?1049h[?25l(B 

 
    
   
  

 
   
  
 
    

   
   
   
   

 
    
    
    
    

 
 
 
 

    
    
[?25l[?12l[?25h(BPackage 
configuration┌┤ Configuring 
mysql-server-5.5 ├─┐│ While not 
mandatory, it is highly recommended that you set a password 
│ (B│ for the MySQL administrative 
root user.   │ 
(B│ 
│ (B│ If 
this field is left blank, the password will not be changed. 
   │ (B│ 
 │ 
(B│ New password for the MySQL root user: 
 │ (B│ 

  │ (B│ 
___ 
│ (B│ 
 │ 
(B│ Ok 
 │ (B│ 

  

Re: Installing mysqldump

2013-08-13 Thread Bob Proulx
Ethan Rosenberg, PhD wrote:
 Reading package lists...
 Building dependency tree...
 Reading state information...
 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
 2 not fully installed or removed.

Those two are problems that need to be fixed.

 After this operation, 0 B of additional disk space will be used.
 Setting up mysql-server-5.5 (5.5.31+dfsg-0+wheezy1) ...

 [?1049h[?25l(B

And people wonder why I don't like the happy colors in the interface! :-)
Let me clean that up a little bit for the archive.

 Package configuration
 Configuring mysql-server-5.5
 While not mandatory, it is highly recommended that you set a password for the 
 MySQL administrative root user.
 If this field is left blank, the password will not be changed.
 New password for the MySQL root user:
 Ok
 [] Stopping MySQL database server: ok
 [] Starting MySQL database server: mysqld . . . . . . . . . . . . .y .FAIL
 failed!
 invoke-rc.d: initscript mysql, action start failed.
 dpkg: error processing mysql-server-5.5 (--configure):
  subprocess installed post-installation script returned error exit status 1
 dpkg: dependency problems prevent configuration of mysql-server:
  mysql-server depends on mysql-server-5.5; however:
   Package mysql-server-5.5 is not configured yet.

Failure reported.  The package is not configured yet.  It is not ready
for use.  It is broken.  It won't work right until it is fixed.
Something went wrong.  It reported the error.  These errors cannot be
ignored and just hoping for the best sometime later.

 dpkg: error processing mysql-server (--configure):
  dependency problems - leaving unconfigured
 Errors were encountered while processing:
  mysql-server-5.5
  mysql-server

As to what the problem is, I do not know.  I have personally often had
problems with mysql upgrades.  But I always had a full database
backup.  Therefore it when things have not worked it was always very
easy to purge all of the packages and then re-install them and then
restore from backup.  But if you don't have a backup then purging the
data would be a very bad thing.

Does anyone else on the list have any suggestions at this point?

If there are no other better ideas I would save off a copy of the
/var/lib/mysql directory as backup.

  cp -a /var/lib/mysql /var/backups/mysql.$(date +%F)

Then I would purge mysql-server-5.5 to clean up this package
installation mess.

  # apt-get purge mysql-server-5.5

I just tested this on my system and it did not actually remove the
/var/lib/mysql directories.  Which is good and what we want even if it
does not comply with policy.  It is the safer behavior.  But make sure
you have a backup anyway.  Then after it has been removed verify that
it is removed.

  # dpkg -l mysql-server-5.5
  dpkg-query: no packages found matching mysql-server-5.5

Then install it again.

  # apt-get install mysql-server
  ...press enter to each of the three questions about changing the
  mysql root access password...this will preserve the previous
  password that you set before without changing it...

Of course if you should have a database password set.  This will
preserve it to the previous value.  If you didn't previously set one
then recover first and then change it later.

I believe that a clean installation should fix your installation
problem and return things to a sane state.

  # dpkg -l mysql-server-5.5
  Desired=Unknown/Install/Remove/Purge/Hold
  | Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
  |/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
  ||/ Name   Version  Architecture Description
  +++-==---=
  ii  mysql-server-5 5.5.31+dfsg- amd64MySQL database server binaries an

If they do not then report what problem is being reported.  Your
system seems pretty messed up so I wouldn't be surprised if you have
yet another problem below this one.

After getting this fixed with mysql you can clean up the old mysql
backup.  And set up regular future backups.  I always have this
following on my systems.

File /etc/cron.d/local-mysql:
  30 3 * * *   root umask 077 ; mysqldump 
--defaults-file=/etc/mysql/debian.cnf --all-databases --events | gzip  
/var/backups/mysql.dump ; savelog -q -d -l -C /var/backups/mysql.dump

That will result in these following files being compressed sql dumps
which I then simply back up normally.  YMMV.

  $ ls -l /var/backups/
  -rw--- 1 root root140177 Aug  2 03:30 mysql.dump.20130802033001
  -rw--- 1 root root140177 Aug  3 03:30 mysql.dump.20130803033002
  -rw--- 1 root root140177 Aug  4 03:30 mysql.dump.20130804033002
  -rw--- 1 root root140177 Aug  5 03:30 mysql.dump.20130805033002
  -rw--- 1 root root140177 Aug  6 03:30 mysql.dump.20130806033001
  -rw--- 1 root root140177 Aug  7 03:30 mysql.dump.20130807033002
  -rw--- 1 

Email Issues (was: Installing mysqldump)

2013-08-13 Thread Bob Proulx
Ethan Rosenberg, PhD wrote:
 Also, please indicate the errors in my Thunderbird email.  I will
 address them.

I don't know how well the box drawing characters will come through but
hopefully they will survive.  I will just give it a try and worry
about them being garbled if they are garbled.  Here is the structure
of the discussion thread.  If the chars don't come through the right
side is using box drawing characters as arrows to indicate the flow of
the discussion.

  5496 r  Aug09 Ethan Rosenberg (1.2K) Installing mysqldump
  5497Aug09 Gary Roach  (1.7K) ├─
  5498Aug09 To debian-user@ (2.4K) ├─
  5499Aug10 Lisi Reisz  (1.3K) │ ├─
  5500Aug11 Ethan Rosenberg (2.9K) │ ├─
  5501Aug11 Lisi Reisz  (1.7K) │ │ ├─
  5502Aug11 Ethan Rosenberg (2.0K) │ │ └─
  5503Aug11 Ethan Rosenberg (0.8K) │ └─
  5504Aug12 The_Ace (1.7K) │   ├─
  5505 r  Aug12 Ethan Rosenberg (1.1K) │   └─
  5506Aug12 To debian-user@ (1.6K) │ ├─
  5507 r  Aug13 Ethan Rosenberg (2.5K) │ └─
  5508Aug12 To debian-user@ (3.1K) │   ├─
  5509 N  Aug13 Ethan Rosenberg (7.2K) │   └─
  5510 N  Aug13 To debian-user@ (5.9K) │ └─
  5511Aug11 Ethan Rosenberg (2.0K) └─

All of the message numbers here are unique to my mailbox.  But I will
reference them for this discussion anyway.  Your numbers will be
different in every other mailbox.

Your message 5509 seemingly replied to my message number 5508 but the
headers are wrong for it.  Your message 5509 says it is a reply to
5507 which is your message before it and ignores my message 5508.  But
you quoted lines from 5508.  Therefore you must have read 5508.  But
your mailer did not include any In-Reply-To or References headers from
it.  The message id on my message.

  Message-ID: 20130813050328.gb12...@dismay.proulx.com

Your Thunderbird should reference it.  It should append it to the
list in the References header.  It should create an In-Reply-To header
like this and insert it into your message.

  In-Reply-To: 20130813050328.gb12...@dismay.proulx.com

Your mailer instead included a In-Reply-To header to your own
message, my number 5507 in the above.  It included these headers.

  References: 52050537.2070...@hygeiabiomedical.com
  20130809185125.gd4...@hysteria.proulx.com
  52082c31.8070...@hygeiabiomedical.com
  52095a1b.9000...@hygeiabiomedical.com
  5209b77d.9040...@hygeiabiomedical.com
  In-Reply-To: 5209b77d.9040...@hygeiabiomedical.com

That is just plain broken!  That is the wrong header values.  Unless
you were replying to your own message.  In which case it would be the
right headers then.  But if were replying to my message then the
headers should be these:

  References: 52050537.2070...@hygeiabiomedical.com
  20130809185125.gd4...@hysteria.proulx.com
  52082c31.8070...@hygeiabiomedical.com
  52095a1b.9000...@hygeiabiomedical.com
  5209b77d.9040...@hygeiabiomedical.com
  20130813050328.gb12...@dismay.proulx.com
  In-Reply-To: 20130813050328.gb12...@dismay.proulx.com

It appears to the rest of us as if you are never replying to our
messages but to the messages previous to it in the mailbox.  And then
it appears as if you are cutting and pasting in all of our text.
Bizarre!  Message 5500 and 5503 both appear as a reply to my message
5498.  But that is also incorrect since 5500 is actually a reply to
Lisi's message 5501 but the headers are wrong for it too and reference
the message before it.  Truly goofy.

Also take a look at your reply as the rest of us see it:

  http://lists.debian.org/debian-user/2013/08/msg00436.html

Your quoting is horrid.  Sorry to say it so harshly.  But it is really
awful.  Your are keeping all of the original message without any
quoting characters, the '' char, on the left side.  This is explained
in more detail here.  Also in a dozen dozen other guides on the net.
If you search a little about how to quote email you should find dozens
of guides on it.

  http://en.wikipedia.org/wiki/Usenet_quoting

Without those quote characters it is difficult to see what you wrote
and what we wrote.  And it makes trimmed replies confusing.  So please
add a '' quote character to the front.  Thunderbird should do this
automatically.  For some reason it is not for you.

And then another problem is that you leave the entire message in its
entirety and bottom post your message after it.  Instead please trim
the message to just enough context to make understood to what you are
referring.  Brian and Ralf do a good job of this in their replies to
you.  Here are two examples:

  http://lists.debian.org/debian-user/2013/07/msg01230.html
  http://lists.debian.org/debian-user/2013/07/msg01249.html

Notice how they trim your reply down to just the relevant parts.  Like
I have done on my messages.  It makes it much easier to read and to
understand and to respond.  And when looking for help making it easy
for others to help you makes

Re: Email Issues (was: Installing mysqldump)

2013-08-13 Thread Ralf Mardorf
On Tue, 2013-08-13 at 17:14 -0600, Bob Proulx wrote:
 I don't know how well the box drawing characters will come through

Perfectly here :).

   5496 r  Aug09 Ethan Rosenberg (1.2K) Installing mysqldump
   5497Aug09 Gary Roach  (1.7K) ├─
   5498Aug09 To debian-user@ (2.4K) ├─
   5499Aug10 Lisi Reisz  (1.3K) │ ├─
   5500Aug11 Ethan Rosenberg (2.9K) │ ├─
   5501Aug11 Lisi Reisz  (1.7K) │ │ ├─
   5502Aug11 Ethan Rosenberg (2.0K) │ │ └─
   5503Aug11 Ethan Rosenberg (0.8K) │ └─
   5504Aug12 The_Ace (1.7K) │   ├─
   5505 r  Aug12 Ethan Rosenberg (1.1K) │   └─
   5506Aug12 To debian-user@ (1.6K) │ ├─
   5507 r  Aug13 Ethan Rosenberg (2.5K) │ └─
   5508Aug12 To debian-user@ (3.1K) │   ├─
   5509 N  Aug13 Ethan Rosenberg (7.2K) │   └─
   5510 N  Aug13 To debian-user@ (5.9K) │ └─
   5511Aug11 Ethan Rosenberg (2.0K) └─


 I am sure this sounds critical.  Don't take it harshly.

It's helpful for Ethan. Often I don't have the time to encrypt the
jigsaw puzzle mails, maybe it's to time consuming for others too.

Regards,
Ralf


-- 
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Archive: http://lists.debian.org/1376437772.1751.8.camel@archlinux



Re: Installing mysqldump

2013-08-13 Thread Jerry Stuckle

On 8/13/2013 6:33 PM, Bob Proulx wrote:

Ethan Rosenberg, PhD wrote:

Reading package lists...
Building dependency tree...
Reading state information...
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
2 not fully installed or removed.


Those two are problems that need to be fixed.


After this operation, 0 B of additional disk space will be used.
Setting up mysql-server-5.5 (5.5.31+dfsg-0+wheezy1) ...



[?1049h[?25l(B


And people wonder why I don't like the happy colors in the interface! :-)
Let me clean that up a little bit for the archive.


Package configuration
Configuring mysql-server-5.5
While not mandatory, it is highly recommended that you set a password for the MySQL 
administrative root user.
If this field is left blank, the password will not be changed.
New password for the MySQL root user:
Ok
[] Stopping MySQL database server: ok
[] Starting MySQL database server: mysqld . . . . . . . . . . . . .y .FAIL
failed!
invoke-rc.d: initscript mysql, action start failed.
dpkg: error processing mysql-server-5.5 (--configure):
  subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
  mysql-server depends on mysql-server-5.5; however:
   Package mysql-server-5.5 is not configured yet.


Failure reported.  The package is not configured yet.  It is not ready
for use.  It is broken.  It won't work right until it is fixed.
Something went wrong.  It reported the error.  These errors cannot be
ignored and just hoping for the best sometime later.


dpkg: error processing mysql-server (--configure):
  dependency problems - leaving unconfigured
Errors were encountered while processing:
  mysql-server-5.5
  mysql-server


As to what the problem is, I do not know.  I have personally often had
problems with mysql upgrades.  But I always had a full database
backup.  Therefore it when things have not worked it was always very
easy to purge all of the packages and then re-install them and then
restore from backup.  But if you don't have a backup then purging the
data would be a very bad thing.

Does anyone else on the list have any suggestions at this point?


Bob,

The best thing to do would be for Ethan to look at the MySQL log to see 
what the failure was.  He was asked to do this before but never 
responded with the messages in his log.


A clean install may or may not fix the problem - it all depends.  For 
instance, if he changed some of the server settings so they are no 
longer compatible with the Debian defaults, then the server won't start 
(unless ALL MySQL data is deleted).


The MySQL log will show the problem.

For the record, I've had problems with MySQL upgrades in the past - but 
all were caused by parameters I changed.  The MySQL log always showed 
the problem, and resetting the defaults from the upgrade to the values I 
use fixed the problems.



--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org

Archive: http://lists.debian.org/520aca7f.8050...@attglobal.net



Re: Installing mysqldump

2013-08-13 Thread Ethan Rosenberg, PhD

On 8/13/2013 6:33 PM, Bob Proulx wrote:

Ethan Rosenberg, PhD wrote:

Reading package lists...
Building dependency tree...
Reading state information...
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
2 not fully installed or removed.


Those two are problems that need to be fixed.


After this operation, 0 B of additional disk space will be used.
Setting up mysql-server-5.5 (5.5.31+dfsg-0+wheezy1) ...



[?1049h[?25l(B


And people wonder why I don't like the happy colors in the interface! :-)
Let me clean that up a little bit for the archive.


Package configuration
Configuring mysql-server-5.5
While not mandatory, it is highly recommended that you set a password for the MySQL 
administrative root user.
If this field is left blank, the password will not be changed.
New password for the MySQL root user:
Ok
[] Stopping MySQL database server: ok
[] Starting MySQL database server: mysqld . . . . . . . . . . . . .y .FAIL
failed!
invoke-rc.d: initscript mysql, action start failed.
dpkg: error processing mysql-server-5.5 (--configure):
  subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
  mysql-server depends on mysql-server-5.5; however:
   Package mysql-server-5.5 is not configured yet.


Failure reported.  The package is not configured yet.  It is not ready
for use.  It is broken.  It won't work right until it is fixed.
Something went wrong.  It reported the error.  These errors cannot be
ignored and just hoping for the best sometime later.


dpkg: error processing mysql-server (--configure):
  dependency problems - leaving unconfigured
Errors were encountered while processing:
  mysql-server-5.5
  mysql-server


As to what the problem is, I do not know.  I have personally often had
problems with mysql upgrades.  But I always had a full database
backup.  Therefore it when things have not worked it was always very
easy to purge all of the packages and then re-install them and then
restore from backup.  But if you don't have a backup then purging the
data would be a very bad thing.

Does anyone else on the list have any suggestions at this point?


Bob,

The best thing to do would be for Ethan to look at the MySQL log to see 
what the failure was.  He was asked to do this before but never 
responded with the messages in his log.


A clean install may or may not fix the problem - it all depends.  For 
instance, if he changed some of the server settings so they are no 
longer compatible with the Debian defaults, then the server won't start 
(unless ALL MySQL data is deleted).


The MySQL log will show the problem.

For the record, I've had problems with MySQL upgrades in the past - but 
all were caused by parameters I changed.  The MySQL log always showed 
the problem, and resetting the defaults from the upgrade to the values I 
use fixed the problems.


===

Dear List -

I am sorry - the mysql log did not have any entries.

I remember changing the local host definition to 127.0.0.1 in my.cnf

I am going to erase my.cnf and see what happens.  I have backed up the 
data files.


I'll keep you posted.

Ethan


--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org

Archive: http://lists.debian.org/520af087.8080...@hygeiabiomedical.com



Re: Installing mysqldump - SOLVED

2013-08-13 Thread Ethan Rosenberg, PhD

On 8/13/2013 6:33 PM, Bob Proulx wrote:
snip
===

Dear List -

I am sorry - the mysql log did not have any entries.

I remember changing the local host definition to 127.0.0.1 in my.cnf

I am going to erase my.cnf and see what happens.  I have backed up the 
data files.


I'll keep you posted.

Ethan


Dear List -

erased my.cnf
purged mysql-server-5.5
reinstalled

IT WORKS!!!

Even my tables are there!!

Thanks for all your help.

Ethan



--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org

Archive: http://lists.debian.org/520af4a2.9080...@hygeiabiomedical.com



Re: Installing mysqldump - SOLVED

2013-08-13 Thread Bob Proulx
Ethan Rosenberg, PhD wrote:
 erased my.cnf

That will have no effect at all on the problem.

 purged mysql-server-5.5
 reinstalled

 IT WORKS!!!
 Even my tables are there!!

Yay!

Bob


signature.asc
Description: Digital signature


Re: Installing mysqldump

2013-08-12 Thread The_Ace
if the database that you need to backup is not in your own PC, use
the -h parameter with mysqldump  and pass the host ip or fqdn of the
PC in which the database resides.
eg :
mysqldump -h 192.168.1.30  -u username_with_external_access -p db_name
 db_name.sql

if the database is in the same PC, then you still have problems as the
local mysql service is not running.
check logs (syslog , mysql log) to see why its not running and attend to that.

On Mon, Aug 12, 2013 at 5:58 AM, Ethan Rosenberg, PhD
erosenb...@hygeiabiomedical.com wrote:
 On Friday 09 August 2013 19:51:25 Bob Proulx wrote:

 Ethan Rosenberg, PhD wrote:

 snip

 Further, I tried to run mysql and receive the following message-

 ERROR 2002 can't connect to local mysql server thru socket
 '/var/run/mysqld/mysqld.sock' (2)

 TIA

 Ethan

 ===
 Dear List -

 I now have a desktop, using xfce.

 I now have mysqldump.

 The following is ABSOLUTELY CRITICAL!

 I have to backup a database so I can install it on another computer

 When I try to to run mysqldump, I receive the following message:


 ERROR 2002 can't connect to local mysql server thru socket
 '/var/run/mysqld/mysqld.sock' (2)

 TIA

 Ethan


 --
 To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject
 of unsubscribe. Trouble? Contact listmas...@lists.debian.org
 Archive: http://lists.debian.org/52082c31.8070...@hygeiabiomedical.com




-- 
The mysteries of the Universe are revealed when you break stuff.


-- 
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Archive: 
http://lists.debian.org/CAM8yCh_XNAcO8exYpuwD=odvb8ie1+qcmqvfs2f_flftow4...@mail.gmail.com



Re: Installing mysqldump

2013-08-12 Thread Ethan Rosenberg, PhD

snip

if the database is in the same PC, then you still have problems as the
local mysql service is not running.
check logs (syslog , mysql log) to see why its not running and attend to 
that.




Here is part of syslog.  The rest is just a repeat of the first line..

Aug 12 14:38:45 meow avahi-daemon[2689]: Received response from host 
192.168.1.1 with invalid source port 32768 on interface 'eth0.0'
Aug 12 14:39:01 meow /USR/SBIN/CRON[7351]: (root) CMD (  [ -x 
/usr/lib/php5/maxlifetime ]  [ -d /var/lib/php5 ]  find 
/var/lib/php5/ -depth -mindepth 1 -maxdepth 1 -type f 
-ignore_readdir_race -cmin +$(/usr/lib/php5/maxlifetime) ! -execdir 
fuser -s {} 2/dev/null \; -delete)
Aug 12 14:39:15 meow avahi-daemon[2689]: Received response from host 
192.168.1.1 with invalid source port 32768 on interface 'eth0.0' 12


I am a newbie and do not lhow to interpert the log.

What now?

TIA

Ethan




--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org

Archive: http://lists.debian.org/52095a1b.9000...@hygeiabiomedical.com



Re: Installing mysqldump

2013-08-12 Thread Bob Proulx
Ethan Rosenberg, PhD wrote:
 When I try to to run mysqldump, I receive the following message:

 ERROR 2002 can't connect to local mysql server thru socket
 '/var/run/mysqld/mysqld.sock' (2)

That tells me that you do not have mysql running.

 I am a newbie and do not lhow to interpert the log.
 
 What now?

What is the output of these commands?

  env COLUMNS=80 dpkg -l | grep mysql-server

Should say:

  ii  mysql-server   5.5.31+dfsg- all  MySQL database server (metapackag
  ii  mysql-server-5 5.5.31+dfsg- amd64MySQL database server binaries an
  ii  mysql-server-c 5.5.31+dfsg- amd64MySQL database server binaries

This one needs root:

  service mysql restart

Should say:

  Stopping MySQL database server: mysqld.
  Starting MySQL database server: mysqld ..
  Checking for tables which need an upgrade, are corrupt or were 
  not closed cleanly..

Bob


signature.asc
Description: Digital signature


Re: Installing mysqldump

2013-08-12 Thread Ethan Rosenberg, PhD

Ethan Rosenberg, PhD wrote:

When I try to to run mysqldump, I receive the following message:

ERROR 2002 can't connect to local mysql server thru socket
'/var/run/mysqld/mysqld.sock' (2)


That tells me that you do not have mysql running.


I am a newbie and do not lhow to interpert the log.

What now?


What is the output of these commands?

  env COLUMNS=80 dpkg -l | grep mysql-server

Should say:

  ii  mysql-server   5.5.31+dfsg- all  MySQL database server 
(metapackag
  ii  mysql-server-5 5.5.31+dfsg- amd64MySQL database server 
binaries an

  ii  mysql-server-c 5.5.31+dfsg- amd64MySQL database server binaries

This one needs root:

  service mysql restart

Should say:

  Stopping MySQL database server: mysqld.
  Starting MySQL database server: mysqld ..
  Checking for tables which need an upgrade, are corrupt or were   not 
closed cleanly..


Bob
=

Bob -

Thanks.

env COLUMNS=80 dpkg -l | grep mysql-server

iU  mysql-server  5.5.31+dfsg-0+wheezy1 
 all  MySQL database server (metapackage depending on the 
latest version)
rc  mysql-server-5.1  5.1.66-0+squeeze1 
 i386 MySQL database server binaries and system database setup
iF  mysql-server-5.5  5.5.31+dfsg-0+wheezy1 
 i386 MySQL database server binaries and system database setup
ii  mysql-server-core-5.5 5.5.31+dfsg-0+wheezy1 
 i386 MySQL database server binaries

+

service mysql restart



Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
+++

TIA

Ethan


signature.asc
Description: PGP signature


Re: Installing mysqldump

2013-08-12 Thread Bob Proulx
Ethan,

I see that you are using Thunderbird.  A lot of people do.  But why
are your messages always broken?  You never reply to the message you
are quoting and seem to be replying to but the message before it.
Strange.  And your quoting is really painful.  I am sure it is not a
problem with Thunderbird since other people use it successfully.

Ethan Rosenberg, PhD wrote:
 env COLUMNS=80 dpkg -l | grep mysql-server

I had asked for the 'env COLUMNS=80 dpkg -l' so that the columns would
not go out too far and would not be hard to read.

 iU  mysql-server  5.5.31+dfsg-0+wheezy1 all  
 MySQL database server (metapackage depending on the latest version)
 rc  mysql-server-5.1  5.1.66-0+squeeze1 i386 
 MySQL database server binaries and system database setup
 iF  mysql-server-5.5  5.5.31+dfsg-0+wheezy1 i386 
 MySQL database server binaries and system database setup
 ii  mysql-server-core-5.5 5.5.31+dfsg-0+wheezy1 i386 
 MySQL database server binaries

But yours go out to column 144 so of course I know you didn't use the
command I asked you to use.  Sigh.

And the above clearly shows the problem.  I will chop it down.

  Desired=Unknown/Install/Remove/Purge/Hold
  | Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
  |/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
  ||/ Name   VersionDescription
  +++-==-==-
  iU  mysql-server5.5.31+dfsg-0+wheezy1
  rc  mysql-server-5.15.1.66-0+squeeze1
  iF  mysql-server-5.55.5.31+dfsg-0+wheezy1
  ii  mysql-server-core-5.5   5.5.31+dfsg-0+wheezy1

mysql-server is Unpacked but not configured.  mysql-server-5.5 install
is marked as Failed.  That is clearly bad.  You can't ignore these
errors.

I would try this first.  Needs root.

  apt-get install -f

That should rerun the configuration of the failed packages.  Since it
produced errors before it will probably produce errors again.  Post
those errors.  They need to be fixed.

After you get the new mysql server installed correctly then, and only
then, purge the previous server.  Doing so will have the side effect
of shutting down the server so it needs to be started again.  But
don't do it until you have the new server installed correctly.

  dpkg --purge mysql-server-5.1
  service mysql start

Bob


signature.asc
Description: Digital signature


Re: Installing mysqldump

2013-08-11 Thread Ethan Rosenberg, PhD

On 08/09/2013 08:05 AM, Ethan Rosenberg, PhD wrote:

Dear List -

I am trying to install  mysqldump.

Here is what I get -


apt-get install mysql-client-5.5
Reading package lists...
Building dependency tree...
Reading state information...
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 mate-screensaver : Depends: mate-screensaver-common (= 1.6.0-1) but
it is not going to be installed
 mysql-client-5.5 : Depends: libdbi-perl but it is not going to be
installed
Depends: libdbd-mysql-perl (= 1.2202) but it is
not going to be installed


apt-get install mysql-core-5.5
Reading package lists...
Building dependency tree...
Reading state information...
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 mate-screensaver : Depends: mate-screensaver-common (= 1.6.0-1) but
it is not going to be installed
 mysql-server-core-5.5 : Depends: libaio1 (= 0.3.93) but it is not
going to be installed
===

TIA
Ethan



Ethan;

I find no Debian listing for mysqldump but do find one for mydumper 
which, I think, is what you are really looking for. As for as the rest, 
try apt-get install mysql-client and/or mysql-server. These are wrappers 
that will install the latest versions. Check the Debian Packages page on 
their web site. I don't see mysql-core-5.5 listed.


Gary R.



Gary

Thanks.

apt-get install mysql-client and now I have mysqldump.

Ethan

--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a 
subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org

Archive: http://lists.debian.org/52051b3c.4080...@verizon.net



--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org

Archive: http://lists.debian.org/5207c2ec.9080...@hygeiabiomedical.com



Re: Installing mysqldump

2013-08-11 Thread Ethan Rosenberg, PhD

On Friday 09 August 2013 19:51:25 Bob Proulx wrote:

Ethan Rosenberg, PhD wrote:
 I am trying to install  mysqldump.




Something is broken in your sources.list file.  Fix it first.


A month ago Ethan had both Squeeze DVDs and wheezy http's enabled 
simultaneously in his sources.list.  So he may also need to fix his pinning.


Lisi


Then
run 'apt-get update'.  Then 'apt-get install -f' as suggested above.
Then install mysql-server.  Then you should be working.  This applies
to both your old Squeeze 6 as well as the current Wheezy 7.

I see by your many messages that you have had much trouble in this
area.  I think you have a system that is partially this and partially
that and partially something else.  So I don't really know where to
begin.  Start by posting your current sources.list file.  You need to
fix it first.

Are you trying to be Squeeze 6 with GNOME 2?  Are you trying to be
with Wheezy 7 with Mate?  What is your target goal?  If you don't know
where you are going then you might be late getting there.

Bob


=

Lisi -

Thanks.

Here is my sources file --

# deb cdrom:[Debian GNU/Linux 6.0.1a _Squeeze_ - Official i386 DVD
#Binary-1 20110322-15:11]/ squeeze contrib main

# deb cdrom:[Debian GNU/Linux 6.0.1a _Squeeze_ - Official i386 DVD
#Binary-1 20110322-15:11]/ squeeze contrib main

# deb cdrom:[Debian GNU/Linux 6.0.1a _Squeeze_ - Official i386 DVD
#Binary-2 20110322-15:11]/ squeeze contrib main

# Line commented out by installer because it failed to verify:
#deb http://security.debian.org/ squeeze/updates main contrib
# Line commented out by installer because it failed to verify:
#deb-src http://security.debian.org/ squeeze/updates main contrib

# squeeze-updates, previously known as 'volatile'
# A network mirror was not selected during install.  The following entries
# are provided as examples, but you should amend them as appropriate
# for your mirror of choice.
#
deb http://ftp.debian.org/debian/ wheezy-updates main contrib
#deb-src http://ftp.debian.org/debian/ wheezy-updates main contrib
deb http://ftp.us.debian.org/debian/ wheezy main contrib non-free
#deb-src http://ftp.us.debian.org/debian/ wheezy main contrib non-free
deb http://packages.mate-desktop.org/repo/debian wheezy main -
deb http://repo.mate-desktop.org/debian wheezy main -

The two noted above were commented out, update performed, commenting 
removed and mate installed.


The system now is Debian7.

I still do not have a desktop, just a command prompt.

OUCH!!!

Further, I tried to run mysql and receivew the followihngf message-
ERROR 2002 can't connect to local mysql server thru socket 
'/var/run/mysqld/mysqld.sock' (2)


TIA

Ethan


--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org

Archive: http://lists.debian.org/5207dec6.9070...@hygeiabiomedical.com



Re: Installing mysqldump

2013-08-11 Thread Lisi Reisz
Reposting to list, where it should have gone in the first place. :-(  Sorry, 
again, Ethan.

On Sunday 11 August 2013 19:58:14 Ethan Rosenberg, PhD wrote:
 Here is my sources file --
[snip many commented out lines]

 deb http://ftp.debian.org/debian/ wheezy-updates main contrib
 #deb-src http://ftp.debian.org/debian/ wheezy-updates main contrib
 deb http://ftp.us.debian.org/debian/ wheezy main contrib non-free
 #deb-src http://ftp.us.debian.org/debian/ wheezy main contrib non-free
 deb http://packages.mate-desktop.org/repo/debian wheezy main -
 deb http://repo.mate-desktop.org/debian wheezy main -

 The two noted above were commented out, update performed, commenting
 removed and mate installed.

There is at least one error.  I do not guarantee that there are no others!

Between trying to install Mate and uncommenting the Mate repositories you need 
to do an update.  Otherwise, apt or aptitude will not know about packages in 
those two repositories and will not install from them.  So:

Uncomment those last two lines.  Then:

# apt-get/aptitude update

# apt-get/aptitude search mate
# apt-get/aptitude install packages the search tells you that you want

 The system now is Debian7.

 I still do not have a desktop, just a command prompt.

You still haven't installed a desktop.  You must have had error reports when 
you tried to install Mate previously.  It would help if your requests for 
help included any error messages you have had.

HTH
Lisi


-- 
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Archive: http://lists.debian.org/201308112252.43277.lisi.re...@gmail.com



Re: Installing mysqldump

2013-08-11 Thread Ethan Rosenberg, PhD

On Sunday 11 August 2013 19:58:14 Ethan Rosenberg, PhD wrote:

Here is my sources file --

[snip many commented out lines]


deb http://ftp.debian.org/debian/ wheezy-updates main contrib
#deb-src http://ftp.debian.org/debian/ wheezy-updates main contrib
deb http://ftp.us.debian.org/debian/ wheezy main contrib non-free
#deb-src http://ftp.us.debian.org/debian/ wheezy main contrib non-free
deb http://packages.mate-desktop.org/repo/debian wheezy main -
deb http://repo.mate-desktop.org/debian wheezy main -

The two noted above were commented out, update performed, commenting
removed and mate installed.


There is at least one error.  I do not guarantee that there are no others!

Between trying to install Mate and uncommenting the Mate repositories 
you need to do an update.  Otherwise, apt or aptitude will not know 
about packages in those two repositories and will not install from them. 
 So:


Uncomment those last two lines.  Then:

# apt-get/aptitude update

# apt-get/aptitude search mate
# apt-get/aptitude install packages the search tells you that you want


The system now is Debian7.

I still do not have a desktop, just a command prompt.


You still haven't installed a desktop.  You must have had error reports 
when you tried to install Mate previously.  It would help if your 
requests for help included any error messages you have had.


HTH
Lisi
==
Lisi -

I tried your sugestions - no luck.

As follows -

apt-get purge mate-*

apt-get update

following the Wiki

apt-get --yes --quiet --allow-unauthenticated install mate-archive-keyring
apt-get update
# Now to install MATE choose 1 of the 3 apt-get lines below.
# this installs the base packages
apt-get install mate-core

apt-get update

no error messages.

Boots to command prompt

TIA

Ethan


--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org

Archive: http://lists.debian.org/52080957.4010...@hygeiabiomedical.com



Re: Installing mysqldump

2013-08-11 Thread Ethan Rosenberg, PhD

On Friday 09 August 2013 19:51:25 Bob Proulx wrote:

Ethan Rosenberg, PhD wrote:

snip

Further, I tried to run mysql and receive the following message-
ERROR 2002 can't connect to local mysql server thru socket 
'/var/run/mysqld/mysqld.sock' (2)


TIA

Ethan

===
Dear List -

I now have a desktop, using xfce.

I now have mysqldump.

The following is ABSOLUTELY CRITICAL!

I have to backup a database so I can install it on another computer

When I try to to run mysqldump, I receive the following message:

ERROR 2002 can't connect to local mysql server thru socket 
'/var/run/mysqld/mysqld.sock' (2)


TIA

Ethan


--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org

Archive: http://lists.debian.org/52082c31.8070...@hygeiabiomedical.com



Re: Installing mysqldump

2013-08-10 Thread Lisi Reisz
On Friday 09 August 2013 19:51:25 Bob Proulx wrote:
 Ethan Rosenberg, PhD wrote:
  I am trying to install  mysqldump.


 Something is broken in your sources.list file.  Fix it first. 

A month ago Ethan had both Squeeze DVDs and wheezy http's enabled 
simultaneously in his sources.list.  So he may also need to fix his pinning.

Lisi

 Then 
 run 'apt-get update'.  Then 'apt-get install -f' as suggested above.
 Then install mysql-server.  Then you should be working.  This applies
 to both your old Squeeze 6 as well as the current Wheezy 7.

 I see by your many messages that you have had much trouble in this
 area.  I think you have a system that is partially this and partially
 that and partially something else.  So I don't really know where to
 begin.  Start by posting your current sources.list file.  You need to
 fix it first.

 Are you trying to be Squeeze 6 with GNOME 2?  Are you trying to be
 with Wheezy 7 with Mate?  What is your target goal?  If you don't know
 where you are going then you might be late getting there.

 Bob


-- 
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Archive: http://lists.debian.org/201308101114.04318.lisi.re...@gmail.com



Installing mysqldump

2013-08-09 Thread Ethan Rosenberg, PhD

Dear List -

I am trying to install  mysqldump.

Here is what I get -


apt-get install mysql-client-5.5
Reading package lists...
Building dependency tree...
Reading state information...
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 mate-screensaver : Depends: mate-screensaver-common (= 1.6.0-1) but it 
is not going to be installed
 mysql-client-5.5 : Depends: libdbi-perl but it is not going to be 
installed
Depends: libdbd-mysql-perl (= 1.2202) but it is 
not going to be installed



apt-get install mysql-core-5.5
Reading package lists...
Building dependency tree...
Reading state information...
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 mate-screensaver : Depends: mate-screensaver-common (= 1.6.0-1) but it 
is not going to be installed
 mysql-server-core-5.5 : Depends: libaio1 (= 0.3.93) but it is not 
going to be installed

===

TIA
Ethan


--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org

Archive: http://lists.debian.org/52050537.2070...@hygeiabiomedical.com



Re: Installing mysqldump

2013-08-09 Thread Gary Roach

On 08/09/2013 08:05 AM, Ethan Rosenberg, PhD wrote:

Dear List -

I am trying to install  mysqldump.

Here is what I get -


apt-get install mysql-client-5.5
Reading package lists...
Building dependency tree...
Reading state information...
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 mate-screensaver : Depends: mate-screensaver-common (= 1.6.0-1) but 
it is not going to be installed
 mysql-client-5.5 : Depends: libdbi-perl but it is not going to be 
installed
Depends: libdbd-mysql-perl (= 1.2202) but it is 
not going to be installed



apt-get install mysql-core-5.5
Reading package lists...
Building dependency tree...
Reading state information...
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 mate-screensaver : Depends: mate-screensaver-common (= 1.6.0-1) but 
it is not going to be installed
 mysql-server-core-5.5 : Depends: libaio1 (= 0.3.93) but it is not 
going to be installed

===

TIA
Ethan



Ethan;

I find no Debian listing for mysqldump but do find one for mydumper 
which, I think, is what you are really looking for. As for as the rest, 
try apt-get install mysql-client and/or mysql-server. These are wrappers 
that will install the latest versions. Check the Debian Packages page on 
their web site. I don't see mysql-core-5.5 listed.


Gary R.


--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org 
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org

Archive: http://lists.debian.org/52051b3c.4080...@verizon.net



Re: Installing mysqldump

2013-08-09 Thread Bob Proulx
Ethan Rosenberg, PhD wrote:
 I am trying to install  mysqldump.

Please install mysql-server.  That will install mysqldump.  Since
you don't have mysqldump I can only assume that you were never able to
install the mysql server.

  apt-get update
  apt-get install mysql-server mysql-client

But that probably won't work until you fix your sources.list problem.

 You might want to run 'apt-get -f install' to correct these:
 The following packages have unmet dependencies:
  mate-screensaver : Depends: mate-screensaver-common (= 1.6.0-1) but
 it is not going to be installed
  mysql-client-5.5 : Depends: libdbi-perl but it is not going to be
 installed
 Depends: libdbd-mysql-perl (= 1.2202) but it is not 
 going to be installed
 You might want to run 'apt-get -f install' to correct these:
 The following packages have unmet dependencies:
  mate-screensaver : Depends: mate-screensaver-common (= 1.6.0-1) but
 it is not going to be installed
  mysql-server-core-5.5 : Depends: libaio1 (= 0.3.93) but it is not going to 
 be installed

Something is broken in your sources.list file.  Fix it first.  Then
run 'apt-get update'.  Then 'apt-get install -f' as suggested above.
Then install mysql-server.  Then you should be working.  This applies
to both your old Squeeze 6 as well as the current Wheezy 7.

I see by your many messages that you have had much trouble in this
area.  I think you have a system that is partially this and partially
that and partially something else.  So I don't really know where to
begin.  Start by posting your current sources.list file.  You need to
fix it first.

Are you trying to be Squeeze 6 with GNOME 2?  Are you trying to be
with Wheezy 7 with Mate?  What is your target goal?  If you don't know
where you are going then you might be late getting there.

Bob


signature.asc
Description: Digital signature