No experience with php3 or mysql

[Trijnie]

Hello,

Step 3 shows this:

Warning: Access denied for user: 'pma@pma-hosting.com' (Using password: YES) in db_mysql.php3 on line 31

Warning: 0 is not a MySQL link index in db_mysql.php3 on line 37

HELP!

Trijnie

[Chris Schreiber]

It looks like you will need to verify your MySQL server settings (hostname, username and password) with your hosting provider.

-Chris

[Trijnie]

Thanks Chris!

Trijnie

[Jez Quigley]

Hmm! This is my first visit / first post .. I am trying to get Lite version up & running .. not only do I not know how to do it(!!) I also dont understand your answer (Chris) .. when you say hostname, username, password .. do you mean for user name; enter Admin & his password or is user name simply the name of a user on that particular Virtual Host??

I have just got a brand spanking new RAQ3 with PHP3 & mySQL installed .. not really familiar with it .. but I do have admin rights .. so should I be using admin as the user??

I get exactly the same error as Tijnie!

I have got Snitz up & running like a dream on my NT server for several clients (so we are not all that dumb!) .. but so far my success rate with CGI / PHP is a bit less than crap!

Can u steer me in right direction & offer suggestions (without being offensive too !!) :)

Thanks

[JimF]

Welcome, Jez :)

If you're running mysql on your own server, your hostname should be localhost, and your user name and password should correspond with a user that has been granted mysql access inside of mysql. Though I'm not sure if the default MySQL user is the same as the server admin; if it is, you would just use the root un/pw. Hopefuly Chris will see this and will be able to provide a more definitive answer on that particular subject.

Hope this helps :)

-jim

BTW: We love people who search for similar topics before they post their own thread - Thanks :)

[Jez Quigley]

Hey Jim:

Thanks 4 yr help .. I am about to have another try!


Originally posted by JimF

BTW: We love people who search for similar topics before they post their own thread - Thanks :)

I am involved in two Snitz forums & fully understand the importance of "looking first" B4 posting!! I just wish more users woud do it! :)

Thanks

[Jez Quigley]

Jim:

I am not having any luck .. another 1 hour down the line & I simply cannot get it to work. The Tech support people who supply my RAQ3 say "You should not need a username/password to use mySQL you just need to make sure you are in root."

I keep getting the exact same error as Tijnie!!

Any ideas??

[JimF]

Originally posted by Jez Quigley
The Tech support people who supply my RAQ3 say "You should not need a username/password to use mySQL you just need to make sure you are in root."

They are correct - to a degree. To work in MySQL, if you are logged in as root you should be okay. However, when you run the install script in your browser, it is not in root. That's the difference.

As root, you'll have to setup a mysql user account. User accounts specify who can connect to the server, where they can connect from - and what priveleges they can have while in MySQL.

For more info on this, see these links:

How the MySQL Privelage System Works (http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.html#Privileges)
Setting Up Initial MySQL Priveleges (http://www.mysql.com/documentation/mysql/bychapter/manual_toc.html#Default_privileges)
Adding New User Priveleges To MySQL (http://www.mysql.com/documentation/mysql/bychapter/manual_toc.html#Adding_users)

All of those are on the same page, but it's a big page :). You can either visit the first one and keep reading, but those are the three things you'll need to focus on.

I hope this helps - a little more :)

-jim

[Jez Quigley]

Dupe message ... text removed

[Edited by Jez Quigley on 10-06-2000 at 03:09 AM]

[JimF]

Okay, I'm confused - since you posted duplicate messages, I don't know if these suggestions worked or not:


Originally posted by JimF

Originally posted by Jez Quigley
The Tech support people who supply my RAQ3 say "You should not need a username/password to use mySQL you just need to make sure you are in root."

They are correct - to a degree. To work in MySQL, if you are logged in as root you should be okay. However, when you run the install script in your browser, it is not in root. That's the difference.

As root, you'll have to setup a mysql user account. User accounts specify who can connect to the server, where they can connect from - and what priveleges they can have while in MySQL.

For more info on this, see these links:

How the MySQL Privelage System Works (http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.html#Privileges)
Setting Up Initial MySQL Priveleges (http://www.mysql.com/documentation/mysql/bychapter/manual_toc.html#Default_privileges)
Adding New User Priveleges To MySQL (http://www.mysql.com/documentation/mysql/bychapter/manual_toc.html#Adding_users)

All of those are on the same page, but it's a big page :). You can either visit the first one and keep reading, but those are the three things you'll need to focus on.

I hope this helps - a little more :)

-jim

Let me know :)

[Jez Quigley]

Jim:

I havent a clue how duplicate messages got posted! I still am not up & running!

I have to say that .. as powerful as your system is .. and I dont doubt it .. my lil 'ol Snitz forums can be setup in 10 minutes & I have never ever posted a duplicate!! :)

However .. I will not give up!!

Thanks M8 for your help so far .. sorry to be apain!

Cheers

[Jez Quigley]

Jim:

According to the company that supplies my RAQ3 ; vBulletin will NOT run on a Cobalt RAQ3 server!

Here's what they said:-

"* I have tried to configure vbulletin every way I know how and it just wont run on a RaQ. The problem lies with the way MySQL is set up on the RaQ. As you know the MySQL runs in root, you can create all sorts of databases but there is no way to be able to login to a database via the vbulletin. I have spoke with cobalt and they concur."

So .. if you ever get any other unfortunate RAQ users tearing their hair out (like I have been doing now for almost 4 days) .. you can put them out of their misery early!

I really am p****d off with this .. I really wanted to get vBulletin up & running for a major customer here in the UK .. I even got an order!

Looks like I am gonna hve to go back to Snitz!

Anyway thanks 4 your help ..

ATB


*

[JimF]

That's very interesting. I could be wrong, but if it can't be set up to run vBulletin, it can't be setup to use any web applications that utilize mysql. That's rather unfortunate.

-jim

[Jez Quigley]

Jim:

I am also very surprised ..... and quite frankly I was a "wee bit" suspicious of their response! Now, reading your reply I am pretty convinced its a load of b*****t.

There's lot of mySQL applications running on RAQ servers.

I'll go & "rattle their cage" again!

I''ll let you know.

ATB

[Jez Quigley]

Hey Jim:

Guess what? vBulletin is installed .. I complained to the provider of my RAQ3 (www.catalog.com) .. and "out of the blue" I get an email saying that they had installed vBulletin Lite for me!!

The guy who did it must sure know his stuff!

I can access the forum but there's no provision for admin to edit posts .. is this a failing of the Lite Version??

Also I cannnot get the date to show d-m-y.
Another thing ... if I go to the URL's shown in the Admin area I get a "chinese" web site??

http://www.php3.net/manual/function.date.php33

Rgds

[Edited by Jez Quigley on 10-10-2000 at 09:21 AM]

[Mike Sullivan]

Originally posted by Jez Quigley
I can access the forum but there's no provision for admin to edit posts .. is this a failing of the Lite Version??Yes. vB Lite is mainly to be used as a test. I suggest you buy the full version :)


http://www.php3.net/manual/function.date.php33That happened when ".php" was translated to ".php3". The new correct URL is: http://www.php.net/manual/function.date.php

[Edited by Ed Sullivan on 10-10-2000 at 09:41 AM]