Results 1 to 5 of 5

Thread: LAMP & Joomla

  1. #1
    Join Date
    Dec 2008
    Location
    East of Eden (tx)
    Posts
    313

    Default LAMP & Joomla

    I want to thank this forum for the help they gave. The original goal of getting Apache 2, MySql and PHP running and successfully installing Joomla has been accomplished. Again, Thank everyone who helped.

    I now need someone to point me in the right direction again. Many of the things I did, I don't understand. Nor do I know how to administer and use the LAMP server(s) except as instructed in the Joomla tutorial.

    Everything is running on a single machine. localhost is the server for now. Here are my dumb newcomer questions:

    1) Is there a GUI interface for Apache, MySql and PureFTP administration? If not, how do I locate the files to create users, set passwords, and configure these servers? Are there any tutorials that are for the rank beginner? Where would I look for them?

    2) How do I see the tables, queries and relationships in MySql? It doesn't seem to "open" like Access or the Base application in OpenOffice. I know it is dumb, but could someone point me in the right direction?

    3) In setting up these servers (and Samba), I used the command line when I had explicit instructions about exactly what to do. How are all these files organized? How do I find (for example) the files needed to configure, secure and administer the FTP server?

    It is easy when someone tells me where to look but I need to know more than that. It seems that different Linux distributions put files in different places so explicit instructions are not always available for openSUSE 11. Can anyone recommend a good book or tutorial?

    How did all of you learn this stuff?

    Cordially,
    TwoHoot
    #1 - openSUSE Leap 42.3; AMD A6-3670; Radeon(tm) HD; 8gb memory; 500 gb HD; KDE 5.8.7
    #2 - openSUSE Leap 42.2; Toshiba Satellite L70-A (Dual Boot - Win10); KDE 5.8.3
    #3 - openSUSE Leap 42.3; AMD A6-6400K; Radeon HD; 8gb memory; 1tb HD; KDE 5.8.7

  2. #2
    Join Date
    Jun 2008
    Location
    UTC+10
    Posts
    9,686
    Blog Entries
    4

    Default Re: LAMP & Joomla

    I've never felt that Apache needed anything in the way of GUI administration. For MySQL I can recommend phpMyAdmin. No opinions on the others.

  3. #3
    martolvan NNTP User

    Default Re: LAMP & Joomla

    In my experience later versions of SuSE Linux are most easily managed by yast. Samba, http, named, dhcp, etc. are well manageable through yast. Pure ftp is though only one file in /etc/pureftp/pureftp.conf.
    How you learn this all? Frankly I have no idea, what I know is all acquired through lots of hacking and reading, and being more of an hardware than software guy I figured finally out that for majority of administrative tasks and configuration figuring out how to do that in yast is time well spent, that way you usually keep compatibility with patches etc.
    There is one thing to be aware of that is SuSE special that is extensive use of rc.config files that is split up in several files in /etc/sysconfig/ that wil probably at some point over ride configurations that are done outside of yast in file level configuration. But once you got the hang of how things tie together SuSE is an great distro even thoug you can find other comments.

    Good luck
    Stefan

  4. #4
    ab@novell.com NNTP User

    Default Re: LAMP & Joomla

    -----BEGIN PGP SIGNED MESSAGE-----
    Hash: SHA1

    1. There may be some, but I would have to restate the preference to use
    Yast for many of these operations. Some operations don't make sense in
    Yast, like extensive database administration, but I'll get to those. If
    you cannot do it in Yast then in typical *nix tradition the configuration
    files are mostly in /etc, for example in /etc/apache2 for the web server.
    For those applications that can be connected-to remotely (MySQL) you can
    use any client that you can find online. MySQL provides some of these
    like (from old memory) MySQL Administrator or MySQL Query Browser. I use
    neither on a day-to-day basis but typically prefer DB Visualizer (yes,
    there is a Linux versions.... joys of good cross-platform code) and
    otherwise use phpMyAdmin on the server itself.

    2. Again, DB Visualizer or MySQL-whatever or phpMyAdmin. The last one
    has been proven for years and years to be a great tool and it runs in the
    web browser you already have. DBVis is my new favorite because it works
    via JDBC with any database I can find that has JDBC connectivity (I
    haven't found one that I needed that didn't... so far.....).

    3. The last question about the FTP server was already answered but how do
    oyu learn all this stuff? The same way you did, but just before you did.
    Forums are a great source because they are customized to your questions
    (at least the answers can be as good as the questions, so bad questions
    beget bad answers.... garbage in garbage out) and come from those who know
    and who usually have a desire to share for one reason or another. In my
    case I want others to succeed in getting their systems to just work as
    well as possible and I believe Linux can do that for anybody so I try to
    give back as I can. Most of the others who are in here probably have
    their own reasons but in any case we learn the same way we teach when it
    comes to forums.

    Other sources of information like IRC have been around for years and are
    also customized in each "channel" to a topic (#linux, #php, #mysql, etc.)
    though the application-specific channels are probably not setup
    per-distribution like the OpenSUSE forums are. Going a bit further you
    always has the man pages which can be very informative. Wikis, 'info'
    materials (another command like 'man')... one nice thing about the Open
    world is that the information isn't usually locked away in books that are
    only available from the creators of the technology or those who have
    learned from those creators. If you want to learn how a product really
    works you can grab the source and find the answers directly and then
    document that, or improve upon it, to meet your own needs. Granted this
    isn't always the most-efficient method but at least it is there; freedom
    is a wonderful thing that you'll start to take for granted until you are
    forced into places where it is gone.

    Anyway enough of this post for now.

    Good luck.






    TwoHoot wrote:
    > I want to thank this forum for the help they gave. The original goal of
    > getting Apache 2, MySql and PHP running and successfully installing
    > Joomla has been accomplished. Again, Thank everyone who helped.
    >
    > I now need someone to point me in the right direction again. Many of
    > the things I did, I don't understand. Nor do I know how to administer
    > and use the LAMP server(s) except as instructed in the Joomla tutorial.
    >
    > Everything is running on a single machine. localhost is the server for
    > now. Here are my dumb newcomer questions:
    >
    > 1) Is there a GUI interface for Apache, MySql and PureFTP
    > administration? If not, how do I locate the files to create users, set
    > passwords, and configure these servers? Are there any tutorials that are
    > for the rank beginner? Where would I look for them?
    >
    > 2) How do I see the tables, queries and relationships in MySql? It
    > doesn't seem to "open" like Access or the Base application in
    > OpenOffice. I know it is dumb, but could someone point me in the right
    > direction?
    >
    > 3) In setting up these servers (and Samba), I used the command line
    > when I had explicit instructions about exactly what to do. How are all
    > these files organized? How do I find (for example) the files needed to
    > configure, secure and administer the FTP server?
    >
    > It is easy when someone tells me where to look but I need to know more
    > than that. It seems that different Linux distributions put files in
    > different places so explicit instructions are not always available for
    > openSUSE 11. Can anyone recommend a good book or tutorial?
    >
    > How did all of you learn this stuff?
    >
    > Cordially,
    > TwoHoot
    >
    >

    -----BEGIN PGP SIGNATURE-----
    Version: GnuPG v2.0.9 (GNU/Linux)
    Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

    iQIcBAEBAgAGBQJJ30bNAAoJEF+XTK08PnB5KLMP/0mp6hj8NhYwGSL6crti395v
    dPo+LxG/4LTH362py4Ps4jwTPM+UL0R29daQ/JEEgabmOd2OnqDlLKcWcauf947c
    SzhqgKLxK2Ve1JpCB7zC+LePZSr6GWrh9GyK/OiJv/cnI/WQqKudkZPil6UIKqOw
    vQSjNo5KUir64+CgJYhp99mayyyMAa4vx/y4+QiScnU7oFwY5xRN+iZMactXhUOm
    zjJDlZMBgXU1OMBS5aLMQ0if0pyLs1A0hH2UYg+zxfbM5BH4c+v5Bc8vAVp2JFz2
    Bu4c17caAZKUiWA8rsp/3JUwADvoHgLe6/Je9NZPeYAk29u6UDkxBFI+YIAga84N
    RzpQStttHt6Oa/lZ/zKD5WO8F4rUi+sHxosnAAaKAgEvqUF9MgRhpXQ7lKRFcV46
    heTjFS9t5+0npYBosq+fRu8sGggrlvUHNEsxV1Nje9pYOhXnOLCKktjCsnDty7KD
    vXSF0Ze1ZXKWB/qCIad0MnJDr87vw76DN1pqfv/dr8DiQbzmE9VnS0MY2KYjbX5+
    DdqsC5L6BGEXAlK298/OejHEzfPBMVKd4ZbaFyqymCnglqlOwO0AdovBcyoJlYYM
    6UQMTQ2SDsbCPm1nh5Fx/ooMJjzuZ12L4Kc2UQ5cwFJTjvSHihONQ9ZdSOql4s+7
    FaWcmYf9IZXO8lssZ4FD
    =jAmw
    -----END PGP SIGNATURE-----

  5. #5
    Join Date
    Dec 2008
    Location
    East of Eden (tx)
    Posts
    313

    Default Re: LAMP & Joomla

    Thank You.

    Cordially,
    TwoHoot
    #1 - openSUSE Leap 42.3; AMD A6-3670; Radeon(tm) HD; 8gb memory; 500 gb HD; KDE 5.8.7
    #2 - openSUSE Leap 42.2; Toshiba Satellite L70-A (Dual Boot - Win10); KDE 5.8.3
    #3 - openSUSE Leap 42.3; AMD A6-6400K; Radeon HD; 8gb memory; 1tb HD; KDE 5.8.7

Posting Permissions

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