记一下TestLink遇到的连接数据方面的一个问题-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

记一下TestLink遇到的连接数据方面的一个问题

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 04:37 PM

one timedataconnectmeet

今天发现登录TestLink总是不成功，前几天还正常的，很奇怪。提示用户名/密码错误之类的，而且其他人的帐号也同样不能登录。然而，我们都很清楚用户名密码是匹配的。解决问题步骤如下： 1. 试了一下，找回密码功能，发现它提示说我的用户名不存在。 2. 查看了

今天发现登录TestLink总是不成功，前几天还正常的，很奇怪。提示用户名/密码错误之类的，而且其他人的帐号也同样不能登录。然而，我们都很清楚用户名密码是匹配的。解决问题步骤如下：
1. 试了一下，找回密码功能，发现它提示说我的用户名不存在。
2. 查看了MySQL数据中users表，我的用户名是存在的啊。遂怀疑是TestLink连接数据方面的的问题。
3. 查看了 config_db.inc.php 配置文件，发现链接MySQL的用户名/密码/主机名都正常的。
4. logs/userlog3.log 和 log/userlog0.log 文件，发现里面有如下的错误：

Declaration of ADODB_mysql::MetaColumns() should be compatible with that of ADOConnection::MetaColumns() - in /home/testlink/third_party/adodb/drivers/adodb-mysql.inc.php - Line 21

这时TestLink使用的ADODB这个第三方库发生的问题，而且刚好是数据库有关的，所以感觉是今天遇到的问题所在。
看到网上有人曾反馈过这个问题，ADOdb与PHP5.2以上的一个兼容性问题，说是需要使用较新版本的ADOdb即可，所以从 http://adodb.sourceforge.net/#download 下载了最新的ADOdb库替换掉原来的即可。
果然，我是用了ADOdb 5.18 就没有上面的错误信息了，用户也可以正常登录了。

尽管问题解决了，有一点还是没想明白，TestLink都使用了2年了，为啥现在爆出了数据库连接层的问题，有问题应该一开始就不能用啊；最近我们似乎没升级过TestLink和PHP的版本。哎，暂时这样吧～

参考资料：

http://www.teamst.org/forum/viewtopic.php?f=11&t=2333

http://forums.phpfreaks.com/topic/181192-solved-php-openchat-doomed-to-blow-outabandoned/

Original article: 记一下TestLink遇到的连接数据方面的一个问题

原文地址：记一下TestLink遇到的连接数据方面的一个问题, 感谢原作者分享。

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

What Are the Limitations of Using Views in MySQL?May 14, 2025 am 12:10 AM

MySQLviewshavelimitations:1)Theydon'tsupportallSQLoperations,restrictingdatamanipulationthroughviewswithjoinsorsubqueries.2)Theycanimpactperformance,especiallywithcomplexqueriesorlargedatasets.3)Viewsdon'tstoredata,potentiallyleadingtooutdatedinforma

Securing Your MySQL Database: Adding Users and Granting PrivilegesMay 14, 2025 am 12:09 AM

ProperusermanagementinMySQLiscrucialforenhancingsecurityandensuringefficientdatabaseoperation.1)UseCREATEUSERtoaddusers,specifyingconnectionsourcewith@'localhost'or@'%'.2)GrantspecificprivilegeswithGRANT,usingleastprivilegeprincipletominimizerisks.3)

What Factors Influence the Number of Triggers I Can Use in MySQL?May 14, 2025 am 12:08 AM

MySQLdoesn'timposeahardlimitontriggers,butpracticalfactorsdeterminetheireffectiveuse:1)Serverconfigurationimpactstriggermanagement;2)Complextriggersincreasesystemload;3)Largertablesslowtriggerperformance;4)Highconcurrencycancausetriggercontention;5)M

MySQL: Is it safe to store BLOB?May 14, 2025 am 12:07 AM

Yes,it'ssafetostoreBLOBdatainMySQL,butconsiderthesefactors:1)StorageSpace:BLOBscanconsumesignificantspace,potentiallyincreasingcostsandslowingperformance.2)Performance:LargerrowsizesduetoBLOBsmayslowdownqueries.3)BackupandRecovery:Theseprocessescanbe

MySQL: Adding a user through a PHP web interfaceMay 14, 2025 am 12:04 AM

Adding MySQL users through the PHP web interface can use MySQLi extensions. The steps are as follows: 1. Connect to the MySQL database and use the MySQLi extension. 2. Create a user, use the CREATEUSER statement, and use the PASSWORD() function to encrypt the password. 3. Prevent SQL injection and use the mysqli_real_escape_string() function to process user input. 4. Assign permissions to new users and use the GRANT statement.

MySQL: BLOB and other no-sql storage, what are the differences?May 13, 2025 am 12:14 AM

MySQL'sBLOBissuitableforstoringbinarydatawithinarelationaldatabase,whileNoSQLoptionslikeMongoDB,Redis,andCassandraofferflexible,scalablesolutionsforunstructureddata.BLOBissimplerbutcanslowdownperformancewithlargedata;NoSQLprovidesbetterscalabilityand

MySQL Add User: Syntax, Options, and Security Best PracticesMay 13, 2025 am 12:12 AM

ToaddauserinMySQL,use:CREATEUSER'username'@'host'IDENTIFIEDBY'password';Here'showtodoitsecurely:1)Choosethehostcarefullytocontrolaccess.2)SetresourcelimitswithoptionslikeMAX_QUERIES_PER_HOUR.3)Usestrong,uniquepasswords.4)EnforceSSL/TLSconnectionswith

MySQL: How to avoid String Data Types common mistakes?May 13, 2025 am 12:09 AM

ToavoidcommonmistakeswithstringdatatypesinMySQL,understandstringtypenuances,choosetherighttype,andmanageencodingandcollationsettingseffectively.1)UseCHARforfixed-lengthstrings,VARCHARforvariable-length,andTEXT/BLOBforlargerdata.2)Setcorrectcharacters

See all articles