Use MySQL-client on apf9328 - Revision history

FabienM: /* Connecting apf9328 to host database */

2008-12-05T13:21:41Z

Connecting apf9328 to host database

← Older revision		Revision as of 15:21, 5 December 2008
Line 38:		Line 38:

	=== Connecting apf9328 to host database ===		=== Connecting apf9328 to host database ===

			<source lang="mysql">
			mysql -u plop -h 192.168.0.214 -p
			</source>

FabienM: /* Configure host database */

2008-12-05T13:20:08Z

Configure host database

← Older revision		Revision as of 15:20, 5 December 2008
Line 34:		Line 34:
	=== Configure host database ===		=== Configure host database ===

	A good tutorial to configure host MySQL database can be found here [http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html]		A good tutorial to configure host MySQL database can be found here [http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html] or here
			[http://www.bidon.ca/Tr%C3%A8s_mini_howto_MySQL.html](fr).
	~~Change~~

	=== Connecting apf9328 to host database ===		=== Connecting apf9328 to host database ===

FabienM: /* Configure host database */

2008-12-05T12:51:16Z

Configure host database

← Older revision		Revision as of 14:51, 5 December 2008
Line 36:		Line 36:
	A good tutorial to configure host MySQL database can be found here [http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html]		A good tutorial to configure host MySQL database can be found here [http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html]

			Change

	=== Connecting apf9328 to host database ===		=== Connecting apf9328 to host database ===

FabienM: New page: I made this page to write some procedure to install mySQL-client in apf9328. It's not a howto, because to be clean, the buildroot package must be rebuild. === Install buildroot package in...

2008-12-05T12:37:23Z

New page: I made this page to write some procedure to install mySQL-client in apf9328. It's not a howto, because to be clean, the buildroot package must be rebuild. === Install buildroot package in...

New page

I made this page to write some procedure to install mySQL-client in apf9328. It's not a howto, because to be clean, the buildroot package must be rebuild.

=== Install buildroot package in makemenuconfig ===

select ''Package Selection for the target -> database -> MySQL-client''.

=== Clean the package ===

MySQL-client buildroot package was made without size optimisation, then if you compile as-is, the rootfs size is 80Mo !
To optimize size, just use a graphical-fs viewer like [http://doc.ubuntu-fr.org/filelight filelight] or [http://kdirstat.sourceforge.net/ kdirstat] to suppress useless files in directory : ''buildroot/project_build_armv4t/apf9328/root/'', and try to reduce by 8Mo or 16Mo according to your flash size.

=== compile ===

* To force buildroot re-building the rootfs suppress ''buildroot/binaries/apf9328/apf9328-rootfs.arm.jffs2'' file then make.
* flash rootfs
* boot

=== Resolve link error ===

If you try to launch mysql you will have an error:
<source lang="bash">
[root@armadeus MySQL-python-1.2.2]# mysql
mysql: can't load library 'libmysqlclient.so.16'
</source>

Quick method to solve it is to make symbolic link in /usr/lib:

<source lang="bash">
[root@armadeus lib]# ln -s mysql/libmysqlclient.so.16
</source>

This is really dirty method but that work ;-)

=== Configure host database ===

A good tutorial to configure host MySQL database can be found here [http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html]

=== Connecting apf9328 to host database ===