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 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)

[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)

[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)

[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)

[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)

[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)

[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)

[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)

[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.

Re: [gentoo-user] phpmyadmin - upgrading

[J. Roeleveld]

On Saturday, September 27, 2014 11:03:48 AM Joseph wrote:
> After upgrade of phpmyadmin, I think it was installed correctly:
> 
> This is an upgrade
> phpmyadmin-4.1.7 is already installed - upgrading
> Running /usr/sbin/webapp-config -U -h localhost -u root -d /phpmyadmin
> phpmyadmin 4.1.14.3 INFO: postinst
> Running /usr/sbin/webapp-cleaner -p -C /phpmyadmin
> 
> But after re-login I get a message:
> 
> $cfg['Servers'][$i]['users'] ...  not OK [ Documentation ]
> $cfg['Servers'][$i]['usergroups'] ... not OK [ Documentation ]
> Configurable menus: Disabled
> 
> I've appended the missing section in config.inc.php
> /* configuration storage */
> ...
> $cfg['Servers'][$i]['users'] = 'pma__users';
> $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
> ?>
> 
> Am I missing any tables?

Maybe.
If you expect help, please be more verbose with the supplied information.

A good place to start:
1) What did you actually do
2) What are you trying to achieve
3) What messages did you get
4) What have you done to try and solve the issue

--
Joost

Re: [gentoo-user] phpmyadmin opening "index.php" with text editor

[Joseph]

On 02/09/08 21:41, Dan Farrell wrote:

Do I need to re-compile phpmyadmin with "vhost"? and setup phpmyadmin
as virtualdomain?


I recommend that you do, to avoid htdocs 'bloat'. 


however that's unlikely to solve your problem.  It sounds like,
perhaps, apache is missing PHP support and therefore doesn't know
what to do with the file.  


I'd look to /etc/conf.d/apache2 if I were you, and see if you need to
add -DPHP5 to APACHE2_OPTS.  My APACHE2_OPTS looks like this:

|  APACHE2_OPTS="-D DEFAULT_VHOST -D INFO -D LANGUAGE -D SUEXEC -DPHP5 \
|   -DUSERDIR"



No, I have php compile into the Apache and support is enabled:
APACHE2_OPTS="-D DEFAULT_VHOST -D INFO -D LANGUAGE -D SSL -D SSL_DEFAULT_VHOST -D 
SUEXEC -D PHP5"

Besides, I have virtual-domain on the same server and php is working without 
any problems.
only when I try to run file "index" from:
/localhost/phpmyadmin/index.php 


the strange part is that if I try to run any *.php script from dir "scripts" 
they are loading just fine, eg:
/localhost/phpmyadmin/scripts/setup.php

That latest upgrade screw someting up, I update these programs:
package x11-base/xorg-server-1.3.0.0-r5
package dev-lang/php-5.2.5_p20080206
package sys-apps/slocate-3.1-r1
package dev-libs/glib-2.14.6
ackage sys-process/psmisc-22.6
package dev-python/pycairo-1.4.0
package dev-python/pycairo-1.4.12
package sys-apps/man-1.6f
package sys-apps/file-4.21-r1
package sys-apps/file-4.23
package sys-libs/cracklib-2.8.12
package dev-libs/libxml2-2.6.30-r1
package sys-libs/readline-5.2_p12-r1
package sys-apps/less-418
package sys-apps/pciutils-2.2.9
package dev-libs/libpcre-7.6
ackage media-libs/tiff-3.8.2-r3
package sys-libs/timezone-data-2007k

Both my backup server and my main server acting the same way, /localhost/phpmyadmin/index.php tries to open with a 
text editor.

My third backup server, which i did not updated yet, is loading 
"phpmyadmin/index.php" and database just fine.

--
#Joseph
GPG KeyID: ED0E1FB7
--
gentoo-user@lists.gentoo.org mailing list

Re: [gentoo-user] phpmyadmin opening "index.php" with text editor

[Dan Farrell]

On Sat, 09 Feb 2008 19:47:48 -0700
Joseph <[EMAIL PROTECTED]> wrote:

> Do I need to re-compile phpmyadmin with "vhost"? and setup phpmyadmin
> as virtualdomain?

