| Question: |
Hi guys! Thanks again for Your work! I have a question for You about the backup database. I would like to configure a third-party client which it downloads automatically and saved on my computer or in the cloud. A database grows and becomes scary, You know. Tried to configure the client but it will not connect to the database. Your IP added to the trusted list. Tell me, is this possible to implement? What data is to drive the input? Thank you |
| Answer: |
Hello there are two options Ustinovka script which you`ll be sozdati dump and budete to download the file , or remote connection but only with static ip with a dynamic ip we available open. |
| Question: |
well it is clear) and open the access for 195.151.21.177 |
| Answer: |
IP address added to the trusted |
| Question: |
Can`t login, the server name so http://185.47.54.91: localhost:3306 name: greendelПравильно? |
| Answer: |
the Question referred to the administrator, wait for amp. |
| Answer: |
how do you connect? bring all the data |
| Question: |
In the SQLBackupandFTP program put the name of the server http://185.47.54.91: localhost:3306имя: greendelпароль as the entrance to the host |
| Answer: |
why http://185.47.54.91 ? and why localhost ? localhost for you is your computer here sauceman clear what you are connecting to the server or from computerw |
| Question: |
Well, I don`t know of this issue and asked for help. You are a smart man in this area, I need to make a backup of the database in automatic mode once a week or a month(no service) from your server and stored on your computer, I in the first message wrote that I need. If this cannot be done or can be done only differently, tell me. I won`t distract You. Thank you |
| Answer: |
we have database backups done daily in an automatic mode. where you used timpanometry that you cited? |
| Question: |
The program SQLBackupandFTP |
| Answer: |
show the screenshot of the settings. the first time we hear about such a program. |
| Question: |
sent in the mail |
| Answer: |
what mail? we do not work with mail upload to this site or to the hosting of images, for example piccy.info |
| Question: |
http://i.piccy.info/i9/eb71015a990d41f645facb13b82e790c/1473423510/307399/1068476/Podderzhka.png |
| Answer: |
server name - specify your domain dannymasterson specify the database user name and his password |
| Question: |
http://i.piccy.info/i9/bc0f33842d67bdd066bf8040f6c99494/1473425301/307039/1068476/Podderzhka.png |
| Answer: |
in the authorization indicate the name of the database user and his password/ you have not yet specified |
| Question: |
pointed greendel_admin also not working |
| Answer: |
check carefully the password |
| Question: |
checked |
| Answer: |
add hotelnovotel for backup |
| Question: |
added all the same |
| Answer: |
show me what |
| Question: |
http://i.piccy.info/i9/763f08614db54c2fad11fa17aa7ff991/1473428006/827616/1068476/Podderzhka.png |
| Answer: |
from what ip you connect? |
| Question: |
195.151.21.177 |
| Answer: |
this is a static ip? |
| Question: |
Yes |
| Answer: |
please Check now.
|
| Question: |
Checked, no change |
| Answer: |
this can not be give all the connection details in the ticket |
| Question: |
website: mfksummit.gipals: greendel_backupпароль: Greenday321@@@ |
| Answer: |
user greendel_user password mfksummit the server 185.47.54.90 try |
| Question: |
Thanks for the help but I left work already, on Monday I will unsubscribe |
| Answer: |
ok
|
| Question: |
Welcome! Cannot connect still |
| Answer: |
how do you connect? from what ip? |
| Question: |
My IP: 195.151.21.177 Location: iso Russian Federation (RU), N/A ISP: LLC Equant Host: N/A OS: Win7 Browser: Firefox 48.0 |
| Answer: |
what you enter and what error you see? |
| Question: |
http://i.piccy.info/i9/943db83d640d6756ce1cf0b705b4ed4d/1473665278/313645/1068476/Podderzhka.png |
| Answer: |
please Check now.
|
| Question: |
not working, screen is the same |
| Answer: |
should work, checked proverit Yong to block your firewall or ISP. |
| Question: |
Eugene to check this out, I`ll have to write a big long letter and to wait from the Central office, I suspect that it can block iron which stands between me and my provider, and I`ve got to distract You. If I can`t turn off power(if it is), I will dump to do it manually( . And thank You for the help |
| Answer: |
try to execute in console konadu telnet 185.47.54.90 3306 |
| Question: |
N 5.5.50-cllп╡F,F^%=D{!☻And§cZ{|zsQ{9F5umysql_native_password |
| Answer: |
this command? |
| Question: |
Yes |
| Answer: |
the question referred to the administrator, wait for amp. |
| Question: |
If it helps You as тоTesting the connection to Microsoft SQL Server.Microsoft.SqlServer.Management.Common.ConnectionFailureException: Failed to connect to server 185.47.54.90:3306. ---> System.Data.SqlClient.SqlException: While establishing a connection to SQL Server error a network-related or instance specific. Server not found or unavailable. Verify that the instance name is specified correctly and that on a SQL Server remote connections are allowed. (provider: SQL Network Interfaces, error: 25 - invalid connection string) ---> System.ComponentModel.Win32Exception: the Parameter is incorrect --- End of stack trace of inner exception --- System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) in System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) in System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) in System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) in System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) in System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) in System.Data.SqlClient.SqlConnection.Open() in Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnect(WindowsIdentity impersonatedIdentity) to Microsoft.SqlServer.Management.Common.ConnectionManager.Connect() --- End of stack trace of inner exception --- at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect() at Microsoft.SqlServer.Management.Common.ConnectionManager.PoolConnect() in Microsoft.SqlServer.Management.Common.ConnectionManager.get_DatabaseEngineType() in Microsoft.SqlServer.Management.Smo.Server.GetExecutionManager() in Microsoft.SqlServer.Management.Smo.SqlSmoObject.get_ServerVersion() in Microsoft.SqlServer.Management.Smo.Server.get_Version() mssqlcmd.Program.connect()SQL server connection Error |
| Answer: |
odite amps. |
| Answer: |
check carefully whether the ip you have told us. |
| Question: |
Eugene, I salute You! The Ip we have highlighted and that`s it, but I already had this topic. Yesterday I tried to put the script, where the main theme is that he makes a backup and sends it to Yandex disk. Is perfect for me, nothing that is not necessary, and burst to the base from the outside too, in fact do not see the point. Here if you achieve to make it work then I`ll be happy as a clam. I have a question how to make a script .sh is executable. To Linux it was launched, and the fact that I got yesterday, he has not earned. Understand what has got You this theme but I need to close the question and forget about the service on the host, so that everyone is happy in fact. |
| Answer: |
ustnovit him Parva 755 in the file Manager pane |
| Question: |
I`ve already done that, now get to work and I will dig further, I`ll try not to pull and in General thanks for the help. |
| Answer: |
you can run it through the cron job. if you have any questions always ask. You have not pulled, that`s our job . |
| Question: |
Eugene, can I ask for the crown? the line I apparently did not write the correct /usr/bin/bash /home/greendel/public_html/backup-ya-disk-mfksummit.sh I wrote the report /usr/local/cpanel/bin/jailshell: /usr/bin/bash: No such file or directory |
| Answer: |
just specify /home/greendel/public_html/backup-ya-disk-mfksummit.sh |
| Question: |
And so Eugene, in the end, everything is fine thanks to Your help! Came database files on Yandex disk, however the subsequent is not going fix Yandex. Perhaps this is due to the fact that the script does not substitute the files with the same name and writes an error, put it on once a day at 6.00 am(if these hours are loaded , say at what hour do I configure CZK), tomorrow we`ll see. It turned out what I wanted. Still under the mood of CZK probably only to weekdays worked. You and a huge Thank you!!! Well, as a suggestion maybe consider this feature to backup on to the POISON for inclusion in the main software(which I can see visibly diverse which is nice), certainly come across such as I am, or will fall in the future with similar goals. |
| Answer: |
Your wish we will give programmers CZK think it is better to migrate for 4-5 hours in the morning. |
| Question: |
Hi guys! Back to the subject of backup. Can`t run script /var/www/greendel/data/www/mfksummit.ru/backup-ya-disk-mfksummit.sh Tell me where the interpreter is sh |
| Answer: |
slhfcndeqnt describe the problem in more detail. how do you launch? |
| Question: |
usr/bin/bash /var/www/greendel/data/www/mfksummit.ru/backup-ya-disk-mfksummit.sh |
| Question: |
write a task on behalf of the user ISP in the crown |
| Answer: |
Ukazat just sh /var/www/greendel/data/www/mfksummit.ru/backup-ya-disk-mfksummit.sh the file has to be executable. we must inform You that we have obnarujili a complaint on the server and all vps are paranasales to another physical server . will change ip |
| Question: |
and when is moving day? About the crown and did not work, says when you manually run Exited with return code = 2, the permissions on the file are 755 |
| Answer: |
the move is planned in the near future. we will notify UCAS when begin , |
| Answer: |
Hello. today we will be moving Your server to a new server. |
| Answer: |
Your new server 94.130.0.100 Panel 94.130.0.100:1500 |
| Question: |
Hi guys! Not going to bother You knowing that this hemorrhoids all these transfers. Now everything looked like working and it`s great! Even my backup script earned(special thanks). I understand we are now already on CentOS? And yet, me root access? (the answer is not necessarily now))). |
| Answer: |
Yes, and more new panel as root you Prazdny server 94.130.0.100 root yjhvgbgh7y |
| Question: |
until I realized but I do not work email notifications from the server and when a backup did shell I wrote a run-time error the functions of mailing , maybe to change something in the domain settings it is necessary?(but it seems it`s to do with). |
| Answer: |
please Check now.
|
| Question: |
Welcome! All you have is normal as I understand it. the reason was that Kron weekend work in half an hour(as configured in the system) but I forgot. Now checked, all normal like. And another question, are there errors in the server buffer writes about NGINX. Can it be increased?2017/05/14 01:05:02 [warn] 2457#2457: *605 an upstream response is buffered to a temporary file /var/cache/nginx/proxy_temp/1/05/0000000051 while reading upstream, client: 91.236.143.52, server: mfksummit.ru, request: \"GET /index.php?c=files&a=download_image&id=437&inline=1&modtime=1464875804 HTTP/1.1\", upstream: \"http://127.0.0.1:8080/index.php?c=files&a=download_image&id=437&inline=1&modtime=1464875804\" host: \"mfksummit.ru\", referrer: \"https://mfksummit.ru/index.php?c=access&a=index\"[Sun May 14 01:06:29.275884 2017] [cgi:error] [pid 28287] [client 91.236.143.52:48974] AH01215: sh: wkhtmltopdf: command not found, referer: https://mfksummit.ru/index.php?c=access&a=index |
| Answer: |
utochnyat where do you see these errors? |
| Question: |
In the error log of the domain mfksummit.ru user greendel |
| Answer: |
please Check now.
|
| Question: |
In my opinion everything is perfect! thank you, tomorrow our office will start working, will check everything and if something is not solved then unsubscribe. Have a nice day!!! |
| Answer: |
ok
|
