Re: [Ltib] MySQL Upgrade

[Rajaram Ghosh]

Hi Daniel,
Appreciate Your Views, and the Continuous Effort Put by Stuart with Due
Respect. Hope I have not Hit the Wrong Cord by Asking for Help, the Work
could be Useful to the Ltib Community with Stuart Looking into it Whenever
He has Time.

At this Point I am only Evaluating a Concept Using Ltib on MPC8308ERDB, We
could Certainly Look for Services from an Expert Like Stuart if things Move
with Ltib, Thanks for the Tips.

With Regards
Rajaram Ghosh

-----Original Message-----
From: address@hidden
[mailto:address@hidden On Behalf Of Daniel
Widyanto
Sent: Tuesday, January 17, 2012 7:40 AM
To: address@hidden
Subject: Re: [Ltib] MySQL Upgrade

Hi Rajaram,

Stuart has done a great work to maintain LTIB, and answering all the
questions in this mailing list. I believe he also has family to feed on as
well. If you have any project in mind using LTIB, and want him to look at
your problem as soon as possible, you can consider to hire him
professionally instead. 

It won't be fair to have someone work on your behalf without getting paid. A
worker deserves his wage, and I don't think you'd like to work for free as
well.

Regards,
-daniel

> -----Original Message-----
> From: address@hidden [mailto:ltib-
> address@hidden On Behalf Of Rajaram Ghosh
> Sent: Tuesday, January 17, 2012 2:23 AM
> To: 'Stuart Hughes'
> Cc: address@hidden
> Subject: Re: [Ltib] MySQL Upgrade
> 
> 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:address@hidden
> Sent: Monday, January 16, 2012 2:17 PM
> To: Rajaram Ghosh
> Cc: address@hidden
> 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:address@hidden
> > Sent: Friday, January 13, 2012 6:55 PM
> > To: Rajaram Ghosh
> > Cc: address@hidden
> > 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:address@hidden
> >> Sent: Friday, January 13, 2012 2:18 PM
> >> To: Rajaram Ghosh
> >> Cc: address@hidden
> >> 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
> address@hidden
> https://lists.nongnu.org/mailman/listinfo/ltib

_______________________________________________
LTIB home page: http://ltib.org

Ltib mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/ltib