解决php5.2与mysql兼容问题
最近在做一键安装包(LAMP、LAMP)--适用于阿里云小白的产品。过程中,遇到一个问题,在Ubuntu14.04系统上,测试Apache2.2+php5.2+mysql5.1 ,编译安装php出现了问题。
报错内容:
ext/zip/lib/.libs/zip_dirent.o: In function `memset':/usr/include/x86_64-linux-gnu/bits/string3.h:81: warning: memset used with constant zero length parameter; this could be due to transposed parametersext/mysqli/.libs/mysqli_repl.o: In function `zif_mysqli_disable_reads_from_master':/root/sh-1.5.5/php-5.2.17/ext/mysqli/mysqli_repl.c:44: undefined reference to `mysql_disable_reads_from_master'ext/mysqli/.libs/mysqli_repl.o: In function `zif_mysqli_disable_rpl_parse':/root/sh-1.5.5/php-5.2.17/ext/mysqli/mysqli_repl.c:60: undefined reference to `mysql_disable_rpl_parse'ext/mysqli/.libs/mysqli_repl.o: In function `zif_mysqli_enable_reads_from_master':/root/sh-1.5.5/php-5.2.17/ext/mysqli/mysqli_repl.c:77: undefined reference to `mysql_enable_reads_from_master'ext/mysqli/.libs/mysqli_repl.o: In function `zif_mysqli_enable_rpl_parse':/root/sh-1.5.5/php-5.2.17/ext/mysqli/mysqli_repl.c:94: undefined reference to `mysql_enable_rpl_parse'ext/mysqli/.libs/mysqli_repl.o: In function `zif_mysqli_master_query':/root/sh-1.5.5/php-5.2.17/ext/mysqli/mysqli_repl.c:112: undefined reference to `mysql_master_query'ext/mysqli/.libs/mysqli_repl.o: In function `zif_mysqli_rpl_parse_enabled':/root/sh-1.5.5/php-5.2.17/ext/mysqli/mysqli_repl.c:131: undefined reference to `mysql_rpl_parse_enabled'ext/mysqli/.libs/mysqli_repl.o: In function `zif_mysqli_rpl_probe':/root/sh-1.5.5/php-5.2.17/ext/mysqli/mysqli_repl.c:148: undefined reference to `mysql_rpl_probe'ext/mysqli/.libs/mysqli_repl.o: In function `zif_mysqli_rpl_query_type':/root/sh-1.5.5/php-5.2.17/ext/mysqli/mysqli_repl.c:169: undefined reference to `mysql_rpl_query_type'ext/mysqli/.libs/mysqli_repl.o: In function `zif_mysqli_slave_query':/root/sh-1.5.5/php-5.2.17/ext/mysqli/mysqli_repl.c:208: undefined reference to `mysql_slave_query'collect2: error: ld returned 1 exit statusmake: *** [sapi/cli/php] Error 1
对于这个问题,我是各种百度Google,没有找到解决办法,唯一看到就是说是mysql版本bug。没办法,去找mysql5.1bug相关信息,才知道需要改编译文件。
php在编译时,不要加 --with-mysqli这个参数,先把php编译安装好,只是不能喝mysql结合。然后,修改php安装包下的文件ext/zip/lib/zip_dirent.c把memset(&tm, sizeof(tm), 0);替换成memset(&tm, 0, sizeof(tm));
然后 ,cd ext/mysqli/
/php/bin/phpize
./configure --with-php-config=/php/bin/php-config --with-mysqli=/mysql-5.1.73/bin/mysql_config
make
make install
然后就OK了。

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



Alipay PHP...

JWT is an open standard based on JSON, used to securely transmit information between parties, mainly for identity authentication and information exchange. 1. JWT consists of three parts: Header, Payload and Signature. 2. The working principle of JWT includes three steps: generating JWT, verifying JWT and parsing Payload. 3. When using JWT for authentication in PHP, JWT can be generated and verified, and user role and permission information can be included in advanced usage. 4. Common errors include signature verification failure, token expiration, and payload oversized. Debugging skills include using debugging tools and logging. 5. Performance optimization and best practices include using appropriate signature algorithms, setting validity periods reasonably,

Article discusses late static binding (LSB) in PHP, introduced in PHP 5.3, allowing runtime resolution of static method calls for more flexible inheritance.Main issue: LSB vs. traditional polymorphism; LSB's practical applications and potential perfo

Session hijacking can be achieved through the following steps: 1. Obtain the session ID, 2. Use the session ID, 3. Keep the session active. The methods to prevent session hijacking in PHP include: 1. Use the session_regenerate_id() function to regenerate the session ID, 2. Store session data through the database, 3. Ensure that all session data is transmitted through HTTPS.

The application of SOLID principle in PHP development includes: 1. Single responsibility principle (SRP): Each class is responsible for only one function. 2. Open and close principle (OCP): Changes are achieved through extension rather than modification. 3. Lisch's Substitution Principle (LSP): Subclasses can replace base classes without affecting program accuracy. 4. Interface isolation principle (ISP): Use fine-grained interfaces to avoid dependencies and unused methods. 5. Dependency inversion principle (DIP): High and low-level modules rely on abstraction and are implemented through dependency injection.

How to automatically set the permissions of unixsocket after the system restarts. Every time the system restarts, we need to execute the following command to modify the permissions of unixsocket: sudo...

Static binding (static::) implements late static binding (LSB) in PHP, allowing calling classes to be referenced in static contexts rather than defining classes. 1) The parsing process is performed at runtime, 2) Look up the call class in the inheritance relationship, 3) It may bring performance overhead.

How to debug CLI mode in PHPStorm? When developing with PHPStorm, sometimes we need to debug PHP in command line interface (CLI) mode...
