PHP - no-ip issues/queries

mjjk91 · - Joined: 03 Feb 2004 Posts: 75 Location: Australia

G'Day Everyone,

I recently setup my abyss web server for php+mysql+php my admim. It was all up and running successfully after following the various tutorials. I recently created a host with no-ip, and once this happenned, i started having problems. Firstly, mysql would not connect. I was able to recify this by uninstalling and re-installing the program. Secondly, i was able to connect to php my admin, but my privledges had been removed. When i tried to add a new user, it would not allow me, saying:

#1045 - Access denied for user: '@localhost' (Using password: NO)

And this is where i am stuck. I plan on re-installing everything and configuring my system for my new no-ip address, which is seifer14.no-ip.com. What changes would i have to make in comparison to the normal configuration?

Any help would be highly appreciated.

Cheers

Mick Koch

TRUSTAbyss · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

Use this website for doing all that
http://os17fan.cjb.net

mjjk91 · - Joined: 03 Feb 2004 Posts: 75 Location: Australia

Yep, this was the site i used to configure my system, but now that i have a host account with no-ip, i am having problems, and this site does not address these issues, from what i can see, i may be blind 8O Using the site i was able to configure everything perfectly, until using no-ip. Any reasons? Should i have to change anything?

Cheers

Mick Koch

TRUSTAbyss · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

What kind of errors are you getting ?
and is it possible that your IP changed ?

if you need more help , add me to
your MSN Messenger and i will help.

Uzi Studios · - Joined: 18 Mar 2004 Posts: 5 Location: Canada

Same problem for me...

Its something with MySQL...

I think we have to configure it right or something..

I also followed the steps on that site and I'm having the same problems.

TRUSTAbyss · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

When I wrote those steps to getting
each of those scripts or programs
configured , I made sure that they
where correct before releasing them.

If you get a error saying

0DBC32.dll not found while viewing a php script
You need to download the following to get it to work.

Microsoft Data Access Components
---------------------------------------

MY MSN is: trustpunk@hotmail.com , I will help both of you !
stay on MSN Messenger today and I will be with you shortly.

mjjk91 · - Joined: 03 Feb 2004 Posts: 75 Location: Australia

G'Day,

I have included screen shots of the errors i have encountered, and the setup i have. I agree with Uzi, i believe it is a mySQL problem Trust, your instructions were great, and yes, following them, i got it up and running perfectly. I have a dynamic IP address, so it would constantly change. Thats why i setup a host using no-ip, to rectify that. Would/could that affect my setup, and how would i need to change that?

This shows all my servers running smoothly

This shows the my.ini setup.

This shows the details i input to add a user.

This is the error i get when i attempt to add a user, using the details above.

I get this error when i attempt to log into phpMyAdmin. This only occurs when i have specified a username and password in the configinc.php file. If i dont specify a username and password, i am able to log into phpMyAdmin, but i still have all the above errors.

This is the configinc.php file - URL Setup.

This is the configinc.php file - with a username and password specified.

This is the error i am getting when i try to run one of my .php files.

Well, thats all of it, any help would be highly appreciated.
Cheers

Mick Koch

TRUSTAbyss · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

Well I have some good news , Uzi Studios problems are solved and he even got PHP Nuke working , now your problem
seems to be a little different , UZi Studios added his info for his username and password wrong so thats why he didn't
have anything working can you add me to your MSN Messenger trustpunk@hotmail.com , im online all day basicly , later!

mjjk91 · - Joined: 03 Feb 2004 Posts: 75 Location: Australia

G'Day TrustPunk,

I have added u to my msn list. My email address is as follows:

s_liston2@hotmail.com

if you would like to add me to your list. Well thats good that uzi's problems were fixed, hopefully means we can fix mine. Its pretty important, as im going into a business venture soon, and i need my database and php functions working optimally.

If anyone else out there knows of this problem, please fell free to add your input.

Cheers

Mick Koch

iNaNimAtE · Posted: Tue Mar 23, 2004 11:33 pm Post subject:

Well it seems you have everything set up right, however you never password protected mySQL. Remove all passwords for phpMyAdmin, and then while logged in, you can password protect mySQL via phpMyAdmin.
_________________
Bienvenidos!

mjjk91 · - Joined: 03 Feb 2004 Posts: 75 Location: Australia

iNam,

I have tried that, and this is the error i am getting:

#1045 - Access denied for user: '@localhost' (Using password: NO)

this occurs when i attempt to add myself as a user, and password protect the mysql database. Any ideas why?

Cheers

Mick Koch

iNaNimAtE · Posted: Wed Mar 24, 2004 2:57 am Post subject:

Yes, but in the screenshot of the my.ini file, I see no values that say anything about username or password.
_________________
Bienvenidos!

mjjk91 · - Joined: 03 Feb 2004 Posts: 75 Location: Australia

G'Day everyone,

I have uninstalled everything and re-installed, and now i am getting the following error:

#1250 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

