Database Errors

En curso Publicado Dec 8, 2012 Pagado a la entrega
En curso Pagado a la entrega

Hello,

We are currently finding a lot of problems with our servers.

We have a database error.

Also some videos do not play. For example when accessing this download link:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

you get this error message: Video not found or access denied: [url removed, login to view]

Also this is a message from another programmer who explains SOME of the problems below:

Hello Simon,

I found the problem. But first of all I let me tell you you a few thing about your servers.

You have clustered server setup. The site runs from one server ( wiredtree ) and files are stored on other different servers like [url removed, login to view], [url removed, login to view], [url removed, login to view], 208.53.158.8 etc. This is good because single server cannot handle streaming, upload/download of large files etc. it will crash.

Now the videos are not playing because files are missing on the server 67.159.60.25. All video files were sylinked to /home/v directory which I see is not present. So I just searched for for one of the video files and i found it in /home4/v , Then I changed the symlink to /home4/v and video [url removed, login to view] started playing fine.

So what I concluded is that files were previously present in /home/v but they were later moved and distributed between /home2/v , /home3/v and /home4/v and some files were deleted/missing. Now none of the disk has has enough space that files of all the harddisk can be moved to a single harddisk.

I can create symlinks to video files in /home2/v & /home3/v to /home/v/ respectively but it's not practically feasible because there are thousands of files. It may take even months.

Suggested Solution: I see nginx execute the script /usr/local/nginx/perl/[url removed, login to view] video file download url is requested. This script converts the url to internal file path and sends the requested file to client browser. So I suggest you to contact your developer and ask him to modify the script so that it automatically search for the file /home2/v, /home3/v and /home4/v and and sent them to the client browser.

-----------------------------------------------------------------------

Technical part

/var/www/cgi-bin/v was symlinked to /home/v which was not present

I changed symlink /var/www/cgi-bin/v to /home4/v and some videos started playing e.g. [url removed, login to view]

Rest of the files are either missing or present in /home2/v , /home3/v and /home4/v

All files cannot be moved to single partition because there is not enought disk space.

Symlink can only point to one folder or file. Which currently is pointing to /home4/v

-----------------------------------------------------------------------

Logs.

==================================================================

2012/09/15 11:00:59 [error] 28656#0: *2185099 open() "/var/www/cgi-bin/v/00035/h1yjke3te0tq" failed (2: No such file or directory), client: [url removed, login to view], server: , request: "GET /d/oricxwfnes7krho6x3h4puvbng5yncuboerutcjcdothmgf6kc5dai5a/[url removed, login to view] HTTP/1.1", host: "[url removed, login to view]"

Regards, [url removed, login to view]

Administración de bases de datos PHP Arquitectura de software

Nº del proyecto: #4022932

Sobre el proyecto

6 propuestas Proyecto remoto Activo Dec 8, 2012

Adjudicado a:

onready

I am ready and available.

$500 USD en 3 días
(39 comentarios)
5.1

6 freelancers están ofertando un promedio de $413 por este trabajo

emiliandobre

Hello, Looking forward to be of help. Please check private message.

$250 USD en 0 días
(20 comentarios)
3.3
basutechnohub

Dear Hiring Manager, Looking for quality work, Please check your mailbox here, for our detailed bid. Thanks and regards, Basu Techno Hub team

$350 USD en 7 días
(10 comentarios)
3.2
webdevit

php/mysql team

$600 USD en 5 días
(6 comentarios)
2.6
bsvin4113

Hi, I am sincerely read your requirements and are ready to endow with the solution as per your requirement. I can assure you that with the help of expert development team,I will provide you high level of satisfac Más

$500 USD en 10 días
(1 comentario)
1.1