Jump to content
The Uniform Server Community

stream

Member
  • Content Count

    20
  • Joined

  • Last visited

Posts posted by stream


  1. Dear DevTeam,

    after no answer I'll give HowTo I run it myself.

     

    First you'll need latest available version of SQLiteManager 1.2.4 it's FREE!!!

     

    and the latest SQLite 3.7.10

     

    Extract the archive to C:\UniServer\home\Sqlitemanager

     

    Edit in php.ini

     

    ....

    ;extension=php_pdo_pgsql.dll

    extension=php_pdo_sqlite.dll

    ;extension=php_pgsql.dll

    ....

    ;extension=php_sockets.dll

    extension=php_sqlite.dll

    ;extension=php_sqlite3.dll

    ....

     

    Edit in httpd.conf

     

    Alias /test_access "C:/UniServer/home/access/www/"

    <Directory "C:/UniServer/home/access/www/">

    Order allow,deny

    Allow from all

    </Directory>

     

    Alias /sqlite "C:/UniServer/home/Sqlitemanager"

    <Directory "C:/UniServer/home/Sqlitemanager">

    Options All

    AllowOverride AuthConfig

    Order allow,deny

    Allow from All

    </Directory>

     

    You can access SQLite Manager via Web Browser at: http://127.0.0.1/sqlite/index.php or http://localhost/sqlite/index.php

     

    In bold I put what need to change to give both SQLite and SQLiteManager (like phpMyAdmin is web based)

     

    Can somebody test and give me feedback and of course need to secure it via .htaccess (need help here) ???

     

    Thanks in advance!

     

    N.B. Smarty 3.1.8 as template engine will be good too to be added in my opinion and giant step with others WAMP competitors!

    ...and will be more useful for Web Developers.


  2. Use .htaccess and block it

    Deny from 200.195.156.242

    and voila.

    Everyday I make LOG check and put a lot of IP's which are using some bot to scan the server for vulnerabilities and exploits. Good configured and maintained server is too hard to hack of course if 0-day exploit was not found.

    I reccomend using .htaccess because no one as I know can pass that type of security :blink:

    Another thing is to gain access ONLY to IP's on which you trust and DENY from all :)

    Enjoy!

     

    I ask before for that type of functionality which I'll appreciate to see in future releases.

    http://forum.uniformserver.com/index.php?s...ic=2293&hl=


  3. OS: MS Windows XP SP3 Pro

    Uniserver 7.1.5 Orion - working just fine

    Following the steps provided here exactly w/o success!

    [Thu Feb 23 18:19:21 2012] [notice] Apache/2.2.22 (Win32) PHP/5.3.10 DAV/2 configured -- resuming normal operations

    [Thu Feb 23 18:19:21 2012] [notice] Server built: Jan 26 2012 14:02:59

    [Thu Feb 23 18:19:21 2012] [notice] Parent: Created child process 5040

    [Thu Feb 23 18:19:22 2012] [notice] Child 5040: Child process is running

    [Thu Feb 23 18:19:22 2012] [notice] Child 5040: Acquired the start mutex.

    [Thu Feb 23 18:19:22 2012] [notice] Child 5040: Starting 250 worker threads.

    [Thu Feb 23 18:19:22 2012] [notice] Child 5040: Starting thread to listen on port 80.

    [Thu Feb 23 18:19:32 2012] [error] [client 127.0.0.1] (OS 3)The system cannot find the path specified. : couldn't create child process: 720003: awstats.pl

    [Thu Feb 23 18:19:32 2012] [error] [client 127.0.0.1] (OS 3)The system cannot find the path specified. : couldn't spawn child process: C:/UniServer/cgi-bin/awstats/awstats.pl


  4. Same issue here after upgrading to Coral 8.X.X

    Everytime when starting Apache as Service and crash unexpected w/o any entry in the LOG files or in event viewer.

    That new Unitray is a crap!

    The new Coral interface with this HTA crap is really annoying.

     

    I'll try on many MS Windows XP SP3 Pro machines w/o success.

    I revert back to 7.1.15 Orion with old, but gold BAT files which is more stable and upgrade all components to it's current state without issues.

    I prefer to work with OLD, but in times faster and stable.

    As I see I'm NOT the only one which experience that problems.

    http://forum.uniformserver.com/index.php?showtopic=2482#

     

    My opinion is that the DevTeam must provide support (update package) for users which still uses the Orion versions.

    In next week I'll provide a link with updated version of UniServer Orion 7.1.15 which will include the following:

    Apache 2.4.1

    MySQL 5.5.21

    PHP 5.3.10

    phpMyAdmin 3.4.10.1

    OpenSSL 1.0.0g

    ActivePerl via Installer

    AWStats 7.0

    FFMPEG Zeranoe Windows Builds

    ffmpeg-php for PHP 5.3.10 from sergey89

    FileZilla FTP

    I'll be very happy if the DevTeam make an upgradeable pack for Orion.

    Thanks.


  5. Current version of AWStats is 7.0

    http://awstats.sourceforge.net/

    I try to use version 7.0 without success, I'm sure the problem is mine, but installing 6.9 and using the module provided in the WiKi I can confirm is working, so I can access it:

    http://127.0.0.1/cgi-bin/awstats/awstats.pl

    I just edit the config file of AWStats - awstats.conf adding the full path to Apache access log file.

    LogFile="C:/UniServer/usr/local/apache2/logs/access.log"


  6. Are you using TeamViewer as Host Service?

    If yes go to TeamViewer icon right click on it go to Options->Advanced and scroll down till found: Don't use incoming ports 80 and 443 (recomended to web servers only) and tick the box.

    Save and Exit and now this ports are free.


  7. Example ffmpeg-screenshot-grabber.php

    (save the code as is w/o modification except the path to ffmpeg, etc.)

    While running form PHP you need to provide full path, eg: C:/UniServer/usr/local/bin/ffmpeg/bin/ffmpeg.exe rather than just exec('ffmpeg')

     

     

    <?php
    if (empty($_GET['video_name'])){
    echo 'error';
    }
    else{
    $video_name = $_GET['video_name'];
    $video_ext = $_GET['video_ext'];
    }
    
    // *nix ffmpeg path/usr/sbin/ffmpeg
    // put the relative path to the ffmpeg.exe file for windows
    $ffmpeg = 'ffmpeg\ffmpeg';
    
    // the input video file
    $video  = $video_name.$video_ext;
    
    // where you'll save the image
    // define the output file
    $image  = 'thumbs/'.$video_name.'.jpg';
    
    // specify the time to get the screen shot at (can easily be randomly generated)
    // default time to get the image
    $second = 15;
    
    // get the duration and a random place within that
    
    $cmd = "$ffmpeg -i $video 2>&1";
    exec($cmd);
    if (preg_match('/Duration: ((\d+):(\d+):(\d+))/s', `$cmd`, $time)) {
    $total = ($time[2] * 3600) + ($time[3] * 60) + $time[4];
    $second = rand(1, ($total - 1));
    }
    
    // get the screenshot
    // finally assemble the command and execute it
    $cmd = "$ffmpeg  -itsoffset -$second  -i $video -vcodec mjpeg -vframes 1 -an -f rawvideo -s 720x480 $image";
    //$return = `$cmd`;
    exec($cmd, $output);
    
    ?>
    

     

    Thanks to the author from here

     

    You'll need to make additional modification on your php.ini to accept larger files and to be able the scripts to work property, as described below:

     

    Edit your php.ini configuration file

     

    ;;;;;;;;;;;;;;;;;;;

    ; Resource Limits ;

    ;;;;;;;;;;;;;;;;;;;

     

    max_execution_time = 6000 ; Maximum execution time of each script, in seconds

    max_input_time = 6000 ; Maximum amount of time each script may spend parsing request data

    memory_limit = 128M ; Maximum amount of memory a script may consume (16MB)

     

    ;;;;;;;;;;;;;;;;;

    ; Data Handling ;

    ;;;;;;;;;;;;;;;;;

     

    ; Maximum size of POST data that PHP will accept.

    post_max_size = 1024M

     

    ;;;;;;;;;;;;;;;;

    ; File Uploads ;

    ;;;;;;;;;;;;;;;;

     

    ; Maximum allowed size for uploaded files.

    upload_max_filesize = 1024M

     

    If you wish additional tunning on your dev encoder server you'll need to modify the .htaccess file too with the following sample settings:

     

    .htaccess

    AddType video/ogg .ogv .ogm .ogg

    AddType audio/ogg .oga .ogg

    AddType video/mp4 .mp4

    AddType video/webm .webm

    AddType video/x-m4v .m4v

    AddType text/x-vcard .vcf

     

    php_value max_execution_time 6000

    php_value upload_max_filesize 1024M

    php_value post_max_size 1024M

    php_value memory_limit 128M

     

    We will add additional tools for maximum compatibility and production.

     

    1. We are using great utility called MP4Box from the gpac package (http://gpac.sourceforge.net/) for post-processing.

    The post processing is necessary because ffmpeg stores the moov-atoms (video meta information) in the end of the file, however, this data needs to be stored at the beginning to give the users the ability to seek the video until it fully loaded. MP4Box moves them at the beginning and processes the file making him match all the required standards and appropriate for streaming through the module.

     

    Sample MP4Box usage:

     

    MP4Box -add temp.mp4 output.mp4

     

    2. The other tool is FLVMeta (http://code.google.com/p/flvmeta/)

     

    It can be used as replacement of flvtool2, but in my opinion it can do some things better that flvtool2.

    You can remux a MP4/M4V video file to a injected FLV video file.

    It's important to know that your MP4/M4V video file HAS to be encoded using H.264 for video and AAC for audio.

    The command for inject the FLV Metadata is very easy, it requires only two parameters, the input and the output file without any flag, here is the command:

     

    flvmeta input.flv injected_output.flv

     

    3. Another great tool that we use for full HTML5 and Open Source compatibility is ffmpeg2theora - http://v2v.cc/~j/ffmpeg2theora/index.html

    With this piece of software we can convert our files to OGV file format.

     

    I'll explain the integration steps above later or soon depends how free time I have ;)

     

    Later I'll share (some day) how to prepare the encoder script which will convert some video files from one format to another and how-to make a page with flash fallback html5 player to playthe video file to all devices compatibility :)

     

    Some people around me asking me why you share that knowledge it's lost of money? - so my answer is simple:

    Knowledge is power and must be free so share it!


  8. Here I will write how to I make FFMPEG + FFMPEG-PHP to work in Uniform Server

     

    later I will include Mencoder + Codecs + FLVTool2

    This guide is for x86 systems NOT for x64!!!

     

    A little explain:

    ffmpeg-php.dll and ffmpeg.exe are NOT the same thing. ffmpeg-php is used to talk to ffmpeg.exe through php scripting.

     

    FFMPEG

    http://sourceforge.net/projects/mplayer-win32/files/FFmpeg/

    http://ffmpeg.zeranoe.com/builds/

    (download the archive)

     

    MENCODER (still researching this)

    http://sourceforge.net/projects/mplayer-win32/files/

    (download the archive)

     

    CODECS FOR MPLAYER (still researching this)

    http://www1.mplayerhq.hu/MPlayer/releases/...al-20071007.zip

    (download the archive)

     

    PHP-FFMPEG

    http://sergey89.ru/files/ffmpeg-php/

    (download the archive incl. support for PHP 5.3.X)

     

    Extract all the files you have download in separate folders in a temp directory.

     

    Stop all running instances of the server!!!

     

    1) copy ffmpeg to C:\UniServer\usr\local\bin\ffmpeg (you can choose any path)

    2) copy mencoder to C:\UniServer\usr\local\bin\mencoder (you can choose any path)

    3) copy mplayer codecs in C:\UniServer\usr\local\bin\mencoder\codecs (all the codecs should be in that codecs folder of mencoder)

    4) copy all php-ffmpeg to %SystemRoot%\system32\ and php\ext (extension folder)

     

    Copying avcodec.dll & avformat.dll and any other *.DLL in package to the %SystemRoot%\system32\

    (C:\windows\system32)

    Copying php_ffmpeg.dll to the PHP5 Extensions path.

    (C:\UniServer\usr\local\php\extensions)

     

    5) open php.ini and add extension=php_ffmpeg.dll

    php.ini is located in C:\UniServer\usr\local\php

    The line need to look something like this:

    ;extension=php_fileinfo.dll
    extension=php_ffmpeg.dll
    extension=php_gd2.dll

     

    6) Restart web server and go to the admin panel.

    Click phpinfo() from the left side and scroll down and look for this between exif and filter

     

    ffmpeg
    
    ffmpeg-php version	0.6.3
    ffmpeg-php built on	Jul 12 2011 03:54:13
    ffmpeg-php gd support	enabled
    ffmpeg libavcodec version	Lavc52.72.2
    ffmpeg libavformat version	Lavf52.64.2
    ffmpeg swscaler version	SwS0.11.0
    
    Directive	Local Value	Master Value
    ffmpeg.allow_persistent	0	0
    ffmpeg.show_warnings	0	0

     

    Voila ;)

     

    7) Make sure the path to ffmpeg is set to be like this one:

    // Set our source file
    $ffmpegpath = "C:/UniServer/usr/local/bin/ffmpeg/bin/ffmpeg.exe";
    $flvtool2path = "C:/UniServer/usr/local/bin/flvtool2/flvtool2.exe";
    $input = 'file.flv';
    $output = 'file.jpg';

     

    N.B. I need help to make the path relative and NOT absolute!


  9. Thank you for your reply!

    It's true, but I think that adding some patterns in Apache (NOT IPTABLES) will good idea, as descibed in Cheyenne project.

    This bots make me crazy, yes it's true it's NOT a production server, but I really want to have security at level up :(

     

    As described here:

    New config keyword in global section: block. It will drop client connection if some given attack patterns are found in the request (usually on request line).

    Examples:

    block "w00tw00t"

    block [

    "php"

    "w00tw00t"

    "/admin"

    ]

     

    When one of the patterns is detected, the connection is closed at once, no response is sent back to client. Additionnaly, you can add the 'ip-host keyword in block argument list to block all requests using an IP address in Host header instead of a valid domain. This is, almost every time, the signature of a web scanner.

     

    Examples:

    block ip-host

    block [

    "php"

    "w00tw00t"

    ip-host

    ]

     

    Sorry for my English, but .... your right that this is good to put in WiKi for discussion!

    Thanks again.


  10. Dear community,

    can you thing if it's good idea to implement an Advanced Firewall like *nix IPTABLES.

    What I mean is using cygwin or another thing to use an IPTABLES, because IPTABLES really rules.

    Yesterday when I take a look at LOGS in Apache I see w00tw00t trying to access the server so I shutdwon the server, put the IP that want to hack me in .htaccess deny, but at this moment I start to thing about the option to integrate something as IPTABLES.

     

    I'll really appreciate if it's possible, because using of functions as:

    Blocking string:

     

    iptables -I INPUT -d XXX.XXX.XXX.XXX -p tcp --dport 80 -m string --to 70 \ --algo bm --string 'GET /w00tw00t.' -j DROP

    where XXX.XXX.XXX.XXX represent YOUR IP!!!

     

    Using attack patterns in config will do the same, but I'm not a programmer. Something like:

     

    block ip-host
    		  block [
    			  "php"
    			  "w00tw00t"
    			  ip-host
    		  ]

     

    Thanks to http://cheyenne-server.googlecode.com for ideas and ipTables for the same.

     

    Good tutorial with example of this can be found here;

    http://spamcleaner.org/en/misc/w00tw00t.html

    or another good example can be found here:

    http://www.fail2ban.org/wiki/index.php/Main_Page

     

    I would like to thanks to the developers of this great piece of software that they provide to us!


  11. Right, but what I mean is FFMPEG + FFSERVER as PlugIn or something like that, but they need MinGW for Windows!

    http://ffmpeg.org/ffserver.html

    Exactly: Live Streams, VoD, Movie Catalog, etc.

     

    If it's possible to make a place where users can share code: For example I have a Movie Catalog with 3 type of options: View Internal NET, View External NET, Download (yes it's basic PHP + MySQL), but many users will be glad to copy and if modified or add additional options to post back.

    Something like this?

     

    Thank you in advance.


  12. Same here.

    When trying to install AWStats an Internal Server Error Occur

     

    Downloaded AWStats PlugIn

    http://sourceforge.net/projects/miniserver...Server_AWStats/

    and extract to \UniServer also tried \UniServer\udrive\

     

    Downloaded and Installed ActivePerl (ActivePerl-5.12.4.1205-MSWin32-x86-294981.msi) installed via:

    \UniServer\a_install_perl\extract_install_perl.bat w/o issues

     

    Left mouse click on UniTray, mouse over "Advanced" and select "Perl Shebang Update cgi-bin" - OK w/o issues

     

    http://localhost/cgi-bin/test.pl - "Hello World" displays OK

     

    http://localhost/cgi-bin/awstats/awstats.pl

     

    Internal Server Error

     

    The server encountered an internal error or misconfiguration and was unable to complete your request.

     

    Please contact the server administrator, admin@localhost and inform them of the time the error occurred, and anything you might have done that may have caused the error.

     

    More information about this error may be available in the server error log.

     

    Can someone help?

     

    And in the LOG files:

    error.log

     

     

    [Wed Jul 06 20:33:43 2011] [error] [client 127.0.0.1] Premature end of script headers: awstats.pl

    [Wed Jul 06 20:33:43 2011] [error] [client 127.0.0.1] Can't locate strict.pm in @INC (@INC contains: C:/UniServer/usr/lib .) at C:/UniServer/cgi-bin/awstats/awstats.pl line 15.\r

    [Wed Jul 06 20:33:43 2011] [error] [client 127.0.0.1] BEGIN failed--compilation aborted at C:/UniServer/cgi-bin/awstats/awstats.pl line 15.\r

    [Wed Jul 06 20:33:47 2011] [error] [client 127.0.0.1] Premature end of script headers: awstats.pl

    [Wed Jul 06 20:33:47 2011] [error] [client 127.0.0.1] Can't locate strict.pm in @INC (@INC contains: C:/UniServer/usr/lib .) at C:/UniServer/cgi-bin/awstats/awstats.pl line 15.\r

    [Wed Jul 06 20:33:47 2011] [error] [client 127.0.0.1] BEGIN failed--compilation aborted at C:/UniServer/cgi-bin/awstats/awstats.pl line 15.\r

     

    Thank you in advance!

×
×
  • Create New...