在GAE上的phpMyAdmin - 身份验证 [英] phpMyAdmin on GAE - Authentication

问题描述

我使用提供的教程在GAE上设置了phpmyadmin @ https://gaeforphp-blog.appspot.com/2013/05/26/setting-up-phpmyadmin-on-app-engine/

应用程序的版本（phpmyadmin）可以毫无问题地被访问，但我似乎无法对我的Cloud SQL实例进行身份验证。

cookie和配置类型认证没有成功。不过，我发现，在提交用户名密码后，使用Cookie auth发现页面只是重新加载而没有错误。

如果我使用config auth，页面：
$ b

2002 - 无法找到套接字传输tcp - 您是否忘记在配置PHP时启用它？

服务器没有响应（或本地服务器的套接字配置不正确）。

所有谷歌搜索都指向我使用php的ssl库。有没有人能够让phpmyadmin在GAE上工作？

如果实际的博客条目（@ gaeforphp-blog.appspot.com）支持评论这个问题给作者，不幸的是，情况并非如此。

解决方案

唯一适用于我的是以下配置。 / p>

  $ cfg ['Servers'] [$ i] ['auth_type'] ='cookie'; 
 / *服务器参数* / 
 $ cfg ['Servers'] [$ i] ['socket'] ='/ cloudsql / project-id：db-instance'; 
 $ cfg ['Servers'] [$ i] ['connect_type'] ='socket'; 
 $ cfg ['Servers'] [$ i] ['extension'] ='mysql'; 
 $ cfg ['Servers'] [$ i] ['compress'] = false; 
 $ cfg ['Servers'] [$ i] ['AllowNoPassword'] = true; 
 $ cfg ['Servers'] [$ i] ['AllowRoot'] = true; 
 
 $ cfg ['McryptDisableWarning'] = true; 
 $ cfg ['PmaNoRelation_DisableWarning'] = true; 
 $ cfg ['ExecTimeLimit'] = 60; 
 $ cfg ['CheckConfigurationPermissions'] = false; 
  

所有其他配置都会因各种错误消息而失败。从未找到套接字到gethostbyaddr错误等。祝你好运！

I have setup phpmyadmin on GAE using the tutorial provided @ https://gaeforphp-blog.appspot.com/2013/05/26/setting-up-phpmyadmin-on-app-engine/

The version of the app (phpmyadmin) can be accessed without problems, but I cannot seem to authenticate against my Cloud SQL instance.

I have tried both cookie and config type authentication without success. However I have discovered, with cookie auth, after submitting the username password, the page just reloads without errors.

If I use config auth, I get the following error on the page:

2002 - Unable to find the socket transport "tcp" - did you forget to enable it when you configured PHP?

The server is not responding (or the local server's socket is not correctly configured).

All google searches point me to ssl library in php. Has anyone been able to get phpmyadmin to work on GAE?

Would have preferred if the actual blog entry (@ gaeforphp-blog.appspot.com) would support comments to ask the question to the Author, unfortunately thats not the case.

解决方案

The only thing that worked for me is the following configuration.

$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['socket'] = '/cloudsql/project-id:db-instance';
$cfg['Servers'][$i]['connect_type'] = 'socket';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Servers'][$i]['AllowRoot'] = true;

$cfg['McryptDisableWarning'] = true;
$cfg['PmaNoRelation_DisableWarning'] = true;
$cfg['ExecTimeLimit'] = 60;
$cfg['CheckConfigurationPermissions'] = false;

All other configurations failed with all kinds of error messages. From socket not found to gethostbyaddr errors etc. Good luck!

这篇关于在GAE上的phpMyAdmin - 身份验证的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！