Hello,
when I try to install mediawiki, I get the following error:
* PHP 5.2.10-2ubuntu6.4 installed * Found database drivers for: MySQL SQLite * PHP server API is cgi-fcgi; using ugly URLs (index.php?title=Page_Title) * Have XML / Latin1-UTF-8 conversion support. * Session save path (/var/lib/php5) appears to be valid. * PHP's memory_limit is 64M. * Couldn't find Turck MMCache, eAccelerator, APC or XCache; cannot use these for object caching. * Found GNU diff3: /usr/bin/diff3. * Found ImageMagick: /usr/bin/convert; image thumbnailing will be enabled if you enable uploads. * Found GD graphics library built-in. * Installation directory: /var/www/web468/html/phys-med.de * Script URI path: * Installing MediaWiki with php file extensions * Environment checked. You can install MediaWiki. * Generating configuration file... * Database type: MySQL * Loading class: DatabaseMysql * Attempting to connect to database server as web468...success. * Connected to mysql 5.1.37-1ubuntu5.1; enabling MySQL 4.1/5.0 charset mode * Database usr_web468_3 exists * Creating tables...Query "CREATE UNIQUE INDEX user_name ON `user` (user_name) " failed with error code "INDEX command denied to user 'web468'@'localhost' for table 'user' (localhost)".
It's a hosted site, I have PhpMyAdmin if that helps. What can I do?
Thanks, Daniel -- MediaWiki 1.15.4 | PHP 5.2.10-2ubuntu6.4 | mysql 5.1.37-1ubuntu5.1
Let me read the error message for you: user web468 doesn't have INDEX permission.
Domas
On Jun 20, 2010, at 1:42 PM, Daniel Walz wrote:
Hello,
when I try to install mediawiki, I get the following error:
* PHP 5.2.10-2ubuntu6.4 installed * Found database drivers for: MySQL SQLite * PHP server API is cgi-fcgi; using ugly URLs(index.php?title=Page_Title) * Have XML / Latin1-UTF-8 conversion support. * Session save path (/var/lib/php5) appears to be valid. * PHP's memory_limit is 64M. * Couldn't find Turck MMCache, eAccelerator, APC or XCache; cannot use these for object caching. * Found GNU diff3: /usr/bin/diff3. * Found ImageMagick: /usr/bin/convert; image thumbnailing will be enabled if you enable uploads. * Found GD graphics library built-in. * Installation directory: /var/www/web468/html/phys-med.de * Script URI path: * Installing MediaWiki with php file extensions * Environment checked. You can install MediaWiki. * Generating configuration file... * Database type: MySQL * Loading class: DatabaseMysql * Attempting to connect to database server as web468...success. * Connected to mysql 5.1.37-1ubuntu5.1; enabling MySQL 4.1/5.0 charset mode * Database usr_web468_3 exists * Creating tables...Query "CREATE UNIQUE INDEX user_name ON `user` (user_name) " failed with error code "INDEX command denied to user 'web468'@'localhost' for table 'user' (localhost)".
It's a hosted site, I have PhpMyAdmin if that helps. What can I do?
Thanks, Daniel -- MediaWiki 1.15.4 | PHP 5.2.10-2ubuntu6.4 | mysql 5.1.37-1ubuntu5.1
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Thanks, I got THAT. I have some more MySQL databases on that server and until now, I had no problem to create indexes on my tables. So I don't understand why that's a problem in this script.
Daniel
Domas Mituzas schrieb am 20.06.2010 12:50:
Let me read the error message for you: user web468 doesn't have INDEX permission.
Domas
On Jun 20, 2010, at 1:42 PM, Daniel Walz wrote:
Hello,
when I try to install mediawiki, I get the following error:
* PHP 5.2.10-2ubuntu6.4 installed * Found database drivers for: MySQL SQLite * PHP server API is cgi-fcgi; using ugly URLs(index.php?title=Page_Title) * Have XML / Latin1-UTF-8 conversion support. * Session save path (/var/lib/php5) appears to be valid. * PHP's memory_limit is 64M. * Couldn't find Turck MMCache, eAccelerator, APC or XCache; cannot use these for object caching. * Found GNU diff3: /usr/bin/diff3. * Found ImageMagick: /usr/bin/convert; image thumbnailing will be enabled if you enable uploads. * Found GD graphics library built-in. * Installation directory: /var/www/web468/html/phys-med.de * Script URI path: * Installing MediaWiki with php file extensions * Environment checked. You can install MediaWiki. * Generating configuration file... * Database type: MySQL * Loading class: DatabaseMysql * Attempting to connect to database server as web468...success. * Connected to mysql 5.1.37-1ubuntu5.1; enabling MySQL 4.1/5.0 charset mode * Database usr_web468_3 exists * Creating tables...Query "CREATE UNIQUE INDEX user_name ON `user` (user_name) " failed with error code "INDEX command denied to user 'web468'@'localhost' for table 'user' (localhost)".
It's a hosted site, I have PhpMyAdmin if that helps. What can I do?
Thanks, Daniel -- MediaWiki 1.15.4 | PHP 5.2.10-2ubuntu6.4 | mysql 5.1.37-1ubuntu5.1
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Maybe you have a limitation on the number of databases?
At 12:12 AM 6/21/2010, you wrote:
Thanks, I got THAT. I have some more MySQL databases on that server and until now, I had no problem to create indexes on my tables. So I don't understand why that's a problem in this script.
Daniel
Domas Mituzas schrieb am 20.06.2010 12:50:
Let me read the error message for you: user web468 doesn't have INDEX permission.
Domas
On Jun 20, 2010, at 1:42 PM, Daniel Walz wrote:
Hello,
when I try to install mediawiki, I get the following error:
* PHP 5.2.10-2ubuntu6.4 installed * Found database drivers for: MySQL SQLite * PHP server API is cgi-fcgi; using ugly URLs(index.php?title=Page_Title) * Have XML / Latin1-UTF-8 conversion support. * Session save path (/var/lib/php5) appears to be valid. * PHP's memory_limit is 64M. * Couldn't find Turck MMCache, eAccelerator, APC or XCache; cannot use these for object caching. * Found GNU diff3: /usr/bin/diff3. * Found ImageMagick: /usr/bin/convert; image thumbnailing will be enabled if you enable uploads. * Found GD graphics library built-in. * Installation directory: /var/www/web468/html/phys-med.de * Script URI path: * Installing MediaWiki with php file extensions * Environment checked. You can install MediaWiki. * Generating configuration file... * Database type: MySQL * Loading class: DatabaseMysql * Attempting to connect to database server as web468...success. * Connected to mysql 5.1.37-1ubuntu5.1; enabling MySQL 4.1/5.0 charset mode * Database usr_web468_3 exists * Creating tables...Query "CREATE UNIQUE INDEX user_name ON `user` (user_name) " failed with error code "INDEX command denied to user 'web468'@'localhost' for table 'user' (localhost)".
It's a hosted site, I have PhpMyAdmin if that helps. What can I do?
Thanks, Daniel -- MediaWiki 1.15.4 | PHP 5.2.10-2ubuntu6.4 | mysql 5.1.37-1ubuntu5.1
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.829 / Virus Database: 271.1.1/2951 - Release Date: 06/20/10 15:37:00
_ _ (o) (o) oOOO----(_)----OOOo--- Henny (Lee Hae Kang) ----------------------------- http://www.henny-savenije.pe.kr Portal to all my sites http://www.hendrick-hamel.henny-savenije.pe.kr (in English) Feel free to discover Korea with Hendrick Hamel (1653-1666) http://www.hendrick-hamel.henny-savenije.pe.kr/indexk2.htm In Korean http://www.hendrick-hamel.henny-savenije.pe.kr/Dutch In Dutch http://www.vos.henny-savenije.pe.kr Frits Vos Article about Witsen and Eibokken and his first Korean-Dutch dictionary http://www.cartography.henny-savenije.pe.kr (in English) Korea through Western Cartographic eyes http://www.hwasong.henny-savenije.pe.kr Hwasong the fortress in Suwon http://www.oldKorea.henny-savenije.pe.kr Old Korea in pictures http://www.british.henny-savenije.pe.kr A British encounter in Pusan (1797) http://www.genealogy.henny-savenije.pe.kr/ Genealogy http://www.henny-savenije.pe.kr/phorum Bulletin board for Korean studies
On Jun 20, 2010, at 6:12 PM, Daniel Walz wrote:
Thanks, I got THAT. I have some more MySQL databases on that server and until now, I had no problem to create indexes on my tables. So I don't understand why that's a problem in this script.
It is not a problem in this script. It is a problem in this user's permissions.
'SHOW GRANTS' for multiple users and compare. OTOH, maybe you never created indexes before, hehehehe.
Domas
Domas Mituzas schrieb am 21.06.2010 11:17:
On Jun 20, 2010, at 6:12 PM, Daniel Walz wrote:
Thanks, I got THAT. I have some more MySQL databases on that server and until now, I had no problem to create indexes on my tables. So I don't understand why that's a problem in this script.
It is not a problem in this script. It is a problem in this user's permissions.
It seems so. My hoster worte me an email that he gave me the permission now (I didn't know that it needs extra permissions to create an index for an database - strange), but it still doesn't work.
'SHOW GRANTS' for multiple users and compare.
Thanks, that helped a lot:
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON `usr_web468_3`.* TO 'web468'@'localhost' WITH GRANT OPTION
In fact, he gave me the right for all my databases except that one I used for mediawiki. I hope he fixes it tomorrow.
OTOH, maybe you never created indexes before, hehehehe.
Could have been, but - yes, I did ;-)
Daniel
mediawiki-l@lists.wikimedia.org