Category Archives: sadmin

sadmin

Docsis проблем с mib файловете

Днес гледам не иска да генерира конфигурационни файлове на модемите и какво да направя.

/usr/local/bin/docsis -e /etc/iptraff/172-16-30-18.cfg /tmp/authfile333333555 /tftpboot/172-16-30-18.bin

и гледам извежда следните грешки:

No log handling enabled -- turning on stderr logging
MIB search path: /root/.snmp/mibs:/usr/share/mibs/site:/usr/share/snmp/mibs:/usr/share/mibs/iana:/usr/share/mibs/ietf:/usr/share/mibs/netsnmp
Cannot find module (SNMP-FRAMEWORK-MIB): At line 9 in /usr/share/mibs/netsnmp/NET-SNMP-AGENT-MIB
Cannot find module (SNMPv2-SMI): At line 8 in /usr/share/mibs/netsnmp/NET-SNMP-MIB
Did not find 'enterprises' in module #-1 (/usr/share/mibs/netsnmp/NET-SNMP-MIB)
….

Cannot adopt OID in UCD-SNMP-MIB: laIndex ::= { laEntry 1 }
Cannot adopt OID in UCD-SNMP-MIB: laNames ::= { laEntry 2 }
Cannot adopt OID in UCD-SNMP-MIB: laLoad ::= { laEntry 3 }
Cannot adopt OID in UCD-SNMP-MIB: laConfig ::= { laEntry 4 }
Cannot adopt OID in UCD-SNMP-MIB: laLoadInt ::= { laEntry 5 }
Cannot adopt OID in UCD-SNMP-MIB: laLoadFloat ::= { laEntry 6 }
Cannot adopt OID in UCD-SNMP-MIB: laErrorFlag ::= { laEntry 100 }
Cannot adopt OID in UCD-SNMP-MIB: laErrMessage ::= { laEntry 101 }
Cannot adopt OID in NET-SNMP-AGENT-MIB: nsNotifyRestart ::= { netSnmpNotifications 3 }
Cannot adopt OID in NET-SNMP-AGENT-MIB: nsNotifyShutdown ::= { netSnmpNotifications 2 }
Cannot adopt OID in NET-SNMP-AGENT-MIB: nsNotifyStart ::= { netSnmpNotifications 1 }
/* Error: Can't find oid docsDevCpeIpMax.0 at line 49 */
encode_vbind: Unknown Object Identifier (Sub-id not found: (top) -> 1)
got len 0 value while scanning for SnmpMibObject
at line 49

Става ясно, че не зарежда MIB файловете.

По следния метод може да се провери от къде иска да ги зареди

net-snmp-config --default-mibdirs

/root/.snmp/mibs:/usr/share/mibs/site:/usr/share/snmp/mibs:/usr/share/mibs/iana:/usr/share/mibs/ietf:/usr/share/mibs/netsnmp

За да се инсталират mib файловете:

/etc/apt/sources.list

deb http://ftp.debian.org/debian/ squeeze contrib non-free
deb-src http://ftp.debian.org/debian/ squeeze contrib non-free

apt-get update && apt-get install snmp-mibs-downloader

