PATH var and more...

[Dan Nelson]

In the last episode (Jul 11), Miguel Cardenas said:
> I've installed MySQL 4.0.20 successfully from source code and
> programs work fine, but have still two little "problems"...
> 
> 1. Can't add /usr/local/mysql/bin to the PATH var from the main 
> configuration... Tried to add:
>    export PATH=$PATH:/usr/local/mysql/bin to /etc/profile, but didn't
> work. It only works if I send the command through the bash shell or
> in $HOME/.profile but /etc/profile does not work... why?  don't want
> to append it to the .profile of each user!!!

Add some echos to /etc/profile to make sure it's really being executed,
maybe.
 
> 2. MySQL is working fine now, but now that am creating/porting a
> client application, once compiled it does not find
> libmysqlclient.so... tried to append the path to /etc/ld.so.conf and
> ld-elf.so.conf and run ldconfig, but still not found by system when
> invoking a program that uses it... how can I add /usr/local/mysql/lib
> to the libraries path?

Edit /etc/rc.conf and add your path to ldconfig_paths, or create a
small startup script to put in /usr/local/etc/rc.d with the command
"ldconfig -m /usr/local/wherever_libmysqlclient.so_is". /etc/ld.so.conf
is a Linuxism.

Or solve both of your problems at once by removing /usr/local/mysql and
installing the /usr/ports/databases/mysql40-client and mysql40-server
ports :)

-- 
	Dan Nelson
	dnelson at allantgroup.com