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

2018-03-26 Thread 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 the...@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



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

2018-03-26 Thread Elijah Mark Anderson
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 the...@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

signature.asc
Description: This is a digitally signed message part.


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

2018-03-26 Thread thelma
On 03/26/2018 10:41 AM, nils.freyd...@posteo.de wrote:
> Hello thelma,
> 
> 
> Am Montag, 26. März 2018, 18:27:31 CEST schrieb the...@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)

2018-03-26 Thread 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)

2018-03-26 Thread Neil Bothwick
On Mon, 26 Mar 2018 19:34:38 +0200, nils.freyd...@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.


pgp2pBdtNOaAe.pgp
Description: OpenPGP digital signature


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

2018-03-26 Thread thelma
On 03/26/2018 11:34 AM, nils.freyd...@posteo.de wrote:
> Am Montag, 26. März 2018, 18:53:51 CEST schrieb the...@sys-concept.com:
>> On 03/26/2018 10:41 AM, nils.freyd...@posteo.de wrote:
>>> Hello thelma,
>>>
>>> Am Montag, 26. März 2018, 18:27:31 CEST schrieb the...@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> /*
>> * 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)

2018-03-26 Thread nils . freydank
Am Montag, 26. März 2018, 18:53:51 CEST schrieb the...@sys-concept.com:
> On 03/26/2018 10:41 AM, nils.freyd...@posteo.de wrote:
> > Hello thelma,
> > 
> > Am Montag, 26. März 2018, 18:27:31 CEST schrieb the...@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 /*
> * 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

signature.asc
Description: This is a digitally signed message part.


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

2018-03-26 Thread thelma
On 03/26/2018 10:41 AM, nils.freyd...@posteo.de wrote:
> Hello thelma,
> 
> 
> Am Montag, 26. März 2018, 18:27:31 CEST schrieb the...@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




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

2018-03-26 Thread nils . freydank
Hello thelma,


Am Montag, 26. März 2018, 18:27:31 CEST schrieb the...@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

signature.asc
Description: This is a digitally signed message part.


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

2018-03-26 Thread 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