Server ошибка 1036 - Решение и исправление самых разных ошибок на TopOshibok.ru

Hi,

Background: I have installed DHCP server on a Windows 2008 R2 server (Std Ed) which is part of a workgroup and not Domain. Server has IP address and subnet mask assigned, no DNS or def gateway configured. Basically installed DHCP Server
using a powershell script which just runs add-windowsfeature DHCP.

Issue: Upon installation I get the following errors.

Error:- 1035 The DHCP service was unable to create or lookup the DHCP Users local group on this computer. The error code is in the data.

Error:- 1036 The DHCP server was unable to create or lookup the DHCP Administrators local group on this computer. The error code is in the data.

Observation: The DHCP Administrators and DHCP Users groups are missing in the system.

Steps taken:

1) Checked the microsft technet site
http://technet.microsoft.com/en-us/library/cc726908(WS.10).aspx and restarted DHCP services, issue still exists.

2) Checked there are no 20035 event log errors.

Strange behaviour: What I have noticed is that if I uninstall DHCP Server role, reboot the machine and install DHCP using the wizard manually with all defaults (no changes apart from TCPIPv6 stateless) then these groups are getting created.
Whereas the same groups are not being created if I install DHCP using a powershell script which runs
add-windowsfeature DHCP.

I need some advice as to what I am doing wrong here, am I missing anything? My understanding was when DHCP is installed using add-windowsfeature cmdlet it should do exactly the same as the wizard. Am I correct here?

WorkAround: I know workaround for this is to create these windows groups manually in the system but I want to confirm if this is what I have to do? Is this a bug or a known behaviour? Does creating teh groups manually
will cause any issues in future?

Thanking you in advance,

Sree

Источник

Обновлено 08.11.2014

На DHCP-сервере Windows 2008 R2 появились две ошибки: «1035: Служба DHCP не смогла создать или просмотреть локальную группу «Пользователи DHCP» на этом компьютере. » и «1036: Служба DHCP не смогла создать или просмотреть локальную группу «Пользователи DHCP» на этом компьютере.»

Ошибки 1035 и 1036 DHCP-сервера на Windows 2008 R2-01

Ошибки 1035 и 1036 DHCP-сервера на Windows 2008 R2-03

Убрать эти ошибки, как оказалось, элементарно.Для начала, как выглядят эти ошибки внешне:

Итак, решение: Заходим в Диспетчер сервера -> Конфигурация -> Локальные пользователи -> Группы, находим группы «Администраторы DHCP» и «Пользователи DHCP», и переименовываем их (жмем правой кнопкой мыши на одной из этих групп, выбираем «Переименовать») на «DHCP Administrators» и «DHCP Users» соответственно. В итоге должно выглядеть так:

Откуда появились такие ошибки? Все просто — изначально была установлена англоязычная версия Windows 2008 R2, а потом на нее сверху установлен русификатор. Часть групп переименовалась корректно, а часть нет. Вот так!

Ноя 8, 2014 00:34

Источник

DHCP Server was unable to create or lookup the DHCP Administrators/Local group on this computer.

For proper functioning of the Dynamic Host Configuration Protocol (DHCP), The DHCP service must be able to create or look up the DHCP Users and DHCP Administrators local groups.

Events

Event ID	Source	Message
1035	Microsoft-Windows-DHCP-Server	The DHCP service was unable to create or lookup the DHCP Users local group on this computer. The error code is in the data.
1036	Microsoft-Windows-DHCP-Server	The DHCP server was unable to create or lookup the DHCP Administrators local group on this computer. The error code is in the data.

Event 1:
Log Name:      System
Source:        Microsoft-Windows-DHCP-Server
Date:          DD-MM-YY
Event ID:      1036
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:     XXX
Description:
The DHCP server was unable to create or lookup the DHCP Administrators local group on this computer. The error code is in the data.

Event 2:
Log Name:      System
Source:        Microsoft-Windows-DHCP-Server
Date:          DD-MM-YY
Event ID:      1035
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      XXX
Description:
The DHCP service was unable to create or lookup the DHCP Users local group on this computer. The error code is in the data.

As per above event, DHCP role is installed on the server, but the Security group “DHCP Users” and “DHCP Administrators” are missing in Active Directory users and computers.

Check if the security groups “DHCP Users” and “DHCP Administrators” are missing in Active Directory (AD). If you can find the security groups restart the DHCP server service and check if the error events have stopped generating.

If you cannot find the security group you can Create the Security group “DHCP Users” and “DHCP Administrators” as shown below.

Run Command Prompt (CMD) in administrator mode and run below cammand

C:\Windows\system32 netsh dhcp add securitygroups
Command completed successfully.

Check if the Security groups have been created in Active Directory (AD).

Restart the DHCP server service and check if event is regenerating.

Reference:

https://technet.microsoft.com/en-us/library/cc726946(v=ws.10).aspx

https://technet.microsoft.com/en-us/library/ee941205(v=ws.10).aspx

Источник

Перейти к контенту

Обновлено 08.11.2014

Ошибки 1035 и 1036 DHCP-сервера на Windows 2008 R2-01

Ошибки 1035 и 1036 DHCP-сервера на Windows 2008 R2-03

Убрать эти ошибки, как оказалось, элементарно.Для начала, как выглядят эти ошибки внешне:

Ноя 8, 2014 00:34

When im trying to insert a record to the table using phpmyadmin it gives me

