SqlLiteAdmin: how to add it to my xampp ?

Problems with the Windows version of XAMPP, questions, comments, and anything related.

SqlLiteAdmin: how to add it to my xampp ?

Postby rappazf » 28. February 2018 15:16

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
rappazf
 
Posts: 4
Joined: 28. February 2018 15:04
XAMPP version: 3.2.2
Operating System: windows 10

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

Postby Altrea » 28. February 2018 21:57

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
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 9202
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

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

Postby rappazf » 01. March 2018 07:58

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
rappazf
 
Posts: 4
Joined: 28. February 2018 15:04
XAMPP version: 3.2.2
Operating System: windows 10

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

Postby Nobbie » 01. March 2018 10:18

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.
Nobbie
 
Posts: 10345
Joined: 09. March 2008 13:04

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

Postby rappazf » 01. March 2018 11:45

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
 
Posts: 4
Joined: 28. February 2018 15:04
XAMPP version: 3.2.2
Operating System: windows 10

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

Postby rappazf » 01. March 2018 15:33

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 ?
rappazf
 
Posts: 4
Joined: 28. February 2018 15:04
XAMPP version: 3.2.2
Operating System: windows 10


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 56 guests