Bugzilla – Full Text Bug Listing
| Summary: | [build.eclipse.org] Need Mysql 5.x and PHP 5.x w/ https support | ||
|---|---|---|---|
| Product: | Community | Reporter: | Nick Boldt <nboldt> |
| Component: | CommitterTools | Assignee: | Eclipse Webmaster <webmaster> |
| Status: | RESOLVED FIXED | QA Contact: | |
| Severity: | normal | ||
| Priority: | P3 | CC: | ns03ja |
| Version: | unspecified | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | Windows XP | ||
| Whiteboard: | |||
(In reply to comment #0) > * mysql 5.x+ > * php 5.x+ (consistency with other Eclipse servers) Actually, you'll get both on Sunday, November 26: http://wiki.eclipse.org/index.php?title=SLES_10_Upgrade_Plan > * compiled support to connect to mysql 5.0+ That'll be included > * compiled support for openssl/https (to be able to do > file('https://bugs.eclipse.org/...')) I can't do this... You'll need to access the bugzilla database directly, not through a web page. > Please note - there's a rather debilitating mysql bug here, but there's > apparently two workarounds available until an actual release is available with > the fix in it: SLES 10 has 5.0.18, so it's likely not affected by this. > > http://bugs.mysql.com/bug.php?id=19810 (see comment [30 Oct 11:13] Magnus > Svensson and comments thereafter) > > Also, I tried to run `mysql` and got: > > modelingBuild@utils:~> mysql > -bash: /usr/bin/mysql: Permission denied I've fixed the permissions on that. You're good to go. Nick, build.eclipse.org has been upgraded. It provides both MySQL 5.0.18 and PHP 5.1.2. Can you confirm that this is what you need? PHP5 and Mysql5 appear fine, but we can't test fully until we have a database and user account. 1258 nickb@utils:/opt $ mysql -u modeling -p Enter password: ERROR 1045 (28000): Access denied for user 'modeling'@'localhost' (using password: YES) Can you create the following: a) database called "modeling" b) read-write access user "modeling", which can access the "modeling" database ONLY on localhost (password is in ~nickb/searchcvs/includes/parsecvs-dbaccess.php on build.eclipse.org) c) read-only web access user "modelingwww", which can access the "modeling" database using /www/modeling/includes/searchcvs-dbaccess.php from www.eclipse.org (please set the same password as in that file) After that we can populate the database and test that everything's working. Note also that while it doesn't impact us, there's some missing .so files: $ php5 -m PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/extensions/bz2.so' - /usr/lib/php5/extensions/bz2.so: cannot open shared object file: No such file or directory in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/extensions/ctype.so' - /usr/lib/php5/extensions/ctype.so: cannot open shared object file: No such file or directory in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/extensions/dom.so' - /usr/lib/php5/extensions/dom.so: cannot open shared object file: No such file or directory in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/extensions/xmlreader.so' - /usr/lib/php5/extensions/xmlreader.so: cannot open shared object file: No such file or directory in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/extensions/xsl.so' - /usr/lib/php5/extensions/xsl.so: cannot open shared object file: No such file or directory in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/extensions/zlib.so' - /usr/lib/php5/extensions/zlib.so: cannot open shared object file: No such file or directory in Unknown on line 0 (In reply to comment #3) > PHP5 and Mysql5 appear fine, but we can't test fully until we have a database > and user account. I sent you mysql credentials in an e-mail on 10/10 at 10:10 (scary). I logged in successfully with them, so let me know if you want me to resend. Although, back then, you only requested one account, so for simplicity's sake, let's leave it at that. utils:~ # mysql -u (username) -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 10 to server version: 5.0.18 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use modeling Database changed mysql> show tables; Empty set (0.00 sec) mysql> Bye As for PHP, it's likely a config file problem. I'll fix that. Closing as fixed, as both upgraded packages have been installed. You're sure you don't want to split between web read-only and localhost read-write user access? I can use the same credentials in both cases, but wouldn't it be more secure to split 'em? BTW, once we have this tested, we'll migrate the database on emft.eclipse to here which means we'll have to update the searchcvs-dbaccess.php file in /www/modeling/includes/ again with the new username/password/servername. I'll open a new bug then and put the file w/ the new details in my ~ dir on build.eclipse. (In reply to comment #5) > You're sure you don't want to split between web read-only and localhost > read-write user access? I can use the same credentials in both cases, but > wouldn't it be more secure to split 'em? Of course, but our goal here is a CBI of some sort, and I don't want to spend my life managing everyone's MySQL accounts - because at some point, someone won't understand why the UPDATE statement failed. At any rate, I created a modeling_ro account for you with the password in your PHP at file~nickb/searchcvs/includes/parsecvs-dbaccess.php - it has SELECT access only. Additional. build.eclipse.org does not have its timezone information loaded: mysql> SELECT CONVERT_TZ(NOW(), 'EST', 'GMT'); +---------------------------------+ | CONVERT_TZ(NOW(), 'EST', 'GMT') | +---------------------------------+ | NULL | +---------------------------------+ 1 row in set (0.00 sec) can you run this? $ mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql mysql -u root -p utils: # mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p Enter password: ERROR 1046 (3D000) at line 1: No database selected utils: # mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p modeling Enter password: ERROR 1146 (42S02) at line 1: Table 'modeling.time_zone' doesn't exist database is "mysql":
$ mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql mysql -u root -p
^^^^^
(In reply to comment #9) > database is "mysql": > > $ mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql mysql -u root -p My eyes! The goggles, they do nothing! (done) Mysql tables loaded; users both work. Closing. |
Build.eclipse.org currently has PHP 4.3.4 and mysql4.1 (?). To support migration of cross-project tools moving from emft.eclipse.org to build.eclipse.org (eg., Search CVS & our new release notes query/generator), we'll need the following updated on build.eclipse.org: * mysql 5.x+ * php 5.x+ (consistency with other Eclipse servers) * compiled support to connect to mysql 5.0+ * compiled support for openssl/https (to be able to do file('https://bugs.eclipse.org/...')) Please note - there's a rather debilitating mysql bug here, but there's apparently two workarounds available until an actual release is available with the fix in it: http://bugs.mysql.com/bug.php?id=19810 (see comment [30 Oct 11:13] Magnus Svensson and comments thereafter) Also, I tried to run `mysql` and got: modelingBuild@utils:~> mysql -bash: /usr/bin/mysql: Permission denied So hopefully I'll be able to connect to mysql through php, if not at the commandline. Ideally I'd be able to do both php AND commandline (makes setting up tables and users easier). I know you guys plan to update this box to SLES10, so if these changes can be done thereafter or incorporated into it, that would be fantastic. In the meantime, we'll hack something workable on emft.eclipse.org. (BTW, you don't have a Component for build.eclipse.org. Might be a handy thing to have, IMHO.)