[gentoo-user] phpmyadmin - edit (empty screen)

[gentoo-user] phpmyadmin - edit (empty screen)

[thelma]

I've updated to phpmyadmin-4.7.8
but when I try to edit a table, no data is loaded, I get an empty screen.

I have downgraded to phpmyadmin-4.7.7-r1 but system shows I have two
version installed. How do I know which one is active, or select lower
version?

eshowkw phpmyadmin
Keywords for dev-db/phpmyadmin:
             |                             |   u           |
             | a a         p   a         s |   n           |
             | l m   h i   p   r m m s   p | e u s         | r
             | p d a p a p c x m 6 i 3   a | a s l         | e
             | h 6 r p 6 p 6 8 6 8 p 9 s r | p e o         | p
             | a 4 m a 4 c 4 6 4 k s 0 h c | i d t         | o
-------------+-----------------------------+---------------+-------
4.0.10.20    | + + o + ~ + + + o o o o o + | 5 o 4.0.10.20 | gentoo
-------------+-----------------------------+---------------+-------
    4.7.0    | + + ~ + ~ + + + o o o o o + | 5 o 4.7.0     | gentoo
-------------+-----------------------------+---------------+-------
 [I]4.7.7-r1 | + + ~ ~ ~ ~ ~ + o o o o o ~ | 5 o 4.7.7-r1  | gentoo
-------------+-----------------------------+---------------+-------
 [I]4.7.8    | + + ~ ~ ~ ~ ~ + o o o o o ~ | 5 o 4.7.8     | gentoo

-- 
Thelma

Re: [gentoo-user] phpmyadmin - edit (empty screen)

[nils.freydank]

