Isaac Bennetch | 20 Oct 04:13 2014
Picon

CSV import: "Columns escaped with" is required?

Hello,

As brought up in [1], it seems "Columns escaped with" is a required
field during CSV import. Is this by design? I think we should allow the
user to leave this field blank if they desire. Any thoughts?

1 -
https://stackoverflow.com/questions/26441151/mysql-importing-csv-file-with-phpmyadmin-without-cell-quotes/26457608#26457608

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
Marc Delisle | 19 Oct 14:04 2014

testing master on a server with many databases

Hi,

With current master (8785ea0) I made some tests on a MySQL 5.5.37 server
containing about 81000 databases and about 81000 users.

In the mysql.db tables there are about 81000 grant entries; each one
grants some wildcard access to databases starting with a certain pattern.

I tested with root, since the reports we got about the server being slow
seem to be occurring for root.

Good news
---------

First, the login. It takes about 7 seconds before seeing the initial
page after login.

In the navi panel, there is a db page selector with 107 page numbers.
Going to any page takes about 7 seconds. Opening a db takes about 4
second (each db seems to contain about 31 tables).

Browsing tables, grid editing, searching inside a table behave normally.

Using Server > Databases works correctly, including switching pages.

Problems
--------

Going to a MyISAM table, Structure, and trying to change a column's
structure takes 30 seconds before seeing the dialog for this column.
(Continue reading)

Jenkins Daemon | 18 Oct 17:16 2014
Picon

Build failed in Jenkins: phpMyAdmin-continuous #7835

See <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/7835/changes>

Changes:

[Madhura Jayaratne] Wrap a long line

[Madhura Jayaratne] Align

[Madhura Jayaratne] Include by default

------------------------------------------
Started by GitHub push by madhuracj
[EnvInject] - Loading node environment variables.
Building in workspace <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/>
 > git rev-parse --is-inside-work-tree # timeout=10
Fetching changes from the remote Git repository
 > git config remote.origin.url git://github.com/phpmyadmin/phpmyadmin.git # timeout=10
Fetching upstream changes from git://github.com/phpmyadmin/phpmyadmin.git
 > git --version # timeout=10
 > git fetch --tags --progress git://github.com/phpmyadmin/phpmyadmin.git +refs/heads/*:refs/remotes/origin/*
 > git rev-parse origin/master^{commit} # timeout=10
Checking out Revision c4f67f05c8c32105255d42cd87048fb268412a37 (origin/master)
 > git config core.sparsecheckout # timeout=10
 > git checkout -f c4f67f05c8c32105255d42cd87048fb268412a37
 > git rev-list d898d66229ba70752e9b8c9093c37d72e8f7fb05 # timeout=10
 > git tag -a -f -m Jenkins Build #7835 jenkins-phpMyAdmin-continuous-7835 # timeout=10
[EnvInject] - Executing scripts and injecting environment variables after the SCM step.
[EnvInject] - Injecting as environment variables the properties content 
TESTSUITE_SERVER=localhost
TESTSUITE_USER=pmatest
(Continue reading)

Jenkins Daemon | 18 Oct 04:00 2014
Picon

Build failed in Jenkins: phpMyAdmin #1218

See <https://ci.phpmyadmin.net/job/phpMyAdmin/1218/changes>

Changes:

[Madhura Jayaratne] bug #4552 Incorrect routines display for database due to case insensitive checks

[weblate] Translated using Weblate (Bulgarian)

[weblate] Translated using Weblate (Catalan)

[weblate] Translated using Weblate (German)

[weblate] Translated using Weblate (Turkish)

[Madhura Jayaratne] Bug #4561 PHP error in transformations

[Madhura Jayaratne] Wrap some long lines

[Madhura Jayaratne] Wrap more long lines

[Madhura Jayaratne] bug #4259 reCaptcha sound session expired problem

[weblate] Translated using Weblate (Latvian)

[Madhura Jayaratne] bug #4560 PHP error on master branch

[weblate] Translated using Weblate (Interlingua)

[weblate] Translated using Weblate (Estonian)

(Continue reading)

Marc Delisle | 17 Oct 14:30 2014

test server

Hi J.M.,
could you ensure that config.inc.php on the test server uses the new option:

$cfg['Servers'][$i]['DisableIS'] = true;

--

-- 
Marc Delisle (phpMyAdmin)

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
Jenkins Daemon | 17 Oct 09:49 2014
Picon

Build failed in Jenkins: phpMyAdmin-4.2 #339

See <https://ci.phpmyadmin.net/job/phpMyAdmin-4.2/339/changes>

Changes:

[Madhura Jayaratne] bug #4259 reCaptcha sound session expired problem

------------------------------------------
Started by GitHub push by madhuracj
[EnvInject] - Loading node environment variables.
Building in workspace <https://ci.phpmyadmin.net/job/phpMyAdmin-4.2/ws/>
 > git rev-parse --is-inside-work-tree # timeout=10
Fetching changes from the remote Git repository
 > git config remote.origin.url git://github.com/phpmyadmin/phpmyadmin.git # timeout=10
Fetching upstream changes from git://github.com/phpmyadmin/phpmyadmin.git
 > git --version # timeout=10
 > git fetch --tags --progress git://github.com/phpmyadmin/phpmyadmin.git +refs/heads/*:refs/remotes/origin/*
 > git rev-parse origin/QA_4_2^{commit} # timeout=10
Checking out Revision bdd76f18ce068302927d006b304faab2e6898998 (origin/QA_4_2)
 > git config core.sparsecheckout # timeout=10
 > git checkout -f bdd76f18ce068302927d006b304faab2e6898998
 > git rev-list f3fe7ca52891487c3b5a558e411293d40ed03936 # timeout=10
[workspace] $ /bin/sh -xe /tmp/hudson458685287459768105.sh
+ ./scripts/generate-mo --quiet
[workspace] $ ant clean phpunit pdepend phpmd phpcpd phpcs phploc jshint
Unable to locate tools.jar. Expected to find it in /usr/lib/jvm/java-6-openjdk-amd64/lib/tools.jar
Buildfile: <https://ci.phpmyadmin.net/job/phpMyAdmin-4.2/ws/build.xml>

clean:
   [delete] Deleting directory <https://ci.phpmyadmin.net/job/phpMyAdmin-4.2/ws/build/api>
   [delete] Deleting directory <https://ci.phpmyadmin.net/job/phpMyAdmin-4.2/ws/build/code-browser>
(Continue reading)

Jenkins Daemon | 17 Oct 09:24 2014
Picon

Build failed in Jenkins: phpMyAdmin-continuous #7819

See <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/7819/changes>

Changes:

[Madhura Jayaratne] bug #4552 Incorrect routines display for database due to case insensitive checks

[weblate] Translated using Weblate (Bulgarian)

[weblate] Translated using Weblate (Catalan)

[weblate] Translated using Weblate (German)

[weblate] Translated using Weblate (Turkish)

[Madhura Jayaratne] Bug #4561 PHP error in transformations

------------------------------------------
[...truncated 766 lines...]
     [exec] 
     [exec] 60) PMA_SeleniumExportTest::testServerImport with data set #2 ('JSON', array('[{"id":"1","val":"2"}]'))
     [exec] Selenium testing not configured.
     [exec] 
     [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBase.php>:165
     [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSeleniumExportTest.php>:28
     [exec] 
     [exec] 61) PMA_SeleniumExportTest::testDbExport with data set #0 ('CSV', array('"1","2"'))
     [exec] Selenium testing not configured.
     [exec] 
     [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBase.php>:165
     [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSeleniumExportTest.php>:28
(Continue reading)

Madhura Jayaratne | 14 Oct 10:34 2014
Picon

Logical error in assessing privileges?

Hi all,

Following queries are used to assess whether the logged in user has super, create user and grant privileges respectively. See [1]

SELECT 1 FROM mysql.user LIMIT 1
SELECT 1 FROM INFORMATION_SCHEMA.USER_PRIVILEGES WHERE PRIVILEGE_TYPE = 'CREATE USER' LIMIT 1
SELECT 1 FROM INFORMATION_SCHEMA.USER_PRIVILEGES WHERE IS_GRANTABLE = 'YES' LIMIT 1

However, if I create a user with all global privileges except for 'GRANT', 'SUPER', and 'CREATE USER' privileges all the above queries return 1 since the queries does not check for the grantee column. Rows corresponding to root user make all these queries return 1.

This obviously looks a bug to me. I'm writing to make sure that I'm not missing out on something obvious.



--
Thanks and Regards,

Madhura Jayaratne

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Madhura Jayaratne | 13 Oct 19:16 2014
Picon

Testing request for bug #4259

Hi all,

I need your help in verifying the fix for bug #4259 [1], which went in to the release 4.2.10.
The bug is reported for Firefox 29 on Linux. I performed tests on following setups, but could not recreate the bug using release 4.2.10 or QA_4_2 branch.

Firefox 20 on Ubuntu 
Firefox 29 on Windows 7 (using BrowserStack local testing)

If you are able to reproduce the problem, pls let me know. 

[1] http://sourceforge.net/p/phpmyadmin/bugs/4259

--
Thanks and Regards,

Madhura Jayaratne
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://p.sf.net/sfu/Zoho
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Marc Delisle | 11 Oct 14:35 2014

phpMyAdmin 4.2.10 is released

Welcome to phpMyAdmin 4.2.10, a bugfix release.

Details will appear on http://phpmyadmin.net. You can also visit
https://sourceforge.net/projects/phpmyadmin/files to download.

The phpMyAdmin team

------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://p.sf.net/sfu/Zoho
Madhura Jayaratne | 9 Oct 15:33 2014
Picon

Solution for poor performance due to querying information_schema

Hi Devs,

As a possible solution to slowness faced by database servers with thousands of databases due to the usage of information_schema [1], I have started working on putting back the 'DisableIS' configuration. What I did so far can be found at [2]. I will update on the progress.

[1] https://wiki.phpmyadmin.net/pma/2014-10_Meeting#Meeting_2
[2] https://github.com/madhuracj/phpmyadmin/commits/DisableIS

--
Thanks and Regards,

Madhura Jayaratne

------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel

Gmane