#1036 - Table 'sch_portfolio' is read only

I saw in some articles they said that this could happen if the owner of this table is somthing other than mysql. so i set the owner as mysql and restart the server. Still im getting the same error. any help would be really appreciated. Thanks in advance

drwxrwxrwx 2 mysql mysql     4096 Jul 13 15:27 schooltap

asked Jul 13, 2013 at 10:42

Make sure you have not set
innodb_force_recovery > 0 in my.cnf

answered Mar 2, 2016 at 7:49

dklovedoctordklovedoctor

5481 gold badge5 silver badges8 bronze badges

One needs super user privs to do this, most commonly sudo is used to acheve this.

in order too Change the owner of the files.

sudo chown -R mysql:mysql /var/lib/mysql

Reboot Mysql for the changes

sudo service mysql restart

who owns sch_portfolio and what group are they in, should be mysql:mysql. you’ll also need to restart mysql for changes to take affect

also check that the currently logged in user had GRANT access to update

The MySQL server is running as user mysql and not as the user I logged into it with. In order for it to access files that have user only rights they must be owned by user ‘mysql’ since that is what the server is running as. Make sure the folder and files used by mysql belong to the user ‘mysql’. These files are located in the /var/lib/mysql directory. The directory itself should also belong to ‘mysql’.

answered Jul 13, 2013 at 10:44

GhostmanGhostman

6,0229 gold badges34 silver badges53 bronze badges

According to me, this is because of storage engine .
If you select storage engine as MRG_MYISAM then that will make your table only readable, you can’t insert data.
So, select myisam as storage engine ..

answered Apr 8, 2016 at 10:52

klausklaus

511 silver badge1 bronze badge

i had a similar problem and the solution for me was to change the owner/group of the table files to mysql.
you can do two options

1

for first you have to go in your server and get privilegies

sudo su

and then i went to the hidden folder mysql doing:

cd /var/lib/mysql/

and then i ran this command:

chown -R mysql:mysql *

and this will solve your problem

then to see if it works you have to reboot the mysql

service mysql restart

2

or you can simply go to phpmyadmin then to your database select all the tables

and then you have to select option repair
(sorry i got phpmyadmin in italian)
you can do this also in bash,

and this will work!
if no option work try to reinstall mysql

answered Jun 11, 2019 at 9:05

R4yR4y

3051 gold badge5 silver badges14 bronze badges

I suspect that in my case, this was caused by a hidden anti malware antivirus Bytefence (probably, it was bundled with something else). The problem was gone after uninstalling this antivirus.

answered May 15, 2017 at 14:13

You can change the Storage Engine so you don’t have to replace settings. If you set it to InnoDB you’re problem sould be solved. ( Changing it can be don in the operations tab in phpmyadmin)

answered Mar 15, 2019 at 11:01

You may receive the following error while repairing or optimizing the MySQL tables:

#1036 – Table ‘xyz’ is read only

When the MySQL tables are in “read only” status, you can update or insert any data in them. In most cases this happens due to incorrect ownership for mysql data directory or data files. The ownership of the mysql director and data files must be mysql:mysql. To correct the ownership, you can run the following command via SSH:

chown -R mysql:mysql /var/lib/mysql

If MySQL data are not stored in /var/lib/mysql, you will need to update this path as per your installation. After changing the ownership, you will need to restart MySQL service:

service mysql restart

-OR-

/etc/init.d/mysql restart

This should fix the “read only” status.

Для этого нужны супер-пользовательские привилегии, чаще всего используется sudo для этого.

для того, чтобы изменить владельца файлов.

sudo chown -R mysql:mysql /var/lib/mysql

Перезагрузите Mysql для изменений

sudo service mysql restart

которому принадлежит sch_portfolio и в какой группе они находятся, должен быть mysql: mysql. вам также потребуется перезапустить mysql, чтобы изменения повлияли на

также проверьте, что у текущего пользователя, имеющего доступ к учетной записи, был доступ GRANT к обновлению

Сервер MySQL работает как user mysql, а не как пользователь, с которым я вошел в него. Чтобы получить доступ к файлам с правами пользователя, они должны принадлежать пользователю ‘mysql’, так как это то, что работает на сервере. Убедитесь, что папка и файлы, используемые mysql, принадлежат пользователю mysql. Эти файлы находятся в каталоге /var/lib/mysql. Сама директория также должна принадлежать ‘mysql’.

Hi,

Issue: Upon installation I get the following errors.

Error:- 1035 The DHCP service was unable to create or lookup the DHCP Users local group on this computer. The error code is in the data.

Error:- 1036 The DHCP server was unable to create or lookup the DHCP Administrators local group on this computer. The error code is in the data.

Observation: The DHCP Administrators and DHCP Users groups are missing in the system.

Steps taken:

1) Checked the microsft technet site
http://technet.microsoft.com/en-us/library/cc726908(WS.10).aspx and restarted DHCP services, issue still exists.

2) Checked there are no 20035 event log errors.

Thanking you in advance,

Sree

Источник

Для этого нужны супер-пользовательские привилегии, чаще всего используется sudo для этого.

для того, чтобы изменить владельца файлов.

sudo chown -R mysql:mysql /var/lib/mysql

Перезагрузите Mysql для изменений

sudo service mysql restart

также проверьте, что у текущего пользователя, имеющего доступ к учетной записи, был доступ GRANT к обновлению

Источник