cp -Rvp /var/lib/mibs/ietf/* /usr/share/mibs/netsnmp/

За да заработи всичко просто се слагат необходимите custom(ако са) MIB-ове в папката и това е

Пускаме /usr/local/bin/docsis -e /etc/iptraff/172-16-30-18.cfg /tmp/authfile333333555 /tftpboot/172-16-30-18.bin
и всичко е ОК

"

##### Calculating CMTS MIC using TLVs:
Main
{
NetworkAccess 1;
BaselinePrivacy
{
AuthTimeout 10;
ReAuthTimeout 10;
AuthGraceTime 600;
OperTimeout 10;
ReKeyTimeout 10;
TEKGraceTime 600;
AuthRejectTimeout 60;
SAMapWaitTimeout 1;
SAMapMaxRetries 4;
}
/* CmMic 1e05591aab60de9ca0a96e977981469e; */
MaxCPE 2;
UsServiceFlow
{
UsServiceFlowRef 1;
QosParamSetType 7;
TrafficPriority 1;
MaxRateSustained 500000;
MaxTrafficBurst 8192;
MinReservedRate 0;
MinResPacketSize 64;
ActQosParamsTimeout 0;
AdmQosParamsTimeout 200;
MaxConcatenatedBurst 3044;
SchedulingType 2;
RequestOrTxPolicy 0x00000080;
IpTosOverwrite 0xfc00;
}
DsServiceFlow
{
DsServiceFlowRef 101;
QosParamSetType 7;
TrafficPriority 1;
MaxRateSustained 8000000;
MaxTrafficBurst 32000;
MinReservedRate 0;
MinResPacketSize 64;
ActQosParamsTimeout 0;
AdmQosParamsTimeout 200;
MaxDsLatency 0;
}
MaxClassifiers 20;
GlobalPrivacyEnable 0;
}
##### End of CMTS MIC TLVs
--- MD5 DIGEST: 0xa44b7547973c4e71a4ac0a521f37036f
Final content of config file:
Main
{
NetworkAccess 1;
MaxCPE 2;
MaxClassifiers 20;
GlobalPrivacyEnable 0;
BaselinePrivacy
{
AuthTimeout 10;
ReAuthTimeout 10;
AuthGraceTime 600;
OperTimeout 10;
ReKeyTimeout 10;
TEKGraceTime 600;
AuthRejectTimeout 60;
SAMapWaitTimeout 1;
SAMapMaxRetries 4;
}
UsServiceFlow
{
UsServiceFlowRef 1;
QosParamSetType 7;
TrafficPriority 1;
MaxRateSustained 500000;
MaxTrafficBurst 8192;
MinReservedRate 0;
MinResPacketSize 64;
ActQosParamsTimeout 0;
AdmQosParamsTimeout 200;
MaxConcatenatedBurst 3044;
SchedulingType 2;
RequestOrTxPolicy 0x00000080;
IpTosOverwrite 0xfc00;
}
DsServiceFlow
{
DsServiceFlowRef 101;
QosParamSetType 7;
TrafficPriority 1;
MaxRateSustained 8000000;
MaxTrafficBurst 32000;
MinReservedRate 0;
MinResPacketSize 64;
ActQosParamsTimeout 0;
AdmQosParamsTimeout 200;
MaxDsLatency 0;
}
CpeMacAddress 00:26:22:84:2f:21;
SnmpMibObject docsDevCpeIpMax.0 Integer 1 ;
SnmpMibObject docsDevCpeEnroll.0 Integer 1; /* none */
SnmpMibObject docsDevCpeStatus.172.16.30.18 Integer 4; /* createAndGo */
SnmpMibObject sysName.0 String "example.net" ;
SnmpMibObject sysContact.0 String "[email protected] amridikon and petkov" ;
SnmpMibObject docsDevNmAccessControl.1 Integer 3; /* readWrite */
SnmpMibObject docsDevNmAccessStatus.1 Integer 4; /* createAndGo */
SnmpMibObject docsDevNmAccessCommunity.1 String "mpetrovexample8718721738712387123" ;
SnmpMibObject docsDevFilterIpDefault.0 Integer 1; /* discard */
SnmpMibObject docsDevFilterIpControl.1 Integer 1; /* discard */
SnmpMibObject docsDevFilterIpIfIndex.1 Integer 0 ;
SnmpMibObject docsDevFilterIpDirection.1 Integer 3; /* both */
SnmpMibObject docsDevFilterIpBroadcast.1 Integer 2; /* false */
SnmpMibObject docsDevFilterIpSaddr.1 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpSmask.1 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpDaddr.1 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpDmask.1 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpProtocol.1 Integer 6 ;
SnmpMibObject docsDevFilterIpSourcePortLow.1 Integer 0 ;
SnmpMibObject docsDevFilterIpSourcePortHigh.1 Integer 65535 ;
SnmpMibObject docsDevFilterIpDestPortLow.1 Integer 135 ;
SnmpMibObject docsDevFilterIpDestPortHigh.1 Integer 139 ;
SnmpMibObject docsDevFilterIpStatus.1 Integer 4; /* createAndGo */
SnmpMibObject docsDevFilterIpControl.2 Integer 1; /* discard */
SnmpMibObject docsDevFilterIpIfIndex.2 Integer 0 ;
SnmpMibObject docsDevFilterIpDirection.2 Integer 3; /* both */
SnmpMibObject docsDevFilterIpBroadcast.2 Integer 2; /* false */
SnmpMibObject docsDevFilterIpSaddr.2 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpSmask.2 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpDaddr.2 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpDmask.2 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpProtocol.2 Integer 17 ;
SnmpMibObject docsDevFilterIpSourcePortLow.2 Integer 0 ;
SnmpMibObject docsDevFilterIpSourcePortHigh.2 Integer 65535 ;
SnmpMibObject docsDevFilterIpDestPortLow.2 Integer 135 ;
SnmpMibObject docsDevFilterIpDestPortHigh.2 Integer 139 ;
SnmpMibObject docsDevFilterIpStatus.2 Integer 4; /* createAndGo */
SnmpMibObject docsDevFilterIpControl.3 Integer 1; /* discard */
SnmpMibObject docsDevFilterIpIfIndex.3 Integer 0 ;
SnmpMibObject docsDevFilterIpDirection.3 Integer 3; /* both */
SnmpMibObject docsDevFilterIpBroadcast.3 Integer 2; /* false */
SnmpMibObject docsDevFilterIpSaddr.3 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpSmask.3 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpDaddr.3 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpDmask.3 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpProtocol.3 Integer 6 ;
SnmpMibObject docsDevFilterIpSourcePortLow.3 Integer 0 ;
SnmpMibObject docsDevFilterIpSourcePortHigh.3 Integer 65535 ;
SnmpMibObject docsDevFilterIpDestPortLow.3 Integer 445 ;
SnmpMibObject docsDevFilterIpDestPortHigh.3 Integer 445 ;
SnmpMibObject docsDevFilterIpStatus.3 Integer 4; /* createAndGo */
SnmpMibObject docsDevFilterIpControl.4 Integer 1; /* discard */
SnmpMibObject docsDevFilterIpIfIndex.4 Integer 0 ;
SnmpMibObject docsDevFilterIpDirection.4 Integer 3; /* both */
SnmpMibObject docsDevFilterIpBroadcast.4 Integer 2; /* false */
SnmpMibObject docsDevFilterIpSaddr.4 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpSmask.4 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpDaddr.4 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpDmask.4 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpProtocol.4 Integer 17 ;
SnmpMibObject docsDevFilterIpSourcePortLow.4 Integer 0 ;
SnmpMibObject docsDevFilterIpSourcePortHigh.4 Integer 65535 ;
SnmpMibObject docsDevFilterIpDestPortLow.4 Integer 445 ;
SnmpMibObject docsDevFilterIpDestPortHigh.4 Integer 445 ;
SnmpMibObject docsDevFilterIpStatus.4 Integer 4; /* createAndGo */
SnmpMibObject docsDevFilterIpControl.5 Integer 1; /* discard */
SnmpMibObject docsDevFilterIpIfIndex.5 Integer 0 ;
SnmpMibObject docsDevFilterIpDirection.5 Integer 3; /* both */
SnmpMibObject docsDevFilterIpBroadcast.5 Integer 2; /* false */
SnmpMibObject docsDevFilterIpSaddr.5 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpSmask.5 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpDaddr.5 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpDmask.5 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpProtocol.5 Integer 6 ;
SnmpMibObject docsDevFilterIpSourcePortLow.5 Integer 0 ;
SnmpMibObject docsDevFilterIpSourcePortHigh.5 Integer 65535 ;
SnmpMibObject docsDevFilterIpDestPortLow.5 Integer 1433 ;
SnmpMibObject docsDevFilterIpDestPortHigh.5 Integer 1434 ;
SnmpMibObject docsDevFilterIpStatus.5 Integer 4; /* createAndGo */
SnmpMibObject docsDevFilterIpControl.6 Integer 1; /* discard */
SnmpMibObject docsDevFilterIpIfIndex.6 Integer 0 ;
SnmpMibObject docsDevFilterIpDirection.6 Integer 3; /* both */
SnmpMibObject docsDevFilterIpBroadcast.6 Integer 2; /* false */
SnmpMibObject docsDevFilterIpSaddr.6 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpSmask.6 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpDaddr.6 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpDmask.6 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpProtocol.6 Integer 17 ;
SnmpMibObject docsDevFilterIpSourcePortLow.6 Integer 0 ;
SnmpMibObject docsDevFilterIpSourcePortHigh.6 Integer 65535 ;
SnmpMibObject docsDevFilterIpDestPortLow.6 Integer 1433 ;
SnmpMibObject docsDevFilterIpDestPortHigh.6 Integer 1434 ;
SnmpMibObject docsDevFilterIpStatus.6 Integer 4; /* createAndGo */
SnmpMibObject docsDevFilterIpControl.7 Integer 1; /* discard */
SnmpMibObject docsDevFilterIpIfIndex.7 Integer 0 ;
SnmpMibObject docsDevFilterIpDirection.7 Integer 3; /* both */
SnmpMibObject docsDevFilterIpBroadcast.7 Integer 2; /* false */
SnmpMibObject docsDevFilterIpSaddr.7 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpSmask.7 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpDaddr.7 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpDmask.7 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpProtocol.7 Integer 6 ;
SnmpMibObject docsDevFilterIpSourcePortLow.7 Integer 0 ;
SnmpMibObject docsDevFilterIpSourcePortHigh.7 Integer 65535 ;
SnmpMibObject docsDevFilterIpDestPortLow.7 Integer 25 ;
SnmpMibObject docsDevFilterIpDestPortHigh.7 Integer 25 ;
SnmpMibObject docsDevFilterIpStatus.7 Integer 4; /* createAndGo */
SnmpMibObject docsDevFilterIpControl.8 Integer 1; /* discard */
SnmpMibObject docsDevFilterIpIfIndex.8 Integer 0 ;
SnmpMibObject docsDevFilterIpDirection.8 Integer 3; /* both */
SnmpMibObject docsDevFilterIpBroadcast.8 Integer 2; /* false */
SnmpMibObject docsDevFilterIpSaddr.8 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpSmask.8 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpDaddr.8 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpDmask.8 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpProtocol.8 Integer 17 ;
SnmpMibObject docsDevFilterIpSourcePortLow.8 Integer 0 ;
SnmpMibObject docsDevFilterIpSourcePortHigh.8 Integer 65535 ;
SnmpMibObject docsDevFilterIpDestPortLow.8 Integer 25 ;
SnmpMibObject docsDevFilterIpDestPortHigh.8 Integer 25 ;
SnmpMibObject docsDevFilterIpStatus.8 Integer 4; /* createAndGo */
SnmpMibObject docsDevFilterIpControl.9 Integer 2; /* accept */
SnmpMibObject docsDevFilterIpIfIndex.9 Integer 0 ;
SnmpMibObject docsDevFilterIpDirection.9 Integer 3; /* both */
SnmpMibObject docsDevFilterIpBroadcast.9 Integer 2; /* false */
SnmpMibObject docsDevFilterIpSaddr.9 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpSmask.9 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpDaddr.9 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpDmask.9 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpProtocol.9 Integer 6 ;
SnmpMibObject docsDevFilterIpSourcePortLow.9 Integer 37 ;
SnmpMibObject docsDevFilterIpSourcePortHigh.9 Integer 37 ;
SnmpMibObject docsDevFilterIpDestPortLow.9 Integer 0 ;
SnmpMibObject docsDevFilterIpDestPortHigh.9 Integer 65535 ;
SnmpMibObject docsDevFilterIpStatus.9 Integer 4; /* createAndGo */
SnmpMibObject docsDevFilterIpControl.10 Integer 2; /* accept */
SnmpMibObject docsDevFilterIpIfIndex.10 Integer 0 ;
SnmpMibObject docsDevFilterIpDirection.10 Integer 3; /* both */
SnmpMibObject docsDevFilterIpBroadcast.10 Integer 2; /* false */
SnmpMibObject docsDevFilterIpSaddr.10 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpSmask.10 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpDaddr.10 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpDmask.10 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpProtocol.10 Integer 17 ;
SnmpMibObject docsDevFilterIpSourcePortLow.10 Integer 37 ;
SnmpMibObject docsDevFilterIpSourcePortHigh.10 Integer 37 ;
SnmpMibObject docsDevFilterIpDestPortLow.10 Integer 0 ;
SnmpMibObject docsDevFilterIpDestPortHigh.10 Integer 65535 ;
SnmpMibObject docsDevFilterIpStatus.10 Integer 4; /* createAndGo */
SnmpMibObject docsDevFilterIpControl.11 Integer 2; /* accept */
SnmpMibObject docsDevFilterIpIfIndex.11 Integer 0 ;
SnmpMibObject docsDevFilterIpDirection.11 Integer 3; /* both */
SnmpMibObject docsDevFilterIpBroadcast.11 Integer 2; /* false */
SnmpMibObject docsDevFilterIpSaddr.11 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpSmask.11 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpDaddr.11 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpDmask.11 IPAddress 0.0.0.0 ;
SnmpMibObject docsDevFilterIpProtocol.11 Integer 256 ;
SnmpMibObject docsDevFilterIpStatus.11 Integer 4; /* createAndGo */
/* CmMic 1e05591aab60de9ca0a96e977981469e; */
/* CmtsMic a44b7547973c4e71a4ac0a521f37036f; */
/*EndOfDataMkr*/
/* Pad */
}
"