I recommend that you do, to avoid htdocs 'bloat'. 

however that's unlikely to solve your problem.  It sounds like,
perhaps, apache is missing PHP support and therefore doesn't know
what to do with the file.  

I'd look to /etc/conf.d/apache2 if I were you, and see if you need to
add -DPHP5 to APACHE2_OPTS.  My APACHE2_OPTS looks like this:

|  APACHE2_OPTS="-D DEFAULT_VHOST -D INFO -D LANGUAGE -D SUEXEC -DPHP5 \
|   -DUSERDIR"

-- 
gentoo-user@lists.gentoo.org mailing list

Re: [gentoo-user] phpMyAdmin

[Hans-Werner Hilse]

Hi,

On Wed, 15 Aug 2007 17:15:17 + (UTC)
Thufir <[EMAIL PROTECTED]> wrote:

> I thought I'd seen a phpmyadmin configuration gui at gentoo.org, but 
> can't seem to locate it again.   gives a 
> list of files.

If those files you see actually are the phpMyAdmin files: Web server
not properly configured to search for an "index.php"? Or no PHP at all?

-hwh
-- 
[EMAIL PROTECTED] mailing list

Re: [gentoo-user] phpmyadmin user/password? [solved]

[David Obwaller]

On Thu, Dec 15, 2005 at 05:00:02PM -0800, Daevid Vincent wrote:
> Hmm. Well I thought I had done this, but issuing this command again seemed
> to have fixed it:
> 
> mysql -u root -p <
> /usr/share/webapps/phpmyadmin/2.7.0_p1/sqlscripts/mysql/2.7.0_p1_create.sql 
> 
> The problem now is that all the images are broken and no CSS is being
> applied if I try to connect from a remote IP.
> 
> I fixed that by setting config.default.php to:
> 
> #$cfg['PmaAbsoluteUri'] = 'http://localhost//phpmyadmin';
> $cfg['PmaAbsoluteUri'] = '';
> 
> Not quite sure why that is set by default when it works better without it...

I believe the correct setting would be something like

$cfg['PmaAbsoluteUri'] = 'http://YOUR_IP_OR_HOSTNAME/phpmyadmin';

David
-- 
gentoo-user@gentoo.org mailing list

RE: [gentoo-user] phpmyadmin user/password? [solved]

[Daevid Vincent]

Hmm. Well I thought I had done this, but issuing this command again seemed
to have fixed it:

mysql -u root -p <
/usr/share/webapps/phpmyadmin/2.7.0_p1/sqlscripts/mysql/2.7.0_p1_create.sql 

The problem now is that all the images are broken and no CSS is being
applied if I try to connect from a remote IP.

I fixed that by setting config.default.php to:

#$cfg['PmaAbsoluteUri'] = 'http://localhost//phpmyadmin';
$cfg['PmaAbsoluteUri'] = '';

Not quite sure why that is set by default when it works better without it...


"You had me at EHLO" --E.Webb (10.04.05)  

> -Original Message-
> From: Qv6 [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, December 15, 2005 4:18 PM
> To: gentoo-user@lists.gentoo.org
> Subject: Re: [gentoo-user] phpmyadmin user/password?
> 
> On Thursday 15 December 2005 05:24 pm, Daevid Vincent wrote:
> > I emerged phpmyadmin 2.7 and when I go to the URL, it prompts for a
> > user/password. What exactly is this user/pw it's looking 
> for? The one
> > stored in mysql.users? My actual account? Both in this case have no
> > password set.
>  
> It's asking for the Mysql username/password root user. Recall that 
> phpmyadmin is used to administer/administrate Mysql
> -- 
> gentoo-user@gentoo.org mailing list
> 
> 

-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] phpmyadmin user/password?

[Qv6]

On Thursday 15 December 2005 05:24 pm, Daevid Vincent wrote:
> I emerged phpmyadmin 2.7 and when I go to the URL, it prompts for a
> user/password. What exactly is this user/pw it's looking for? The one
> stored in mysql.users? My actual account? Both in this case have no
> password set.
 
It's asking for the Mysql username/password root user. Recall that 
phpmyadmin is used to administer/administrate Mysql
-- 
gentoo-user@gentoo.org mailing list