Koozali.org: home of the SME Server

Obsolete Releases => SME 7.x Contribs => Topic started by: davelister on April 18, 2008, 05:17:49 AM

Title: php help please
Post by: davelister on April 18, 2008, 05:17:49 AM
G'day

My non-profit work place has just had mysql/php database built by a very helpful bloke, but sadly it needs zip, pdo, gd2 and mysqli installed with php. Can anyone help a complete noob get it working please? BTW the server is 7.3 in server gateway mode

Regards from
Dean
Title: Re: php help please
Post by: cactus on April 18, 2008, 10:21:21 AM
G'day

My non-profit work place has just had mysql/php database built by a very helpful bloke, but sadly it needs zip, pdo, gd2 and mysqli installed with php. Can anyone help a complete noob get it working please? BTW the server is 7.3 in server gateway mode
Perhaps we can, although I do not know if all libraries are available for the relatively old version of PHP that installed on SME Server by default. So far I have not been able to find a 4.3.9 version of mysqli, pdo and zip. I know gd is available and most likely already installed.

First see what you already got.
Title: Re: php help please
Post by: davelister on April 18, 2008, 12:29:47 PM
thanks for the reply

php-4.3.9-3.22.9
php-pear-4.3.9-3.22.9
php-gd-4.3.9-3.22.9
php-ldap-4.3.9-3.22.9
php-mysql-4.3.9-3.22.9
php-domxml-4.3.9-3.22.9
php-imap-4.3.9-3.22.9
php-mbstring-4.3.9-3.22.9
e-smith-php-1.12.0-4.el4.sme
smeserver-phpmyadmin-multiuser-2.11.5-1
Title: Re: php help please
Post by: cactus on April 18, 2008, 12:46:53 PM
thanks for the reply

php-4.3.9-3.22.9
php-pear-4.3.9-3.22.9
php-gd-4.3.9-3.22.9
php-ldap-4.3.9-3.22.9
php-mysql-4.3.9-3.22.9
php-domxml-4.3.9-3.22.9
php-imap-4.3.9-3.22.9
php-mbstring-4.3.9-3.22.9
e-smith-php-1.12.0-4.el4.sme
smeserver-phpmyadmin-multiuser-2.11.5-1

That is like expected, gd is already installed. The others I have not been able to obtain for php-4.3.9. So I think you are stuck here, unfortunately with this version.

Perhaps you can consider installing PHP5 along side the PHP4 installation that comes with SME Server by default as explained at: http://sme.firewall-services.com/spip.php?article46&debut_forums=10 .

Unfortunately it will not install the required packages in your case. You will have to manually install them as well, which might prove difficult, certainly when you are a complete noob as they are not readily available.

Perhaps you should have specified to the very helpful bloke that you were to use it on SME Server, so he could have taken into account that some libraries (he uses) for your application are not available.
Title: Re: php help please
Post by: brianr on April 18, 2008, 01:14:20 PM
I suggest you find another (old?) Pc, to install (eg) centos 5 (which I presume will come with the packages you need), and use that as the web server.

Title: Re: php help please
Post by: davelister on May 01, 2008, 07:50:00 AM
ok thanks for everyone's help thus far.

I have installed ubuntu on another pc and it is up and running fine it is also setup with ISPconfig

However I have one problem to overcome to get this whole long saga over with :-)

The SME server is in server gateway is 'pinestraining.com.au'
The new server is called 'server1.pinestraining.com.au'
I have followed the instruction on the SME documentation page regarding proxypass and done the following on the SME server;

db domains set server1.pinestraining.com.au domain
db domains setprop server1.pinestraining.com.au Nameservers internet
db domains setprop server1.pinestraining.com.au ProxyPassTarget http://192.168.70.8/
db domains setprop server1.pinestraining.com.au TemplatePath ProxyPassVirtualHosts
signal-event domain-create server1.pinestraining.com.au

From the outside network I can reach http://server1.pinestraining.com.au
but I can not reach for example http://server1.pinestraining.com.au:81 (which is the admin page for the ISPConfig) _ I can reach this page from the internal network, although only through http://192.168.70.8:81
Furthermore when I try to ftp from outside the network I connect but it is to SME server

