Error accessing config table glpi

Forum GLPI-Project

Announcement

#1 2011-03-29 11:19:17

Migrate OCS/GLPI — Error accessing config table

Hello lady’s and gentleman,

I have tested GLPI for some time on the Fedora 14 workstation. And i liked it.

So after some time i’ve installed it on CentOS 5.5. But i wanted to move/migrate the database(‘s) (ocsweb and glpi) from Fedora to CentOS. Because ive already put some useful information in it.

So ive installed phpmyadmin on both of them. And exported and imported the databases (glpi and ocsweb) from Fedora and Imported to CentOS. And now i get «Error accessing config table» on the glpi webinterface. And cant login to ocsreports webinterface to.

I have googled but cant find something useful or something i would understand. I would say my Linux knowledge is kind of average. Not to advanced maybe. So i hope maybe i could get some help / explanation here.

What i was wondering actually also. Is this:
While in the phpmyadmin web interface, on the left side, where you choose between databases,
On the Fedora the databases i have look like this:
— glpi (168)
— information_schema (28)
— mysql (23)
— ocsweb (54)
On the CentOS:
— glpi (168)
— information_schema (17)
— mysql (17)
— ocsweb (54)

This is after ive imported the glpi and ocsweb databases. As it was described on some forum on internet. That only glpi and ocsweb are the databases that you move when you move glpi. Right? Does it matter if the information_schema and mysql has different (are that entries right?) numbers.

I hope possibly that solution is not that complicated.
Thank you in advance,
Sincerely yours,
Nikolai

Источник

Ошибка в базе. Ошибка в таблице Config.

Живой Ископаемый

Живой Ископаемый

(4) СПС. Да этот вариант я храню в запасе, если ничего не получится, то так и сделаю. Но проблема интересная, не часто с ней сталкиваюсь, хотелось бы добить другим способом.

(6) Точно не знаю. На эту таблицу SQL не ругался. Из доступных действий в конфигураторе у меня есть «Открыть конфигурацию» — приводит к ошибке. «Сохранить конфигурацию БД в файл», «Сравнить конфигурацию», тоже приводит к ошибке. Или как то еще можно?

понять какой объект метаданных можно просмотрев запись через Tool_1CD.

спасибо авторам Tool_1CD и DT:менеджер

(18)
код за Вас писать не буду.

для восстановления работоспособности
(с помощью отсключения(удаления) индекса при создании если версия скл >=2005) )

2) удалить запись с задвоенным PK или исправить PK на уникальный
3) восстановить индекс.
из таблицы config, которую создаст 1с при загрузке из dt файла и прервется на ошибке.

потернируйтесь на пустой базе создавая config исполнением скрипта, без загрузки из 1с.

(0) Если записи в CONFIG задвоились, надо удалить лишнюю запись (одну из двух). Чтобы удалить запись, надо:
1. Сделать копию файла 1CD!
2. В Tool_1CD включить в настройках отображение смещений в файле.
3. Посмотреть адрес (смещение) лишней записи.
4. Шестнадцатиричным редактором изменить по этому адресу один байт с 00 на 01.
5. Открыть базу в конфигураторе. Открыть ТиИ.
6. Поставить галочку (только одну!) на «Реиндексация таблиц». Выполнить ТиИ.
7. Поставить галочку (только одну!) на «Сжатие таблиц». Выполнить ТиИ.

После этого можно пробовать открыть конфигурацию, выгружать в dt и т.д.
Если это ошибка единственная, должно помочь, только, как правило, ошибки в одиночку не ходят.

