| View previous topic :: View next topic |
| Author |
Message |
liyanage
Site Admin
Joined: 22 May 2003
Posts: 1104
Location: Zurich, Switzerland
|
 Posted: Thu Jan 24, 2008 0:47 Post subject: Leopard: PHP 5.2.5 Release 6 BETA |
 |
|
Here is release 6. It adds the ming extension and is built with a patch to the PHP5 sources which seems to fix the IMAP titlecase problem in the imap_utf8() function.
I hope it doesn't break anything else IMAP-related. I would still be interested to hear if anyone got the PHP5 IMAP extension working with the IMAP c-client library 2007 and doesn't experience the capitalization problem.
I would also like to hear if anyone got the Ming extension working with version 4.x of the ming library, I had to downgrade to 0.3.0 which seems fairly old.
Please read these previous beta threads:
http://www.entropy.ch/phpbb2/viewtopic.php?t=2940
http://www.entropy.ch/phpbb2/viewtopic.php?t=2941
http://www.entropy.ch/phpbb2/viewtopic.php?t=2942
http://www.entropy.ch/phpbb2/viewtopic.php?t=2944
Installation:
| Code: | sudo mv /usr/local/php5 ~/Desktop/php5.old
curl -O http://www2.entropy.ch/download/php5-5.2.5-6-beta.tar.gz
tar -xzf php5-*-beta.tar.gz
sudo mv php5 /usr/local/
sudo ln -sf /usr/local/php5/entropy-php.conf /etc/apache2/other/+entropy-php.conf
sudo apachectl restart |
DO NOT USE “apachectl configtest” or -t to check if it works. If you have to, use “/usr/local/php5/bin/apachectl configtest” instead. |
|
| Back to top |
|
 |
