Problem when creating new databases

Andreas Flack

Problem when creating new databases
Wed March 12 2008 16:55:04 UTC
Hi!

I'm trying to create a new Midgard database with 1.8.6.1 ATM. I
encountered the problem mentioned in another thread

Updating database: multilang
/usr/local/bin/repligard: error while loading shared libraries:
libmidgard.so.9: cannot open shared object file: No such file or directory

Can not import languages.xml

but I managed to navigate around it by manually adding /usr/local/lib to
/etc/ld.conf (but it would really be nicer if Midgard did that
automatically).

But the problem is that creating a new database still fails:

datagard stops when Importing AegirAddOn_FileSync and writes this error
across the dialog interface:

/usr/local/share/midgard/datagard/lib.postinst: line 609: 26535
Abgebrochen $MGD_USR_PATH/bin/repligard -c
$MGD_CONFIG_PATH/repligard.conf -a -i $TMPFILE >/dev/null 2>&1─

underneath the dialog interface, I see this additional error:

Updating database: multilang

repligard-CRITICAL **: Error logging into Database
aborting...
/usr/local/share/midgard/datagard/lib.postinst: line 787: 26564
Abgebrochen $MGD_USR_PATH/bin/repligard -c
$MGD_CONFIG_PATH/repligard.conf -i $MGD_SHARE_PATH/languages.xml

Can not import languages.xml

Now you might say that I didn't enter the correct password or that the
mysql user doesn't have sufficient privileges, but I looked in
/usr/local/etc/midgard/repligard.conf, where username and password are
saved. I took this exact data and logged into mysql from the command
line like this:

mysql -u midgard -p

I could then do things like "USE my_new_db" and "DROP TABLE article", so
the privileges seem to be OK. So... where did I go wrong?

Bye,

Andreas
_______________________________________________
user mailing list
user@lists.midgard-project.org
http://lists.midgard-project.org/mailman/listinfo/user
- Reply
- Report abuse
Piotr Pokora

Re: [midgard-user] Problem when creating new databases
Wed March 12 2008 17:20:02 UTC
Andreas Flack writes:
> Hi!

Hi!

> but I managed to navigate around it by manually adding /usr/local/lib to
> /etc/ld.conf (but it would really be nicer if Midgard did that
> automatically).

It's something can not be done by midgard's configure & make build.
It's system's linker issue. Depending on automake/atuconf versions installed
you should be informed about this at least.

> underneath the dialog interface, I see this additional error:
>
> Updating database: multilang
>
> repligard-CRITICAL **: Error logging into Database
> aborting...
> /usr/local/share/midgard/datagard/lib.postinst: line 787: 26564
> Abgebrochen $MGD_USR_PATH/bin/repligard -c
> $MGD_CONFIG_PATH/repligard.conf -i $MGD_SHARE_PATH/languages.xml

In MySQL:
`DESCRIBE member`

Send/paste output.

Piotras

_______________________________________________
user mailing list
user@lists.midgard-project.org
http://lists.midgard-project.org/mailman/listinfo/user
- Reply
- Report abuse
Andreas Flack

Re: [midgard-user] Problem when creating new databases
Wed March 12 2008 17:50:03 UTC
Piotr Pokora schrieb:
> Andreas Flack writes:
>> Hi!
>
> Hi!
>
> > but I managed to navigate around it by manually adding /usr/local/lib to
>> /etc/ld.conf (but it would really be nicer if Midgard did that
>> automatically).
>
> It's something can not be done by midgard's configure & make build.
> It's system's linker issue. Depending on automake/atuconf versions installed
> you should be informed about this at least.
>
>> underneath the dialog interface, I see this additional error:
>>
>> Updating database: multilang
>>
>> repligard-CRITICAL **: Error logging into Database
>> aborting...
>> /usr/local/share/midgard/datagard/lib.postinst: line 787: 26564
>> Abgebrochen $MGD_USR_PATH/bin/repligard -c
>> $MGD_CONFIG_PATH/repligard.conf -i $MGD_SHARE_PATH/languages.xml
>
> In MySQL:
> `DESCRIBE member`
>
> Send/paste output.

