--
-- Host: localhost    Database: t1
-- ------------------------------------------------------


--
-- Table structure for table `test`
--

CREATE TABLE `test` (
  `seb_sup_id` int(11) unsigned NOT NULL,
  `seb_body` longtext NOT NULL,
  `seb_full_email` longtext NOT NULL,
  PRIMARY KEY (`seb_sup_id`),
  FULLTEXT KEY `ft_support_email` (`seb_body`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `test`
--

INSERT INTO `test` VALUES (4535,'Hi Arjen,\r\n\r\nI\'ll have to run this past my MD as this is an unscheduled job in this\r\nproject and I need to see how much budget is available; I\'ll get back to\r\nyou as soon as there is an answer.\r\n\r\nKindest Regards\r\n\r\nXXXXXXXXXXX\r\n\r\nXXXXXXXXXXX\r\nWeb Designer\r\nXXXXXXXXXXX Ltd\r\nXXXXXXXXXXX logo\r\nXXXXXXXXXXX\r\nXXXXXXXXXXX\r\n\r\nTel:       XXXXXXXXXXX\r\nFax:      XXXXXXXXXXX\r\nE-mail:  XXXXXXXXXXX@XXXXXXXXXXX.com\r\nWeb:    www.XXXXXXXXXXX.com\r\nConnect with me on Skype: XXXXXXXXXXX, Twitter: XXXXXXXXXXX or\r\nLinkedIn\r\nPlease consider the environment before printing this e-mail\r\n\r\n> -----Original Message-----\r\n> From: Arjen Lentz [via OQ Service Tracker]\r\n[mailto:XXXXXXXXXXX]\r\n> Sent: 03 August 2009 12:51\r\n> To: XXXXXXXXXXX\r\n> Subject: [OQ#322] Re: Open Query inquiry - MySQL tweaks for Joomla\r\nsite\r\n> (XXXXXXXXXXX)[Scanned]\r\n> \r\n> Hi XXXXXXXXXXX,\r\n> \r\n> On Tue, 04 Aug 2009, 06:25:02 EST, XXXXXXXXXXX@XXXXXXXXXXX.com wrote:\r\n> > OK, PHPMyAdmin is telling me I\'m on MySQL client version: 5.0.45\r\n> > We\'re on Redhat Enterprise Linux 5.3 over at XXXXXXXXXXX with Apache\r\nand\r\n> PHP.\r\n> >\r\n> > If there are any more details you need I can try and dig them out.\r\nThe\r\n> > MySQL default config *may* have been changed but I will chase\r\nXXXXXXXXXXX\r\n> > support to check for sure.\r\n> \r\n> No worries.\r\n> \r\n> Ok, and you\'d like us to take a take a peek at the setup and tweak it,\r\n> within the boundaries of the version of Joomla you run and the\r\nunderlying\r\n> server? For a single server where we can\'t directly get queries\r\nchanged in\r\n> the app above, we\'d a minimum of 4 hours, up to 8 depending on the\r\nexact\r\n> situation.\r\n> \r\n> As you\'ve probably seen on the OQ site, our rate for remote work is\r\nEUR\r\n> XXXXXXXXXXX. Payment is through visa/mastercard or PayPal, and in the case\r\nof a\r\n> limited amount of ad-hoc work we post-bill. We don\'t do \"statements of\r\n> work\" as we don\'t regard it realistic to diagnose a patient before\r\nseeing\r\n> them. However, we\'d note our initial findings back to you so the rest\r\nof\r\n> the work can be tuned to your needs and wishes.\r\n> \r\n> The easiest way for us to work is direct on the box through SSH, with\r\n> appropriate access levels for MySQL and Linux (generally root on\r\nboth).\r\n> We\'ll generate an SSH key specifically for you which we can use for\r\nthe\r\n> login, and then use sudo for Linux root needs. Naturally that needs to\r\nbe\r\n> set up from your end (or by XXXXXXXXXXX).\r\n> \r\n> I\'ve just generated a key for XXXXXXXXXXX, and the public key is:\r\n> ssh-rsa\r\n>\r\nAAAAB3NzaC1yc2EAAAABIwAAAgEArmv/i07FmaBXohz+aonB5EjRc0OMD46Ej2NiJuR+Hrv8\r\n4h\r\n>\r\nbIR58J5tWFQij5DnYIvcO2mQbtDRVjYZWC824LYXxnzwQJn1x7I6WrcyyDxxTG/Nt13IcnI0\r\nfW\r\n>\r\nupeS3Iwb5LyEz4MPgg1BX8g1MDSBAel0bfS+g5IaerB++U2s0Xon/4lHNIxWSZUuex+to1S7\r\ngl\r\n>\r\n9iRbwiYRC7GN0U9+a9xpAJlQzaL+YEXcxlUwaKX0xNwM59RpGjuNqddzoHw99wUKRFrYiJqv\r\nlF\r\n>\r\nsdEUrm0u+ONlEM0igZd1niXOY4qsCwmjmH0VDfM7bui0qa5jHB1k4aKwNN9CKd2vyK6WRPKO\r\nkI\r\n>\r\n9lB2RtiqQ6fcAQ1WnFTETwbHBCkAEV4KHkt/uhZhHfZcJsBQtyCDf4fdHfzbs0eTRftQtYyE\r\nzI\r\n>\r\nX1yW1YOEK9Oh0c9nZnJ4kvQzWX3CM6ufOtmrVbgXPIxi2Fug7ZZoaKUONn8EZPn4XBgZ7QkW\r\nk/\r\n>\r\nbb9MHWSFmoFPpG81kWXk+Gy6iQsVxQtVYfPKt3UNBfU5ryyFf7DtnJ1wGFuqyFALEPOvWwNk\r\nJr\r\n>\r\nuiCKgaVrjXn//DZdFa6TE+d+kmJ84AmgJFQVEogvcR7ptq0Okj9OpN4VR14VPQWdvE6rWLAx\r\nkj\r\n> wqjuuEx9SaXLKA6qdmBfKmYetVy4YCDKqQ+RGgWWylqGM= service@openquery.com\r\n> \r\n> It\'s easiest you create a user openquery on Linux with that key (copy\r\ninto\r\n> ~openquery/.ssh/authorized_keys), add openquery to the group that\'s\r\n> allowed to use sudo, and a \"GRANT ALL ON *.* TO openquery@localhost\r\n> IDENTIFIED BY \'somepwd\'\" in MySQL which equates to root-equivalent\r\naccess\r\n> on local connections.\r\n> The Linux user will also require a password for sudo.\r\n> You can place both passwords in a file in ~openquery, so we can see it\r\n> when we first get in using our key, without the password getting\r\n> transferred over email or other insecure channels.\r\n> \r\n> \r\n> If all that is ok, just send us the IP or domain address of the\r\nserver,\r\n> any details from the above which in setup deviate from the suggested\r\n> defaults, and I\'ll assign an engineer to take a first peek!\r\n> Thanks\r\n> \r\n> Regards,\r\n> Arjen.\r\n> --\r\n> Arjen Lentz, Director @ Open Query (http://openquery.com)\r\n> Affordable Training and ProActive Support for MySQL & related\r\ntechnologies\r\n> \r\n> Follow our blog at http://openquery.com/blog/\r\n> OurDelta: free enhanced builds for MySQL @ http://ourdelta.org\r\n','Return-Path: <XXXXXXXXX@XXXXXXXXX.com>\r\nReceived: from cartman.pipegrep.com.au ([unix socket]) by cartman.pipegrep.com.au (Cyrus v2.2.13-Debian-2.2.13-14+b3) with LMTPA; Mon, 03 Aug 2009 12:18:43 +0000\r\nX-Sieve: CMU Sieve 2.2\r\nReceived: from hostXXXXXXXXX.in-addr.btopenworld.com ([XXXXXXXXX] helo=mail.XXXXXXXXX.com) by cartman.pipegrep.com.au with esmtp (Exim 4.69) (envelope-from <XXXXXXXXX@XXXXXXXXX.com>) id 1MXwV0-00041g-PW for XXXXXXXXX; Mon, 03 Aug 2009 12:18:43 +0000\r\nContent-class: urn:content-classes:message\r\nMIME-Version: 1.0\r\nContent-Type: text/plain; charset=\"us-ascii\"\r\nContent-Transfer-Encoding: quoted-printable\r\nSubject: RE: [OQ#322] Re: Open Query inquiry - MySQL tweaks for Joomla site (XXXXXXXXX)[Scanned]\r\nX-MimeOLE: Produced By Microsoft Exchange V6.5\r\nDate: Mon, 3 Aug 2009 13:18:33 +0100\r\nMessage-ID: <9B40F2E2EFAA6C40B9EC441545C44B4A836908@XXXXXXXXX>\r\nIn-Reply-To: <eventum.1le43znw.bud2rz@eventum.openquery.com.au>\nX-MS-Has-Attach: \r\nX-MS-TNEF-Correlator: \r\nThread-Topic: [OQ#322] Re: Open Query inquiry - MySQL tweaks for Joomla site (XXXXXXXXX)[Scanned]\r\nthread-index: AcoUMLBSMmTMBml0RJu1WhOTL8TxRQAA22oQ\r\nReferences: <eventum.1le1qw2p.9z1f2c@eventum.openquery.com.au>\r\n <eventum.1le1rppv.nujgga@eventum.openquery.com.au>\r\n <9B40F2E2EFAA6C40B9EC441545C44B4A836900@XXXXXXXXX>\r\n <eventum.1le43znw.bud2rz@eventum.openquery.com.au>\nFrom: \"XXXXXXXXX\" <XXXXXXXXX@XXXXXXXXX.com>\r\nTo: \"Arjen Lentz [via OQ Service Tracker]\" <XXXXXXXXX>\r\nX-Originally-To: XXXXXXXXX\r\n\r\nHi Arjen,\r\n\r\nI\'ll have to run this past my MD as this is an unscheduled job in this\r\nproject and I need to see how much budget is available; I\'ll get back to\r\nyou as soon as there is an answer.\r\n\r\nKindest Regards\r\n\r\nXXXXXXXXX\r\n\r\nXXXXXXXXX\r\nWeb Designer\r\nXXXXXXXXX Ltd\r\nXXXXXXXXX logo\r\nXXXXXXXXX\r\nXXXXXXXXX\r\n\r\nTel:       XXXXXXXXX\r\nFax:      XXXXXXXXX\r\nE-mail:  XXXXXXXXX@XXXXXXXXX.com\r\nWeb:    www.XXXXXXXXX.com\r\nConnect with me on Skype: XXXXXXXXX, Twitter: XXXXXXXXX or\r\nLinkedIn\r\nPlease consider the environment before printing this e-mail\r\n\r\n> -----Original Message-----\r\n> From: Arjen Lentz [via OQ Service Tracker]\r\n[mailto:XXXXXXXXX]\r\n> Sent: 03 August 2009 12:51\r\n> To: XXXXXXXXX\r\n> Subject: [OQ#322] Re: Open Query inquiry - MySQL tweaks for Joomla\r\nsite\r\n> (XXXXXXXXX)[Scanned]\r\n>=20\r\n> Hi XXXXXXXXX,\r\n>=20\r\n> On Tue, 04 Aug 2009, 06:25:02 EST, XXXXXXXXX@XXXXXXXXX.com wrote:\r\n> > OK, PHPMyAdmin is telling me I\'m on MySQL client version: 5.0.45\r\n> > We\'re on Redhat Enterprise Linux 5.3 over at XXXXXXXXX with Apache\r\nand\r\n> PHP.\r\n> >\r\n> > If there are any more details you need I can try and dig them out.\r\nThe\r\n> > MySQL default config *may* have been changed but I will chase\r\nXXXXXXXXX\r\n> > support to check for sure.\r\n>=20\r\n> No worries.\r\n>=20\r\n> Ok, and you\'d like us to take a take a peek at the setup and tweak it,\r\n> within the boundaries of the version of Joomla you run and the\r\nunderlying\r\n> server? For a single server where we can\'t directly get queries\r\nchanged in\r\n> the app above, we\'d a minimum of 4 hours, up to 8 depending on the\r\nexact\r\n> situation.\r\n>=20\r\n> As you\'ve probably seen on the OQ site, our rate for remote work is\r\nEUR\r\n> XXXXXXXXX. Payment is through visa/mastercard or PayPal, and in the case\r\nof a\r\n> limited amount of ad-hoc work we post-bill. We don\'t do \"statements of\r\n> work\" as we don\'t regard it realistic to diagnose a patient before\r\nseeing\r\n> them. However, we\'d note our initial findings back to you so the rest\r\nof\r\n> the work can be tuned to your needs and wishes.\r\n>=20\r\n> The easiest way for us to work is direct on the box through SSH, with\r\n> appropriate access levels for MySQL and Linux (generally root on\r\nboth).\r\n> We\'ll generate an SSH key specifically for you which we can use for\r\nthe\r\n> login, and then use sudo for Linux root needs. Naturally that needs to\r\nbe\r\n> set up from your end (or by XXXXXXXXX).\r\n>=20\r\n> I\'ve just generated a key for XXXXXXXXX, and the public key is:\r\n> ssh-rsa\r\n>\r\nAAAAB3NzaC1yc2EAAAABIwAAAgEArmv/i07FmaBXohz+aonB5EjRc0OMD46Ej2NiJuR+Hrv8\r\n4h\r\n>\r\nbIR58J5tWFQij5DnYIvcO2mQbtDRVjYZWC824LYXxnzwQJn1x7I6WrcyyDxxTG/Nt13IcnI0\r\nfW\r\n>\r\nupeS3Iwb5LyEz4MPgg1BX8g1MDSBAel0bfS+g5IaerB++U2s0Xon/4lHNIxWSZUuex+to1S7\r\ngl\r\n>\r\n9iRbwiYRC7GN0U9+a9xpAJlQzaL+YEXcxlUwaKX0xNwM59RpGjuNqddzoHw99wUKRFrYiJqv\r\nlF\r\n>\r\nsdEUrm0u+ONlEM0igZd1niXOY4qsCwmjmH0VDfM7bui0qa5jHB1k4aKwNN9CKd2vyK6WRPKO\r\nkI\r\n>\r\n9lB2RtiqQ6fcAQ1WnFTETwbHBCkAEV4KHkt/uhZhHfZcJsBQtyCDf4fdHfzbs0eTRftQtYyE\r\nzI\r\n>\r\nX1yW1YOEK9Oh0c9nZnJ4kvQzWX3CM6ufOtmrVbgXPIxi2Fug7ZZoaKUONn8EZPn4XBgZ7QkW\r\nk/\r\n>\r\nbb9MHWSFmoFPpG81kWXk+Gy6iQsVxQtVYfPKt3UNBfU5ryyFf7DtnJ1wGFuqyFALEPOvWwNk\r\nJr\r\n>\r\nuiCKgaVrjXn//DZdFa6TE+d+kmJ84AmgJFQVEogvcR7ptq0Okj9OpN4VR14VPQWdvE6rWLAx\r\nkj\r\n> wqjuuEx9SaXLKA6qdmBfKmYetVy4YCDKqQ+RGgWWylqGM=3D service@openquery.com\r\n>=20\r\n> It\'s easiest you create a user openquery on Linux with that key (copy\r\ninto\r\n> ~openquery/.ssh/authorized_keys), add openquery to the group that\'s\r\n> allowed to use sudo, and a \"GRANT ALL ON *.* TO openquery@localhost\r\n> IDENTIFIED BY \'somepwd\'\" in MySQL which equates to root-equivalent\r\naccess\r\n> on local connections.\r\n> The Linux user will also require a password for sudo.\r\n> You can place both passwords in a file in ~openquery, so we can see it\r\n> when we first get in using our key, without the password getting\r\n> transferred over email or other insecure channels.\r\n>=20\r\n>=20\r\n> If all that is ok, just send us the IP or domain address of the\r\nserver,\r\n> any details from the above which in setup deviate from the suggested\r\n> defaults, and I\'ll assign an engineer to take a first peek!\r\n> Thanks\r\n>=20\r\n> Regards,\r\n> Arjen.\r\n> --\r\n> Arjen Lentz, Director @ Open Query (http://openquery.com)\r\n> Affordable Training and ProActive Support for MySQL & related\r\ntechnologies\r\n>=20\r\n> Follow our blog at http://openquery.com/blog/\r\n> OurDelta: free enhanced builds for MySQL @ http://ourdelta.org\r\n');


