stream

July 21, 2012

Thank you for sharing knowledge!

March 3, 2012

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.

February 24, 2012

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=

February 23, 2012

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

February 23, 2012

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.

February 21, 2012

@ traxxus - Thank you.

Steps 5 to 8 is the missing ones for me.

So as I say the problem is mine :blink:

Very good and usefull tutorial. Thanks again!

February 21, 2012

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!

February 21, 2012

Can you explain please and thank you!

February 21, 2012

http://forum.uniformserver.com/index.php?s...ost&p=10152

February 21, 2012

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"

November 26, 2011

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.

November 25, 2011

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!

November 2, 2011

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!

July 20, 2011

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.

July 19, 2011

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!

July 11, 2011

Is there a way to perform UPGRADE from 7.1.0 to 7.1.2 without loosing any data and configuration?

Thank you in advance.

I mean an automatic way, no copy paste/replace, etc.

This feature will be good to implement.

July 7, 2011

Confirmed on Windows 7 SP1 x64 Enterprise the same error.

UniServer Orion 7.1.1

The tray icon is shown, but when I click Install and Run all Services nothing happen.

When I click Server status:

- Apache run status: Not running

- MySQL run status: Not Running

In Task Manager: Apache.exe is presented and mysqld-opt.exe too!

On Windows XP SP3 everythung is just fine.

July 6, 2011

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.

July 6, 2011

Can somebody provide FFMPEG support for UniServer.

Will be great to have abilities to test encode/decode.thumbnailing etc. on localhost!

Thank you in advance.

July 6, 2011

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!

Sign In

stream

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by stream

[FIX] Slow MySQL on Windows7

RQ: SQLite

Uniserver Security

AWStats for Coral?

Problem starting Apache

AWStats for Coral?

RQ: SQLite

AWStats for Coral?

Awstats

AWStats for Coral?

Help with port 80 and 443

FFMPEG Integration?

FFMPEG Integration?

RQ: IP Tables via CYGWIN or similar!

RQ: IP Tables via CYGWIN or similar!

UniServer Orion 7.1.0 to 7.1.2 - How to Upgrade?

Will not run in Windows Server 2008 R2 Datacenter

FFMPEG Integration?

FFMPEG Integration?

Awstats

Community