Jump to content
The Uniform Server Community


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

1 Follower

About stream

  • Rank
    Junior Member

Previous Fields

  • Main OS
    Windows XP
  1. stream

    RQ: SQLite

    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 Edit in httpd.conf You can access SQLite Manager via Web Browser at: 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 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 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!
  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 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. @ traxxus - Thank you. Steps 5 to 8 is the missing ones for me. So as I say the problem is mine Very good and usefull tutorial. Thanks again!
  6. Dear DevTeam, can you plan integration of SQLite DB and of course web management as phpMyAdmin, but named SQLiteManager all under GPL I'm sure, many of us here will be glad if you make it for us. Thank you in advance!
  7. Can you explain please and thank you!
  8. stream


  9. 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: 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"
  10. 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.
  11. 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 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 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!
  12. 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!
  13. 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: Sorry for my English, but .... your right that this is good to put in WiKi for discussion! Thanks again.
  14. 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!
  • Create New...