Here you go:

mysql> describe member;
+-----------+-----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra
|
+-----------+-----------------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL |
auto_increment |
| uid | int(11) | NO | MUL | 0 |
|
| gid | int(11) | NO | MUL | 0 |
|
| extra | longtext | NO | | |
|
| info | set('owner','member') | NO | | |
|
| sitegroup | int(11) | NO | MUL | 0 |
|
+-----------+-----------------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)

Bye,

Andreas

>
> Piotras
>
> _______________________________________________
> user mailing list
> user@lists.midgard-project.org
> http://lists.midgard-project.org/mailman/listinfo/user

_______________________________________________
user mailing list
user@lists.midgard-project.org
http://lists.midgard-project.org/mailman/listinfo/user
- Reply
- Report abuse
Andreas Flack

Re: [midgard-user] Problem when creating new databases
Wed March 12 2008 17:55:02 UTC
Hi!

I think I just found out what the problem was: I installed the 1.8.6.1
hotfix package with ./configure && make, because
http://www.midgard-project.org/documentation/installation-source-midgard-data/
says make and make install do the same for this package. Out of
curiosity, I now also ran make install, and now creating new databases
seems to work.

Is this an issue specific to the hotfix package or is the documentation
outdated?

Bye,

Andreas

Andreas Flack schrieb:
> Piotr Pokora schrieb:
>> Andreas Flack writes:
>>> Hi!
>>
>> Hi!
>>
>> > but I managed to navigate around it by manually adding
>> /usr/local/lib to
>>> /etc/ld.conf (but it would really be nicer if Midgard did that
>>> automatically).
>>
>> It's something can not be done by midgard's configure & make build.
>> It's system's linker issue. Depending on automake/atuconf versions
>> installed
>> you should be informed about this at least.
>>
>>> underneath the dialog interface, I see this additional error:
>>>
>>> Updating database: multilang
>>>
>>> repligard-CRITICAL **: Error logging into Database
>>> aborting...
>>> /usr/local/share/midgard/datagard/lib.postinst: line 787: 26564
>>> Abgebrochen $MGD_USR_PATH/bin/repligard -c
>>> $MGD_CONFIG_PATH/repligard.conf -i $MGD_SHARE_PATH/languages.xml
>>
>> In MySQL:
>> `DESCRIBE member`
>>
>> Send/paste output.
>
> Here you go:
>
> mysql> describe member;
> +-----------+-----------------------+------+-----+---------+----------------+
>
> | Field | Type | Null | Key | Default | Extra |
> +-----------+-----------------------+------+-----+---------+----------------+
>
> | id | int(11) | NO | PRI | NULL |
> auto_increment |
> | uid | int(11) | NO | MUL | 0 | |
> | gid | int(11) | NO | MUL | 0 | |
> | extra | longtext | NO | | | |
> | info | set('owner','member') | NO | | | |
> | sitegroup | int(11) | NO | MUL | 0 | |
> +-----------+-----------------------+------+-----+---------+----------------+
>
> 6 rows in set (0.00 sec)
>
>
>
> Bye,
>
> Andreas
>
>>
>> Piotras
>>
>> _______________________________________________
>> user mailing list
>> user@lists.midgard-project.org
>> http://lists.midgard-project.org/mailman/listinfo/user
>
> _______________________________________________
> user mailing list
> user@lists.midgard-project.org
> http://lists.midgard-project.org/mailman/listinfo/user

_______________________________________________
user mailing list
user@lists.midgard-project.org
http://lists.midgard-project.org/mailman/listinfo/user
- Reply
- Report abuse
Piotr Pokora