[-- Attachment #1: Type: text/plain, Size: 1538 bytes --]

Hello thelma,


Am Montag, 26. März 2018, 18:27:31 CEST schrieb thelma@sys-concept.com:
> I've updated to phpmyadmin-4.7.8
> but when I try to edit a table, no data is loaded, I get an empty screen.
I had similar issue when I installed v4.7.8, and enabling PHP debug output to 
the website helped me fixing the actuall PHP issue (while I couldn't get the 
logging to write these messages to any logfile).

Here is my nginx snippet for phpmyadmin in a subdirectory:
#=== POSTFIXADMIN ===
location /postfixadmin {
        try_files $uri $uri/ index.php;
}
location ~ .php$ {
#fastcgi_split_path_info ^(.+\.php)(/.+)$;
include fastcgi_params;
fastcgi_pass php-handler; # see below
fastcgi_index index.php;
include fastcgi_params;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
fastcgi_param PATH_INFO $fastcgi_path_info;
fastcgi_buffer_size 16k;
fastcgi_buffers 4 16k;
}
#EOF
#=== snippet for the php-handler:
upstream php-handler{
        server 127.0.0.1:9000;
}
#EOF

> I have downgraded to phpmyadmin-4.7.7-r1 but system shows I have two
> version installed. How do I know which one is active, or select lower
> version?
With portage you install something like a "draft" to /usr, and then app-admin/
webapp-config actually manages the files inside your webroot. For details how 
to use it take a look to our wiki page:
https://wiki.gentoo.org/wiki/Webapp-config

> […]

HTH,
Nils

-- 
GPG fingerprint: '00EF D31F 1B60 D5DB ADB8 31C1 C0EC E696 0E54 475B'
Nils Freydank

[-- Attachment #2: This is a digitally signed message part. --]
[-- Type: application/pgp-signature, Size: 833 bytes --]

Re: [gentoo-user] phpmyadmin - edit (empty screen)

[thelma]

On 03/26/2018 10:41 AM, nils.freydank@posteo.de wrote:
> Hello thelma,
> 
> 
> Am Montag, 26. März 2018, 18:27:31 CEST schrieb thelma@sys-concept.com:
>> I've updated to phpmyadmin-4.7.8
>> but when I try to edit a table, no data is loaded, I get an empty screen.
> I had similar issue when I installed v4.7.8, and enabling PHP debug output to 
> the website helped me fixing the actuall PHP issue (while I couldn't get the 
> logging to write these messages to any logfile).
> 
> Here is my nginx snippet for phpmyadmin in a subdirectory:
> #=== POSTFIXADMIN ===
> location /postfixadmin {
>         try_files $uri $uri/ index.php;
> }
> location ~ .php$ {
> #fastcgi_split_path_info ^(.+\.php)(/.+)$;
> include fastcgi_params;
> fastcgi_pass php-handler; # see below
> fastcgi_index index.php;
> include fastcgi_params;
> fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
> fastcgi_param PATH_INFO $fastcgi_path_info;
> fastcgi_buffer_size 16k;
> fastcgi_buffers 4 16k;
> }
> #EOF
> #=== snippet for the php-handler:
> upstream php-handler{
>         server 127.0.0.1:9000;
> }
> #EOF
> 
>> I have downgraded to phpmyadmin-4.7.7-r1 but system shows I have two
>> version installed. How do I know which one is active, or select lower
>> version?
> With portage you install something like a "draft" to /usr, and then app-admin/
> webapp-config actually manages the files inside your webroot. For details how 
> to use it take a look to our wiki page:
> https://wiki.gentoo.org/wiki/Webapp-config
> 
>> […]
> 
> HTH,
> Nils

In the past I didn't have to do anything after upgrading phpmyadmin.
I can see the table, but when I try to edit data inside them I get an empty screen:

Here is my current: config.inc.php
b<?php
/*
* Generated configuration file
* Generated by: phpMyAdmin 3.4.0 setup script
* Date: Mon, 23 May 2011 10:23:03 -0400
*/

/* Servers configuration */
$i = 0;

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';


/* End of servers configuration */

$cfg['blowfish_secret'] = '';
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
$cfg['DefaultLang'] = 'en';
$cfg['ServerDefault'] = 1;

/* configuration storage */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['controluser'] = 'phpmyadmin';
$cfg['Servers'][$i]['controlpass'] = 'MeyLCywYz3TUjYx9';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';
$cfg['Servers'][$i]['recent'] = 'pma_recent';
$cfg['Servers'][$i]['table_uiprefs']  = 'pma_table_uiprefs';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
?>

Re: [gentoo-user] phpmyadmin - edit (empty screen)

[nils.freydank]

[-- Attachment #1: Type: text/plain, Size: 1237 bytes --]

Am Montag, 26. März 2018, 18:53:51 CEST schrieb thelma@sys-concept.com:
> On 03/26/2018 10:41 AM, nils.freydank@posteo.de wrote:
> > Hello thelma,
> > 
> > Am Montag, 26. März 2018, 18:27:31 CEST schrieb thelma@sys-concept.com:
> >> I've updated to phpmyadmin-4.7.8 [...]
> In the past I didn't have to do anything after upgrading phpmyadmin.
Then you either
a) actually never updated the files actually used by your webserver, or
b) run your webserver to serve files from /usr, which sounds a bit…stranges 
and might bring security implications, or
c) installed phpmyadmin without portage (which means you wouldn't have to care 
anyway), or
d) portage installed earlier into a webroot (what is quite unlikely).

> Here is my current: config.inc.php
> b<?php
> /*
> * Generated configuration file
> * Generated by: phpMyAdmin 3.4.0 setup script
> * Date: Mon, 23 May 2011 10:23:03 -0400
> */

3.4.0 from _2011_ is not even in the tree anymore (if it was). I don't know 
what happens on upgrades, but if this header is correct then your setup is 
still on a state nearly seven years old. Maybe check for that with ls?

-- 
GPG fingerprint: '00EF D31F 1B60 D5DB ADB8 31C1 C0EC E696 0E54 475B'
Nils Freydank

[-- Attachment #2: This is a digitally signed message part. --]
[-- Type: application/pgp-signature, Size: 833 bytes --]

Re: [gentoo-user] phpmyadmin - edit (empty screen)

[thelma]

On 03/26/2018 11:34 AM, nils.freydank@posteo.de wrote:
> Am Montag, 26. März 2018, 18:53:51 CEST schrieb thelma@sys-concept.com:
>> On 03/26/2018 10:41 AM, nils.freydank@posteo.de wrote:
>>> Hello thelma,
>>>
>>> Am Montag, 26. März 2018, 18:27:31 CEST schrieb thelma@sys-concept.com:
>>>> I've updated to phpmyadmin-4.7.8 [...]
>> In the past I didn't have to do anything after upgrading phpmyadmin.
> Then you either
> a) actually never updated the files actually used by your webserver, or
> b) run your webserver to serve files from /usr, which sounds a bit…stranges 
> and might bring security implications, or
> c) installed phpmyadmin without portage (which means you wouldn't have to care 
> anyway), or
> d) portage installed earlier into a webroot (what is quite unlikely).
> 
>> Here is my current: config.inc.php
>> b<?php
>> /*
>> * Generated configuration file
>> * Generated by: phpMyAdmin 3.4.0 setup script
>> * Date: Mon, 23 May 2011 10:23:03 -0400
>> */
> 
> 3.4.0 from _2011_ is not even in the tree anymore (if it was). I don't know 
> what happens on upgrades, but if this header is correct then your setup is 
> still on a state nearly seven years old. Maybe check for that with ls?

