(I apologize if people are receiving this message twice -- I sent it out earlier, but I don't think that it was posted to the list.)
I am looking to create my own wikiwiki website using the MediaWiki software, but I'm uncertain as to how I should proceed, because I do not have access to the command line. I first attempted to have my host's support people run the install.php script for me, but they ran into errors and told me that they ran into errors when they ran the script from the backend, and to look for errors in the code. (You'll have to forgive my ignorance here -- I'm pretty good with websites, but server management isn't something I know anything about yet!)
So, I'm looking for a way to install MediaWiki and set up my site using nothing but FTP upload, phpMyAdmin access (full admin/dba permissions), and a normal Web browser. Can anyone provide some assistance with this?
Thank you, Dan Carlson
On Thu, Nov 20, 2003 at 05:13:40PM -0500, Dan Carlson wrote:
(I apologize if people are receiving this message twice -- I sent it out earlier, but I don't think that it was posted to the list.)
I am looking to create my own wikiwiki website using the MediaWiki software, but I'm uncertain as to how I should proceed, because I do not have access to the command line. I first attempted to have my host's support people run the install.php script for me, but they ran into errors and told me that they ran into errors when they ran the script from the backend, and to look for errors in the code. (You'll have to forgive my ignorance here -- I'm pretty good with websites, but server management isn't something I know anything about yet!)
Did they tell you what kind of errors they got?
Regards,
JeLuF
On Nov 20, 2003, at 14:13, Dan Carlson wrote:
So, I'm looking for a way to install MediaWiki and set up my site using nothing but FTP upload, phpMyAdmin access (full admin/dba permissions), and a normal Web browser. Can anyone provide some assistance with this?
Some manual install instructions: http://mail.wikipedia.org/pipermail/mediawiki-l/2003-October/000004.html
-- brion vibber (brion @ pobox.com)
Thanks very much for those instructions, Brion! I've now gotten the program up and running properly, but I've found a new problem -- the default admin user hasn't been created, and so I can't log in to change some of the internal settings. How do I create the admin user? I tried the "users.sql" script, but I'm not familiar enough with SQL queries yet to know what all those other various parameters do -- or more specifically, the server addresses. Since I assume that the users.sql file is what I need, what do I need to do to it?
Thanks, Dan Carlson
On Nov 22, 2003, at 10:40 AM, Brion Vibber wrote:
On Nov 20, 2003, at 14:13, Dan Carlson wrote:
So, I'm looking for a way to install MediaWiki and set up my site using nothing but FTP upload, phpMyAdmin access (full admin/dba permissions), and a normal Web browser. Can anyone provide some assistance with this?
Some manual install instructions: http://mail.wikipedia.org/pipermail/mediawiki-l/2003-October/ 000004.html
-- brion vibber (brion @ pobox.com) _______________________________________________ Wikitech-l mailing list Wikitech-l@Wikipedia.org http://mail.wikipedia.org/mailman/listinfo/wikitech-l
On Nov 22, 2003, at 15:57, Dan Carlson wrote:
Thanks very much for those instructions, Brion! I've now gotten the program up and running properly, but I've found a new problem -- the default admin user hasn't been created, and so I can't log in to change some of the internal settings. How do I create the admin user?
I assume you mean a wiki user account; you'll need to manually change the user_rights field through the db:
UPDATE user SET user_rights='sysop' WHERE user_name='My admin account';
I tried the "users.sql" script, but I'm not familiar enough with SQL queries yet to know what all those other various parameters do -- or more specifically, the server addresses. Since I assume that the users.sql file is what I need, what do I need to do to it?
That sets up MySQL user accounts, so the regular wiki scripts can run without the ability to alter the table structure, while the admin scripts do, and the sysop sql query feature can only be used for read-only access and not to read private data from the user tables (email, password hash, watchlist).
User accounts in MySQL are sort of scary and I'm not sure I understand it myself. :) It's perfectly possible to run the whole wiki under an existing all-powerful MySQL user, but could be more damaging if something goes wrong or a hole is exploited. In particular be careful about the SQL user account ($wgDBsqluser/$wgDBsqlpassword), since any wiki user logged in with admin access can issue arbitrary SQL commands executed as the SQL user.
-- brion vibber (brion @ pobox.com)
On Nov 23, 2003, at 12:55 AM, Brion Vibber wrote:
On Nov 22, 2003, at 15:57, Dan Carlson wrote:
Thanks very much for those instructions, Brion! I've now gotten the program up and running properly, but I've found a new problem -- the default admin user hasn't been created, and so I can't log in to change some of the internal settings. How do I create the admin user?
I assume you mean a wiki user account; you'll need to manually change the user_rights field through the db:
UPDATE user SET user_rights='sysop' WHERE user_name='My admin account';
Ah, THAT'S what I was looking for! I just didn't know what the name of the setting would be...
I tried the "users.sql" script, but I'm not familiar enough with SQL queries yet to know what all those other various parameters do -- or more specifically, the server addresses. Since I assume that the users.sql file is what I need, what do I need to do to it?
That sets up MySQL user accounts, so the regular wiki scripts can run without the ability to alter the table structure, while the admin scripts do, and the sysop sql query feature can only be used for read-only access and not to read private data from the user tables (email, password hash, watchlist).
User accounts in MySQL are sort of scary and I'm not sure I understand it myself. :) It's perfectly possible to run the whole wiki under an existing all-powerful MySQL user, but could be more damaging if something goes wrong or a hole is exploited. In particular be careful about the SQL user account ($wgDBsqluser/$wgDBsqlpassword), since any wiki user logged in with admin access can issue arbitrary SQL commands executed as the SQL user.
Hehheh, I understand what you mean about MySQL users. Fortunately, my web host account has a control panel that allows me to set those kinds of things up without having to worry about the gritty details. A horrifying situation for purists, I know, but simpler for novices. ;-)
Thanks again! Dan Carlson
wikitech-l@lists.wikimedia.org