Index
Subject
: [lug] Digest (9 messages)
From
: lug-owner@lists.ncsu.[redacted]
Date
: Tue, 03 Mar 2015 16:25:42 -0500
The Lug Digest
Volume 1 : Issue 344 : "text" Format
Messages in this Issue:
201502/13 : Re: [TriLUG-announce] Meeting 12 March: Performance Analysis
Bill Farrow <bill@arrowsreach.[redacted]>
201502/14 : Re: [TriLUG-announce] Meeting 12 March: Performance Analysis
Joshua Small <jmsmall@ncsu.[redacted]>
201502/15 : Copyright for Software Engineers Talk (3/3,EB2 1227, 7pm)
"Stephen Waddell" <ArmillarySphere@mail.[redacted]>
201502/16 : Hack Day
"Stephen Waddell" <ArmillarySphere@mail.[redacted]>
201503/1 : Help with MySQL and sshfs.
Jeffery Mewtamer <mewtamer@gmail.[redacted]>
201503/2 : Re: Help with MySQL and sshfs.
Markus Eger <meger@ncsu.[redacted]>
201503/3 : Re: Help with MySQL and sshfs.
Shawn Taylor <taylorshawn@hotmail.[redacted]>
201503/4 : Re: Help with MySQL and sshfs.
Daniel Underwood <daniel.underwood@ncsu.[redacted]>
201503/5 : Re: Help with MySQL and sshfs.
Jim Turner <jdturne8@ncsu.[redacted]>
----------------------------------------------------------------------
Date: Tue, 24 Feb 2015 23:08:18 -0500
From: Bill Farrow <bill@arrowsreach.[redacted]>
To: lug@lists.ncsu.[redacted]
Cc: TriLUG General List <trilug@trilug.[redacted]>
Subject: Re: [TriLUG-announce] Meeting 12 March: Performance Analysis
Message-ID: <CAPm8Nr3pJe1AoOXfoYE170eCzdwVDLytE5oNNr3y5zA6SAuu0Q@mail.gmail.[redacted]>
On Tue, Feb 24, 2015 at 5:11 PM, Joshua Small <jmsmall@ncsu.[redacted]> wrote:
> I have a small question about calendar invites in case anyone knows the
> answer:
>
> My question is, do these emails have this capability that I can use or
> set-up, or could it be added to work simply by clicking a button every time?
Hey Josh,
I think I know what you want and we can probably get half way there
with the Drupal module "Add to Cal". This will hopefully present a
button that retrieves an iCal file with all of the event details - and
your personal calendar program would then add it to your calendar. I'm
working on this solution now...
I say that we can only get 50% of the way because you wanted this in
the email itself, but our mailing list is configured for plain-text
emails only, and this might mean you have to click on the link to the
website to get to the iCal button.
Bill
------------------------------
Date: Tue, 24 Feb 2015 23:33:50 -0500
From: Joshua Small <jmsmall@ncsu.[redacted]>
To: lug@lists.ncsu.[redacted]
Cc: TriLUG General List <trilug@trilug.[redacted]>
Subject: Re: [TriLUG-announce] Meeting 12 March: Performance Analysis
Message-ID: <CAPV1hbyvwskKkW1_Ljb4g5a4YGEqjZT+NXsizxAyJCpkbWV6zQ@mail.gmail.[redacted]>
That sounds great, can't wait to try it out!
On Feb 24, 2015 11:11 PM, "Bill Farrow" <bill@arrowsreach.[redacted]> wrote:
> On Tue, Feb 24, 2015 at 5:11 PM, Joshua Small <jmsmall@ncsu.[redacted]> wrote:
> > I have a small question about calendar invites in case anyone knows the
> > answer:
> >
> > My question is, do these emails have this capability that I can use or
> > set-up, or could it be added to work simply by clicking a button every
> time?
>
> Hey Josh,
> I think I know what you want and we can probably get half way there
> with the Drupal module "Add to Cal". This will hopefully present a
> button that retrieves an iCal file with all of the event details - and
> your personal calendar program would then add it to your calendar. I'm
> working on this solution now...
>
> I say that we can only get 50% of the way because you wanted this in
> the email itself, but our mailing list is configured for plain-text
> emails only, and this might mean you have to click on the link to the
> website to get to the iCal button.
>
> Bill
>
[Attachment of type text/html removed.]
------------------------------
Date: Fri, 27 Feb 2015 04:02:12 +0100
From: "Stephen Waddell" <ArmillarySphere@mail.[redacted]>
To: "LUG List" <lug@lists.ncsu.[redacted]>
Subject: Copyright for Software Engineers Talk (3/3,EB2 1227, 7pm)
Message-ID: <trinity-fb69da31-d144-408f-917b-a725c961b827-1425006132457@3capp-mailcom-lxa15>
Hello, The next meeting proper for the LUG will be held on 3/3 (this
upcoming Tuesday). Matthew Frasier (Leafstorm) will be giving a talk on
how copyright laws affect software. We'll be holding this meeting in EB2
room 1227 at 7pm. Stephen WaddellNC State UniversityLinux Users Group,
PR Officer
------------------------------
Date: Fri, 27 Feb 2015 22:18:36 +0100
From: "Stephen Waddell" <ArmillarySphere@mail.[redacted]>
To: "LUG List" <lug@lists.ncsu.[redacted]>
Subject: Hack Day
Message-ID: <trinity-f5faf8c2-3982-4a57-9e1e-fb165b8097f4-1425071916421@3capp-mailcom-lxa05>
Hello All, We'll be having one of our famous Hack Days tomorrow
(Sat,2/28) in Mann 304 from 12pm to 7pm. Come on out if you have some
work you'd like to share or just want to hang out. Stephen WaddellNC
State UniversityLinux Users Group, PR Officer
------------------------------
Date: Tue, 3 Mar 2015 19:11:03 +0000
From: Jeffery Mewtamer <mewtamer@gmail.[redacted]>
To: lug <lug@lists.ncsu.[redacted]>
Subject: Help with MySQL and sshfs.
Message-ID: <CAO2sX31qMiUYReO2kr75t2o=mU4Kg16ypxqpA7G-092P47ncyw@mail.gmail.[redacted]>
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.
[Attachment of type application/x-sh removed.]
------------------------------
Date: Tue, 3 Mar 2015 14:31:46 -0500
From: Markus Eger <meger@ncsu.[redacted]>
To: lug@lists.ncsu.[redacted]
Subject: Re: Help with MySQL and sshfs.
Message-ID: <CAO6OnT4br5cbiFbbgN62ezNsSLN_vBiZ2QMMui-vJ58Z7+aAcA@mail.gmail.[redacted]>
What command line are you using to connect to your mysql server? I don't
know the default configuration on Debian, but:
mysql -h localhost -u root -p
should work. If not, try:
mysql -h 127.0.0.1 -u root -p
(Yes, there is a difference: localhost will use a Unix socket file,
127.0.0.1 will use a network connection ...)
"Access Denied", if it's coming from mysql, is actually a good error to get
because it means that your server is up and running, and you just need to
figure out the correct permutation of flags.
hth, and if it doesn't, feel free to stop by on our IRC channel (#ncsulug
on freenode)
-Markus
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.
>
[Attachment of type text/html removed.]
------------------------------
Date: Tue, 3 Mar 2015 14:46:12 -0500
From: Shawn Taylor <taylorshawn@hotmail.[redacted]>
To: "lug@lists.ncsu.[redacted]" <lug@lists.ncsu.[redacted]>
Subject: Re: Help with MySQL and sshfs.
Message-ID: <BLU173-W431657C11AB12828AF83F2B1110@phx.[redacted]>
Go look at /etc/my.cnf and see if there is a default user/password in the [clients] section of the configuration on the server your prof is running.
If not, try typing in
mysql -U root -p <enter>
on your local server and see what happens.
Shawn
> Date: Tue, 3 Mar 2015 19:11:03 +0000
> Subject: Help with MySQL and sshfs.
> From: mewtamer@gmail.[redacted]
> To: lug@lists.ncsu.[redacted]
>
> 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.
[Attachment of type text/html removed.]
------------------------------
Date: Tue, 03 Mar 2015 15:10:18 -0500
From: Daniel Underwood <daniel.underwood@ncsu.[redacted]>
To: lug@lists.ncsu.[redacted]
Subject: Re: Help with MySQL and sshfs.
Message-ID: <1425413418.1348297.235059873.334A44F3@webmail.messagingengine.[redacted]>
Have you tried these commands?
$ sudo mysqladmin -u root -h localhost password 'mypassword'
$ sudo mysqladmin -u root -h myhostname password 'mypassword'
(source: https://ariejan.net/2007/12/12/how-to-install-mysql-on-ubuntudebian/)
When running the command on line 3 of your bash script, try using the following sshfs option:
-o IdentityFile=~/.ssh/id_rsa
(see http://unix.stackexchange.com/questions/61567/sshfs-specify-key)
I'm not an expert when it comes to databases and sshfs, so someone else can probably chime in if I'm off base here. But maybe these suggestions will help.
-Daniel
On Tue, Mar 3, 2015, at 02:11 PM, Jeffery Mewtamer 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.
> Email had 1 attachment:
> + mount.sh
> 1k (application/x-sh)
--
Daniel Underwood
North Carolina State University
PhD Candidate - Industrial Engineering
email: daniel.underwood@ncsu.[redacted]
phone: XXX.302.3291
web: http://djunderwood.net
------------------------------
Date: Tue, 3 Mar 2015 16:24:56 -0500
From: Jim Turner <jdturne8@ncsu.[redacted]>
To: lug@lists.ncsu.[redacted]
Subject: Re: Help with MySQL and sshfs.
Message-ID: <CABSFCMRxqdriZZ7oKk-yhQstCx5xeEw+BA1d0avrTLwQrBaV9Q@mail.gmail.[redacted]>
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.
>
[Attachment of type text/html removed.]
------------------------------
End of [lug] Digest (9 messages)
**********