I've emerge "phpmyadmin-4.7.8" with "setup" and try to run run
configuration from from a web-browser:
http://localhost//phpmyadmin/setup/

but it complained it couldn't find any web-server.
So I rename the: config.sample.inc.php  to: config.inc.php
It found my server but same effect:
When I try to open a table to edit data inside I get an empty screen.

--
Thelma

Re: [gentoo-user] phpmyadmin - edit (empty screen)

[Neil Bothwick]

[-- Attachment #1: Type: text/plain, Size: 783 bytes --]

On Mon, 26 Mar 2018 19:34:38 +0200, nils.freydank@posteo.de wrote:

> > In the past I didn't have to do anything after upgrading phpmyadmin.  
> Then you either
> a) actually never updated the files actually used by your webserver, or
> b) run your webserver to serve files from /usr, which sounds a
> bit…stranges and might bring security implications, or
> c) installed phpmyadmin without portage (which means you wouldn't have
> to care anyway), or
> d) portage installed earlier into a webroot (what is quite unlikely).

If the vhosts USE flag is unset, the ebuild runs webapp-config when
installing a new version. If you want to switch back to the older version
you should run webapp-config manually.


-- 
Neil Bothwick

If you cannot fix it, feature it.

[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 833 bytes --]

Re: [gentoo-user] phpmyadmin - edit (empty screen)

[thelma]

Are there any alternative to phpmyadmin in portage?

All do is editing/deleting one entry from a table in mysql database.

--
Thelma

Re: [gentoo-user] phpmyadmin - edit (empty screen)

[thelma]

On 03/26/2018 10:41 AM, nils.freydank@posteo.de wrote:
> Hello thelma,
> 
> 
> Am Montag, 26. März 2018, 18:27:31 CEST schrieb thelma@sys-concept.com:
>> I've updated to phpmyadmin-4.7.8
>> but when I try to edit a table, no data is loaded, I get an empty screen.
> I had similar issue when I installed v4.7.8, and enabling PHP debug output to 
> the website helped me fixing the actuall PHP issue (while I couldn't get the 
> logging to write these messages to any logfile).
> 
> Here is my nginx snippet for phpmyadmin in a subdirectory:
> #=== POSTFIXADMIN ===
> location /postfixadmin {
>         try_files $uri $uri/ index.php;
> }
> location ~ .php$ {
> #fastcgi_split_path_info ^(.+\.php)(/.+)$;
> include fastcgi_params;
> fastcgi_pass php-handler; # see below
> fastcgi_index index.php;
> include fastcgi_params;
> fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
> fastcgi_param PATH_INFO $fastcgi_path_info;
> fastcgi_buffer_size 16k;
> fastcgi_buffers 4 16k;
> }
> #EOF
> #=== snippet for the php-handler:
> upstream php-handler{
>         server 127.0.0.1:9000;
> }
> #EOF
> 
>> I have downgraded to phpmyadmin-4.7.7-r1 but system shows I have two
>> version installed. How do I know which one is active, or select lower
>> version?
> With portage you install something like a "draft" to /usr, and then app-admin/
> webapp-config actually manages the files inside your webroot. For details how 
> to use it take a look to our wiki page:
> https://wiki.gentoo.org/wiki/Webapp-config
> 
>> […]
> 
> HTH,
> Nils

I've pulled phpmyadmin-4.4.12 from attic and it is working.
So some additional setting have changed that is not allowing me to
access and edit database entries.

--
Thelma

Re: [gentoo-user] phpmyadmin - edit (empty screen)

[Elijah Mark Anderson]

