Getting Started

[Jioruji Derako]

How's it going.

 

Just signed up, maybe ten, fifteen minutes ago... got my account set up, just waiting for the validation. (log in errors on the cPanel just mean it's not set up yet, correct?) In the meantime, I've got questions and other semi-random comments.

 

Now, questions first. I haven't done much other then get my account set up, and set up my forum account; I didn't spot anything else, but have I missed any part of the process?

Two, I'm planning to set up my site with MediaWiki software if I can, or possibly a simpler, similar software. I know a lot of random little tidbits of setup info, but to be completely honest, I've never set up a website before (well, I do have an offline wiki running, but I don't think that's quite the same). Can I expect it to be a fairly simple and straightforward setup, or am I going to be running crying to internet support forums for weeks? (and on that note, which forum should I really be posting questions of that nature in, this one or another one?) Thanks in advance for any insight.

 

As for the semi-random comments; been reading reviews and the forums here, and I'm pretty impressed and surprised. I was expecting some big corporation-type effect here, but I'm seeing whom I can only assume is the main admin (djbob) posting on nearly every topic, a generally friendly tone across the board (no pun intended), and a pretty simple setup overall (so far). Where's the catch, when does my computer get beset by viruses or something?

 

Geo - a.k.a. Jioruji Derako

[Ashoat]

For installing web applications you'll need to know how to use FTP, how to CHMOD through FTP, and how to setup a SQL account. I think other than that everything's relatively simple. cPanel has a wizard for MySQL accounts, but you'll need to download an FTP client and lookup CHMOD'ing. I recommend SmartFTP for your client. If you use Fantastico the whole process will be automated.

 

No catch

[Jioruji Derako]

FTP, SQL, CHMOD. Nothing I can't fix with a google search. Should be fun to get fiddling around with all that once the site's up and running.

SmartFTP you say? You also mentioned Fantastico, is this the same thing as SmartFTP (an FTP client) or something different?

 

Geo - a.k.a. Jioruji Derako

 

P.S.: Don't think I mentioned it before, my URL's http://vynaioccwiki.heliohost.org, iirc. (edit x2)

[awesomegamer]

Fantastico is a program in your cpanel which can auto install many popular online scripts. Such as php forums and other useful programs.

FTP is File Transfer Protocol. It allows you to browse the contents of the server and edit/add/modify files.

CHMOD sets the permissions on the files.

 

Those are the basics.

[Jioruji Derako]

Thanks a bunch... I got SmartFTP already up and running, and I know where to find tutorials for everything else, so I think I'm all set. I just need to wait for the site to be activated.

On that note, how do I know when it's activated? I've been testing by attempting to log into cPanel, and it gives me a login failed message; that means it's not running yet, correct? Or does it mean I'm not actually doing it right?

 

Geo - a.k.a. Jioruji Derako

 

Wow, turns out I was entering the capitalization incorrectly. My username starts with a capital letter, but cPanel doesn't like that.

 

Anyway, I've got the site running... well, more or less. MediaWiki is mostly installed, I simply need to complete running the setup. But I'm running into errors... just one error, to be exact. I've got a MySQL database up and running, with a user set up as well; this works fine, as far as I can tell. The database is there, the database user is there, the database user has all permissions, as far as I know... but I'm still getting a 1044 error when I finish the installation... here's the full writeup:

 

* PHP 5.2.4 installed

* Found database drivers for: MySQL PostgreSQL

* PHP server API is cgi; using ugly URLs (index.php?title=Page_Title)

* Have XML / Latin1-UTF-8 conversion support.

* Warning: A value for session.save_path has not been set in PHP.ini. If the default value causes problems with saving session data, set it to a valid path which is read/write/execute for the user your web server is running under.

* PHP's memory_limit is 24M.

* 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: /home/defiant/public_html/mediawiki-1.11.0

* Script URI path: /mediawiki-1.11.0

* 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 defiant...success.

* Connected to 5.0.45-community

* * Error selecting database wikidb: 1044 Access denied for user 'defiant'@'localhost' to database 'wikidb'

 

I dug around for tutorials and whatnot, but couldn't seem to find anything specifically for my issue, that actually helped me. Chances are, it's my own fault, this is my first try with anything of this sort; but I'm not really sure how to tell... any ideas?

Attempting to set the user permissions to full access via phpMyAdmin comes up with the same 1044 error... and I've already set the permissions from cPanel's MySQL Databases section. Is there somewhere else I should be setting this?

 

Geo - a.k.a. Jioruji Derako

 

P.S.: Is this the right forum to be asking these questions in, for that matter?

 

::EDIT::

 

Okay, I actually fixed it again on my own. Seems it's not as complicated as I thought, I merely fiddled with it for a few... hours, and stumbled upon the issue.

 

For future reference; the database and database usernames need to have the "username_" prefix on them. When you create a MySQL database, you'll notice it adding your cPanel username and an underscore to the database name... that's important. You need to add those to the full database name when it asks for a MySQL database in MediaWiki's setup script.