Please help I am getting pressure from everywhere to fix this situation and to be honest I have no clue, it has been a steep learning curve, and one I wish to have a little break from :-)
Title: Re: php help please
Post by: cactus on May 01, 2008, 10:07:12 AM
From the outside network I can reach http://server1.pinestraining.com.au
but I can not reach for example http://server1.pinestraining.com.au:81 (which is the admin page for the ISPConfig) _ I can reach this page from the internal network, although only through http://192.168.70.8:81
Furthermore when I try to ftp from outside the network I connect but it is to SME server

Please help I am getting pressure from everywhere to fix this situation and to be honest I have no clue, it has been a steep learning curve, and one I wish to have a little break from :-)

That is strange... as normally all ports should be forwarded AFAIK. What do the log files of both systems say. Start with looking the /var/log/httpd/access_log and error_log to see if requests are forwarded to your internal server for port 81.
Title: Re: php help please
Post by: davelister on May 01, 2008, 11:23:51 AM
i can see 'server1.pinestraining.com.au 118.208.123.66' in the access log

so I can assume that it working :-)

but I can not see anything in the logs refering to port 81

in the error logs I see this entry;

[error] [client 118.208.123.66] denied by server configuration: /home/e-smith/files/ibay/html

Thanks for your willingness to help!
Title: Re: php help please
Post by: cactus on May 01, 2008, 11:26:58 AM
i can see 'server1.pinestraining.com.au 118.208.123.66' in the access log

so I can assume that it working :-)
No, as you do not get the desired funtionality that is the only way to judge if things are working isn't it?

but I can not see anything in the logs refering to port 81

in the error logs I see this entry;

[error] [client 118.208.123.66] denied by server configuration: /home/e-smith/files/ibay/html

Thanks for your willingness to help!
Please do not paraphrase from the logs, place the full lines as I am sure there is more data in the log lines, as well as some lines before and after as they sometimes also contain clues to people who know how to read them.

At first glance it looks like SME Server is thinking it should look on its own server, but I can not see what was requested from the data you posted.
Title: Re: php help please
Post by: janet on May 01, 2008, 04:05:29 PM
davelister

Quote
From the outside network I can reach http://server1.pinestraining.com.au

So the proxypass configuration is working.


Quote
...I can not reach for example http://server1.pinestraining.com.au:81

I thought proxypass only worked for port 80 & port 443 (https), that's why you can't use proxypass to access other ports.

You will need to setup a port forwarding entry for port 81 to be forwarded to a specific servers IP, as presently it goes to the gateway sme server, that's why you get the sme server.
Title: Re: php help please
Post by: davelister on May 02, 2008, 12:21:14 AM
thanks mary!

all I had to do was forward port 81 through to 192.168.70.8 and bingo! Now all I have to do is change the default ftp port on 192.168.70.8 and forward that port on the SME server and problem solved!

If only you could all see me now - I have taken my clothes off and running around the room dancing! Well perhaps it might be best you can't see me as I am a bit on the porky side  :lol:
Title: Re: php help please
Post by: janet on September 17, 2010, 03:42:26 AM
davelister

Sorry, I felt a desire to answer this old post.

Quote
If only you could all see me ... I have taken my clothes off and running around the room dancing!

In your present health circumstances in 2010, you should perhaps be doing more of that dancing around in the nude on a regular basis. It may well lift your spirits & improve your well being.
Title: Re: php help please
Post by: davelister on September 17, 2010, 04:41:43 AM
davelister

Sorry, I felt a desire to answer this old post.

In your present health circumstances in 2010, you should perhaps be doing more of that dancing around in the nude on a regular basis. It may well lift your spirits & improve your well being.

I'd love too but the kids have banned me from doing so. I have also sent one neighbour blind
Title: Re: php help please
Post by: janet on September 17, 2010, 05:04:30 AM
davelister

Find a secluded beach, or some wild bush, plenty of those on/near the sunshine coast
Title: Re: php help please
Post by: davelister on September 17, 2010, 05:09:43 AM
I can see the headline now... 'Big Foot spotted in hinterland on Queenland Coast'
Title: Re: php help please
Post by: janet on September 17, 2010, 05:21:22 AM
davelister

Quote
I can see the headline now... 'Big Foot spotted in hinterland on Queenland Coast'

Great, if I see that in the news, I'll know it was you !!!