Hi Arjen,

I'll have to run this past my MD as this is an unscheduled job in this
project and I need to see how much budget is available; I'll get back to
you as soon as there is an answer.

Kindest Regards

XXXXXXXXXXX

XXXXXXXXXXX
Web Designer
XXXXXXXXXXX Ltd
XXXXXXXXXXX logo
XXXXXXXXXXX
XXXXXXXXXXX

Tel:       XXXXXXXXXXX
Fax:      XXXXXXXXXXX
E-mail:  XXXXXXXXXXX@XXXXXXXXXXX.com
Web:    www.XXXXXXXXXXX.com
Connect with me on Skype: XXXXXXXXXXX, Twitter: XXXXXXXXXXX or
LinkedIn
Please consider the environment before printing this e-mail

> -----Original Message-----
> From: Arjen Lentz [via OQ Service Tracker]
[mailto:XXXXXXXXXXX]
> Sent: 03 August 2009 12:51
> To: XXXXXXXXXXX
> Subject: [OQ#322] Re: Open Query inquiry - MySQL tweaks for Joomla
site
> (XXXXXXXXXXX)[Scanned]
> 
> Hi XXXXXXXXXXX,
> 
> On Tue, 04 Aug 2009, 06:25:02 EST, XXXXXXXXXXX@XXXXXXXXXXX.com wrote:
> > OK, PHPMyAdmin is telling me I'm on MySQL client version: 5.0.45
> > We're on Redhat Enterprise Linux 5.3 over at XXXXXXXXXXX with Apache
and
> PHP.
> >
> > If there are any more details you need I can try and dig them out.
The
> > MySQL default config *may* have been changed but I will chase
XXXXXXXXXXX
> > support to check for sure.
> 
> No worries.
> 
> Ok, and you'd like us to take a take a peek at the setup and tweak it,
> within the boundaries of the version of Joomla you run and the
underlying
> server? For a single server where we can't directly get queries
changed in
> the app above, we'd a minimum of 4 hours, up to 8 depending on the
exact
> situation.
> 
> As you've probably seen on the OQ site, our rate for remote work is
EUR
> XXXXXXXXXXX. Payment is through visa/mastercard or PayPal, and in the case
of a
> limited amount of ad-hoc work we post-bill. We don't do "statements of
> work" as we don't regard it realistic to diagnose a patient before
seeing
> them. However, we'd note our initial findings back to you so the rest
of
> the work can be tuned to your needs and wishes.
> 
> The easiest way for us to work is direct on the box through SSH, with
> appropriate access levels for MySQL and Linux (generally root on
both).
> We'll generate an SSH key specifically for you which we can use for
the
> login, and then use sudo for Linux root needs. Naturally that needs to
be
> set up from your end (or by XXXXXXXXXXX).
> 
> I've just generated a key for XXXXXXXXXXX, and the public key is:
> ssh-rsa
>
AAAAB3NzaC1yc2EAAAABIwAAAgEArmv/i07FmaBXohz+aonB5EjRc0OMD46Ej2NiJuR+Hrv8
4h
>
bIR58J5tWFQij5DnYIvcO2mQbtDRVjYZWC824LYXxnzwQJn1x7I6WrcyyDxxTG/Nt13IcnI0
fW
>
upeS3Iwb5LyEz4MPgg1BX8g1MDSBAel0bfS+g5IaerB++U2s0Xon/4lHNIxWSZUuex+to1S7
gl
>
9iRbwiYRC7GN0U9+a9xpAJlQzaL+YEXcxlUwaKX0xNwM59RpGjuNqddzoHw99wUKRFrYiJqv
lF
>
sdEUrm0u+ONlEM0igZd1niXOY4qsCwmjmH0VDfM7bui0qa5jHB1k4aKwNN9CKd2vyK6WRPKO
kI
>
9lB2RtiqQ6fcAQ1WnFTETwbHBCkAEV4KHkt/uhZhHfZcJsBQtyCDf4fdHfzbs0eTRftQtYyE
zI
>
X1yW1YOEK9Oh0c9nZnJ4kvQzWX3CM6ufOtmrVbgXPIxi2Fug7ZZoaKUONn8EZPn4XBgZ7QkW
k/
>
bb9MHWSFmoFPpG81kWXk+Gy6iQsVxQtVYfPKt3UNBfU5ryyFf7DtnJ1wGFuqyFALEPOvWwNk
Jr
>
uiCKgaVrjXn//DZdFa6TE+d+kmJ84AmgJFQVEogvcR7ptq0Okj9OpN4VR14VPQWdvE6rWLAx
kj
> wqjuuEx9SaXLKA6qdmBfKmYetVy4YCDKqQ+RGgWWylqGM= service@openquery.com
> 
> It's easiest you create a user openquery on Linux with that key (copy
into
> ~openquery/.ssh/authorized_keys), add openquery to the group that's
> allowed to use sudo, and a "GRANT ALL ON *.* TO openquery@localhost
> IDENTIFIED BY 'somepwd'" in MySQL which equates to root-equivalent
access
> on local connections.
> The Linux user will also require a password for sudo.
> You can place both passwords in a file in ~openquery, so we can see it
> when we first get in using our key, without the password getting
> transferred over email or other insecure channels.
> 
> 
> If all that is ok, just send us the IP or domain address of the
server,
> any details from the above which in setup deviate from the suggested
> defaults, and I'll assign an engineer to take a first peek!
> Thanks
> 
> Regards,
> Arjen.
> --
> Arjen Lentz, Director @ Open Query (http://openquery.com)
> Affordable Training and ProActive Support for MySQL & related
technologies
> 
> Follow our blog at http://openquery.com/blog/
> OurDelta: free enhanced builds for MySQL @ http://ourdelta.org
