• ptroot
  • Junior Member
  • Offline
  • Registered: 2008-01-21
  • Posts: 2

Topic: building PHP with Mysql or moving databases from mysql to postgres

I'm trying to build a new apache with mod_perl (and Embperl) and php, to replace an old machine.

It's a Sun, running Solaris 10, gcc 3.4.6, apache 1.3.39, mod_perl 1.30, Embedded perl 2.3.0, php 5.2.5,
mysql 14.7 Distrib 4.1.22.

I configured mod_perl and Embperl first and it's working. 

The old Solaris 8 system with php4 running the forum had a newer version of mysql than what's installed
in Solaris 10's /usr/sfw, so I installed mysql (from sunfreeware.com). So my config of php is like this:

./configure --with-apache=../apache_1.3.39 --with-mysql=/usr/local/mysql

It goes through the compile and then comes up with:
/bin/sh /src/http/grinch/php-5.2.5/libtool --silent --preserve-dup-deps --mode=link gcc -I/usr/local/include -g -O2 -prefer-non-pic -static  -rpath /src/http/grinch/php-5.2.5/libs -L/usr/ucblib -L/usr/local/lib/gcc/sparc-sun-solaris2.10/3.4.6 -L/usr/local/mysql/lib 
.
.
.
-lxml2 -lz -lm -lsocket -lnsl  -o libphp5.la
copying selected object files to avoid basename conflicts...
make: *** [libphp5.la] Error 255


and bombs out.

Any ideas on this? I've given some other arguments (like where zlib is) and I get wrong architecture (32 vs 64 bit).


My alternative, is that I have another server that is also running punbb with postgres as the backend.   
Is it possible to pull the data out of mysql and put it into Postgres?

Thanks,
Paul.

2 Reply by MattF

  • MattF
  • Senior Member
  • Offline
  • From: South Yorkshire, England
  • Registered: 2007-03-15
  • Posts: 1,956

Re: building PHP with Mysql or moving databases from mysql to postgres

You'd need to look at the INSTALL files for the source you're compiling. You'll probably find you'll need some extra switches during configure for compiling on Solaris. It tends to be one of the the quirkier systems to build on, by all accounts. smile

Here's a link on the postgresql site which contains info on MySQL to PgSQL conversion:

http://www.postgresql.org/docs/techdocs.3.html

MattF's Website

  • ptroot
  • Junior Member
  • Offline
  • Registered: 2008-01-21
  • Posts: 2

Re: building PHP with Mysql or moving databases from mysql to postgres

I should know that. I remember the good old days when thing were created on SunOS and then ported.
Looks like I was missing a couple of packages. Seems it should have complained.


Thanks for the link. I'll check it out.

4 Reply by MattF

  • MattF
  • Senior Member
  • Offline
  • From: South Yorkshire, England
  • Registered: 2007-03-15
  • Posts: 1,956

Re: building PHP with Mysql or moving databases from mysql to postgres

Glad you got it sorted. smile

MattF's Website