SqlLiteAdmin: how to add it to my xampp ?

[rappazf]

I have downloaded SqlLiteAdmin
https://www.phpliteadmin.org/download/

and would like to have it working with my xampp installation
I have just copied the unzip folder under my xampp installation

Code: Select all

C:\xampp\phpLiteAdmin

but when I try to follow a link from the index.php in the dashboard

Code: Select all

<a href="/phpLiteAdmin/phpliteadmin.config.php">phpLiteAdmin</a></li>

I got a file not found error

Thanks for any help
François

[Altrea]

By default the XAMPP Apache root directory for serving files is \xampp\htdocs\.
If you want to serve files from another subdirectory of \xampp\ you need tell Apache.
You need to define access rules for this new directory too.

If you want to get an idea how this can be made, simply search for all occurances of phpmyadmin in the file \xampp\apache\conf\extra\httpd-xampp.conf

[rappazf]

Thanks for replying !
The httpd-xampp.conf says

Code: Select all

   Alias /phpmyadmin "C:/xampp/phpMyAdmin/"
    <Directory "C:/xampp/phpMyAdmin">
        AllowOverride AuthConfig
        Require local
        ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var
    </Directory>

I tried

Code: Select all

   Alias /phpliteadmin "C:/xampp/phpLiteAdmin/"
    <Directory "C:/xampp/phpLiteAdmin">
        AllowOverride AuthConfig
        Require local
        ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var
    </Directory>

Which still gives a file not found.
I also tried

Code: Select all

   Alias /phpliteadmin "C:/xampp/phpLiteAdmin/"
    <Directory "C:/xampp/phpLiteAdmin">
        <IfModule php5_module>
          <Files "phpliteadmin.config.php">
             php_admin_flag safe_mode off
          </Files>
        </IfModule
        AllowOverride AuthConfig
        Require local
        ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var
    </Directory>

Which crash appache on start up
....
So there must be something more to change/add

François

[Nobbie]

The first try should be sufficient, maybe you have an issue with uppercase/lowercase (ALIAS is case sensitive, your ALIAS contains upper letters, the link does only contain lowercase letters). You also might have an issue with Windows rights management, which error code did you get? Also watch access_log and error_log for more information.

The second try contains a severe syntax error (which you should also find in the error_log), as " </IfModule" lacks the closing character ">". But as already said, your other try should work.

[rappazf]

Yes It was a problem with character case
In the phpLiteAdmin directory: I got
a config file: phpliteadmin.config.sample.php
and phpliteadmin.php

I now have this in httpd-xampp.conf

Code: Select all

    Alias /phpliteadmin "C:/xampp/phpLiteAdmin/"
    <Directory "C:/xampp/phpLiteAdmin">
        AllowOverride AuthConfig
        Require local
        ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var
    </Directory>

And I still have an error

New XAMPP security concept:
Access to the requested directory is only available from the local network.
This setting can be configured in the file "httpd-xampp.conf".

Renaming phpliteadmin.php to index.php does not remove the message, though I don't understand how appache can detect which file to load.
Commenting out Require local does not remove the error neither

F.

[rappazf]

I have done this
- renaming phpliteadmin.php into index.php

Set the entry in httpd_xamp.conf to

Code: Select all

    Alias /phpliteadmin "C:/xampp/phpLiteAdmin/"
    <Directory "C:/xampp/phpLiteAdmin">
        AllowOverride AuthConfig
        # Require local
        Require all granted
       # ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var
    </Directory>

It works but is it correct ?