Jump to content

Patrick

New Members
  • Posts

    8
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

Patrick's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Hi there, I have a question, and I\'m not sure if it possible... I am running Apache, and using localhost for as my test server. It is not serving any pages outside of a localhost environment. The document root is set to htdocs, and each of the sites that I work on sits in a folder in htdocs. I am programming in Dreamweaver MX, and I need to use Site Root relative links. If I set the document root in Apache\'s config file to htdocs/sitex then http://localhost will give me sitex as expected. But I can\'t access any other site. Without setting the document root to htdocs/sitex, the root relative links in the site all point to the root - htdocs, not where I want them - htdocs/sitex. I investigated virtual hosts, and it seems that this is only any good for requests being served from outside, and not locally. What I want to achieve is instead of setting the document root to htdocs/sitex and then typing http://localhost to access sitex, I want to be able to type http://sitex (or something) and get sitex and http://sitey for sitey. This will allow site root relative links on all my sites to work as and when required, without changing the apache config settings. My question then I guess is: is it possible to use virtual hosts locally? I hope I have explained my situation clearly enough for someone to know what I\'m talking about and even possibly come back with an answer to my problem. Any assistance is greatly appreciated. Regards, Patrick
  2. Thanks, some such things are very easily overlooked...
  3. effigy, thank you for your assistance, but I came up with a new theory... If it doesn\'t work and you can\'t fix it throw it out and start again. Might not be very good, but the problem is gone and I\'m happy. I suspect that there was a conflict with the code generator I\'m using, it\'s very powerful and I\'m still getting used to it. It turned out that the error messages were generated by Code Charge and that helped to confuse me a bit. Thanks again, Patrick.
  4. Good on ya guys, consider using phpMyAdmin to manage your databases instead of using the command prompt - it does make life much easier. Just my opinion though... Patrick
  5. Thank you, I have tried both connect and pconnect with the same results, again with no luck. It has however, confirmed that it is a problem with permissions and not with the connect. I\'m racking my brains to think what is not right with the permissions - especially having used the grant statement you mentioned earlier... it is a puzzle. Any more ideas appreciated, but thank you very much for your assistance. Patrick
  6. I have been running MySQL and an Apache Web server (with PHP installed as a module) as services on Win 2000 and it\'s been working well -althought I am having troubles with sessions and authentication. I\'ve found the easiest way to manage MySQL is by using phpMyAdmin, see www.phpMyAdmin.net - free download - just extract to your document root, and access index.php. If you\'d rather use the MySQL command prompt open the command prompt and select c:INSTALLATION_PATHmysqlbin then type: mysql -u \'username\' -p or just: mysql -u root if you haven\'t changed the root password yet. (phpMyAdmin makes it much easier) I start by building the database in phpMyAdmin and then starting on the php code from there. Hope that helps, Patrick
  7. Thanks for such a quick reply effigy, I\'ve tried both of your suggestions but so far not having any luck. The pconnect arguments are held in variables. The strange thing is that it connects for authentication, and for displaying the list, but refuses authorisation for the add/edit screen. I\'m thinking it is to do with permission settings, but I can\'t find any differences with the permissions between the pages, or any anomaly in the MySQL users database. Any further thoughts? Any help is appreciated. Once again, thanks for your reply. Patrick
  8. Hi, I hoping that someone will be able to help me, I\'m getting an odd error, that I can not seem to get to the bottom of. When attempting to access a list page, I get put through to the login screen and after successfully entering a valid user name and password I get put through to the page I expected, which is a list of database records. Upon clicking a link to add or edit a record I get the error below. Is anyone able to give me any ideas as to what might cause this to happen upon editing or adding a record. The user is a root user with all privileges and both the list and edit screens have the same security restrictions. Using CodeCharge Studio, Apache 2.0.43, PHP 4.2.3, MySQL 3.23.54, with MySQL and Apache running as services on Windows 2000 where applicable. I get the same error when running from a Unix test server running similar versions. Most appreciative if anyone could give any advice. Patrick ERROR Warning: Access denied for user: \'patrick@localhost\' (Using password: YES) in /home/patrick/public_html/test/xyz.php on line x Warning: MySQL Connection Failed: Access denied for user: \'patrick@localhost\' (Using password: YES) in /home/whitit/public_html/test/xyz.php on line x Database error: pconnect(localhost, patrick, $Password) failed. MySQL Error: () Session halted.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.