PS: Тук се вижда какво е cfg-то което ползвам ;)

VN:F [1.9.22_1171]
Rating: 5.0/5 (1 vote cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

MySQL Кратко ръководство

MySQL е много бърза, стабилна система за управление на релационни бази данни (Relational Management Systems- RDBMS). Базата данни позволява ефективно съхранение, претърсване, сортиране и извличане на данни. MySQL контролира достъпа до вашите данни и позволява едновременна работа на множество потребители, бърз достъп, както и осигуряване на достъп само на оторизираните за това потребители. …

Цялата статия

PS: Готин домейн за дрехи: dreha.bg

 

VN:F [1.9.22_1171]
Rating: 5.0/5 (1 vote cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

vim трик

Идеята е да се премахнат всички празни редове:

g/^\s*$/d

Друг трик е да се премахне всичко след конкретен символ. Примерно имам следния ред:" Мартин Петров (Мартин" и желая да премахна всичко след "(":

%s/ (.*/

 

 

VN:F [1.9.22_1171]
Rating: 5.0/5 (1 vote cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Откриване на наличните dhcp сървъри в мрежата

Идеята е да се открият какви dhcp сървъри има в мрежата.

dhcping -s 255.255.255.255 -r -v

Got answer from: 172.16.2.2
received from 172.16.2.2, expected from 255.255.255.255
Got answer from: 172.16.2.2
received from 172.16.2.2, expected from 255.255.255.255
no answer

Тук става ясно, че има един -- 172.16.2.2

 

VN:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Godaddy промокод fb30tld

ПРОМОКОД : fb30tld

Промокод за Godaddy валиден до  8/15/2011 г.

Намаляване на цената с 30% при  закупване на следните домейни от Godaddy:

.COM, .NET, .ORG, .BIZ, и .US

VN:F [1.9.22_1171]
Rating: 5.0/5 (1 vote cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Mysql replication slave -- Could not initialize master info structure

При change master на mysql slave  излиза следната грешка съпроводена с решение :) :

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> stop slave;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> CHANGE MASTER TO MASTER_HOST='192.193.123.4', MASTER_USER='slaveuser', MASTER_PASSWORD='pass', MASTER_LOG_FILE='mysql-bin.000020', MASTER_LOG_POS=49869;
ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log

mysql> reset slave;
Query OK, 0 rows affected (0.00 sec)

mysql> CHANGE MASTER TO MASTER_HOST='192.193.123.4', MASTER_USER='slaveuser', MASTER_PASSWORD='pass', MASTER_LOG_FILE='mysql-bin.000020', MASTER_LOG_POS=49869;
Query OK, 0 rows affected (0.02 sec)

mysql> start slave;
Query OK, 0 rows affected (0.00 sec)

VN:F [1.9.22_1171]
Rating: 5.0/5 (1 vote cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Режим само за четене в mysqld

Идяета е да се стартира mysqld които да предлага само четене без запис. Това е подходящо за репликиращи схеми и други.

Първи метод :
1.1

Със Superuser т.е. root сетвамее read_only=1 или read_only=yes

mysql-h localhost-u root-p
set GLOBAL read_only = true;

Със нормален потребител притежаващ пълни права върху конкретна база изпълняваме следната заявка:

mysql> insert into x (c) values ('test_mysql_read_only_by_amri');
ERROR 1290 (HY000): The MySQL server is running with the --read-only option so it cannot execute this statement

За да активираме write правата на всеки нормален потребител(изключение е само root):

mysql-h localhost-u root-p
set GLOBAL read_only = false;

1.2
Във файл /etc/mysql/my.cnf и по- точно в секция [mysqld] се добавя:

[mysqld]
read_only=1

/etc/init.d/mysql restart;

Втори метод за заключване на таблиците само за четене:

2.1
Отварят се две конзоли свързани към mysql. На втората се изпълнява(заключваме):

mysql> FLUSH TABLES WITH READ LOCK;
Query OK, 0 rows affected (0.01 sec)

На първата конзола която също е свързана към mysql се прави опит за INSERT , но не става :)

За да се активира отново на втората конзола се изпълнява:

mysql> UNLOCK TABLES;
Query OK, 0 rows affected (0.00 sec)

VN:F [1.9.22_1171]
Rating: 5.0/5 (1 vote cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)