Moofo
Joined: 16 Nov 2007
Posts: 6
|
| Posted: Thu Jan 24, 2008 4:09 Post subject: MySQL on PPC |
|
|
Just so you know, the MySQL authentification seems to be broken on PPC. I can't login to my database as it keeps saying the password is wrong...
I'm using beta 5. I'm gonna try beta 6 |
|
| Back to top |
|
|
Moofo
Joined: 16 Nov 2007
Posts: 6
|
| Posted: Thu Jan 24, 2008 14:20 Post subject: MySQL Login |
|
|
My setup:
G4 Dual
Stock MySQL from Apple.
I know it worked with release 1
It fails (using PhpMyAdmin) using a socket on the local machine.
It works (using PhpMyAdmin) using over TCP on a remote machine. |
|
| Back to top |
|
|
tazz_ben
Joined: 12 Jan 2006
Posts: 9
Location: USA
|
| Posted: Thu Jan 24, 2008 14:58 Post subject: Works Great! |
|
|
| Just wanted to say it now works great; I am curios though. Could you elaborate on the patch? I found it surprising that the problem existed in the PHP source not the IMAP source. |
|
| Back to top |
|
|
liyanage
Site Admin
Joined: 22 May 2003
Posts: 1104
Location: Zurich, Switzerland
|
| Posted: Thu Jan 24, 2008 15:17 Post subject: Re: Works Great! |
|
|
| tazz_ben wrote: | | Just wanted to say it now works great; I am curios though. Could you elaborate on the patch? I found it surprising that the problem existed in the PHP source not the IMAP source. |
The problem could be in the IMAP source. They extended their UTF8 support between versions 2004g, which I used previously, and 2007, which is the current version. There is some title-casing going on in the new version in order to do collation properly. Maybe there's an unintended side-effect that's a bug, maybe the PHP glue code doesn't use the new/changed API properly, I don't really know.
It's just that my dirty quick fix was easier in the PHP glue code (the PHP extension module source).
This is the patch:
| Code: | --- php-5.2.5/ext/imap/php_imap.c 2007-07-31 02:31:10.000000000 +0200
+++ php-5.2.5-imapfix/ext/imap/php_imap.c 2008-01-23 23:55:33.000000000 +0100
@@ -2209,7 +2209,7 @@
#ifndef HAVE_NEW_MIME2TEXT
utf8_mime2text(&src, &dest);
#else
- utf8_mime2text(&src, &dest, U8T_CANONICAL);
+ utf8_mime2text(&src, &dest, 0);
#endif
RETVAL_STRINGL(dest.data, dest.size, 1);
if (dest.data) {
|
As you can see, I suppress the U8T_CANONICAL flag, which could have other bad consequences. That's what I'd like to know from people like you who use IMAP  Any strangeness happening? |
|
| Back to top |
|
|
revision29
Joined: 23 Jan 2008
Posts: 3
|
| Posted: Thu Jan 24, 2008 19:52 Post subject: Re: MySQL on PPC |
|
|
| Moofo wrote: | Just so you know, the MySQL authentification seems to be broken on PPC. I can't login to my database as it keeps saying the password is wrong...
I'm using beta 5. I'm gonna try beta 6 |
I am having the same problem on my machine which is a 1Ghz ppc. I can connect with MySQL Administrator and other such tools, but authentication fails. I have checked user privs and have even changed my script to use the root user. It fails.
Again, MySQL worked in BR1. |
|
| Back to top |
|
|
liyanage
Site Admin
Joined: 22 May 2003
Posts: 1104
Location: Zurich, Switzerland
|
| Posted: Fri Jan 25, 2008 1:20 Post subject: |
|
|
| Seems the MySQL problem only appears on PPC machines. It works on my Intel Mac. I'll have to take a look at that. |
|
| Back to top |
|
|
tazz_ben
Joined: 12 Jan 2006
Posts: 9
Location: USA
|
| Posted: Fri Jan 25, 2008 1:39 Post subject: |
|
|
| It also works on my dual G5 Xserves, I wonder if it is only 32 bit PPC. |
|
| Back to top |
|
|
liyanage
Site Admin
Joined: 22 May 2003
Posts: 1104
Location: Zurich, Switzerland
|
| Posted: Fri Jan 25, 2008 9:29 Post subject: |
|
|
| tazz_ben wrote: | | It also works on my dual G5 Xserves, I wonder if it is only 32 bit PPC. |
You mean the module in general or the MySQL extension specifically works on your Xserves? |
|
| Back to top |
|
|
liyanage
Site Admin
Joined: 22 May 2003
Posts: 1104
Location: Zurich, Switzerland
|
| Posted: Fri Jan 25, 2008 9:38 Post subject: |
|
|
It seems to be a 32bit/64bit problem with the MySQL client library I build, regardless of architecture.
64bit Intel works, both 32 bit Intel and PPC don't work:
| Code: | primavera:.libs liyanage$ arch -x86_64 ./mysql -h 127.0.0.1 -u wwwtest -pabc foo
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 39
Server version: 5.0.45 MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> Bye
primavera:.libs liyanage$ arch -ppc ./mysql -h 127.0.0.1 -u wwwtest -pabc foo
ERROR 1045 (28000): Access denied for user 'wwwtest'@'localhost' (using password: YES)
primavera:.libs liyanage$ arch -i386 ./mysql -h 127.0.0.1 -u wwwtest -pabc foo
ERROR 1045 (28000): Access denied for user 'wwwtest'@'localhost' (using password: YES) |
|
|
| Back to top |
|
|
tazz_ben
Joined: 12 Jan 2006
Posts: 9
Location: USA
|
| Posted: Fri Jan 25, 2008 17:16 Post subject: |
|
|
| liyanage wrote: | | tazz_ben wrote: | | It also works on my dual G5 Xserves, I wonder if it is only 32 bit PPC. |
You mean the module in general or the MySQL extension specifically works on your Xserves? |
Both. |
|
| Back to top |
|
|
revision29
Joined: 23 Jan 2008
Posts: 3
|
| Posted: Sun Jan 27, 2008 2:56 Post subject: MySQL connects w/command line |
|
|
| I forgot to say in my first post that when I parse a php page with the command line php, it authenticates with MySQL perfectly. I use /usr/local/php5/bin/php ~/Sites/page.php and it works great. I can scroll back through the output and there are no MySQL connection errors and the page content is filled as it should. |
|
| Back to top |
|
|
liyanage
Site Admin
Joined: 22 May 2003
Posts: 1104
Location: Zurich, Switzerland
|
| Posted: Sun Jan 27, 2008 12:12 Post subject: Re: MySQL connects w/command line |
|
|
| revision29 wrote: | | I forgot to say in my first post that when I parse a php page with the command line php, it authenticates with MySQL perfectly. I use /usr/local/php5/bin/php ~/Sites/page.php and it works great. I can scroll back through the output and there are no MySQL connection errors and the page content is filled as it should. |
Now that is interesting... So the same code works on the command line but breaks when run in the Apache module?
I can't imagine how that could work, because i just tried it with just the mysql client I built as part of the PHP package, and even that client breaks on 32bit. PHP is not even involved. |
|
| Back to top |
|
|
revision29
Joined: 23 Jan 2008
Posts: 3
|
| Posted: Mon Jan 28, 2008 5:50 Post subject: Re: MySQL connects w/command line |
|
|
| liyanage wrote: |
Now that is interesting... So the same code works on the command line but breaks when run in the Apache module?
I can't imagine how that could work, because i just tried it with just the mysql client I built as part of the PHP package, and even that client breaks on 32bit. PHP is not even involved. |
Crap, you know what? When I cd'ed to the /usr/bin/php5/bin and executed php ~/Sites/index.php, the shipping version of PHP was run, not the one in the directory. So I deleted the shipping php and executed your b6 and it was broken.
Sorry for spreading false information. |
|
| Back to top |
|
|
wegus
Joined: 30 Mar 2005
Posts: 23
|
| Posted: Mon Jan 28, 2008 12:47 Post subject: |
|
|
FreeTDS works perfect with my SQL Server 2000
Thank you Marc 
_________________
An Apple a day keeps the doctor away! |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