[-- Attachment #1: Type: text/plain, Size: 1680 bytes --]

Out of curiosity, have you tried just grabbing phpMyAdmin from the up-stream 
website and running it as a regular PHP site? I've always found working with 
distro-packaged PHP apps to be cumbersome; more trouble than their supposed 
advantages are worth, especially now that most PHP apps can update themselves.

On Monday, March 26, 2018 11:27:31 AM CDT thelma@sys-concept.com wrote:
> I've updated to phpmyadmin-4.7.8
> but when I try to edit a table, no data is loaded, I get an empty screen.
> 
> I have downgraded to phpmyadmin-4.7.7-r1 but system shows I have two
> version installed. How do I know which one is active, or select lower
> version?
> 
> eshowkw phpmyadmin
> 
> Keywords for dev-db/phpmyadmin:
>              |                             |   u           |
>              | 
>              | a a         p   a         s |   n           |
>              | l m   h i   p   r m m s   p | e u s         | r
>              | p d a p a p c x m 6 i 3   a | a s l         | e
>              | h 6 r p 6 p 6 8 6 8 p 9 s r | p e o         | p
>              | a 4 m a 4 c 4 6 4 k s 0 h c | i d t         | o
> 
> -------------+-----------------------------+---------------+-------
> 4.0.10.20    | + + o + ~ + + + o o o o o + | 5 o 4.0.10.20 | gentoo
> -------------+-----------------------------+---------------+-------
>     4.7.0    | + + ~ + ~ + + + o o o o o + | 5 o 4.7.0     | gentoo
> -------------+-----------------------------+---------------+-------
>  [I]4.7.7-r1 | + + ~ ~ ~ ~ ~ + o o o o o ~ | 5 o 4.7.7-r1  | gentoo
> -------------+-----------------------------+---------------+-------
>  [I]4.7.8    | + + ~ ~ ~ ~ ~ + o o o o o ~ | 5 o 4.7.8     | gentoo

[-- Attachment #2: This is a digitally signed message part. --]
[-- Type: application/pgp-signature, Size: 833 bytes --]

Re: [gentoo-user] phpmyadmin - edit (empty screen)

[thelma]

On 03/26/2018 07:37 PM, Elijah Mark Anderson wrote:
> Out of curiosity, have you tried just grabbing phpMyAdmin from the up-stream 
> website and running it as a regular PHP site? I've always found working with 
> distro-packaged PHP apps to be cumbersome; more trouble than their supposed 
> advantages are worth, especially now that most PHP apps can update themselves.

I was told I should try 4.7.9 (latest, not in portage yet).  Since
4.4.12 (is old ) and working I'm in no hurry to try to upgrade.  Will
wait for portage version I think, even unstable :-/

I wish there were some alternatives to phymyadmin in portage.

--
Thelma

> 
> On Monday, March 26, 2018 11:27:31 AM CDT thelma@sys-concept.com wrote:
>> I've updated to phpmyadmin-4.7.8
>> but when I try to edit a table, no data is loaded, I get an empty screen.
>>
>> I have downgraded to phpmyadmin-4.7.7-r1 but system shows I have two
>> version installed. How do I know which one is active, or select lower
>> version?
>>
>> eshowkw phpmyadmin
>>
>> Keywords for dev-db/phpmyadmin:
>>              |                             |   u           |
>>              | 
>>              | a a         p   a         s |   n           |
>>              | l m   h i   p   r m m s   p | e u s         | r
>>              | p d a p a p c x m 6 i 3   a | a s l         | e
>>              | h 6 r p 6 p 6 8 6 8 p 9 s r | p e o         | p
>>              | a 4 m a 4 c 4 6 4 k s 0 h c | i d t         | o
>>
>> -------------+-----------------------------+---------------+-------
>> 4.0.10.20    | + + o + ~ + + + o o o o o + | 5 o 4.0.10.20 | gentoo
>> -------------+-----------------------------+---------------+-------
>>     4.7.0    | + + ~ + ~ + + + o o o o o + | 5 o 4.7.0     | gentoo
>> -------------+-----------------------------+---------------+-------
>>  [I]4.7.7-r1 | + + ~ ~ ~ ~ ~ + o o o o o ~ | 5 o 4.7.7-r1  | gentoo
>> -------------+-----------------------------+---------------+-------
>>  [I]4.7.8    | + + ~ ~ ~ ~ ~ + o o o o o ~ | 5 o 4.7.8     | gentoo