Index
Subject
: [lug] Digest (8 messages)
From
: lug-owner@lists.ncsu.[redacted]
Date
: Mon, 16 Mar 2015 17:47:28 -0400
The Lug Digest
Volume 1 : Issue 345 : "text" Format
Messages in this Issue:
201503/6 : Re: Help with MySQL and sshfs.
Jeffery Mewtamer <mewtamer@gmail.[redacted]>
201503/7 : Re: Help with MySQL and sshfs.
Kyle Ferriter <krferrit@ncsu.[redacted]>
201503/8 : Re: Help with MySQL and sshfs.
Jeffery Mewtamer <mewtamer@gmail.[redacted]>
201503/9 : [TriLUG-announce] TriLUG Meeting Thursday 12 March: Performance
Analysis
Bill Farrow <bill@arrowsreach.[redacted]>
201503/10 : Spam at FOSS Fair 2015 page
Vaclav Petras <vpetras@ncsu.[redacted]>
201503/11 : (no subject)
"Stephen Waddell" <ArmillarySphere@mail.[redacted]>
201503/12 : Tuesday 3/17 at 7pm in EB2 1227
"Stephen Waddell" <ArmillarySphere@mail.[redacted]>
201503/13 : Re: Tuesday 3/17 at 7pm in EB2 1227
Quentin Young <qlyoung@ncsu.[redacted]>
----------------------------------------------------------------------
Date: Tue, 3 Mar 2015 21:57:55 +0000
From: Jeffery Mewtamer <mewtamer@gmail.[redacted]>
To: lug@lists.ncsu.[redacted]
Subject: Re: Help with MySQL and sshfs.
Message-ID: <CAO2sX33Jvtnkv4MUd=2R-o510mjZgJGKb_=ktu17KbS9eS5_Vg@mail.gmail.[redacted]>
It'll be Thursday before I can test the suggestions for my sshfs
issue(can only access the server while my netbook is connected to the
school network). Must admit that I've become a bit spoiled from having
pmount handle the creation and permission setting of mount points.
As for mysql,
mysql -u root -p
Fixes my access denied issue and give my the mysql prompt I'm use to
being presented with after typing mysql after ssh-ing into the school
server.
I am running into another issue however. After reboot, trying to login
to mysql give me the following error:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)
Telling Aptitude to reinstall the mysql packages resolves this, but
only until the next reboot. From Aptitude's output, I suspect that
Aptitude automatically starts the local mysql server upon
installation, but the server has to be manually started after each
reboot(and Google isn't be very helpful on initial search).
On 3/3/15, Jim Turner <jdturne8@ncsu.[redacted]> wrote:
> Regarding the sshfs issue, it looks like the problem is that you are
> creating the /media/ssh directory owned by root. Assuming your username and
> group are `jeffrey`, you can create the directory, make yourself the owner,
> and set the permissions like this:
>
> sudo mkdir /media/ssh
> sudo chown jeffrey:jeffrey /media/ssh
> chmod 755 /media/ssh
>
> You only need to do this once, unless your /media directory gets cleared on
> each reboot or something. (You can choose different permissions with chmod
> if you'd like, e.g. 777 for all users to access it.)
>
> Then, whenever you want to mount the remote directory via sshfs, you should
> be able to do it without sudo:
>
> sshfs dbwright@oracledev.ecsu.[redacted]: /media/ssh
>
> By the way, if you'd prefer a GUI, the Nautilus (GNOME), Thunar (XFCE), and
> Dolphin (KDE) file managers (among others) have built-in support for
> mounting remote directories via sftp. You can also bookmark the remote link
> in the file manager so that it's easy to connect.
>
> Jim
>
> On Tue, Mar 3, 2015 at 2:11 PM, Jeffery Mewtamer <mewtamer@gmail.[redacted]>
> wrote:
>
>> I'm presently taking a Database class and we're working with MySQL. In
>> class, I can simply use ssh to log-in to the school's server and
>> access a MySQL server administered by the professor, but I need to
>> set-up a local environment for out of class assignments. I've
>> installed the mysql-client and mysql-server packages from the Debian
>> repositories, but get an access denied error when I type the mysql
>> command at my terminal. Any idea on what I need to do next in get
>> MySQL set-up for local use?
>>
>> Also, I've been using sshfs to mount my network drive on the school's
>> server to my local file system for moving files between locl and
>> network storage, but can't figure out how to mount the network drive
>> without needing to use sudo to read or write to/from the network
>> drive. I've attached the bash script I use when I need to mount the
>> network drive and would like input on how to modify it to have
>> /media/ssh act like a local removable disk.
>>
>> Thanks in and vance for any help.
>>
>> --
>> Sincerely,
>>
>> Jeffery Wright
>> President Emeritus, Nu Nu Chapter, Phi Theta Kappa.
>> Former Secretary, Student Government Association, College of the
>> Albemarle.
>>
>
--
Sincerely,
Jeffery Wright
President Emeritus, Nu Nu Chapter, Phi Theta Kappa.
Former Secretary, Student Government Association, College of the Albemarle.
------------------------------
Date: Tue, 3 Mar 2015 18:35:44 -0500
From: Kyle Ferriter <krferrit@ncsu.[redacted]>
To: lug@lists.ncsu.[redacted]
Subject: Re: Help with MySQL and sshfs.
Message-ID: <CAEH4A+CVfhbr5baLn-+Q3C3rPgAKJGg+eOMeRwezhAn5YyVpSA@mail.gmail.[redacted]>
I've never used MySQL, but I'm guessing the package installs a service,
which Aptitude will automatically start for you, but won't be autostarted
on boot. Since you probably won't need it always running, I wouldn't
recommend setting it to autostart, just start it whenever you need it.
http://askubuntu.com/a/19324/155645
It looks like maybe "sudo service mysqld start" might do it.
On Tue, Mar 3, 2015 at 4:57 PM, Jeffery Mewtamer <mewtamer@gmail.[redacted]> wrote:
> It'll be Thursday before I can test the suggestions for my sshfs
> issue(can only access the server while my netbook is connected to the
> school network). Must admit that I've become a bit spoiled from having
> pmount handle the creation and permission setting of mount points.
>
> As for mysql,
>
> mysql -u root -p
>
> Fixes my access denied issue and give my the mysql prompt I'm use to
> being presented with after typing mysql after ssh-ing into the school
> server.
>
> I am running into another issue however. After reboot, trying to login
> to mysql give me the following error:
>
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> '/var/run/mysqld/mysqld.sock' (2)
>
> Telling Aptitude to reinstall the mysql packages resolves this, but
> only until the next reboot. From Aptitude's output, I suspect that
> Aptitude automatically starts the local mysql server upon
> installation, but the server has to be manually started after each
> reboot(and Google isn't be very helpful on initial search).
>
> On 3/3/15, Jim Turner <jdturne8@ncsu.[redacted]> wrote:
> > Regarding the sshfs issue, it looks like the problem is that you are
> > creating the /media/ssh directory owned by root. Assuming your username
> and
> > group are `jeffrey`, you can create the directory, make yourself the
> owner,
> > and set the permissions like this:
> >
> > sudo mkdir /media/ssh
> > sudo chown jeffrey:jeffrey /media/ssh
> > chmod 755 /media/ssh
> >
> > You only need to do this once, unless your /media directory gets cleared
> on
> > each reboot or something. (You can choose different permissions with
> chmod
> > if you'd like, e.g. 777 for all users to access it.)
> >
> > Then, whenever you want to mount the remote directory via sshfs, you
> should
> > be able to do it without sudo:
> >
> > sshfs dbwright@oracledev.ecsu.[redacted]: /media/ssh
> >
> > By the way, if you'd prefer a GUI, the Nautilus (GNOME), Thunar (XFCE),
> and
> > Dolphin (KDE) file managers (among others) have built-in support for
> > mounting remote directories via sftp. You can also bookmark the remote
> link
> > in the file manager so that it's easy to connect.
> >
> > Jim
> >
> > On Tue, Mar 3, 2015 at 2:11 PM, Jeffery Mewtamer <mewtamer@gmail.[redacted]>
> > wrote:
> >
> >> I'm presently taking a Database class and we're working with MySQL. In
> >> class, I can simply use ssh to log-in to the school's server and
> >> access a MySQL server administered by the professor, but I need to
> >> set-up a local environment for out of class assignments. I've
> >> installed the mysql-client and mysql-server packages from the Debian
> >> repositories, but get an access denied error when I type the mysql
> >> command at my terminal. Any idea on what I need to do next in get
> >> MySQL set-up for local use?
> >>
> >> Also, I've been using sshfs to mount my network drive on the school's
> >> server to my local file system for moving files between locl and
> >> network storage, but can't figure out how to mount the network drive
> >> without needing to use sudo to read or write to/from the network
> >> drive. I've attached the bash script I use when I need to mount the
> >> network drive and would like input on how to modify it to have
> >> /media/ssh act like a local removable disk.
> >>
> >> Thanks in and vance for any help.
> >>
> >> --
> >> Sincerely,
> >>
> >> Jeffery Wright
> >> President Emeritus, Nu Nu Chapter, Phi Theta Kappa.
> >> Former Secretary, Student Government Association, College of the
> >> Albemarle.
> >>
> >
>
>
> --
> Sincerely,
>
> Jeffery Wright
> President Emeritus, Nu Nu Chapter, Phi Theta Kappa.
> Former Secretary, Student Government Association, College of the Albemarle.
>
[Attachment of type text/html removed.]
------------------------------
Date: Wed, 4 Mar 2015 12:10:48 +0000
From: Jeffery Mewtamer <mewtamer@gmail.[redacted]>
To: lug@lists.ncsu.[redacted]
Subject: Re: Help with MySQL and sshfs.
Message-ID: <CAO2sX33XwL=3OZ6oF8ezpDpSraY-192YppBXSEqBOhFRcsxcpg@mail.gmail.[redacted]>
Turns out the correct command for starting the mysql service is:
sudo service mysql start
With this, I think my setup is to the point that any futher questions
should be within the scope of the course and within my proffessor's
knowledge(the school I'm currently attending is much smaller and less
cosmopolitan than NC State and I find myself the token Linux user in a
class full of Windows users, so the professor is more familiar with
helping students set-up a local working envornment on Windows
machines).
I'll report back regarding the sshfs issue after I can test the
solutions during class tomorrow.
On 3/3/15, Jim Turner <jdturne8@ncsu.[redacted]> wrote:
> Regarding the sshfs issue, it looks like the problem is that you are
> creating the /media/ssh directory owned by root. Assuming your username and
> group are `jeffrey`, you can create the directory, make yourself the owner,
> and set the permissions like this:
>
> sudo mkdir /media/ssh
> sudo chown jeffrey:jeffrey /media/ssh
> chmod 755 /media/ssh
>
> You only need to do this once, unless your /media directory gets cleared on
> each reboot or something. (You can choose different permissions with chmod
> if you'd like, e.g. 777 for all users to access it.)
>
> Then, whenever you want to mount the remote directory via sshfs, you should
> be able to do it without sudo:
>
> sshfs dbwright@oracledev.ecsu.[redacted]: /media/ssh
>
> By the way, if you'd prefer a GUI, the Nautilus (GNOME), Thunar (XFCE), and
> Dolphin (KDE) file managers (among others) have built-in support for
> mounting remote directories via sftp. You can also bookmark the remote link
> in the file manager so that it's easy to connect.
>
> Jim
>
> On Tue, Mar 3, 2015 at 2:11 PM, Jeffery Mewtamer <mewtamer@gmail.[redacted]>
> wrote:
>
>> I'm presently taking a Database class and we're working with MySQL. In
>> class, I can simply use ssh to log-in to the school's server and
>> access a MySQL server administered by the professor, but I need to
>> set-up a local environment for out of class assignments. I've
>> installed the mysql-client and mysql-server packages from the Debian
>> repositories, but get an access denied error when I type the mysql
>> command at my terminal. Any idea on what I need to do next in get
>> MySQL set-up for local use?
>>
>> Also, I've been using sshfs to mount my network drive on the school's
>> server to my local file system for moving files between locl and
>> network storage, but can't figure out how to mount the network drive
>> without needing to use sudo to read or write to/from the network
>> drive. I've attached the bash script I use when I need to mount the
>> network drive and would like input on how to modify it to have
>> /media/ssh act like a local removable disk.
>>
>> Thanks in and vance for any help.
>>
>> --
>> Sincerely,
>>
>> Jeffery Wright
>> President Emeritus, Nu Nu Chapter, Phi Theta Kappa.
>> Former Secretary, Student Government Association, College of the
>> Albemarle.
>>
>
--
Sincerely,
Jeffery Wright
President Emeritus, Nu Nu Chapter, Phi Theta Kappa.
Former Secretary, Student Government Association, College of the Albemarle.
------------------------------
Date: Sun, 8 Mar 2015 09:57:14 -0400
From: Bill Farrow <bill@arrowsreach.[redacted]>
To: TriLUG General List <trilug@trilug.[redacted]>,
TriLUG Announce <trilug-announce@trilug.[redacted]>
Subject: [TriLUG-announce] TriLUG Meeting Thursday 12 March: Performance
Analysis
Message-ID: <CAPm8Nr0NYKwUJUDakFgjnXj7MyenhU--pgVSLQLj_1uuAv7F+w@mail.gmail.[redacted]>
Topic: Performance Analysis
Presenter: Jeremy Eder
When: Thursday, 12th March 2015, 7pm - 9pm (6:45pm for pizza)
Where: NC State Engineering Building II Room 1021, Centennial Campus
Parking: The parking decks and Oval Drive street parking are free after 5pm
https://trilug.org/2015-03-12/performance
Synopsis:
Jeremy will provide an overview of how the Performance Engineering
group at Red Hat approaches performance analysis, show specific
examples of testing methods that produced interesting results, and
show how they are able to performance-tune infrastructure in the field
using tools like tuned.
You will leave with a new appreciation for how many knobs and levers
are available in the Linux kernel, and understanding how a practical
approach to performance tuning can have a big impact on every-day
deployments.
Bio:
Jeremy Eder is a Principal Software Engineer and Network Performance
Lead at Red Hat Inc, where he specializes in measurement and analysis
of kernel-related performance metrics, and using that analysis to
guide performance-tuning of real-world infrastructure.
--
This message was sent to: lug@lists.ncsu.[redacted] <lug@lists.ncsu.[redacted]>
To unsubscribe, send a blank message to trilug-announce-leave@trilug.[redacted] from that address.
TriLUG-announce mailing list : http://www.trilug.org/mailman/listinfo/trilug-announce
Unsubscribe or edit options on the web : http://www.trilug.org/mailman/options/trilug-announce/lug%40lists.ncsu.edu
TriLUG is dedicated to a harassment-free experience for everyone. Our anti-harassment policy can be found at: http://trilug.org/anti-harassment
------------------------------
Date: Thu, 12 Mar 2015 11:00:48 -0400
From: Vaclav Petras <vpetras@ncsu.[redacted]>
To: lug@lists.ncsu.[redacted]
Subject: Spam at FOSS Fair 2015 page
Message-ID: <CAJeX9NrXEtCF5DeixWDYJiJ3Uxf4_uLMLC=UWf2_U0ePGWgg1w@mail.gmail.[redacted]>
Hello LUG,
thanks for a great FOSS Fair. When looking back to it, I noticed that the
page is being spammed. I guess I could just revert but it applies to
different versions from different users.
I don't know who is the administrator, that's why I'm writing to the list.
Best,
Vashek
http://lug.ncsu.edu/fossfair/FossFair2015
http://lug.ncsu.edu/fossfair/FossFair2015?action=info
[Attachment of type text/html removed.]
------------------------------
Date: Mon, 16 Mar 2015 21:31:10 +0100
From: "Stephen Waddell" <ArmillarySphere@mail.[redacted]>
To: "LUG List" <lug@lists.ncsu.[redacted]>
Message-ID: <trinity-15aafe5e-f405-4efc-8ad3-a0e03569a295-1426537870014@3capp-mailcom-lxa15>
Hi Lug People, We have an awesome talk taking place this week, given by
Berry Peddycord III take a look: In this meeting, Barry will hold a
workshop on getting a virtual private server running on Digital Ocean. A
few of the activities will include setting up a reverse proxy for hosting
a personal wiki, setting up a personal IRC bouncer using ZNC, hosting
your own private git repositories, and other topics as requested by the
audience.
Before coming to the meeting, please visit http://isharacomix.org/speaking/foss-fair-2015/ and
follow the instructions for getting your account started - if you are a
student, you can create an account for free without providing a credit
card by using the Github explorer's pack. This will maximize the amount
of time we have in the workshop for doing more interesting things!
The meeting will be held at EB2 room 1227 at 7:00pm on Tuesday 3/17.
Hope to see you there! Signed, Stephen WaddellNC State UniversityLinux
Users Group, PR OfficerArt Studies, Computer Programming Minor
------------------------------
Date: Mon, 16 Mar 2015 21:37:16 +0100
From: "Stephen Waddell" <ArmillarySphere@mail.[redacted]>
To: "LUG List" <lug@lists.ncsu.[redacted]>
Subject: Tuesday 3/17 at 7pm in EB2 1227
Message-ID: <trinity-478eeb13-31ee-4160-8476-1332b9cecce7-1426538236227@3capp-mailcom-lxa04>
Hi all, Sorry about that, i forgot the subject line for the last one.
Just to reiterate this Tuesday we have a talk by Berry on VPNs via
DigitalOcean.
------------------------------
Date: Mon, 16 Mar 2015 17:47:24 -0400
From: Quentin Young <qlyoung@ncsu.[redacted]>
To: lug@lists.ncsu.[redacted]
Subject: Re: Tuesday 3/17 at 7pm in EB2 1227
Message-ID: <CANhSzx0gcNzLDoZFFy2BLP=gzJx0Kt4sS=LzPvs98VqUdHcnBg@mail.gmail.[redacted]>
VPS's, not vpn's :)
On Mar 16, 2015 5:45 PM, "Stephen Waddell" <ArmillarySphere@mail.[redacted]> wrote:
> Hi all,
>
> Sorry about that, i forgot the subject line for the last one. Just to
> reiterate this Tuesday we have a talk by Berry on VPNs via DigitalOcean.
>
>
>
[Attachment of type text/html removed.]
------------------------------
End of [lug] Digest (8 messages)
**********