Pb : "DBD::mysql::db do failed: Can"t create/write to file..."

> Hello,
>
> I've a very little experience with mysql/perl/perl's modules. I try to
> install and to use the sympa server (mailing-list diffusion server)
> which need his database with mysql. The database is created, but I
> cannot access it, here are the error logs :
>
> >>unix passed to setlogsock, but path not available at
> /home/sympa/bin/Log.pm line 95
> >>DBD::mysql::db do failed: Can't create/write to file
> './sympa/user_table.frm' (Errcode: 13) at /home/sympa/bin/List.pm line
> 6751.
> >>DBD::mysql::db do failed: Can't create/write to file
> './sympa/subscriber_table.frm' (Errcode: 13) at
> /home/sympa/bin/List.pm line 6751.
> >>Database sympa defined in sympa.conf has not the right structure or
> is unreachable. If you don't use any database, comment db_xxx
> parameters in sympa.conf
>
> I thought that it was a problem of databases' location or access
> permissions but it's not. But user_table.frm and subscriber_table.frm
> exists (in /usr/local/mysql/var/sympa - automatically created with a
> sympa command).
>
> I search since 3 days, I already have asked to the sympa's
> mailing-list, but no answer.
>
> Hope that someone can help me.
>
> Thanks.
>
> Lionel David.




--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Pb : "DBD::mysql::db do failed: Can"t create/write to file..."

On Fri, 7 Nov 2003, Lionel David wrote:

> > Hello,

Hello,

> > >>DBD::mysql::db do failed: Can't create/write to file
> > './sympa/user_table.frm' (Errcode: 13) at /home/sympa/bin/List.pm line
> > 6751.
> > >>DBD::mysql::db do failed: Can't create/write to file
> > './sympa/subscriber_table.frm' (Errcode: 13) at
> > /home/sympa/bin/List.pm line 6751.
> > >>Database sympa defined in sympa.conf has not the right structure or
> > is unreachable. If you don't use any database, comment db_xxx
> > parameters in sympa.conf
> >
> > I thought that it was a problem of databases' location or access
> > permissions but it's not. But user_table.frm and subscriber_table.frm
> > exists (in /usr/local/mysql/var/sympa - automatically created with a
> > sympa command).

It sounds like you have a permissions error and the mysql is not able to
write to the file and/or directory. Try chmoding it so that the user that
you are runing the mysql daemon under has permssions to read and write to
the files and directories.


Rudy


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Pb : "DBD::mysql::db do failed: Can"t create/write to file..."

On Fri, 7 Nov 2003, Lionel David wrote:

> > Hello,

Hello,

> > >>DBD::mysql::db do failed: Can't create/write to file
> > './sympa/user_table.frm' (Errcode: 13) at /home/sympa/bin/List.pm line
> > 6751.
> > >>DBD::mysql::db do failed: Can't create/write to file
> > './sympa/subscriber_table.frm' (Errcode: 13) at
> > /home/sympa/bin/List.pm line 6751.
> > >>Database sympa defined in sympa.conf has not the right structure or
> > is unreachable. If you don't use any database, comment db_xxx
> > parameters in sympa.conf
> >
> > I thought that it was a problem of databases' location or access
> > permissions but it's not. But user_table.frm and subscriber_table.frm
> > exists (in /usr/local/mysql/var/sympa - automatically created with a
> > sympa command).

It sounds like you have a permissions error and the mysql is not able to
write to the file and/or directory. Try chmoding it so that the user that
you are runing the mysql daemon under has permssions to read and write to
the files and directories.


Rudy


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org