Need help with adding Extension:ConfirmAccount.- Is it possible to use a cron job with Godaddy hosting for the update.php?
Resolved (At least for now.)
I'm working on adding the extension Confirm Account, and I've uploaded the files, and added the line to the local settings folder, but I'm having trouble with a line of code that I'm supposed to enter into the database.
I have MySQL, and I know the prefix that I add.
mysql -h DB_HOST -u WIKIUSER -p WIKIDB < ConfirmAccount.sql
This is the code that I am having trouble with.
What exactly am I supposed to substitute here? This isn't clear at all, and I've had a lot of trouble with a lot of directions here not being explicit, and a huge problem with a lack of explanation of whether or not things need to be substituted.
- Is WIKIDB the name of the database?
- Do I add the prefix in front of ConfirmAccount.sql?
- What do I put for WIKIUSER and where do I find it?
- What do I put for DB_HOST and where do I find it?
- Is there anything else I need to add?
I'm hosting with Go Daddy, for anyone who knows what that setup looks like.
WIKIDB is the name of your database. WIKIUSER is the username you use for mysql. Both these should be able to be found in your LocalSettings.php file. For the DB prefix you have to open the confirmAccount.sql file in a text editor, and replace every occourance of /*_*/ with your db prefix.
Note, this is much easier to do with the update.php script instead of by hand...
Thank you.
How do you "run the script?"
See manual:update.php. Basically, if you have shell access, change into the maintinance sub-directory of your mediawiki install and run php update.php (Update.php is used both for upgrading mediawiki, and for extensions needing schema changes)
I don't think I have shell access, or at least I don't know enough about it if I do.
It looks like that line is the only thing I need to add, so is that the only place where I need to substitute things?
What does DB_HOST change to?
Thanks.
Is it possible to use a cron job for the update? I think I read something about using cron jobs when shell access is not available.
I suppose you could use a cron job to do that (in the way you could use a cron job to essentially run any command). At the very least I do not see any reason for it not to work.
>I don't think I have shell access, or at least I don't know enough about it if I do. >It looks like that line is the only thing I need to add, so is that the only place where I need to substitute things? >What does DB_HOST change to?
In order to run the mysql command you have above, you need shell access, so if you can do that, then you do have shell access. If you don't have shell access, then you cannot run that command. (You can also use phpmyadmin to import the confirmAccount.sql file) DB_HOST is the server where your mysql server is located. In your LocalSettings.php file is the config setting $wgDBserver
