Re: phpMyAdmin problem - no Edit/Delete on Browse

2006-06-02 Thread Ian Smith
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

2006-06-02 Thread fbsd
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

2006-05-28 Thread Matthew Seaman
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

2006-05-28 Thread Ian Smith
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

2006-05-28 Thread Matthew Seaman
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