— создание ddl триггера
GO
IF EXISTS (SELECT * FROM sys.triggers
WHERE parent_class = 0 AND name = ‘Config_no_PK’)
DROP TRIGGER Config_no_PK
ON DATABASE ;
GO
CREATE TRIGGER Config_no_PK
—PRINT ‘CREATE TABLE Issued.’
/*

DROP TRIGGER Config_no_PK
/*
ALTER TABLE [dbo].[Config] ADD PRIMARY KEY CLUSTERED
(
GO

(24)
попробуйте удалить один из дублей или оба

перед удалением сохраните дубли в отдельную таблицу

Источник

Syntax error or access violation: 1103 Incorrect table name #2530

Description:

D:xampphtdocslara-admin>php artisan admin:install

IlluminateDatabaseQueryException : SQLSTATE[42000]: Syntax error or access
violation: 1103 Incorrect table name » (SQL: create table « ( id int unsigne
d not null auto_increment primary key, `username` varchar(190) not null, `passwo
rd` varchar(60) not null, `name` varchar(255) not null, `avatar` varchar(255) nu
ll, `remember_token` varchar(100) null, `created_at` timestamp null, `updated_at
` timestamp null) default character set utf8mb4 collate ‘utf8mb4_unicode_ci’)

at D:xampphtdocslara-adminvendorlaravelframeworksrcIlluminateDatabase
Connection.php:664
660| // If an exception occurs when attempting to run a query, we’ll
format the error
661| // message to include the bindings with SQL, which will make th
is exception a
662| // lot more helpful to the developer instead of just the databa
se’s errors.
663| catch (Exception $e) <

664| throw new QueryException(
665| $query, $this->prepareBindings($bindings), $e
666| );
667| >
668|

Steps To Reproduce:

php artisan admin:install

The text was updated successfully, but these errors were encountered:

Источник

CRITICAL:yum.cli:Config Error: Error accessing file for config file:///etc/yum/yum.co

DirectAdmin Support

Administrator

We’re aware of the issue but do not yet have a solution. I believe it’s caused by something in custombuild (not yet sure), perhaps a library being installed breaking python (which runs yum). This has yet to be confirmed. I installed CentOS 6 64-bit manually, testing yum at each step, but it worked fine up until ./build all d (I believe). It may also be a time-delay issue, where a previous change to the system was only triggered by running ldconfig.. so the issue could be caused earlier on.. or even be a CentOS 6 bug, we’re not yet sure.

SeLLeRoNe

Super Moderator

That error appear usually when yum.conf got deleted, is possible that DA installation when change the exclude list delete the file? Or maybe permission/owner changed?

nobaloney

NoBaloney Internet Svcs — In Memoriam †

John, I presume you’ve already tried this, but have you tried reinstalling yum again from RPM after running custombuild?

DirectAdmin Support

Administrator

It’s still there, and permissions are unaffected.
I installed DA step by step as well, and the yum.conf was unchanged.
I went as far as running python through gdb (aka yum is a python script) and the lstat returned an error, that the file didn’t exit. This leads me to believe that it’s a linking issue, as low level functions like that need a good reason to fail.

And yes, removed yum, re-installed the rpm. No change.

nobaloney

NoBaloney Internet Svcs — In Memoriam †

Have you tried building all the services individually, one by one, in custombuild, and checking after each one, instead of ./build all.

I know this could be time-consuming, but it’s important to me to have yum; updating with rpm manually, including getting all the files, and then resolving all dependencies, is just too time consuming when managing multiple servers.

I suppose one option would be if someone would run a bare machine (without DirectAdmin) just to keep yum update running automatically, monitor the yum update logs, and then create a script which would create a script to use rpm to update everything on the machines running DirectAdmin.

However I’m not sure how combersome this would be.

Have you brought up the issue on the CentOS mailing list?

Have you (or anyone) tried Scientific Linux to see if it has the same issue?

Have you (or anyone) tried Red Hat Enterprise Linux to see if it has the same issue?

Источник

Installing and upgrading help

error right after installation — Config table does not contain version

error right after installation — Config table does not contain version

Moodle Version: 2.1.1+ (Build: 20110928)
(although I also tried with Moodle 2.1.1 1st August 2011 release with same result)
I’m using XAMPP version 1.7.7
The computer I’m on is Windows 7, 64 bit.
PHP: 5.3.8

browser: Firefox and chrome, same result.

At the recommendation of one of the other posts on this same problem, I turned debug on but it didn’t help me solve the problem. Here is the output:

Config table does not contain version, can not continue, sorry.

There were also other posts for installing on MAC OS X, and they sais there were problems not having InnoDB.. I checked and I think I have it configured properly — here is what it says on my phpmyadmin > engines > InnoDB > Buffer Pool page:

Buffer Pool Usage Buffer Pool Activity

— Advertisement —

GLPi is a web application that helps companies with the management of their information system. Among its features, this solution is able to build an inventory of all resources of the organization and manage administrative and financial tasks. GLPI stands for Gestionnaire Libre de Parc Informatique is a Free Asset and IT Management Software package, that provides ITIL Service Desk features, licenses tracking and software auditing. In other words, it’s a good idea install GLPI in your company.

The tool is build for Apache-PHP-MySQL environments, so you can install it on both windows and linux servers.

GLPI features:

• Inventory of computers, peripherals, network printers and any associated components through an interface, with inventory tools such as: FusionInventory or OCS Inventory.
• Data Center Infrastructure Management (DCIM).
• Item lifecycle management.
• Licenses management (ITIL compliant).
• Management of warranty and financial information (purchase order, warranty and extension, damping).
• Management of contracts, contacts, documents related to inventory items.

In addition, like any open source project, it is possible to modify and examine its source code.

In this article, i will show you how to install GLPI on Ubuntu Server 18.04.

What you need

The installation of GLPI is really simple, but you must have a previous knowledge in the use of the terminal. Besides installing LAMP stack and of course a computer with Ubuntu Server 18.04.

Let’s get to work.

1. Upgrade the system

First you have to update the system. Doing this will ensure you have the latest package news, as well as the latest security patches. Open a terminal and run.

:~$ sudo -i

When you enter the password, you will be root. Then run:

:~# apt update && apt upgrade

And with this done, you’ll have your system up to date.

2. Install LAMP Stack

GLPI is a web-based application, i.e. you need an installed and fully functional web server. For this tutorial, I will use apache2. It is the most popular web server and is available easily and directly from the Ubuntu repositories. Run:

:~# apt install apache2

Now enable it to start the service as soon as you load the system and initialize the service as well.

:~# systemctl enable apache2
:~# systemctl start apache2

Now if you go to your web browser and access http://IP_SERVER you will see this.

It’s PHP’s turn.

PHP is a programming language in which GLPI is built. You have to install it to run it.

:~# apt install php7.2 php7.2-curl php7.2-gd php7.2-intl php-pear php-imagick php7.2-imap php-memcache php7.2-pspell php7.2-recode php7.2-tidy php7.2-xmlrpc php7.2-xsl php7.2-mbstring php-gettext php7.2-ldap php-cas php7.2-apcu libapache2-mod-php7.2 php7.2-mysql

Finally install MariaDB. Type on a terminal:

:~# apt install mariadb-server

Now run the configuration script to define password and other options.

:~# mysql_secure_installation

After defining the password, you will be asked about other things. Answer Y N Y Y.

Now you have to create a database dedicated to GLPI and a new MariaDB user.

:~# mysql -u root -p

And then creates the database and the new user.

CREATE DATABASE glpidb;
USE glpidb;
GRANT ALL PRIVILEGES ON glpidb.* TO 'glpiuser'@'localhost' IDENTIFIED BY 'glpipss';
FLUSH PRIVILEGES;
exit;

Of course, you’re free to change the names to whatever you want.

3. Download and install GLPI

Now it’s time to install GLPI. First, download it.

:~# cd /tmp/
wget https://github.com/glpi-project/glpi/releases/download/9.3.1/glpi-9.3.1.tgz

Afterwards, you have to extract it, move it to /var/www/html and assign permissions to it.

:~# tar -xvf glpi-9.3.1.tgz
:~# mv glpi /var/www/html/
:~# chmod 755 -R /var/www/html/
:~# chown www-data:www-data -R /var/www/html/

Now go to your browser and access GLPI to complete the installation http://IP_SERVER/glpi

Then you have to accept the license terms.

On the next screen you will be asked if it is an installation or an upgrade.

Afterwards, the system will make an inspection of the dependencies in need.

On the next screen, you will be prompted to enter the MariaDB for GLPI information.

And at the end, you have select the database created.

It will then initialize the database.

The following screens show that the installation is on the right way.

And finally you will see the log in screen.

When you enter the password, you’ll see something like this.

Conclusion

GLPI is a great system that allows us to obtain computer solutions for our company. You can modify and take inventory, tracking incidents and so on.

We want to know about you, have you used GLPI? How did you like the installation?

Please share this article through your social networks

All times are GMT +1. The time now is 12:54 PM.

vBulletin �2000 — 2023, Jelsoft Enterprises Ltd. Ubuntu Logo, Ubuntu and Canonical � Canonical Ltd. Tango Icons � Tango Desktop Project.

User contributions on this site are licensed under the Creative Commons Attribution Share Alike 4.0 International License. For details and our forum data attribution, retention and privacy policy, see here

Salut ! Bonjour à toutes et à tous donc j’ai un léger problème avec l’installation de la glpi sur mon ubuntu 16.04, donc en gros j’ai suivi tout l’installation à la lettre (excepté le php5 que j’ai repris de l’ancien serveur glpi qui était mort) donc voilà si quelqu’un à un début d’idée car j’ai essayé beaucoup de choses merci :

Voilà quelque copie de fichier :

GLPI.conf

<VirtualHost *:80>

ServerName glpi.local.fr

ServerAlias glpi

DocumentRoot /var/www/glpi

<Directory /var/www/glpi>

Options Indexes FollowSymLinks MultiViews

AllowOverride All

Order allow,deny

allow from all

AuthType Basic

</Directory>

</VirtualHost>

-Sur apache le site est bien activé j’ai crée la table sql, j’ai accordé les droit au dossier glpi pour que apache est les droit de le modifier, j’ai installer les dépendances, j’ai modifié dans le fichier la limite à 128m , mais impossible d’accéder à l’installation du glpi. SI quelqu’un à une idée ou même un début, je suis preneur et merci d’avoir pris le temps de lire