Re: [midgard-user] Problem when creating new databases
Wed March 12 2008 18:10:02 UTC
Andreas Flack writes:
> Hi!

Hi!

> http://www.midgard-project.org/documentation/installation-source-midgard-data/
> says make and make install do the same for this package. Out of
> curiosity, I now also ran make install, and now creating new databases
> seems to work.
>
> Is this an issue specific to the hotfix package or is the documentation
> outdated?

Documentation issue.
I just removed note about `make` and `make install`equality.

Piotras
_______________________________________________
user mailing list
user@lists.midgard-project.org
http://lists.midgard-project.org/mailman/listinfo/user
- Reply
- Report abuse
Andreas Flack

Re: [midgard-user] Problem when creating new databases
Wed March 12 2008 19:50:03 UTC
Piotr Pokora schrieb:
> Andreas Flack writes:
>> Hi!
>
> Hi!
>
>> http://www.midgard-project.org/documentation/installation-source-midgard-data/
>> says make and make install do the same for this package. Out of
>> curiosity, I now also ran make install, and now creating new databases
>> seems to work.
>>
>> Is this an issue specific to the hotfix package or is the documentation
>> outdated?
>
> Documentation issue.
> I just removed note about `make` and `make install`equality.

Thanks!

In the meantime, I discovered one more issue: After creating the
database and a sitewizard host, I got the following error when trying to
log into /sitewizard:

( ! ) Warning: (pid:32406): QUERY FAILED: Unknown column 'guid' in
'field list' in
/usr/share/php/midcom/lib/midcom/services/auth/sessionmgr.php on line 116
Call Stack
# Time Memory Function Location
1 0.0121 90356 {main}( ) ../7-82-14-0.php:0
2 0.0218 159072 require( '/usr/share/php/midcom/lib/midcom.php' )
../7-82-14-0.php:51
3 0.2259 2477804 midcom_services_auth->initialize( ) ../midcom.php:126
4 0.2583 2650148 midcom_services_auth->_check_for_new_login_session( )
../auth.php:497
5 0.2585 2650336 midcom_services_auth_backend->create_login_session( )
../auth.php:527
6 0.2586 2650360
midcom_services_auth_sessionmgr->create_login_session( ) ../backend.php:103
7 0.2688 2659432 midcom_core_login_session_db->create( )
../sessionmgr.php:116

When I looked into the DB, I saw that midcom_core_login_session was
indeed missing all the metadata columns. Running midgard-schema dbname
didn't do anything, but after running datagard update, the issue went away.

Bye,

Andreas

>
>
> Piotras
> _______________________________________________
> user mailing list
> user@lists.midgard-project.org
> http://lists.midgard-project.org/mailman/listinfo/user

_______________________________________________
user mailing list
user@lists.midgard-project.org
http://lists.midgard-project.org/mailman/listinfo/user
- Reply
- Report abuse
Piotr Pokora

Re: [midgard-user] Problem when creating new databases
Wed March 12 2008 21:55:02 UTC
Andreas Flack writes:

Hi!

> In the meantime, I discovered one more issue: After creating the
> database and a sitewizard host, I got the following error when trying to
> log into /sitewizard:
>
> ( ! ) Warning: (pid:32406): QUERY FAILED: Unknown column 'guid' in
> 'field list' in
> /usr/share/php/midcom/lib/midcom/services/auth/sessionmgr.php on line 116

> When I looked into the DB, I saw that midcom_core_login_session was
> indeed missing all the metadata columns. Running midgard-schema dbname
> didn't do anything, but after running datagard update, the issue went away.

Yes, this is correct way.
midgard-schema configname updates table(s) only if TableCreate and
TableUpdate is set to true.

The latter has some minor issues with keys and indexes, however it's
improved in upcoming 1.8.7 release.

Piotras
_______________________________________________
user mailing list
user@lists.midgard-project.org
http://lists.midgard-project.org/mailman/listinfo/user
- Reply
- Report abuse