Hi Aaron,
I suppose you have two MySQL installs: one from RPM packages
and one from sources (in /usr/local).
Because of the order in which libraries are loaded
(directory order) Campsite (PHP) may try to use
the standard libs first: /usr/lib instead of /usr/local/lib.
If the two MySQL installs have
different versions then the connection will fail.
The solution is to uninstall the standard MySQL RPM packages
if you don't use them and leave only
the install from sources.
Regards,
Mugur
--- Aaron Woldman <aaron visn.net> wrote:
> The root account can attach to the db with no problem
from the mysql
> command line but not
> the campsite-create-instance
>
> So I tried dropping the DB and recreating, checked
again that the root
> account could access it.
>
> I did just realize that the cron jobs might have told
me what the
> problem was.
> The output from one of them is:
>
> /libexec/ld-elf.so.1: Shared object
"libmysqlclient.so.12" not found
>
> SO I went looking and in
> /usr/local/mysql/lib/mysql
> I found
>
> lrwxr-xr-x 1 root wheel 20 Mar 21 2005
libmysqlclient.so ->
> libmysqlclient.so.14
> -rwxr-xr-x 1 root mysql 376383 Mar 21 2005
libmysqlclient.so.14
>
> So my quick attemot to fix was to add a symbolic link
> lrwxr-xr-x 1 root mysql 20 Jan 18 09:15
libmysqlclient.so.12 ->
> libmysqlclient.so.14
>
> Still no luck
>
> Ondra Koutek wrote:
> > Dear aaron,
> > I believe the message says exactly what is
happening. I do not know much
> > about your installation, but I recommend you to
check following:
> > #/usr/local/bin/campsite-create-instance --db_user
<username>
> > --db_password <password> --db_name
<database_name>
> > If that fails, try:
> > #mysql -u <username> -p <password>
<database_name>
> > I believe this will fail too, but if that will
connect you, you you
> > might want to drop the database and create empty
one for campsite
> > instance.
> >
> > Ondra
> >
> >
> > aaronvisn.net píše v st 17. 01. 2007 v 20:25
+0100:
> >
> >> Hey all,
> >> Hopefully someone can help me out with my
install.
> >> I am running on Freebsd 5.2.1 , PHP 4.4.4 ,
Mysql 4.1
> >>
> >> The install seemed to run fine.. I have made
it to the point of
> >> creating the local instance.
> >>
> >> Campsite create instance utility
> >> --------------------------------
> >> Create instance script version: 2.6.4
"Joey"
> >> Creating instance: campsite
> >> * Creating the database
configuration...done.
> >> * Creating the template engine
configuration...done.
> >> * Creating the email notifiers
configuration...done.
> >> * Creating the Apache configuration...done.
> >> * Setting privileges to the configuration
files...done.
> >> * Creating site directories...done.
> >> * Creating the site structure...done.
> >> * Creating the Apache virtual host
configuration file...done.
> >> * Setting privileges for the site
directories...done.
> >> There were ERRORS!!!
> >> Unable to connect to database server.
> >>
> >> I have changed the base parameters and tried
both the db logon
> >> I created and tried as root with no luck.
> >>
> >> Mysql is running fine, I have about 30
databases on it. I know the
> >> users and passwords are good, I can log in
through the mysql cli
> >>
> >> I have also tried changing the db connect ip
to: localhost and the main ip.
> >>
> >> The only other thing I have tried so far was
to input 3306 for the db port.
> >>
> >> All with the same results.
> >>
> >> Thanks for any input
> >>
> >> Aaron
> >>
> >>
> >
> >
>
>
____________________________________________________________
________________________
The fish are biting.
Get more visitors on your site using Yahoo! Search
Marketing.
http://searchmarketing.yahoo.com/arp/sponsoredsearch_
v2.php
|