Page 1 of 1

SqlLiteAdmin: how to add it to my xampp ?

PostPosted: 28. February 2018 15:16
by 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

Re: SqlLiteAdmin: how to add it to my xampp ?

PostPosted: 28. February 2018 21:57
by 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

Re: SqlLiteAdmin: how to add it to my xampp ?

PostPosted: 01. March 2018 07:58
by 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

Re: SqlLiteAdmin: how to add it to my xampp ?

PostPosted: 01. March 2018 10:18
by 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.

Re: SqlLiteAdmin: how to add it to my xampp ?

PostPosted: 01. March 2018 11:45
by 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.

Re: SqlLiteAdmin: how to add it to my xampp ?

PostPosted: 01. March 2018 15:33
by 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 ?