Problems getting joomla to work

[krisd32]

i'm trying to install joomla,

got everything else working bar my sql getting an error saying that port 3306 is blocked so it cannot continue setup checked everything i can think of. nothing in tcp/ip filtering of nic either.

we do have an isa server if thats any help.

 

its doing my head in, please save from insanity

[fooby]

Has tcp/ip access to mysql been enabled? is this a windows server? have you got MySQL Administrator?

 

I have joomla running here on windows server 2003 mysql5 php5 iis 6 so maybe i can help

 

 

fooby

[Guest]

Can you provide some more info to your setup.

[krisd32]

only win 2k svr, my sql 5, and the latest version of php, and whatever version of iis comes with win 2k server.

is mysql administraotr a different package? if it is then no. set up as according to these notes on

 

http://www.online64.net/content/view/36/2

 

never used mysql before so i'm a newcomer to it all!

[krisd32]

setup is as follows

 

1 x win2k server for AD + sophos

1 x win2k server for files + printers

1 x isa server

1 x admin server (win 2k also)

 

as i mentioned before complete newbie to my sql so if you have any ideas i would be greatful

 

thanks

Kris

[Guest]

Have you considered setting up apache rather than IIS? Much easier you setup and configure.

[krisd32]

not thought about that, i'll give it a go but that still won't sort out the sql issue

 

this is the specific error

 

error No. 1045

Access denied for user 'root'@'localhost' (using password: NO)

[Guest]

I currently run an intranet site on joomla using http://apache2triad.net/

 

Has everything you need in one package. Just drop in the joomla core and run the install and you are good to go.

 

Are you sure the MySQL service is running?

[krisd32]

would i need to remove iis from my server in order to install apache cause i currently have a maths program that is constantly being used set up in iis so i couldn't take that off.

[Guest]

Yes you can have both running on the same box. There are a few ways of setting it up. Take alook here http://www.edugeek.net/index.php?name=Forums&file=viewtopic&t=1608&postdays=0&postorder=asc&start=15

[krisd32]

yeah mysql service is definately running!

[fooby]

Instead of uniservity, try Moodle. Moodle is an open source course management system.

[krisd32]

will try this!!

[webman]

I'd recommend getting a combined package of the core services - "WAMP Server" springs to mind. It includes Apache, PHP and MySQL and pre-configures them for you. It also includes a system tray service manager.

[Guest]

Well if its for a demo you could install apache2triad on a Laptop / PC and create your site to show SMT and then just transfer to a webserver at a later date if SMT like it.

[krisd32]

managed to get round the initial problem now, but a new one has occured when the joomla install page comes up i have no mysql support and by the looks of things with it its not connecting to a database.

[krisd32]

i'm gonna try the solution you mentioned at home over the weekend to see if i can get a better response from it !

[MikeW]

You just need to set/change a password for root - have a look at http://www.netadmintools.com/art90.html

[krisd32]

the root password is set and get in to it using mysql administraotr.

 

the only problem now seems to be with joomla its self with the installer saying there is no mysql support.

 

sorry to be a pain but i can' get it to work any way at all.

[ZeroHour]

not thought about that, i'll give it a go but that still won't sort out the sql issue

 

this is the specific error

 

error No. 1045

Access denied for user 'root'@'localhost' (using password: NO)

 

Sounds like you need to put the root password in.

Also makesure you are connecting to the DB on localhost.

Get phpMyAdmin and login to your db with that. You can then manage DB permissions and user accounts

[Norphy]

ahahaha

 

I had that one. I solved it by doing the following:

 

Open a MySQL command prompt. Type in your root password. Then type in the following:

 

SET PASSWORD FOR root@localhost = OLD_PASSWORD('password');

 

Subsituting the password in quotes for your root password.

 

Its probably not the best method of solving the problem but it worked for me.

[krisd32]

thanks for all the help people. got it working now using apache 2 triad on another server as a last resort.