Josh Marshall
99abd5ed05
Bugfix deleting a PostgreSQL database
...
Was just a typo
2020-01-09 00:52:10 +10:00
Anthony Rossbach
8f2fdfb8d3
Fixes for dumps of large databases
2019-04-08 21:47:22 -07:00
Serghey Rodin
b5874764a7
RACK911LABS.COM: safer mysql/pgsql query
2018-04-26 17:29:13 +03:00
dpeca
6b97f7394c
Determining is it MySQL or MariaDB in mysql_connect() func
2018-04-05 21:55:39 +02:00
Serghey Rodin
5556e03090
Merge pull request #989 from Skamasle/patch-10
...
Fix for mysql 5.7 when reset password
2017-12-28 16:06:35 +02:00
Serghey Rodin
aefc654922
Merge pull request #1267 from IStranger/master
...
fix db.sh for postgres 9.5+
2017-12-28 15:52:16 +02:00
Serghey Rodin
8aff5db015
delted unnecessary backslashes
2017-12-28 15:22:42 +02:00
G.Azamat
4868823057
fix db.sh for postgres 9.5+
...
fixed backup function for postgres 9.5+ (removed "-i" option)
2017-08-30 22:01:38 +05:00
Made I.T
25e96c3216
Fix for Databases size not updated.
...
https://forum.vestacp.com/viewtopic.php?f=10&t=13526#p57651
2017-03-15 08:50:41 +01:00
Skamasle
c1cbbd3eb4
Fix for mysql 5.7 when reset password
...
Whit mysql 5.7 when reset password db.conf not get updated because cant get new md5 hash
This will fix it
I not touch GRANT ALL queryes because all working fine whit that part and all passwords was changed, but maybe you want change it.
I see this bug may afect this function:
dump_mysql_database()
But I not know fot what is used grep -v "Grants for" > $grants
So I not touch it because not know how test it :)
2016-12-09 20:42:27 +01:00
Serghey Rodin
04d617d756
MySQL 5.7 support. Fixes #959 . Thanks Maks Skamasle!
2016-12-09 18:43:20 +02:00
dpeca
5d6c0137c1
Fix for: /usr/local/vesta/func/db.sh: line 390: [: : integer expression expected
...
Every night cron is sending email with subject: Cron <admin@host> sudo /usr/local/vesta/bin/v-update-sys-queue disk
And content of that email is: /usr/local/vesta/func/db.sh: line 390: [: : integer expression expected
This is a fix for that bug.
I guess mysql for some databases returns empty string for DB size, so this will handle that case.
2016-07-21 02:27:51 +02:00
Serghey Rodin
5d30b67fb1
refactoring: log_event(), is_format_valid()
2016-06-24 16:33:24 +03:00
Serghey Rodin
e05dca61a6
refactoring: log_event(), is_format_valid()
2016-06-09 16:55:35 +03:00
Serghey Rodin
1a1d333ea4
improved sql functions
2015-03-29 14:43:02 +03:00
Serghey Rodin
14c507685e
dump mysql database using --single-transaction
2015-01-11 20:34:04 +02:00
Serghey Rodin
840b12ce30
Aligned event logger calls with new formating
2014-12-09 23:47:44 +02:00
Serghey Rodin
9be508768a
send detailed mysql error if dump failed
2014-07-31 13:01:51 +03:00
Serghey Rodin
260cc5171a
delete database user
2013-10-28 17:56:27 +02:00
Serghey Rodin
861585bcca
removed unnecessary sed expr defenition
2013-10-27 13:54:31 +02:00
Serghey Rodin
a5714c10e6
removed empty string
2013-10-23 23:45:28 +03:00
Serghey Rodin
2dce1a5de4
updated error code table
2013-05-24 11:02:58 +03:00
Yonathan Dossow
104bfc2277
[db.sh] change -d to --inserts
...
the -d parameter was removed in pgsql 8.4
Signed-off-by: Yonathan Dossow <ydossow@inf.utfsm.cl>
2013-04-19 11:01:05 -03:00
Serghey Rodin
e23249a997
backup/restore procedure
2013-03-27 01:16:14 +02:00
Serghey Rodin
bbba9aeb34
web backup scheduler
2013-03-13 16:07:49 +02:00
Serghey Rodin
7113dd6625
email notification in case of failed backup
2013-03-07 14:00:57 +02:00
Serghey Rodin
2ce5290efc
fixed database disk space calculation
2012-12-13 09:57:39 +02:00
Serghey Rodin
fe7c4cb95c
dashes as valid character for mysql databases
2012-12-11 22:56:53 +02:00
Serghey Rodin
f79262da21
fixed database disk space calculation
2012-12-09 02:34:57 +02:00
Serghey Rodin
e9e3323c36
fixed mysql unsuspend bug
2012-12-01 11:25:40 +02:00
Serghey Rodin
4fffddddfb
fixed typo in rebuid script
2012-11-23 13:18:03 +02:00
Serghey Rodin
0aba6a267f
bug: delete user from database host
2012-10-09 11:54:37 +03:00
Serghey Rodin
3cec339748
sycned repo with current build
2012-07-13 12:26:58 +03:00
Serghey Rodin
9dd6022057
database add page
2012-06-20 16:58:16 +03:00
Serghey Rodin
46e0bc239b
mysql bugfix + updated rrd functions
2012-04-28 22:44:22 +03:00
Serghey Rodin
4b44937540
improved rebuilds
2012-04-05 17:19:59 +03:00
Serghey Rodin
f2133f9776
Refactoring stage VI (mail)
2012-04-03 22:08:48 +03:00
Serghey Rodin
fb40168aa3
Refactoring stage V (user)
2012-04-02 15:17:28 +03:00
Serghey Rodin
33717629f7
Refactoring stage III (db)
2012-03-27 23:08:44 +03:00
Serghey Rodin
4fa3013716
Refactoring stage III
2012-03-19 02:42:28 +02:00
Serghey Rodin
83196f310b
Refactoring stage I
2012-03-06 22:07:06 +02:00
