[campsite-support] Install problem - Newscoop Support Discussions on Sourcefabric Forum

import

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

import

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
--db_password --db_name
If that fails, try:
#mysql -u -p
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

aaron@visn.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
>

import

Hi Aaron,

Please check this page:
http://code.campware.org/manuals/campsite/2.6/index.php?id=203

Please make sure the database password does not contain any of the characters listed in this page.

If it still doesn't work please give me access to your site so I can debug.

Regards,
Mugur

--- aaron@visn.net wrote:
> 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
>
>

____________________________________________________________________________________
Be a PS3 game guru.
Get your game face on with the latest PS3 news and previews at Yahoo! Games.
http://videogames.yahoo.com/platform?platform=120121

import

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
> --db_password --db_name
> If that fails, try:
> #mysql -u -p
> 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
>
>
> aaron@visn.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
>>
>>
>
>

import

Passwords were fine, just letters and numbers.

As of right now I cannot give you access to the site. If I continue to
have trouble I will
try and do so, thank you for the offer!!!!

Aaron

Mugur Rus wrote:
> Hi Aaron,
>
> Please check this page:
> http://code.campware.org/manuals/campsite/2.6/index.php?id=203
>
> Please make sure the database password does not contain any of the characters listed in this page.
>
> If it still doesn't work please give me access to your site so I can debug.
>
> Regards,
> Mugur
>
> --- aaron@visn.net wrote:
>
>> 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
>>
>>
>>
>
>
>
>
> ____________________________________________________________________________________
> Be a PS3 game guru.
> Get your game face on with the latest PS3 news and previews at Yahoo! Games.
> http://videogames.yahoo.com/platform?platform=120121
>

import

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 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
> > --db_password --db_name
> > If that fails, try:
> > #mysql -u -p
> > 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
> >
> >
> > aaron@visn.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

Howdy, Stranger!

Categories

Poll

Top Posters