I am upgrading to version 1.42.1 and am getting the following error:
...cargo_tables_template_id key doesn't exist. Running D:...\extensions\OATHAuth/maintenance/updateTOTPScratchTokensToArray.php...
An error occurred: Error 1044: Access denied for user 'db_username'@'%' to database 'virtual' Function: Wikimedia\Rdbms\DatabaseMySQL::doSelectDomain Query: USE `virtual`
Notes:
$wgDBuser = is _not_ in the form of an email address (xxxxx@yyyyyy.zzz)
db_username (above is a replacement for the actual db username).
Any ideas on how to overcome this?
-Brian
Hi Brian,
Have you already executed the update.php script?
php maintenance/run.php update.php
https://mediawiki.org/wiki/Manual:Upgrading
Cheers
Il 6 luglio 2024 15:47:56 CEST, Bri dev@rlyehable.com ha scritto:
I am upgrading to version 1.42.1 and am getting the following error:
...cargo_tables_template_id key doesn't exist. Running D:...\extensions\OATHAuth/maintenance/updateTOTPScratchTokensToArray.php...
An error occurred: Error 1044: Access denied for user 'db_username'@'%' to database 'virtual' Function: Wikimedia\Rdbms\DatabaseMySQL::doSelectDomain Query: USE `virtual`
...
Any ideas on how to overcome this?
-Brian
MediaWiki-l mailing list -- mediawiki-l@lists.wikimedia.org To unsubscribe send an email to mediawiki-l-leave@lists.wikimedia.org https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/
I do not have access to command-line php commands. I was updating through https://wiki/mw-config
On 2024-07-06 10:05, Valerio Bozzolan via MediaWiki-l wrote:
Hi Brian,
Have you already executed the update.php script?
php maintenance/run.php update.php
https://mediawiki.org/wiki/Manual:Upgrading
Cheers
Il 6 luglio 2024 15:47:56 CEST, Bri dev@rlyehable.com ha scritto:
I am upgrading to version 1.42.1 and am getting the following error:
...cargo_tables_template_id key doesn't exist. Running D:...\extensions\OATHAuth/maintenance/updateTOTPScratchTokensToArray.php...
An error occurred: Error 1044: Access denied for user 'db_username'@'%' to database 'virtual' Function: Wikimedia\Rdbms\DatabaseMySQL::doSelectDomain Query: USE `virtual`
...
Any ideas on how to overcome this?
-Brian
MediaWiki-l mailing list -- mediawiki-l@lists.wikimedia.org To unsubscribe send an email to mediawiki-l-leave@lists.wikimedia.org https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/
Hi Brian,
It seems your wiki is using Cargo and your error seems like "MediaWiki can connect to the database tables of Cargo, but their table structure is unexpected"
This kind of errors usually means that your wiki was not updated successfully; or, your version of Cargo is not compatible with MediaWiki.
Double-check, try another update, share errors if any.
Waiting for Cargo experts in the meanwhile.
Cheers
-Valerio bozz
Il giorno Sat, 06/07/2024 alle 11.38 -0400, Bri ha scritto:
I do not have access to command-line php commands. I was updating through https://wiki/mw-config
On 2024-07-06 10:05, Valerio Bozzolan via MediaWiki-l wrote:
Hi Brian,
Have you already executed the update.php script?
php maintenance/run.php update.php
https://mediawiki.org/wiki/Manual:Upgrading
Cheers
Il 6 luglio 2024 15:47:56 CEST, Bri dev@rlyehable.com ha scritto:
I am upgrading to version 1.42.1 and am getting the following error:
...cargo_tables_template_id key doesn't exist. Running D:...\extensions\OATHAuth/maintenance/updateTOTPScratchTokensToA rray.php...
An error occurred: Error 1044: Access denied for user 'db_username'@'%' to database 'virtual' Function: Wikimedia\Rdbms\DatabaseMySQL::doSelectDomain Query: USE `virtual`
...
Any ideas on how to overcome this?
-Brian
MediaWiki-l mailing list -- mediawiki-l@lists.wikimedia.org To unsubscribe send an email to mediawiki-l-leave@lists.wikimedia.org https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/
MediaWiki-l mailing list -- mediawiki-l@lists.wikimedia.org To unsubscribe send an email to mediawiki-l-leave@lists.wikimedia.org https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/
I think you are misinterpreting the error message. I dont think this is cargo related. It looks like the virtual domain configuration for OATHAuth is wrong (its literally giving a use virtual statement which should not happen), but i dont know what circumstances would cause that.
-- Brian
On Saturday 6 July 2024, Valerio Bozzolan via MediaWiki-l < mediawiki-l@lists.wikimedia.org> wrote:
Hi Brian,
It seems your wiki is using Cargo and your error seems like "MediaWiki can connect to the database tables of Cargo, but their table structure is unexpected"
This kind of errors usually means that your wiki was not updated successfully; or, your version of Cargo is not compatible with MediaWiki.
Double-check, try another update, share errors if any.
Waiting for Cargo experts in the meanwhile.
Cheers
-Valerio bozz
Il giorno Sat, 06/07/2024 alle 11.38 -0400, Bri ha scritto:
I do not have access to command-line php commands. I was updating through https://wiki/mw-config
On 2024-07-06 10:05, Valerio Bozzolan via MediaWiki-l wrote:
Hi Brian,
Have you already executed the update.php script?
php maintenance/run.php update.php
https://mediawiki.org/wiki/Manual:Upgrading
Cheers
Il 6 luglio 2024 15:47:56 CEST, Bri dev@rlyehable.com ha scritto:
I am upgrading to version 1.42.1 and am getting the following error:
...cargo_tables_template_id key doesn't exist. Running D:...\extensions\OATHAuth/maintenance/updateTOTPScratchTokensToA rray.php...
An error occurred: Error 1044: Access denied for user 'db_username'@'%' to database 'virtual' Function: Wikimedia\Rdbms\DatabaseMySQL::doSelectDomain Query: USE `virtual`
...
Any ideas on how to overcome this?
-Brian
MediaWiki-l mailing list -- mediawiki-l@lists.wikimedia.org To unsubscribe send an email to mediawiki-l-leave@lists.wikimedia.org https://lists.wikimedia.org/postorius/lists/mediawiki-l.
lists.wikimedia.org/
MediaWiki-l mailing list -- mediawiki-l@lists.wikimedia.org To unsubscribe send an email to mediawiki-l-leave@lists.wikimedia.org https://lists.wikimedia.org/postorius/lists/mediawiki-l.
lists.wikimedia.org/
MediaWiki-l mailing list -- mediawiki-l@lists.wikimedia.org To unsubscribe send an email to mediawiki-l-leave@lists.wikimedia.org https://lists.wikimedia.org/postorius/lists/mediawiki-l. lists.wikimedia.org/
Thank you. This is what it appeared to me as well (issue with OATHAuth), but as Mr. Wolff stated, I also don't know why it is trying to use 'virtual'.
The only other thing that I can think of is that it is part of a small (2 wiki) wiki farm.
LocalSettings.php has the following code:
switch ( $_SERVER['SERVER_NAME'] ) { case '1.rlyehable.com': $wgDBprefix = "rly1_"; require_once 'LocalSettings_1.php'; break;
case '2.rlyehable.com': $wgDBprefix = "rly2_"; require_once 'LocalSettings_2.php'; break;
default: header( 'HTTP/1.1 404 Not Found' ); echo "This wiki ("" . htmlspecialchars( $callingurl ) . "") is not available. Check configuration."; exit( 0 ); }
-Brian B
On 2024-07-06 13:16, Brian Wolff wrote:
I think you are misinterpreting the error message. I dont think this is cargo related. It looks like the virtual domain configuration for OATHAuth is wrong (its literally giving a use virtual statement which should not happen), but i dont know what circumstances would cause that.
-- Brian
On Saturday 6 July 2024, Valerio Bozzolan via MediaWiki-l mediawiki-l@lists.wikimedia.org wrote:
Hi Brian, It seems your wiki is using Cargo and your error seems like "MediaWiki can connect to the database tables of Cargo, but their table structure is unexpected" This kind of errors usually means that your wiki was not updated successfully; or, your version of Cargo is not compatible with MediaWiki. Double-check, try another update, share errors if any. Waiting for Cargo experts in the meanwhile. Cheers -Valerio bozz Il giorno Sat, 06/07/2024 alle 11.38 -0400, Bri ha scritto: > I do not have access to command-line php commands. I was updating > through https://wiki/mw-config > > On 2024-07-06 10:05, Valerio Bozzolan via MediaWiki-l wrote: > > Hi Brian, > > > > Have you already executed the update.php script? > > > > php maintenance/run.php update.php > > > > <https://mediawiki.org/wiki/Manual:Upgrading <https://mediawiki.org/wiki/Manual:Upgrading>> > > > > Cheers > > > > Il 6 luglio 2024 15:47:56 CEST, Bri <dev@rlyehable.com> ha scritto: > > > I am upgrading to version 1.42.1 and am getting the following > > > error: > > > > > > ...cargo_tables_template_id key doesn't exist. > > > Running > > > D:\...\extensions\OATHAuth/maintenance/updateTOTPScratchTokensToA > > > rray.php... > > > > > > An error occurred: > > > Error 1044: Access denied for user 'db_username'@'%' to database > > > 'virtual' > > > Function: Wikimedia\Rdbms\DatabaseMySQL::doSelectDomain > > > Query: USE `virtual` > > > > > > ... > > > > > > Any ideas on how to overcome this? > > > > > > -Brian > > > > > > > > > > > > > > > _______________________________________________ > > > MediaWiki-l mailing list -- mediawiki-l@lists.wikimedia.org <mailto:mediawiki-l@lists.wikimedia.org> > > > To unsubscribe send an email to > > > mediawiki-l-leave@lists.wikimedia.org <mailto:mediawiki-l-leave@lists.wikimedia.org> > > > https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/ <https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/> > > > _______________________________________________ > MediaWiki-l mailing list -- mediawiki-l@lists.wikimedia.org <mailto:mediawiki-l@lists.wikimedia.org> > To unsubscribe send an email to mediawiki-l-leave@lists.wikimedia.org <mailto:mediawiki-l-leave@lists.wikimedia.org> > https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/ <https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/> _______________________________________________ MediaWiki-l mailing list -- mediawiki-l@lists.wikimedia.org <mailto:mediawiki-l@lists.wikimedia.org> To unsubscribe send an email to mediawiki-l-leave@lists.wikimedia.org <mailto:mediawiki-l-leave@lists.wikimedia.org> https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/ <https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/>
MediaWiki-l mailing list --mediawiki-l@lists.wikimedia.org To unsubscribe send an email tomediawiki-l-leave@lists.wikimedia.org https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/
The only way I could see this happening is if your version of MediaWiki was 1.40 or lower and you were using a newer version of the OATHAuth extension.
I assume you do not have anything set for $wgVirtualDomainsMapping or $wgOATHAuthDatabase and are just keeping them at the default?
-- brian
On Sat, Jul 6, 2024 at 10:56 AM Bri dev@rlyehable.com wrote:
Thank you. This is what it appeared to me as well (issue with OATHAuth), but as Mr. Wolff stated, I also don't know why it is trying to use 'virtual'.
The only other thing that I can think of is that it is part of a small (2 wiki) wiki farm.
LocalSettings.php has the following code:
switch ( $_SERVER['SERVER_NAME'] ) { case '1.rlyehable.com': $wgDBprefix = "rly1_"; require_once 'LocalSettings_1.php'; break; case '2.rlyehable.com': $wgDBprefix = "rly2_"; require_once 'LocalSettings_2.php'; break; default: header( 'HTTP/1.1 404 Not Found' ); echo "This wiki (\"" . htmlspecialchars($callingurl ) . "") is not available. Check configuration."; exit( 0 ); }
-Brian B On 2024-07-06 13:16, Brian Wolff wrote:
I think you are misinterpreting the error message. I dont think this is cargo related. It looks like the virtual domain configuration for OATHAuth is wrong (its literally giving a use virtual statement which should not happen), but i dont know what circumstances would cause that.
-- Brian
On Saturday 6 July 2024, Valerio Bozzolan via MediaWiki-l < mediawiki-l@lists.wikimedia.org> wrote:
Hi Brian,
It seems your wiki is using Cargo and your error seems like "MediaWiki can connect to the database tables of Cargo, but their table structure is unexpected"
This kind of errors usually means that your wiki was not updated successfully; or, your version of Cargo is not compatible with MediaWiki.
Double-check, try another update, share errors if any.
Waiting for Cargo experts in the meanwhile.
Cheers
-Valerio bozz
Il giorno Sat, 06/07/2024 alle 11.38 -0400, Bri ha scritto:
I do not have access to command-line php commands. I was updating through https://wiki/mw-config
On 2024-07-06 10:05, Valerio Bozzolan via MediaWiki-l wrote:
Hi Brian,
Have you already executed the update.php script?
php maintenance/run.php update.php
https://mediawiki.org/wiki/Manual:Upgrading
Cheers
Il 6 luglio 2024 15:47:56 CEST, Bri dev@rlyehable.com ha scritto:
I am upgrading to version 1.42.1 and am getting the following error:
...cargo_tables_template_id key doesn't exist. Running D:...\extensions\OATHAuth/maintenance/updateTOTPScratchTokensToA rray.php...
An error occurred: Error 1044: Access denied for user 'db_username'@'%' to database 'virtual' Function: Wikimedia\Rdbms\DatabaseMySQL::doSelectDomain Query: USE `virtual`
...
Any ideas on how to overcome this?
-Brian
MediaWiki-l mailing list -- mediawiki-l@lists.wikimedia.org To unsubscribe send an email to mediawiki-l-leave@lists.wikimedia.org
https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/
MediaWiki-l mailing list -- mediawiki-l@lists.wikimedia.org To unsubscribe send an email to mediawiki-l-leave@lists.wikimedia.org
https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/
MediaWiki-l mailing list -- mediawiki-l@lists.wikimedia.org To unsubscribe send an email to mediawiki-l-leave@lists.wikimedia.org
https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/
MediaWiki-l mailing list -- mediawiki-l@lists.wikimedia.org To unsubscribe send an email to mediawiki-l-leave@lists.wikimedia.orghttps://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/
MediaWiki-l mailing list -- mediawiki-l@lists.wikimedia.org To unsubscribe send an email to mediawiki-l-leave@lists.wikimedia.org
https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/
mediawiki-l@lists.wikimedia.org