SitePoint Sponsor

User Tag List

Results 1 to 6 of 6

Thread: PHP Intranet

  1. #1
    SitePoint Enthusiast
    Join Date
    Apr 2004
    Location
    york
    Posts
    42
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    PHP Intranet

    Hi,

    I built a website for a client recently and they've asked me to provide a proposal and quote for providing a similar CMS-based approach to their corporate intranet.

    I haven't done an intranet before but I'm always keen to try something new so would like to go for this one but have a number of issues I'm trying to get to grips with.

    I know they would like to host this on an internal server but I would need to access this remotely as they are based a long distance from me. I'm confident I can get a LAMP server setup with FTP access but would normally use CPanel to manage my sites and PHPMyAdmin for the database. I'm therefore not clear at the moment on how best to migrate and maintain the site once its developed. Any thought and advice would be most welcome.

    Also, I'm assuming that the root of the site would be an IP address or localhost. I'm assuming that there are no serious difficulties in building a navigation system and links based on a different root, but again confirmation on that would be good.

    Last one would be security issues. I'm guessing that PHP would struggle to authenticate using the corporate account server?

    Any thoughts, warnings or tips would be very much appreciated.

  2. #2
    Non-Member
    Join Date
    Oct 2007
    Posts
    363
    Mentioned
    11 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by arthurnegas View Post
    Hi,

    I built a website for a client recently and they've asked me to provide a proposal and quote for providing a similar CMS-based approach to their corporate intranet.

    I haven't done an intranet before but I'm always keen to try something new so would like to go for this one but have a number of issues I'm trying to get to grips with.

    I know they would like to host this on an internal server but I would need to access this remotely as they are based a long distance from me. I'm confident I can get a LAMP server setup with FTP access but would normally use CPanel to manage my sites and PHPMyAdmin for the database. I'm therefore not clear at the moment on how best to migrate and maintain the site once its developed. Any thought and advice would be most welcome.

    Also, I'm assuming that the root of the site would be an IP address or localhost. I'm assuming that there are no serious difficulties in building a navigation system and links based on a different root, but again confirmation on that would be good.

    Last one would be security issues. I'm guessing that PHP would struggle to authenticate using the corporate account server?

    Any thoughts, warnings or tips would be very much appreciated.
    Really, all you should actually need is ssh access to the server. You shouldn't be using ftp as a deployment mechanism anyway, and cpanel really isn't something you should be reliant on. I'd recommend learning how to ssh from the command line, and doing it all that way.

    Other people will probably be able to give you more gui friendly advice...

    Edit: Also, phpmyadmin should be a major no-no for something like this. If you can access phpmyadmin remotely on the production server, what's stopping someone with nasty intentions from also doing so? Phpmyadmin shouldn't even be installed.

  3. #3
    Hosting Team Leader silver trophybronze trophy
    cpradio's Avatar
    Join Date
    Jun 2002
    Location
    Ohio
    Posts
    5,245
    Mentioned
    156 Post(s)
    Tagged
    1 Thread(s)
    That are a variety of things that could be done, one RDP (Remote Desktop) over VPN to get you internal access to install LAMP and get it setup (deployments may need to be handled differently, sending the client the code and let them deploy it for example).

    I also agree that phpMyAdmin is likely unnecessary and as @aaarrrggh ; pointed out, it could be taken as a security risk.

    From an Intranet perspective, you'd have to see what they use for authentication. Do they use Active Directory? Another tool? Can you integrate with it through a service? Also seeing phpinfo() will be of great help to you! I know there is a variable that has the username of the user in it, you'll then have to figure out how to validate that.

    You may even want to install PHP on IIS (if they are a Windows shop), but I digress, that decision would need to happen between you and the client.

  4. #4
    SitePoint Enthusiast
    Join Date
    Apr 2004
    Location
    york
    Posts
    42
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks guys - some very useful stuff there. I will look into the ssh side in more depth.

  5. #5
    Non-Member
    Join Date
    Oct 2007
    Posts
    363
    Mentioned
    11 Post(s)
    Tagged
    0 Thread(s)
    For database administration, try looking into a program like navicat. It can connect to your database via an ssh tunnel, which means so long as you have ssh access and the database username and password details, you can connect to the database as if you were locally connected to the machine, and you can do it without leaving a big security hole open such as phpmyadmin.

    Navicat for mysql: http://www.navicat.com/en/products/n..._overview.html

    The best way to learn how to setup a server via ssh is probably to setup a virtual machine for yourself and play around with it. There are loads of tutorials and information available online that will take you through the whole process step by step.

  6. #6
    Always A Novice bronze trophy
    K. Wolfe's Avatar
    Join Date
    Nov 2003
    Location
    Columbus, OH
    Posts
    2,182
    Mentioned
    67 Post(s)
    Tagged
    2 Thread(s)
    Quote Originally Posted by aaarrrggh View Post
    For database administration, try looking into a program like navicat. It can connect to your database via an ssh tunnel, which means so long as you have ssh access and the database username and password details, you can connect to the database as if you were locally connected to the machine, and you can do it without leaving a big security hole open such as phpmyadmin.

    Navicat for mysql: http://www.navicat.com/en/products/n..._overview.html

    The best way to learn how to setup a server via ssh is probably to setup a virtual machine for yourself and play around with it. There are loads of tutorials and information available online that will take you through the whole process step by step.
    Also worth note: https://www.webyog.com/ and free: http://dev.mysql.com/downloads/tools/workbench/


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •