[SGVLUG] Shell quoting

[Matt Campbell]

Ok, that left out a layer.

The full correct command would be:

system('ssh -l<user> <isp shell host> \'bash -c \\\'mysql -u<database user>
<database name> -p <database password> -h <isp sql host> \\\\\\\'ALTER TABLE
\\\\\\\`Layouts\\\\\\\` ORDER BY \\\\\\\`Date\\\\\\\`;\\\\\\\'\\\' 2\\>\\&1
\' '

Matt

> -----Original Message-----
> From: Matt Campbell [mailto:dvdmatt at gmail.com]
> Sent: Monday, April 19, 2010 9:51 AM
> To: DVDMatt Cambell; 'SGVLUG Discussion List.'
> Subject: RE: [SGVLUG] Shell quoting
> 
> Really sorry for all the typos, that's what I get for 2 hours of sleep.
> ;)
> 
> The correct command should have read:
> 
> 'ssh -l<user> <isp shell host> \'mysql -u<database user> <database
> name> -p <database password> -h <isp sql host> \\\'ALTER TABLE
> \\\`Layouts\\\` ORDER BY \\\`Date\\\`;\\\'\' '
> 
> Matt
> 
> > -----Original Message-----
> > From: Matt Campbell [mailto:dvdmatt at gmail.com]
> > Sent: Monday, April 19, 2010 9:48 AM
> > To: 'SGVLUG Discussion List.'
> > Subject: RE: [SGVLUG] Shell quoting
> >
> > Hi Dan,
> >
> > Trying to run a SQL statement on my web server reqmotely.  The SQL
> > engine is protected to localhost only so I have to ssh to the host to
> > run the SQL.
> >
> > I am trying to write a generic execute function for future project.
> I
> > don't want to assume what the default shell is locally or remotely.
> >
> > The whole command that does not work is:
> > 'ssh -l<user> \'<isp shell host> mysql -u<database user> <database
> > name> -p <database password> -h <isp sql host> \\\'ALTER TABLE
> > \\\`Layouts\\\` ORDER BY \\\`Date\\\`;\\\'\' '
> >
> > I have played with a couple dozen versions of quoting the quotes to
> no
> > avail.  I do not want to mix quotes (which works) as I need to be
> able
> > to programmatically quote all types of quotes in the arbitrary
> command
> > passed to this function.
> >
> > Thanks for looking at it!
> >
> > Matt
> >
> >
> > > -----Original Message-----
> > > From: sgvlug-bounces at sgvlug.net [mailto:sgvlug-bounces at sgvlug.net]
> On
> > > Behalf Of Dan Kegel
> > > Sent: Monday, April 19, 2010 9:38 AM
> > > To: SGVLUG Discussion List.
> > > Subject: Re: [SGVLUG] Shell quoting
> > >
> > > On Mon, Apr 19, 2010 at 9:29 AM, Matt Campbell <dvdmatt at gmail.com>
> > > wrote:
> > > > Wow.  And I thought I knew my shell cold.
> > > >
> > > > Does anyone know the logic why this does not work?
> > > >
> > > >     matt at scar:166% bash -c 'echo \'ALTER TABLE\' '
> > > >
> > > >     Unmatched '.
> > > >
> > > > And how this is actually parsed?
> > > >
> > > >     matt at scar:144% bash -c echo 'ALTER TABLE `Components`'
> > > >
> > > >     (returns a blank line)
> > >
> > > What are you trying to do?  i.e. what do you want to appear in the
> > > final output?
> > > I guess you're generating a shell script that will generate SQL?
> > >
> > > - Dan