Hi Stuart, Thanks for Your Reply, I will Look Forward to it. Please Do Let Me Know When You Get the Time to Review the Work.
The Perl Installed with Ltib, Does it have DBD::mysql Module for DBI (to Know if I can Run the MySQL Benchmark Test) With Regards Rajaram Ghosh -----Original Message----- From: Stuart Hughes [mailto:[email protected]] Sent: Monday, January 16, 2012 2:17 PM To: Rajaram Ghosh Cc: [email protected] Subject: Re: [Ltib] MySQL Upgrade Hi Rajaram, I will help where I can but I have absolutely zero free time right now, so I can't promise any timescales. Regards, Stuart On 15/01/12 15:41, Rajaram Ghosh wrote: > Hi Stuart, > Thanks for Your Guidance, I did Some Work over the Weekend to Upgrade to > MySQL-5.1.61 (the MySQL-5.5 Seems to Use cmake instead of autotools, Need to > Work Further), Please Review the MySQL-5.1.61 Work, I will Need Feedback. > > Here's What I have Done > > 1) Downloaded the 'mysql-5.1.61.tar.gz' Tarball from > http://dev.mysql.com/get/Downloads/MySQL-5.1/mysql-5.1.61.tar.gz/from/http:/ > /mysql.borsen.dk/ > > 2) Placed the MySQL-5.1.61 Source Tarball in /opt/freescale/pkgs > > 3) Edited the dist/lfs-5.1/mysql/mysql.spec File > > 3) Unpacked the Source with > > $ ./ltib -m prep -p mysql > > 4) Modified/Added the Following Files in rpm/BUILD/mysql-5.1.61 based on the > OpenWrt Patch for MySQL-5.1.53 > (https://dev.openwrt.org/browser/packages/libs/mysql/patches/500-cross_compi > le.patch, and > https://dev.openwrt.org/browser/packages/libs/mysql/patches/501-disable-pthr > ead-and-tests.patch) > > mysql-5.1.61/configure > mysql-5.1.61/extra/Makefile.am > mysql-5.1.61/extra/Makefile.in > mysql-5.1.61/libmysql/Makefile.in > mysql-5.1.61/sql/Makefile.am > mysql-5.1.61/sql/Makefile.in > mysql-5.1.61/sql/lex_hash.h > mysql-5.1.61/storage/innodb_plugin/plug.in > > > These Solved Primarily the Below Two Issues, Cross Compile Check during > ./configure and lex_hash Which Gets Build for the Target System but Expected > to Run on Host > > ---------------------------------------------------------------------------- > ---------------------------------- > checking for sched_yield... (cached) yes > checking for fdatasync... (cached) yes > checking for localtime_r... (cached) yes > checking whether byte ordering is bigendian... (cached) yes > checking whether GCC atomic builtins are available... configure: error: in > `/home/rajaram/ltib-mpc8308erdb-20100413/rpm/BUILD/mysql-5.1.61': > configure: error: cannot run test program while cross compiling > See `config.log' for more details. > error: Bad exit status from > /home/rajaram/ltib-mpc8308erdb-20100413/tmp/rpm-tmp.92007 (%build) > > > RPM build errors: > Bad exit status from > /home/rajaram/ltib-mpc8308erdb-20100413/tmp/rpm-tmp.92007 (%build) > Build time for mysql: 54 seconds > > Failed building mysql > > > f_scbuild() returned an error, exiting > traceback: > main:560 > > Exiting on error or interrupt > > ---------------------------------------------------------------------------- > ---------------------------------- > make[2]: Leaving directory > `/home/rajaram/ltib-mpc8308erdb-20100413/rpm/BUILD/mysql-5.1.61/sql' > ./gen_lex_hash> lex_hash.h-t > /bin/sh: ./gen_lex_hash: cannot execute binary file > make[1]: *** [lex_hash.h] Error 126 > make[1]: Leaving directory > `/home/rajaram/ltib-mpc8308erdb-20100413/rpm/BUILD/mysql-5.1.61/sql' > make: *** [all-recursive] Error 1 > error: Bad exit status from > /home/rajaram/ltib-mpc8308erdb-20100413/tmp/rpm-tmp.12104 (%build) > > > RPM build errors: > Bad exit status from > /home/rajaram/ltib-mpc8308erdb-20100413/tmp/rpm-tmp.12104 (%build) > Build time for mysql: 152 seconds > > Failed building mysql > > > f_scbuild() returned an error, exiting > traceback: > main:560 > > Exiting on error or interrupt > > ---------------------------------------------------------------------------- > ---------------------------------- > > 5) Build, Install and Deploy the MySQL Package with > > $ ./ltib -m scbuild -p mysql > $ ./ltib -m scinstall -p mysql > $ ./ltib -m scdeploy -p mysql > > > The rootfs Image Size was 10MB Bigger Compared to When Building with > mysql-4.1.12, The Primary Reason being Bigger Size of 'mysql-test' Directory > (in the MySQL Install Folder '/usr'). For this I have Removed the > 'mysql-test' and 'sql-bench' Directory after Install. If the MySQL Test and > Benchmark Suit is Required to Check MySQL is Working Fine in the Target > System (Must be Done Initially), Then Remove the Following Lines from the > 'mysql.spec' File Under '%Install' > > rm -fr $RPM_BUILD_ROOT/%{pfx}/%{_prefix}/mysql-test > rm -fr $RPM_BUILD_ROOT/%{pfx}/%{_prefix}/sql-bench > > Attached is the 'mysql-5.1.61-1326634483.patch' and the 'mysql.spec' File > (Not Sure if Attachments are Allowed). > > Please Help Evaluating, Thanks. > > Regards > Rajaram Ghosh > > > > > -----Original Message----- > From: Stuart Hughes [mailto:[email protected]] > Sent: Friday, January 13, 2012 6:55 PM > To: Rajaram Ghosh > Cc: [email protected] > Subject: Re: [Ltib] MySQL Upgrade > > Hi Rajaram, > > You'll need to look on the website http://ltib.org/ (FAQ) and under the > docs in the distribution. There are some hints there. > > Regards, Stuart > > On 13/01/12 10:24, Rajaram Ghosh wrote: >> Hi Stuart, >> Please Give Us Some Pointers on How to Go about Upgrading the MySQL, and > PHP >> (We would Like to have PHP Working with MySQL, as We are Building a LAMP >> Server). We Don't have any Prior Knowledge about Modifying/Upgrading > things >> in Ltib, So Far Just Using the Ltib BSP as is. >> >> Appreciate Your Guidance, Thanks. >> >> Regards >> Rajaram >> >> -----Original Message----- >> From: Stuart Hughes [mailto:[email protected]] >> Sent: Friday, January 13, 2012 2:18 PM >> To: Rajaram Ghosh >> Cc: [email protected] >> Subject: Re: [Ltib] MySQL Upgrade >> >> On 12/01/12 16:13, Rajaram Ghosh wrote: >>> Hi, >>> There was an Old Discussion about MySQL Used in Ltib being an Old Version >>> (http://lists.gnu.org/archive/html/ltib/2008-03/msg00005.html ). >>> >>> We are Using MySQL, and have the Need to Support Database Triggers, >> Events, >>> and Stored Procedures. The MySQL Version Used in Ltib is 4.1, Which >> doesn't >>> Support all these Features. We are Using a Ltib BSP from Freescale >>> (ltib-mpc8308erdb-20100413.iso). How Do We add Support for the Latest >> MySQL >>> (at least 5.1 or above), and What are the other Packages that also Need >>> Upgrade because of MySQL. >> You'll need to upgrade the MySQL package, I don't think it has many >> other dependent packages. >>> While selecting PHP from the Package List it Automatically Selects MySQL, >> is >>> it an Expected Behavior. >> Yes. We wanted to make sure MySQL support was built into the PHP engine >> that was built. >> >> Regards, Stuart >> _______________________________________________ LTIB home page: http://ltib.org Ltib mailing list [email protected] https://lists.nongnu.org/mailman/listinfo/ltib
