DB Error: extension not found on Step 2 of 3.10

(Mat Griffin) #1

Im getting thge error 'DB Error: extension not found' when running step_02.php


But I know for a fact that php is compiled with postgres as I have other db's running pulling out content using php.





I using OS X 10.4.7

php 4.4.2

postgresql 8.1.3

Apache 1.3x



all Pear modules are installed





any ideas?

(Nic Hubbard) #2

Is this an upgrade? And are you getting this running step step_02 while Disable Database Triggers? If so, I got this same error, but I just moved on. I kept following the upgrade steps and everything went fine, and I am up and running.

(Avi Miller) #3

There is a difference between the CLI binary of PHP and the Apache module. When you're running the step_0x.php, you're using the CLI binary. That binary also needs PostgreSQL support.


Also, if you ever get an error running one of the step_0x.php scripts, you need to fix it. They are critical to Matrix and can seriously affect the performance (or even total operation) of a system.

(Mat Griffin) #4

Not an upgrade bu a clean install.


Have recompiled php, first step_1.php runs find but still get 'DB Error: extension not found' when running step_02.php



:frowning:

(Nic Hubbard) #5

You sure you are running the CLI version of PHP not the CGI?

(Mat Griffin) #6

[quote]You sure you are running the CLI version of PHP not the CGI?
[right][post=“11357”]<{POST_SNAPBACK}>[/post][/right][/quote]



yep a php -v gives 4.4.1 cli

(Mat Griffin) #7

I’ve stopped the install on the OS X box as I have also been installing on a CentOS box - which is going much better.


But I cant login, when I got to

http://faraday/mysource_matrix/_admin

I get “Login Key incorrect”



if I just go to http://faraday/mysource_matrix/_admin

I get a green box with



MySource Notice

URL “faraday/mysource_matrix” not found [SYS0218]



I’ve checked Apache can write to the data cache, so now I’m stumped!



Help (again, sorry) :blink:

(Nic Hubbard) #8

And you tried root/root for login and pass? The URL not found notice is correct. Since you have never set your sites index page, it is not finding anything.

(Mat Griffin) #9

[quote]And you tried root/root for login and pass?  The URL not found notice is correct.  Since you have never set your sites index page, it is not finding anything.
[right][post=“11361”]<{POST_SNAPBACK}>[/post][/right][/quote]



yep logging in with root/root

(Nic Hubbard) #10

Refer to this post:


Logging in not working


[quote]As mentioned elsewhere on the forum, you can't use single word hostnames, i.e. "debian" as this breaks the Matrix security sandpit.



You need to use a FQDN, i.e. "debian.local" will be fine. It needs at least a single . in it.[/quote]

(Mat Griffin) #11

[quote]Refer to this post:


Logging in not working

[right][post=“11363”]<{POST_SNAPBACK}>[/post][/right][/quote]





Thanks very helpful thread, I have not tested as I’m away from the office but I am certain is due to single word hostname, I just have faraday.



Won’t be back in the office until Monday so will try then.



:smiley:

(Avi Miller) #12

[quote]I’ve stopped the install on the OS X box as I have also been installing on a CentOS box - which is going much better.
[right][post=“11360”]<{POST_SNAPBACK}>[/post][/right][/quote]



Did you compile your own version of Apache and PHP on MacOS X? The versions that ship with MacOS do not support PostgreSQL.

(Jeremy Gregson) #13

just wanted to toss in that I'm hoping for an answer to this one too - clean server, fresh install of Debian 3.1, postgresql up and running, PEAR installed, database built, and the DSNs labelled in main.inc just the way you like them… still getting the error message about "extension not found".
I've tried adding a few extra optional packages: php4-dev, odbc-postgresql, just in case they were needed and not mentioned. No dice.

By the way - if Matrix really needs a FQDN in those DSNs in main.inc, you'd better update page 18 of the Server Administrator book - the examples there don't comply.



good luck!

(Avi Miller) #14

We don't require a FQDN in the DSN entries (a single hostname in a DSN is just fine, as long as it resolves). We do require FQDN entries in the SYSTEM_ROOT_URLS configuration option.


If you guys do a php -i or phpinfo(); call, do you see pgsql support for PostgreSQL? In Debian, you'd need the php4-pgsql package installed. Make sure both the CLI binary (php -i at the command line) and the Apache Module (phpinfo(); in a .php file served by Apache) both have PostgreSQL support.

(Mat Griffin) #15

My install on CentOS is now working :smiley: - Thanks all!


As for OS X, yes I did recompile php with postgres and it was the CLI version. Did recompile Apache though, could that be the problem?





Next question :rolleyes:



Can I run Matrix and Classic on the same box? and also whats the best way to migrate content from Classic to Matrix (please dont say copy and paste!!!)

(Avi Miller) #16

[quote]As for OS X, yes I did recompile php with postgres and it was the CLI version. Did recompile Apache though, could that be the problem?
Next question  :rolleyes:[/quote]



Yes – the Apache that ships with MacOS X does not have PostgreSQL support. :slight_smile:


[quote]Can I run Matrix and Classic on the same box? and also whats the best way to migrate content from Classic to Matrix (please dont say copy and paste!!!)

[right][post=“11441”]<{POST_SNAPBACK}>[/post][/right][/quote]



Yes, you can run them both at the same time. However, there is no way to upgrade from Classic to Matrix. You would need to recreate your website in Matrix and then manually migrate the content across.



(See, I didn’t say cut and paste!)

(Jeremy Gregson) #17

Bingo!!

Funny, you'd sorta think that Debian would have included that in the default install, given that telling it you're installing a web server and a sql server automatically selects Apache, PHP and Postgresql... just doesn't glue them together with that package!

thanks heaps.
(Mat Griffin) #18

[quote]Yes, you can run them both at the same time. However, there is no way to upgrade from Classic to Matrix.


You would need to recreate your website in Matrix and then manually migrate the content across.



(See, I didn’t say cut and paste!)

[right][post=“11442”]<{POST_SNAPBACK}>[/post][/right][/quote]



I have hundreds and hundreds of pages is there a way I could export them from the MySQL db and into the PostgeSQL db?? Else its going to take me dys to transfer the content, someone must of already done this?



:unsure:

(Avi Miller) #19

[quote]I have hundreds and hundreds of pages is there a way I could export them from the MySQL db and into the PostgeSQL db??
[right][post=“11473”]<{POST_SNAPBACK}>[/post][/right][/quote]



You should contact Squiz Sales to see if there is anything we can do to make this migration easier – I believe the MySource Classis has done some work on a migration tool, but I’m not sure if that was ever completed. However, there are some tools to make recreating your site easier in Matrix. For example, you can mass-create pages and mass-upload files.



However, having been involved in more than a few migration projects, most involving websites into the tens of thousands of pages, it is still faster and cheaper to migrate manually (i.e. cut’n’paste). Any script conversion would still need to be checked by a human to ensure that absolutely everything was converted correctly. Also, you would need to spend a lot of money developing a conversion script that (you hope) would only ever get run once.