Jump to content

WormTongue

Members
  • Posts

    13
  • Joined

  • Last visited

    Never

Contact Methods

  • AIM
    Bocko98
  • ICQ
    3943404
  • Yahoo
    teksup1

Profile Information

  • Gender
    Not Telling
  • Location
    Illinois

WormTongue's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. The way i start mysql right now is by this... /data/mysql/mysql/support-files/mysql.server start So, then i would need to start the sql database by this... /data/mysql/mysql/support-files/mysql.server start --datadir=/data/mysql/mysql/data Is this correct?
  2. Bump! i really need some help here. does anybody have any ideas?
  3. I just installed the mysql database on my RH 9.0 webserver. I did not install it to the default path, i installed it where i wanted it to go. Now, when i try to access the database through the web, i don\'t get any data. I can connect just fine, but nothing shows up. All i get is \"\"); } ?> \". I\'m thinking that i don\'t have the server configured correctly to point to the data when it starts. So, my question is where would i go about configuring mysql to look in the correct directory? I\'ve been editing some files that i think are the ones i need to change, but nothing has worked yet. Thanks for the help.
  4. Thanks for the reply. That really helps out a lot.
  5. I am trying to setup a mysql table that will only hold images. As a webpage is requested, the code will look in the mysql database and pic a random image. My question is 1) is this possible? and 2) how do i go about making my table to store the images and upload the images? Thanks for your help.
  6. I know that port 80 is HTTP, so i set it up at 1500 since i am not root. Now, is it really safe to startup apache as root because of the child processes? Then i can get to port 80 and everything works smoothly? Does anybody have any references to the potential security issues with apache?
  7. If i do start the webserver as root, and even though the child process are set to nobody, won\'t the parent stay as root? So, even if somebody hacks into my webserver, they can still get to the parent and evenutally get into my system because the parent is root. Is my thinking correct? Thanks for the help. I set it up on a port greater than 1024 and everything worked fine.
  8. I\'m am getting this error... Now, i am not root when i start the webserver, but when i become root and run it, everything works fine. So, my guess is that i don\'t have permission to open up port 80. Does anybody know how to fix this error? Someone told me that you can\'t open port 80 when you aren\'t root, so you have to run apache as root. This is really bad because i do not want to run apache as root, since that is a major security problem. Thanks for your help.
  9. Ok, let me better clarify what i\'m thinking. We have a membership database with everybodies info in it. We want to put that online so members can update their info and such through the web. We are going to have them signup with their username being their e-mail address. I need to find a way to link their e-mail address with their info in the membership database. Now we do have their e-mail in their account, but that information has not been updated in a long time since we never needed it until now. I don\'t want to call each person to get their correct e-mail address, so i would like to link their username(e-mail address) with their name and not by e-mail. The only problem is that i don\'t know how to do this...
  10. yea, basically. If i understand where you are going, could i just change tables in my query statements to the member table? Is this is easiest way? What i was thinking was a way to link the two so that i don\'t have to change my query statements. I guess have the login table call the member table for me then i just have to access one table. Does this make sense?
  11. Hello. I am very new to the whole mysql/m$sql and i was wondering what the easiest way is to link two tables together. Here is my situation: I have a membership system where users log on to check their account info and such. The log in info is stored in a different table than the rest of the data. So, what i want is when they log in, it points from the login table to the member table that has all of their account information. Is there any easy way to do this? Thanks for your help.
  12. yea, i just saw that. Thanks for your help.
  13. I am trying to create a table and i have the code for mysql, but i need it in m$sql. If i run the same code, i get errors and i think i have found the error. Does the data type \"enum\" work in m$sql? Here is the sample from my code: user_level enum(\'0\',\'1\',\'2\',\'3\') NOT NULL default \'0\', Now, i get an error on this line and i\'m thinking that mssql doesn\'t recognize the enum data type. Any ideas?
×
×
  • 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.