C2k Help

Program Sets => All Others => Topic started by: ballsricky on March 29, 2006, 11:38:41 AM

Title: HP intranet hosting
Post by: ballsricky on March 29, 2006, 11:38:41 AM: I know some people have already got this up and working but I just have a few general questions.

I have activated mambo and it has installed itself in /cms/ folder, does this mean i now have to redirect to here from the main index page?

I also have a booking system currently running that I would now like to move over, it's running php and mysql. Does anyone know how I can go about this? There are thousands of enteries in this database and I like to be able to just copy it over without having to recreate anything.

I have never used anything like plesk before so any help would be much appreciated.
Title: HP intranet hosting
Post by: casper on March 29, 2006, 11:51:27 AM: Simply create a blank index.html page and put this in the head

<META http-equiv="refresh" content="0;URL=http://your_intranet/CMS">

As for the database:

Backup the database

Recreate it in the Control Panel on your intranet site - try and give it the same Name/User/Password etc

Then import the backup you did and this should recreate all the tables and insert the data.

Then upload your existing files for the script. You many have to tweak some of the setting in the script e.g absolute path etc.

This should work
Title: HP intranet hosting
Post by: ballsricky on March 29, 2006, 12:09:54 PM: how do you import?

i can only see an export option. this is in the databases > dbwebadmin ? or should i be somewher eelse
Title: HP intranet hosting
Post by: casper on March 29, 2006, 12:27:00 PM: Sorry should have mentioned this :(

You should see SQL in the DB Admin. In there there is an option to browse to your backup file. Then just click 'go'
Title: HP intranet hosting
Post by: ballsricky on March 29, 2006, 12:44:13 PM: hey,

i managed to find the import but now i'm getting an error:

SQL-query:

-- phpMyAdmin SQL Dump

-- version 2.6.0-pl3

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Generation Time: Mar 29, 2006 at 12:29 PM

-- Server version: 4.1.8

-- PHP Version: 5.0.3

--

-- Database: `mrbs`

--

CREATE DATABASE `mrbs` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

MySQL said:

#1044 - Access denied for user 'root'@'%' to database 'mrbs'

how come i'm being denied access when root is the only user i have made for this database?

by the way, thanks for the help
Title: HP intranet hosting
Post by: ballsricky on March 29, 2006, 01:24:28 PM: I'm a bit confused.

I want to call the database mrbs, and for some reason it thinks that it already exists.

Would anyone know why?
Title: HP intranet hosting
Post by: casper on March 29, 2006, 01:50:31 PM: Your intranet is on a shared hosting server so someone else has already created a database called 'mrbs'. The safest option is to put your DENI number before the name of the database e.g db12345678_mrbs
Title: HP intranet hosting
Post by: ballsricky on March 29, 2006, 03:27:59 PM: thanks for the reply,

eventually my brain started working today. I guessed as much and once I got the database made, i put the deni number in front, I realised that my sql file was actually trying to create the database as well as update the tables.

Did a of editing and now I am up and running!!!

Now I just have to do a crash course in mambo followed by another in phpBB.

Just as a matter of interest, do you provide username and password for the intranet site and phpBB or do you not bother with that? Connecting to the LDAP would be the best option but I asked and they said no.
Title: HP intranet hosting
Post by: ciaran on April 04, 2006, 03:11:20 PM: here did anyone get a call from c2k about hosting wesites with them? approx £195 per annum , they give you a free 2 week trial to see what you think of the setup.
Title: HP intranet hosting
Post by: casper on April 04, 2006, 03:50:41 PM: Yea I got that too :)
Title: HP intranet hosting
Post by: ciaran on April 04, 2006, 03:58:46 PM: have you had your two weeks free trial?