Re: phpMyAdmin problem - no Edit/Delete on Browse
On Sun, 28 May 2006 at 18:26:46 +0100, Matthew Seaman wrote: Ian Smith wrote: On Sun, 28 May 2006, Matthew Seaman wrote: Ian Smith wrote: running 5.4-RELEASE and installed phpMyAdmin 2.6.1.3 with pkg_add -r [..] You would be well advised to upgrade to the latest phpMyAdmin, which is version 2.8.1, and is in the current ports. There are a number of security problems that affect many earlier versions. If you look at the list of security announcements at http://www.phpmyadmin.net/home_page/security.php then with version 2.6.1pl3 you're potentially vulnerable to anything announced after PMASA-2005-1 It's good advice for sure, however not practicable at the moment. As I said, this laptop is not net-accessible, and I just needed to get a job done. According to the requirement list, I'd have to update php, expat, mysql version! - surely a case of the tail wagging the dog? - and even xorg, pretty much everything. Not really doable on a 28.8k modem link. So, given my broadband application is on 'hold' awaiting local enabling which might take months, I'm going for a 6.1 4-CD set as soon as they're available; packages and/or distfiles is really the only way to go for those (still many) parts of the planet without fast, cheap connections. Think I'll start again with the installed config. I really can't recall if this problem was there since installation, but as mentioned all other import/export, create/drop/copy database/table, adding rows etc all just works well so far, excepting edit/delete availability on browse. I did start again from scratch; no difference. Still can't believe that such a show-stopper bug wouldn't have obviously affected many phpmyadmin users on 5.4 - people do use it to edit records, don't they? - so still have to suspect some local config issue. Tried another browser and all. I have a vague memory that I've seen something like this mentioned as a bugfix in the release notes for phpMyAdmin, but I can't put my finger on exactly where. You can see the release notes for most phpMyAdmin versions here: https://sourceforge.net/project/showfiles.php?group_id=23067package_id=16462 but the formatting is all wrong before the 2.8.x series. Yes, read every one since 2.6.1; nothing that struck me as even similar. Anyway, thankyou Matthew for your helpful advice and clues. Cheers, Ian ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: phpMyAdmin problem - no Edit/Delete on Browse
I use phpMyAdmin on freebsd 6.1 and it has working edit/delete on browsed rows. I did pkg_add -r for mysql5 then had to run port for php5 doing make config first to select apache module. The package version on phpmyadmin is broken because it needs some other dependant wicch is broken. Use port version of phpmyadmin first run make config and de-select all options then make install. It will use php5 and mysql5 because it finds them all ready installed.This should also work on your 5.4 system -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ian Smith Sent: Friday, June 02, 2006 12:48 PM To: Matthew Seaman Cc: [EMAIL PROTECTED] Subject: Re: phpMyAdmin problem - no Edit/Delete on Browse On Sun, 28 May 2006 at 18:26:46 +0100, Matthew Seaman wrote: Ian Smith wrote: On Sun, 28 May 2006, Matthew Seaman wrote: Ian Smith wrote: running 5.4-RELEASE and installed phpMyAdmin 2.6.1.3 with pkg_add -r [..] You would be well advised to upgrade to the latest phpMyAdmin, which is version 2.8.1, and is in the current ports. There are a number of security problems that affect many earlier versions. If you look at the list of security announcements at http://www.phpmyadmin.net/home_page/security.php then with version 2.6.1pl3 you're potentially vulnerable to anything announced after PMASA-2005-1 It's good advice for sure, however not practicable at the moment. As I said, this laptop is not net-accessible, and I just needed to get a job done. According to the requirement list, I'd have to update php, expat, mysql version! - surely a case of the tail wagging the dog? - and even xorg, pretty much everything. Not really doable on a 28.8k modem link. So, given my broadband application is on 'hold' awaiting local enabling which might take months, I'm going for a 6.1 4-CD set as soon as they're available; packages and/or distfiles is really the only way to go for those (still many) parts of the planet without fast, cheap connections. Think I'll start again with the installed config. I really can't recall if this problem was there since installation, but as mentioned all other import/export, create/drop/copy database/table, adding rows etc all just works well so far, excepting edit/delete availability on browse. I did start again from scratch; no difference. Still can't believe that such a show-stopper bug wouldn't have obviously affected many phpmyadmin users on 5.4 - people do use it to edit records, don't they? - so still have to suspect some local config issue. Tried another browser and all. I have a vague memory that I've seen something like this mentioned as a bugfix in the release notes for phpMyAdmin, but I can't put my finger on exactly where. You can see the release notes for most phpMyAdmin versions here: https://sourceforge.net/project/showfiles.php?group_id=23067package _id=16462 but the formatting is all wrong before the 2.8.x series. Yes, read every one since 2.6.1; nothing that struck me as even similar. Anyway, thankyou Matthew for your helpful advice and clues. Cheers, Ian ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: phpMyAdmin problem - no Edit/Delete on Browse
Ian Smith wrote: (originally posted to -database some days ago .. no nibbles) running 5.4-RELEASE and installed phpMyAdmin 2.6.1.3 with pkg_add -r (after finding installing from ports wanted to also fetch php4 sources and heaps of other stuff I already had installed from packages on the 2-CD set). I'd managed to find and install 5.4-R mysql packages also: smithi on paqi% pkg_info | grep -i php\|mysql libmcrypt-2.5.7_1 Multi-cipher cryptographic library (used in PHP) mysql-client-4.1.10a Multithreaded SQL database (client) mysql-server-4.1.10a Multithreaded SQL database (server) php4-4.3.10_2 PHP Scripting Language (Apache Module and CLI) php4-bz2-4.3.10_2 The bz2 shared extension for php php4-gd-4.3.10_2The gd shared extension for php php4-mbstring-4.3.10_2 The mbstring shared extension for php php4-mcrypt-4.3.10_2 The mcrypt shared extension for php php4-mysql-4.3.10_2 The mysql shared extension for php php4-openssl-4.3.10_2 The openssl shared extension for php php4-pcre-4.3.10_2 The pcre shared extension for php php4-zlib-4.3.10_2 The zlib shared extension for php phpMyAdmin-2.6.1.3 A set of PHP-scripts to manage MySQL over the web phpmyadmin basically works fine. I'd imported my databases from dumps, and all looked good after a bit of configuration. However when starting to do some real work on a couple of databases, I noticed that while browsing any database, the Edit and Delete options do not appear with each row, ie I can not update existing records (even as -u root) I'd suspected permissions, but I can insert new records, add/drop/empty tables and databases, bookmark queries and all. The permissions and ownership of and in /var/db/mysql are the same as my old 4.5-R system. $cfg['ModifyDeleteAtLeft'] = TRUE; I've also tried adding ...AtRight as well, but neither show up. If relevant, I'm using apache-1.3.33_1 and mozilla-1.7.7,2 .. all of this is just running on the local machine, so I'm not at the moment concerned with just security-issue updates. I haven't been able to find anything in later version change notes or PRs indicating anything like this problem, and updating to the current port would require updating php, mysql, expat and even xorg versions, which is just not doable over a 28.8k modem connection I'm afraid, so the 'usual' answer of cvsuping and updating everything is not helpful; in any case I suspect this is more likely a maybe subtle config issue? What is the UID *within* MySQL you are using to connect with? Does running: SHOW GRANTS FOR [EMAIL PROTECTED] ; make things any clearer? phpMyAdmin is clever enough to modify its user interface according to what the user has permission to do to the database. The user name use within the database depends on how you've configured phpMyAdmin -- I generally like to use 'cookie' mode authentication where the username and password are passed straight through to MySQL from the login dialog, but the 'config' mode given in the example config files requires you to put the username and password directly in the phpMyAdmin configuration file. Cheers, Matthew -- Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate Kent, CT11 9PW signature.asc Description: OpenPGP digital signature
Re: phpMyAdmin problem - no Edit/Delete on Browse
On Sun, 28 May 2006, Matthew Seaman wrote: Ian Smith wrote: running 5.4-RELEASE and installed phpMyAdmin 2.6.1.3 with pkg_add -r [..] mysql-client-4.1.10a Multithreaded SQL database (client) mysql-server-4.1.10a Multithreaded SQL database (server) php4-4.3.10_2 PHP Scripting Language (Apache Module and CLI) phpMyAdmin-2.6.1.3 A set of PHP-scripts to manage MySQL over the web [..] phpmyadmin basically works fine. I'd imported my databases from dumps, and all looked good after a bit of configuration. However when starting to do some real work on a couple of databases, I noticed that while browsing any database, the Edit and Delete options do not appear with each row, ie I can not update existing records (even as -u root) I'd suspected permissions, but I can insert new records, add/drop/empty tables and databases, bookmark queries and all. The permissions and ownership of and in /var/db/mysql are the same as my old 4.5-R system. $cfg['ModifyDeleteAtLeft'] = TRUE; I've also tried adding ...AtRight as well, but neither show up. If relevant, I'm using apache-1.3.33_1 and mozilla-1.7.7,2 .. all of this is just running on the local machine, so I'm not at the moment concerned with just security-issue updates. [..] What is the UID *within* MySQL you are using to connect with? Does running: SHOW GRANTS FOR [EMAIL PROTECTED] ; make things any clearer? Nope. Show processlist confirms that I'm logged in as [EMAIL PROTECTED], with an idle [EMAIL PROTECTED] process as well for bookmarks etc. SHOW GRANTS FOR [EMAIL PROTECTED]; GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*A5obscured4C2EFF' WITH GRANT OPTION phpMyAdmin is clever enough to modify its user interface according to what the user has permission to do to the database. The user name use within the database depends on how you've configured phpMyAdmin -- I generally like to use 'cookie' mode authentication where the username and password are passed straight through to MySQL from the login dialog, but the 'config' mode given in the example config files requires you to put the username and password directly in the phpMyAdmin configuration file. Just using 'config' mode, user root so far; thought I'd tighten it up properly for outside access after getting it doing some useful work! Think I'll start again with the installed config. I really can't recall if this problem was there since installation, but as mentioned all other import/export, create/drop/copy database/table, adding rows etc all just works well so far, excepting edit/delete availability on browse. Thanks Matthew, cheers, Ian ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: phpMyAdmin problem - no Edit/Delete on Browse
Ian Smith wrote: On Sun, 28 May 2006, Matthew Seaman wrote: Ian Smith wrote: running 5.4-RELEASE and installed phpMyAdmin 2.6.1.3 with pkg_add -r [..] You would be well advised to upgrade to the latest phpMyAdmin, which is version 2.8.1, and is in the current ports. There are a number of security problems that affect many earlier versions. If you look at the list of security announcements at http://www.phpmyadmin.net/home_page/security.php then with version 2.6.1pl3 you're potentially vulnerable to anything announced after PMASA-2005-1 Think I'll start again with the installed config. I really can't recall if this problem was there since installation, but as mentioned all other import/export, create/drop/copy database/table, adding rows etc all just works well so far, excepting edit/delete availability on browse. I have a vague memory that I've seen something like this mentioned as a bugfix in the release notes for phpMyAdmin, but I can't put my finger on exactly where. You can see the release notes for most phpMyAdmin versions here: https://sourceforge.net/project/showfiles.php?group_id=23067package_id=16462 but the formatting is all wrong before the 2.8.x series. Cheers, Matthew -- Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate Kent, CT11 9PW signature.asc Description: OpenPGP digital signature