I dont know if this means i have an out-of-date MySql, but i have version 5.0, which i believe is the latest, so i dont know what the problems is there. I have been speaking to truth, and we believe a problem may be with Microsoft IIS. For those who have XP Professional, have you had any problems with IIS? I have not installed IIS, but for some reason, an error comes up when i we try to view my site, which specifies an IIS problem. If anyone can help with these two problems, that would be highly appreciated.

Cheers

Mick Koch

iNaNimAtE · Posted: Wed Mar 24, 2004 7:25 am Post subject:

What exactly gives you this error?
_________________
Bienvenidos!

mjjk91 · - Joined: 03 Feb 2004 Posts: 75 Location: Australia

I get this error when i attempt to log into phpMyAdmin. All passwords and operations are per the tutorial provided by trust, but, yeah, i keep getting this error. Any ideas?

Cheers

Mick Koch

mjjk91 · - Joined: 03 Feb 2004 Posts: 75 Location: Australia

G'Day everyone,

Well, i just uninstalled, reinstalled, and went through all the steps according to the instructions set out by trust, and again, im getting the same error once i try to password-protect the mySQL database:

#1250 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

Any ideas? I mean, 2 days ago, everything was running fine. Things only started to go wrong when i got myself an account with no-ip, and set up a host under the name "seifer14", making my account name seifer14.no-ip.com. Something has affected my setup, and now i really cant do anything, when a couple of days ago i could. Any ideas and any help would be HIGHLY, HIGHLY appreciated.

Cheers

Mick Koch

iNaNimAtE · Posted: Thu Mar 25, 2004 4:41 am Post subject:

I understand your frustration, and I hope it starts working soon.

Now I haven't looked at the configuration in a long time, however somewhere in the "config.inc.php" is there a line that only allows connections from localhost? If so, definitely change it to include your new domain name.

EDIT: I now posted the screenshot.

Your config file should look exactly (or basically similar) to this:

To view line numbers, open the config file with notepad, and go to "View>Status Bar." The line numbers are displayed on the bottom.

EDIT (Again): I can send you my complete "config.inc.php" file if you want it. (Via Email or whatnot).
_________________
Bienvenidos!

mjjk91 · - Joined: 03 Feb 2004 Posts: 75 Location: Australia

G'Day everyone,

Well, i still have not got ova my last error. Its working fine on my PC ,but not on my laptop, so i will compare my configurations and figure something out. My main problems exists with IIS and Windows XP Professional. For all those who use XP Pro, have u had any problems with IIS? I have uninstalled, and stopped the IIS Server, and for some reason, it still exists, and when i try to run my page, it says the page does not exist from that server. Obviously, i want to run my page through abyss, not IIS. Does anyone know how to TRUELY stop the IIS server in Windows XP? Like i said, i have uninstalled and stopped the server, but it still runs. I think it may because i am in a Business LAN, but i will be able to test this out on my laptop when THAT is working. :evil: 4 now, any ideas anyone?

cheers

Mick Koch

aprelium · - Joined: 22 Mar 2002 Posts: 6800

mjjk91,

Disabling IIS by Microsoft: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B321141 .
_________________
Support Team
Aprelium - http://www.aprelium.com

aprelium · - Joined: 22 Mar 2002 Posts: 6800

mjjk91,

Disabling IIS by Microsoft: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B321141 .
_________________
Support Team
Aprelium - http://www.aprelium.com

TRUSTAbyss · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

Just so you know , I will be helping my friend on Sunday
with the MySQL Problems , I wrote the tutorials , I can fix it.

I am very experianced so I don't think it has to do with
my tutorials after all those installations of phpMyAdmin
and MySQL , I fixed everyone's problem so far that needed
help so seifer14.no-ip.com will be running on Sunday , LateR!

mjjk91 · - Joined: 03 Feb 2004 Posts: 75 Location: Australia

G'Day everyone,

Well, i have fixed the problem. As i thought, it was related to my business LAN. Once i got home and tried it out on my laptop on my home connection, it worked like a charm. I would like to thank everyone on this board who has helped me out heaps, especialy trust. Been a champion bloke, keep watching th croc hunter mate. :lol: Anyways, cheers everyone. Will speak to u all soon.

Cheers

Mick Koch

mjjk91 · - Joined: 03 Feb 2004 Posts: 75 Location: Australia

G'Day everyone,

Well, just when you think you have it all done, something goes wrong. :twisted: This relates to MySQL, and im sure you have all come across it b4. Yesterday, everything was running smooth, MySQL was up, as was my site, with database capabilities, it was all awesome. I go to check everything tonight, and what happens, MySQL wont connect, the green light wont go on. Now, i dont want to muck around and uninstall MySQL because i now have important databases on there. How can this be, yesterday it was al fine, as today, its down. I have not touches any .ini files. I have not even used my computer for other reasons. This was the first time i went on it since everything was running awesome. Any ideas what could be causing this problem, and why the MySQL server will not connect?

Cheers Everyone

Mick Koch

TRUSTAbyss · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

Log onto MSN Messenger today and I will fix this problem !